C# (.net) program for working with the CarService database
This program was created using a local database, it is fully written in C#.net in the Visual Studio environment based on WindowsForm.
The SQL database is in the SQL Management Studio environment.
The program has output for editing, deleting, and sorting the following data:
Client data
Car data
Employee data
Order data
The screenshot shows the section Client Data; the remaining sections are implemented in a table. When the "More Details" button is pressed, a user profile will open with all the information about them and data about their cars, which will be divided into separate data about repairs.
The database consists of:
1. Clients
2. Cars
3. Orders
4. Employees
5. Payment details
6. Spare parts
The principle of operation is as follows:
The client ID is linked to the car, meaning there can be multiple cars but one owner.
Then the car ID is linked to the order, and the employee ID is also linked to the order.
Spare parts and payment details link to the order ID.
The SQL database is in the SQL Management Studio environment.
The program has output for editing, deleting, and sorting the following data:
Client data
Car data
Employee data
Order data
The screenshot shows the section Client Data; the remaining sections are implemented in a table. When the "More Details" button is pressed, a user profile will open with all the information about them and data about their cars, which will be divided into separate data about repairs.
The database consists of:
1. Clients
2. Cars
3. Orders
4. Employees
5. Payment details
6. Spare parts
The principle of operation is as follows:
The client ID is linked to the car, meaning there can be multiple cars but one owner.
Then the car ID is linked to the order, and the employee ID is also linked to the order.
Spare parts and payment details link to the order ID.