# ahirraoshubham/auto-spare-parts-management-system architecture

> Architecture diagram of the GitHub repository ahirraoshubham/auto-spare-parts-management-system, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2025-07-23). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/ahirraoshubham/auto-spare-parts-management-system
- Repository: https://github.com/ahirraoshubham/auto-spare-parts-management-system

## Overview

##### Project Type and Purpose
- This is a standalone, desktop‐based Java application (“Auto Spare Part Management System”) built on Java 1.6+ with a Microsoft Access (.accdb) backend.
- It provides CRUD and reporting functionality for spare parts, customers, staff, orders, quotations, and billing.

##### File Structure
- Top‐level Java classes (Bill.java, Customer.java, Order.java, etc.) indicate domain entities and GUIs (Home.java, Login.java, Welcome.java).
- Resources/Auto spare.accdb is the database file.
- Run.bat, Delete class files.bat and Readme.txt/README.md are deployment and documentation artifacts.

##### Extract Insights from the README
- Confirms a Windows‐only Java+Access stack.
- Describes modules: stock management, billing, customer & staff records, distributor ordering.
- No mention of a web or service layer—pure desktop.

a. Main Components
- Presentation Layer (Java Swing UIs): Login, Home, ViewQuotation, Reports, etc.
- Business Logic Layer (Service Classes): CustomerDetails.java, Variables.java, Reports.java, BillReport.java, OrderReport.java.
- Data Access Layer (DAO): classes or methods inside domain classes that use JDBC-ODBC bridge to connect to Auto spare.accdb.
- Database (Microsoft Access .accdb file)
- External Tools (BAT scripts for launch and cleanup)
- Reporting Engine (built‐in Java reporting code, e.g., BillReport, OrderReport)

b. Relationships and Data Flow
1. User interacts with a Swing form (e.g., Login.java → Home.java → Order.java).
2. Forms call Business Logic methods to validate input, enforce rules.
3. Business Logic invokes Data Access methods to perform SQL CRUD on the Access DB.
4. Results flow back up: DAOs → Services → UIs.
5. Reports components read from the DB, transform data into printable bills, reports.
6. Batch scripts wrap application start and optional cleanup.

c. Architectural Patterns & Principles
- Layered (Presentation → Business → Data Access → Database)
- MVC‐style separation (Forms = View, service classes = Controller/Model)
- Single Database file acts as central datastore (no microservices)

d. Key Technologies & Frameworks
- Java 1.6+ (Swing/AWT)
- JDBC‐ODBC bridge or UCanAccess driver
- Microsoft Access (.accdb)
- Windows Batch (.bat) for orchestration

##### Detailed Elements to Capture
- The single Access database file as a shared resource.
- Reporting modules as a subcomponent of the Business Logic layer.
- Batch files as entry/exit points.

## Diagram (Mermaid)

