The conceptual model of the "Shop" database is shown in Image 1.
Image 1 - Conceptual model of the "Shop" database
This project is implemented in C#, on Windows Forms.
- Log in to your profile (if you don't have one, then register).
- Select a product from the list of products.
- Specify the required quantity of the product
- Click the "Добавить в корзину" button.
- Click the "Корзина" button.
- Click the "Оформление заказа с копией в PDF" button.
Then go to the store to pick up your product.
Image 2 shows the main form of the store.
Image 2 - The main form of the store
- The MySQL database management system was used.
- A simple example of queries in the code:
SELECT Категории.Наименование AS Категория, Продукты.Наименование, Количество, Цена FROM Продукты, Категории WHERE Категории.ID_Категория=Продукты.ID_Категория. - It was also possible to output images through the code.
- The main thing is to install Visual Studio
- Launch "Shopping.sln".
- Assign 'connectionString' the connection path to the "Shop" database.