💻 Sample project showcasing a basic API implementation for an Insurance Management System.

This is a practice and learning project built with C# and ASP.NET Core Web API, focused on the core structure of an Insurance Management System.

It demonstrates essential concepts in modern API development, including layered architecture, clean coding standards, and key features like authentication, data handling, and policy management.

Designed for experimentation and foundational training, this project serves as a starting point for developing more robust, production-ready insurance applications.

---

🔥 Tech Stack & Tools

---

✨ Features

🧱 API & Service Foundations

• Architectural Principles: Layered Architecture, Object-Oriented Programming (OOP), SOLID Principles
• Core API Design: Dependency Injection, API Versioning, JWT Authentication, Request Validation, CORS Handling

🗄️ Data Management & Interaction

• Database Abstraction: DB Wrapper, API DB Factory Wrapper
• Database Design & Structure:
  • Schema & Constraints: Primary Keys, Foreign Keys, Normalization, Column/Field Standardization
  • Programmability: Stored Procedures, Functions, Views, Procedure Return Results
  • Performance & Efficiency: Query Optimization, Pagination, Indexing, UTC Time Saving

⚙️ Operational Excellence

• Monitoring & Reliability: API Logging, Timeout Handling

🧼 Code Quality & Standards

• Development Practices: Clean Code, Maintainability First
• Resource Management: Constants, Static Data, Static Messages

🧪 Development Workflow & Testing

• Documentation & Testing: API Documentation, Unit Tests, Mock Data for Testing
• Deployment Readiness: Docker Prepared

---

📚 Modules

1. 🧑‍💼 Agents
2. 🧑‍💼 Sub-Agents
3. 📣 Promo Managers
4. 📊 Sales Managers
5. 🕵️ Promo Officers
6. 🤝 Partners
7. 👤 Clients
8. 🏢 Providers
9. 🔀 Distribution Channels
10. 🗂️ Product Categories
11. 📦 Products
12. 📘 Policy Components:

• 💠 Benefits
• 🛡️ Deductibles
• 💰 Premiums
• 👨‍👩‍👧 Beneficiary
• 💳 Payments
• 📎 Attachments

13. 🔄 Policy Booking CRUD Operations:

• 🧾 Individual Policy Booking
• 🏢 Partner Policy Booking
• 👥 Group Policy Booking

---

🛠 Requirements

• .NET Framework 8.0 or Higher
• MS SQL Server 16.0 or Higher
• Visual Studio

---

🔑 Default Authentication

You can decode and verify this JWT at jwt.io

📌 Header

{
  "alg": "HS256",
  "typ": "JWT"
}

📦 Payload

{
  "sub": "500329",
  "name": "John Doe",
  "role": "Sales Agent",
  "iss": "http://localhost:7175",
  "aud": "mc.ims.api",
  "exp": 1893456000
}

✍️ Signature

83afd726d5595c1eb62f0e5c839f52581b6ad0d13e4c6087ca8b764ab2c8409b
2401240e69236d1ef65bf76fa22ad731d8e252d585de3369c5b5545bdf9a6e6d

---

▶️ How to Run

1. Clone the repo:

   git clone https://github.com/MasterConnoisseurs/mc-2025-csharp-aspnetwebapi.git

2. Execute Database Script : Database Script 📄
3. Update the connection string to match your connection details.

"ConnectionStrings": {
  "DefaultConnection": "Server=localhost;Database=mc_ims;TrustServerCertificate=True;Trusted_Connection=True;"
},

---

🖼️ Gallery

Here are some screenshots of the MC Laundry Shop Application in action: