📦 Inventory Management System

An enterprise-grade inventory management solution built with ASP.NET Core, featuring Clean Architecture principles and Domain-Driven Design patterns.

🌟 Overview

DevSkill Inventory is a comprehensive inventory management system designed for businesses to efficiently manage their products, sales, customers, and financial transactions. Built with modern .NET technologies and cloud-native architecture, this application ensures scalability, security, and maintainability.

Why This Project?

🏗️ Clean Architecture: Separation of concerns for better maintainability
🔐 Enterprise Security: Role-based and claim-based access control
☁️ Cloud-Ready: AWS S3 and SQS integration
📊 Real-Time Insights: Comprehensive reporting and analytics
🐳 Container-First: Docker support for easy deployment

✨ Features

📦 Product Management

Complete CRUD operations for products
Category-based product organization
Stock level tracking with low-stock alerts
Dual pricing support (MRP, wholesale)
Image upload with automatic resizing (AWS S3)

💰 Sales & Financial Management

Multi-type sales transactions (MRP, wholesale)
Payment status tracking
Customer balance management
Account transfers (Cash, Bank, Mobile)
Comprehensive sales reporting

👥 Customer Management

Customer database with purchase history
Balance tracking
Customer-specific pricing
Relationship management

🔐 Security & User Management

Hybrid authentication (role + claim-based)
Fine-grained permission system
Employee management
Department and unit management
Secure password policies with ASP.NET Core Identity

⚡ Advanced Features

Background job processing for image resizing
AWS SQS message queuing
Email notifications
Real-time dashboard
Audit logging with Serilog

🏗️ Architecture

This project implements Clean Architecture with Domain-Driven Design (DDD) principles, ensuring a clear separation of concerns and high testability.

Project Structure

DevSkill.Inventory/
├── DevSkill.Inventory.Domain/          # Core business logic & entities
│   ├── Entities/                       # Domain models
│   ├── Interfaces/                     # Repository & service contracts
│   └── DTOs/                          # Data transfer objects
│
├── DevSkill.Inventory.Application/     # Use cases & business logic
│   ├── Features/                       # CQRS commands & queries
│   ├── Services/                       # Application services
│   └── Mappings/                       # AutoMapper profiles
│
├── DevSkill.Inventory.Infrastructure/  # External concerns
│   ├── Data/                          # EF Core & repositories
│   ├── Identity/                      # Authentication & authorization
│   └── Services/                      # External service implementations
│
├── DevSkill.Inventory.Web/            # Presentation layer
│   ├── Controllers/                   # MVC controllers
│   ├── Views/                         # Razor views
│   └── wwwroot/                       # Static files
│
└── DevSkill.Inventory.Worker/         # Background processing
    └── Jobs/                          # Scheduled tasks

Design Patterns

Pattern	Implementation	Benefits
🏛️ Repository	Data access abstraction	Testability, persistence ignorance
🔄 Unit of Work	Transaction management	Data consistency, atomic operations
⚡ CQRS	MediatR implementation	Scalability, separation of concerns
🔌 Dependency Injection	Autofac container	Loose coupling, maintainability

🛠️ Technology Stack

Backend

Framework: ASP.NET Core MVC (.NET 9)
ORM: Entity Framework Core
Database: Microsoft SQL Server (with stored procedures)
Authentication: ASP.NET Core Identity (extended)
Patterns: CQRS via MediatR

Frontend

UI Framework: AdminLTE
Templating: Razor Pages
Styling: Bootstrap 5 + Custom CSS
JavaScript: Modern ES6+

Cloud & DevOps

Storage: Amazon S3 (image storage)
Messaging: Amazon SQS (async processing)
Containerization: Docker & Docker Compose
Logging: Serilog

Development Tools

DI Container: Autofac
Object Mapping: AutoMapper
Testing: NUnit, Moq, Shouldly
Code Coverage: Coverlet

🚀 Getting Started

Prerequisites

Before you begin, ensure you have the following installed:

✅ .NET 9 SDK
✅ SQL Server 2019+ or Docker
✅ Visual Studio 2022 or VS Code
✅ EF Core CLI Tools: dotnet tool install --global dotnet-ef

Optional (for full features)

🪣 AWS Account with S3 bucket
📨 AWS SQS Queue configured
🔑 AWS IAM credentials

📥 Installation

Method 1: Local Development

Clone the repository

git clone https://github.com/your-username/DevSkill.Inventory.git
cd DevSkill.Inventory

Restore dependencies
```
dotnet restore
```

Update database connection

