Automated System Of A Sports Equipment Store

Description

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.

How to use it

You need to perform several operations:

• 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

About the project

SQL

• 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.

Project setup

1. The main thing is to install Visual Studio
2. Launch "Shopping.sln".
3. Assign 'connectionString' the connection path to the "Shop" database.