```mermaid
flowchart TB
    %% External Tools
    subgraph "External Tools"
        style ET fill:#e2e3e5,stroke:#d6d8db
        RunBat["Run.bat"]:::external
        DeleteClasses["Delete class files.bat"]:::external
    end

    %% Presentation Layer
    subgraph "Presentation Layer (Swing UIs)"
        style UI fill:#cce5ff,stroke:#004085
        Login["Login.java"]:::ui
        Home["Home.java"]:::ui
        Welcome["Welcome.java"]:::ui
        Load["Load.java"]:::ui
        OrderUI["Order.java"]:::ui
        QuotationUI["Quotation.java"]:::ui
        ViewQuotation["ViewQuotation.java"]:::ui
    end

    %% Business Logic Layer
    subgraph "Business Logic Layer"
        style BL fill:#d4edda,stroke:#155724
        CustomerDetails["CustomerDetails.java"]:::business
        Variables["Variables.java"]:::business
        Reports["Reports.java"]:::business
        BillReport["BillReport.java"]:::business
        OrderReport["OrderReport.java"]:::business
    end

    %% Data Access Layer
    subgraph "Data Access Layer"
        style DA fill:#fff3cd,stroke:#856404
        BillDAO["Bill.java"]:::dataaccess
        CustomerDAO["Customer.java"]:::dataaccess
        DistributorDAO["Distributor.java"]:::dataaccess
        OrderDAO["Order.java"]:::dataaccess
        QuotationDAO["Quotation.java"]:::dataaccess
        SpareDAO["Spare.java"]:::dataaccess
        StaffDAO["Staff.java"]:::dataaccess
        UserDAO["User.java"]:::dataaccess
    end

    %% Database
    Database[(Access Database<br/>Auto spare.accdb)]:::db

    %% Connections: Scripts to Loader
    RunBat -->|launches| Load
    DeleteClasses -->|cleans up| Load

    %% UI to Business Logic
    Load -->|loads| Welcome
    Welcome -->|navigates to| Login
    Login -->|authenticates via| CustomerDetails
    Home -->|uses config| Variables
    Home -->|opens order form| OrderUI
    OrderUI -->|submits order to| OrderReport
    QuotationUI -->|creates quotation via| CustomerDetails
    ViewQuotation -->|views report via| Reports

    %% Business Logic to DAOs
    CustomerDetails -->|CRUD user data| UserDAO
    CustomerDetails -->|CRUD customer data| CustomerDAO
    Reports -->|fetches billing data| BillDAO
    Reports -->|fetches order data| OrderDAO
    BillReport -->|generates bills| BillDAO
    OrderReport -->|generates orders| OrderDAO

    %% Data Access to Database
    BillDAO -->|SQL CRUD| Database
    CustomerDAO -->|SQL CRUD| Database
    DistributorDAO -->|SQL CRUD| Database
    OrderDAO -->|SQL CRUD| Database
    QuotationDAO -->|SQL CRUD| Database
    SpareDAO -->|SQL CRUD| Database
    StaffDAO -->|SQL CRUD| Database
    UserDAO -->|SQL CRUD| Database

    %% Click Events
    click Login "https://github.com/ahirraoshubham/auto-spare-parts-management-system/blob/master/Login.java"
    click Home "https://github.com/ahirraoshubham/auto-spare-parts-management-system/blob/master/Home.java"
    click Welcome "https://github.com/ahirraoshubham/auto-spare-parts-management-system/blob/master/Welcome.java"
    click Load "https://github.com/ahirraoshubham/auto-spare-parts-management-system/blob/master/Load.java"
    click OrderUI "https://github.com/ahirraoshubham/auto-spare-parts-management-system/blob/master/Order.java"
    click QuotationUI "https://github.com/ahirraoshubham/auto-spare-parts-management-system/blob/master/Quotation.java"
    click ViewQuotation "https://github.com/ahirraoshubham/auto-spare-parts-management-system/blob/master/ViewQuotation.java"
    click CustomerDetails "https://github.com/ahirraoshubham/auto-spare-parts-management-system/blob/master/CustomerDetails.java"
    click Variables "https://github.com/ahirraoshubham/auto-spare-parts-management-system/blob/master/Variables.java"
    click Reports "https://github.com/ahirraoshubham/auto-spare-parts-management-system/blob/master/Reports.java"
    click BillReport "https://github.com/ahirraoshubham/auto-spare-parts-management-system/blob/master/BillReport.java"
    click OrderReport "https://github.com/ahirraoshubham/auto-spare-parts-management-system/blob/master/OrderReport.java"
    click BillDAO "https://github.com/ahirraoshubham/auto-spare-parts-management-system/blob/master/Bill.java"
    click CustomerDAO "https://github.com/ahirraoshubham/auto-spare-parts-management-system/blob/master/Customer.java"
    click DistributorDAO "https://github.com/ahirraoshubham/auto-spare-parts-management-system/blob/master/Distributor.java"
    click OrderDAO "https://github.com/ahirraoshubham/auto-spare-parts-management-system/blob/master/Order.java"
    click QuotationDAO "https://github.com/ahirraoshubham/auto-spare-parts-management-system/blob/master/Quotation.java"
    click SpareDAO "https://github.com/ahirraoshubham/auto-spare-parts-management-system/blob/master/Spare.java"
    click StaffDAO "https://github.com/ahirraoshubham/auto-spare-parts-management-system/blob/master/Staff.java"
    click UserDAO "https://github.com/ahirraoshubham/auto-spare-parts-management-system/blob/master/User.java"
    click Database "https://github.com/ahirraoshubham/auto-spare-parts-management-system/blob/master/Resources/Auto spare.accdb"
    click RunBat "https://github.com/ahirraoshubham/auto-spare-parts-management-system/blob/master/Run.bat"
    click DeleteClasses "https://github.com/ahirraoshubham/auto-spare-parts-management-system/blob/master/Delete class files.bat"

    %% Styles
    classDef ui fill:#cce5ff,stroke:#004085
    classDef business fill:#d4edda,stroke:#155724
    classDef dataaccess fill:#fff3cd,stroke:#856404
    classDef external fill:#e2e3e5,stroke:#d6d8db
    classDef db fill:#e2e3e5,stroke:#d6d8db,stroke-dasharray: 5 5,shape:cylinder
```
