🚀 InvoiceFlow: Smart Invoice Management System

Effortlessly manage invoices with a robust SQL backend, a powerful .NET API, and a sleek AngularJS frontend. Automate invoice generation, track details, and ensure data integrity with transactional operations.

🌟 Features

• Database Layer

  • Invoice Header, Detail, and Sequence tables
  • Stored procedures for CRUD operations with automatic total calculation
  • Transaction-safe insert/update/delete operations

• API Layer (.NET Web API)

  • Full invoice header/detail models
  • Repository pattern with transactional support
  • RESTful endpoints for all operations

• Client Layer (AngularJS + DevExpress)

  • Interactive invoice listing grid
  • Modal-driven create/update flows
  • Detail management with inline editing
  • Responsive UI with DevExpress components

🛠 Tech Stack

Frontend

Backend

Database

🚀 Installation

Prerequisites

• SQL Server 2019+
• .NET 7 SDK
• Node.js 18+
• Angular CLI

# Clone repository
git clone git@github.com:HopeforgeDev/InvoiceFlow.git
cd InvoiceFlow

# Restore NuGet packages
dotnet restore

# Install client dependencies
cd ClientApp
npm install

Start API:

dotnet run --project InvoiceFlow.API

💻 Client Setup

cd ClientApp

# Configure API endpoint
echo 'export const environment = {
  production: false,
  apiUrl: "https://localhost:5001/api"
};' > src/environments/environment.ts

# Start Dev Server
ng serve

🔄 Transaction Flow

sequenceDiagram
    Client->>API: Create Invoice Header
    API->>SQL: EXEC spwv_tr_insertinvoiceheader
    SQL-->>API: Return ih_seq
    API->>Client: New Invoice ID
    
    Client->>API: Add Detail Line
    API->>SQL: EXEC spwv_tr_insertinvoicedetail
    SQL->>SQL: Update ih_total
    SQL-->>API: New detail ID

Loading

📜 License

MIT License - see LICENSE for details

---

Happy Invoicing! 💰📄