Home About Projects Certificates Skills Contact Download CV
Home / Projects / Jewelry System
01 / ERP & Financial
Platform Enterprise Web ERP
Production System

Jewelry SystemERP Platform

An enterprise-grade ERP built with .NET 10 and ASP.NET Core MVC, purpose-built for jewelry manufacturers and precious metal retail chains. Features a DynamicExpresso runtime pricing formula engine, dual-currency supplier accounting (EGP + grams), multi-branch weight-based stock control, QuestPDF Arabic RTL invoice generation, custom RFC 6238 TOTP 2FA, and 130+ granular permissions.

ASP.NET Core (.NET 10) C# Entity Framework Core 10 SQL Server (66 DbSets) DynamicExpresso Formula Engine QuestPDF (Arabic RTL) Custom TOTP 2FA
Enterprise Client System Client NDA
Repository Access Private Repo
SCREENSHOTS
59
TIMELINE
+1 Year
LEVEL
Enterprise

Engineering Highlights.

[01]

Dynamic Formula Pricing Engine

Runtime mathematical evaluation engine powered by DynamicExpresso.Core to calculate fluctuating karat spot rates. Resolves dynamic variables (WEIGHT, ItemPriceEx, OldFees, MAT[id].Price, TAX.Formula) with custom regex pattern matching.

DynamicExpresso / Runtime Formulas
[02]

Dual-Currency Supplier Accounting

Specialized double-entry ledger system (SupplierAccountLedger) simultaneously tracking financial obligations in Egyptian Pounds alongside raw metal weight in grams, featuring SupplierTransfer cross-material conversions.

Double-Entry / EGP + Grams Ledger
[03]

Multi-Location Stock & 13 Tx Types

Granular stock tracking across branches and safe vaults, managing quantities and decimal gram weights. Enforces 13 distinct transaction types (SALE, PURCHASE, KASR_MERGE, TRANSFER) with fast tray barcode auditing.

13 StockTxTypes / FastStockChecker
[04]

QuestPDF Arabic RTL Invoices & Labels

Vector PDF pipeline via QuestPDF 2026 with native Arabic RTL text layout, A4/A5 formats, dynamic social QR codes, ClosedXML Excel analytics, and 2-up dual-column CSV exports for BarTender jewelry string tags.

QuestPDF RTL / BarTender 2-Up CSV
[05]

Custom RFC 6238 TOTP 2FA & RBAC

Bespoke Two-Factor Authentication built from scratch following RFC 6238 (HMAC-SHA1, Base32 decoding, ±1 window) for Google Authenticator, coupled with 130+ seeded granular permissions enforced via [RequirePermission] and tag helpers.

Custom TOTP (RFC 6238) / Custom RBAC
[06]

EF Core Interceptor Auditing & SignalR

AuditSaveChangesInterceptor capturing field-level changes with a 15-second merge window to coalesce rapid edits and mask sensitive credentials, alongside real-time user notifications powered by SignalR NotificationHub.

EF Core Interceptors / SignalR

Backend & Architecture

  • .NET 10.0 & ASP.NET Core MVC
  • 60 Controllers & 26+ Service Layers
  • 350 C# Files (~1.85 MB)
  • DynamicExpresso Mathematical Engine

Data & Persistence

  • SQL Server & EF Core 10.0.6
  • 68 Entity Models & 66 DbSets
  • Fluent API (AppDbContext)
  • AuditSaveChangesInterceptor

Documents & Hardware

  • QuestPDF 2026.5
  • ClosedXML 0.105
  • ZXing.Net & QRCoder
  • CSV Industrial Label Exporter

Security & Real-Time

  • Custom RFC 6238 TOTP (Google Auth)
  • 130+ Granular Permissions RBAC
  • Cookie Auth & Session
  • SignalR NotificationHub

Screenshots.

Activity Logs Admin & System
Activity Logs
Barcode Generator Inventory
Barcode Generator
Business Location Admin & System
Business Location
Calendar Admin & System
Calendar
Checker Review Inventory
Checker Review
Coupons Create Accounting
Coupons Create
Create Customer Users & Roles
Create Customer
Create New User Users & Roles
Create New User
Create Safes Accounting
Create Safes
Customer Classifications Users & Roles
Customer Classifications
Customers POS POS & Sales
Customers POS
Customers Users & Roles
Customers
Edit System Config Admin & System
Edit System Config
Expenses Payments POS & Sales
Expenses Payments
Export Labels Data Inventory
Export Labels Data
Fast Stock Checker Inventory
Fast Stock Checker
Home Page Admin & System
Home Page
Invoice Details POS & Sales
Invoice Details
Invoice PDF POS & Sales
Invoice PDF
Invoices List POS & Sales
Invoices List
Login Log Admin & System
Login Log
Manual Add to Stock Inventory
Manual Add to Stock
Material Balance Analysis Admin & System
Material Balance Analysis
Notifications Admin & System
Notifications
Payments Details Accounting
Payments Details
Payments List Accounting
Payments List
Print invoices Modal POS & Sales
Print invoices Modal
Products Price Functions Inventory
Products Price Functions
Products Inventory
Products
Profit Sales Reports Admin & System
Profit Sales Reports
Quick Calculator Admin & System
Quick Calculator
Quick Prices Edit Inventory
Quick Prices Edit
RawMaterial Price Reports Inventory
RawMaterial Price Reports
RawMaterials Inventory
RawMaterials
RecycleBin Admin & System
RecycleBin
Refund Invoice POS & Sales
Refund Invoice
Roles List Users & Roles
Roles List
Roles Management Users & Roles
Roles Management
Safe Balance Analysis Accounting
Safe Balance Analysis
Safes Transactions Accounting
Safes Transactions
Split Pending Weight Inventory
Split Pending Weight
Stock Check History Inventory
Stock Check History
Stock History Detail Inventory
Stock History Detail
Stock History Inventory
Stock History
Stock List Inventory
Stock List
Stock Transfer Inventory
Stock Transfer
Supplier Balances Accounting
Supplier Balances
Supplier Details Users & Roles
Supplier Details
Supplier Reports Users & Roles
Supplier Reports
SupplierPayment Users & Roles
SupplierPayment
Suppliers POS POS & Sales
Suppliers POS
Suppliers Users & Roles
Suppliers
SuppliersAccounting Accounting
SuppliersAccounting
System Config Admin & System
System Config
System Setting Admin & System
System Setting
Today Balances Accounting
Today Balances
Transfer Balances Between Suppliers Accounting
Transfer Balances Between Suppliers
User Details Users & Roles
User Details
User Reports Users & Roles
User Reports