An SQL project for managing an ice-cream shop
Make sure you have 'dotnet' installed.
Make sure you have a running SQL server locally on your machine, and in 'DAL.cs' file make sure to have the correct ConnectionString in 'connectToSQL()' function.
Simply run 'dotnet run' to run the program
Once running 'dotnet run' a single Windows Form will pop up with two buttons:
- Admin
- New Sale
In the Admin windows you can perform different function that includes observing data in the database (such as 'Best Sellers', 'Get Receipt' and more..),
as well as managing the database itself (such as 'SQL''MongoDB' toggle button, reinitializing database and more..).
The 'New Sale' button pops up a window "for the client", thats why its pink. get it? (At this point it should be clear that this is not a UI\UX project..)
There, you have 3 text boxs. One for choosing cup type, other for choosing the taste of the next ball to add, and the third for the extra tasete to add.
After you write down in the text box what taste you want to add, click the 'add' button below it to add it to the sale. You can see your current sale through 'see sale' button. (Yep.. bad UI).
If you play with it enough you WILL get exceptions that are probably for bad combinations of tastes. (In the Business-Logic-Layer there are conditions and constraints that will cause exepctions).
- it is important to note that both the ERD and UML were designed prior to implementation.
The following ERD describes the relations for the SQL database in the project.
