🚀 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 dependenciescd ClientApp
npm install

Start API:

dotnet run --project InvoiceFlow.API

💻 Client Setup

cd ClientApp
# Configure API endpointecho'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! 💰📄