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.

• 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

Frontend
AngularJS
DevExpress

Backend
.NET

Database
SQL Server

• 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

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

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

MIT License - see LICENSE for details

Happy Invoicing! 💰📄