GP AutoAccounts is a tailored C# Windows Forms solution designed to automate end-to-end financial and inventory management for GP Automotive Workshop. By analyzing their daily workflows, this system replaces manual tracking with a digital ecosystem powered by SQL Server.
- Language & Framework: C# (Windows Forms)
- Database: SQL Server
- IDE: Visual Studio
- Digital Dashboard: Tracks sales, expenses, and overall account balances.
- Automated Financials: Streamlines invoice generation and financial reporting.
- Dynamic Client Tracking: Features dynamic customer balance tracking to easily manage pending payments and credit.
- Relational Database Modules: Uses a normalized SQL Server architecture to securely manage workshop inventory and financial transactions.
Follow these instructions to set up and run the project locally on your machine.
- Visual Studio (with .NET desktop development workload installed)
- SQL Server (Express, Developer, or Standard edition)
-
Clone the repository: git clone https://github.com/AsfaThahani/GP_Auto_Accounts.git
-
Database Setup:
- Open SQL Server Management Studio (SSMS).
- Execute the provided database script (
schema.sql) to generate the tables and relations.
-
Configuration:
- Open the project in Visual Studio.
- Update the connection string in your
App.configfile to match your local SQL Server instance name and credentials.
- Open the solution (
.sln) file in Visual Studio. - Build the solution (Ctrl + Shift + B).
- Press F5 or click Start to run the application.

