- Category
- Desktop / C# / SQL Server
- Role
- Analysis, database design, development and testing
- Year
- 2026
- Tools
- C# · .NET 10 · Windows Forms · SQL Server · ADO.NET
C#Windows FormsSQL ServerOOP

01
The brief
Built as an object-oriented programming project: a working pharmacy system that also demonstrates classes, inheritance, polymorphism, collections, validation and database access in C#.
02
What it does
- 01Admin dashboard with total sales, medicine count and active orders
- 02Medicine records with dosage, price, stock, expiry date, category, supplier and a prescription-required flag
- 03Customer and order management, including order-status updates
- 04Customers register, search by name and price range, fill a cart, place orders and track them
- 05Stock reduced automatically when an order is placed
- 06Sales, low-stock and order-history reports with CSV export
- 07Parameterised SQL queries, input validation and handled database errors
- 08ERD, class, use-case and architecture diagrams, a user manual and 16 recorded test cases
03
In numbers
12forms
7database tables
16recorded test cases
06Velora
Beauty atelier website, a front-end showcase
