N / 26Portfolio · 2026
Engineering
Loading
0%
SmartMed: white capsules in a grid before a row of black medicine bottles, one capsule orange
All work05 / 08

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
SmartMed: white capsules in a grid before a row of black medicine bottles, one capsule orange
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