Edit DevSkill.Inventory.Web/appsettings.json:

{
  "ConnectionStrings": {
    "DefaultConnection": "Server=localhost;Database=InventoryDB;Trusted_Connection=true;"
  }
}

Apply database migrations

cd DevSkill.Inventory.Web
dotnet ef database update

Run the application
```
dotnet run
```
Access at: https://localhost:5001 or http://localhost:5000

Method 2: Docker Deployment (Recommended)

Clone and navigate

git clone https://github.com/your-username/DevSkill.Inventory.git
cd DevSkill.Inventory

Configure environment variables

Create .env file:

DB_CONNECTION=Server=sql-server;Database=InventoryDB;User=sa;Password=YourStrong@Passw0rd
AWS_REGION=us-east-1
AWS_ACCESS_KEY=your_access_key
AWS_SECRET_KEY=your_secret_key
AWS_S3_BUCKET=your-bucket-name
AWS_SQS_URL=your-sqs-url

Launch with Docker Compose
```
docker-compose up --build -d
```
Access at: http://localhost:8000

⚙️ Configuration

AWS Configuration (Optional)

For full functionality with image storage and background processing:

{
  "AWS": {
    "Profile": "your-profile",
    "Region": "us-east-1",
    "BucketName": "your-inventory-bucket",
    "SqsUrl": "https://sqs.us-east-1.amazonaws.com/your-account/your-queue",
    "UrlExpiryMinutes": 15
  }
}

Default Admin Credentials

After first run:

Email: [email protected]
Password: 123456

⚠️ Important: Change these credentials immediately after first login!

🧩 Core Modules

Accounts Module

Manages financial accounts and transaction types:

Cash accounts
Bank accounts
Mobile banking accounts
Balance transfers

Categories Module

Product categorization system:

Hierarchical categories
Category-based filtering
Bulk category operations

Customers Module

Customer relationship management:

Customer profiles
Purchase history
Balance tracking
Customer analytics

Products Module

Core inventory functionality:

Product CRUD operations
Stock management
Pricing (MRP & wholesale)
Image management
Low-stock alerts

Sales Module

Sales transaction processing:

Order creation
Payment tracking
Sales reports
Invoice generation

Users Module

Identity and access management:

User authentication
Role management
Claim-based permissions
Employee assignments

🐳 Docker Deployment

The project includes a complete Docker setup with multi-service orchestration.

Docker Compose Structure

services:
  - web: ASP.NET Core web application
  - worker: Background processing service
  - sql-server: Microsoft SQL Server database

Quick Start with Docker

# Build and start all services
docker-compose up --build -d

# View logs
docker-compose logs -f

# Stop services
docker-compose down

# Stop and remove volumes (⚠️ deletes data)
docker-compose down -v

🧪 Testing

Run the comprehensive test suite:

# Run all tests
dotnet test

# Run tests with coverage
dotnet test /p:CollectCoverage=true /p:CoverletOutputFormat=opencover

# Run specific test project
dotnet test DevSkill.Inventory.Tests

Test Structure

Unit Tests: Domain and application logic
Integration Tests: Database and external services
E2E Tests: Complete user workflows

🤝 Contributing

We welcome contributions! Please follow these guidelines:

Fork the repository
Create a feature branch
```
git checkout -b feature/AmazingFeature
```
Commit your changes
```
git commit -m 'Add some AmazingFeature'
```
Push to the branch
```
git push origin feature/AmazingFeature
```
Open a Pull Request

Code Standards

Follow C# coding conventions
Write unit tests for new features
Update documentation as needed
Ensure all tests pass before submitting

📄 License

This project is licensed under the MIT License - see the LICENSE file for details.

📞 Contact

Nazmul

💼 LinkedIn: https://linkedin.com/in/md-nazmulhasan
🐙 GitHub: https://github.com/na2mul
📧 Email: [email protected]

🙏 Acknowledgments

Clean Architecture principles by Robert C. Martin
Domain-Driven Design by Eric Evans
ASP.NET Core community
All contributors who have helped this project

⭐ If this project helped you, please consider giving it a star!

Made with ❤️ using ASP.NET Core

Report Bug · Request Feature

Name		Name	Last commit message	Last commit date
Latest commit History 75 Commits
DevSkill.Inventory		DevSkill.Inventory
Tests/DevSkill.Inventory.Application.Tests		Tests/DevSkill.Inventory.Application.Tests
volume		volume
.gitignore		.gitignore
README.md		README.md

na2mul/Inventory-Management-System

Folders and files

Latest commit

History

Repository files navigation