How noor-rehman/inventory-management-system---windows-application-with-integrated-database works
Project Type and Purpose
• Desktop “thick‐client” WinForms application
• Purpose: inventory tracking, billing/receipt printing, expense & refund management
Main Architectural Components
a. User Interface Layer (WinForms)
– All “*.cs” and “*.Designer.cs” files under root (Form1, Attendants, Category, Expense, SellingForm, Refunds, History, ResetPasswordForm, Loading, Splash, etc.)
– Responsible for user interactions, form events, data entry, bill printing UI
b. Business Logic Layer
– Embedded in form code‐behind (validation, computing totals, business rules)
– Could be pulled out later into separate classes if needed
c. Data Access Layer
– db.cs (connection management, raw SQL execution)
– star_platinumDataSet.* (Typed DataSet, TableAdapters, schema definitions)
– Bridges business logic and SQL Server database
d. Database
– SQL Server (local or remote) storing inventory, sales, refunds, history tables
– Accessed via ADO.NET Typed DataSets & TableAdapters
e. Reporting/Bill Printing Component
– Printing logic invoked by SellingForm or other sales forms
– Uses .NET PrintDocument/PrintPreview controls
Relationships and Data Flows
1) User interacts with WinForm → triggers event handler
2) Event handler invokes Business Logic (calculations, validations)
3) Business Logic calls Data Access Layer (db.cs or TableAdapter)
4) Data Access Layer opens SQL connection → runs queries or stored procedures → returns DataSet or scalar result
5) Business Logic processes results → updates UI or triggers printing
6) For bill printing: UI passes sale details to Reporting component → PrintDocument → Printer
Architectural Patterns & Design Principles
• Layered architecture (UI → BLL → DAL → Database)
• Separation of concerns (forms for UI, db.cs for data access, DataSet for schema)
• Event‐driven programming (WinForms)
• Typed DataSets as simple ORM alternative
Technologies & Frameworks
• .NET Framework WinForms
• ADO.NET Typed DataSets (star_platinumDataSet.xsd/.xsc/.xss)
• SQL Server (Express or full edition)
• C# language
• .resx resource files for localization