Inventory Management System

A full-stack Inventory Management System built with Angular and .NET Core APIs, featuring comprehensive book inventory tracking, sales and purchase management, supplier management, and user authentication.

📑 Table of Contents

• ✨ Features
• 🛠️ Tech Stack
• 📜 Project History
• 🚀 Quick Start with Docker
• 💻 Development Setup
  • A. Backend
  • B. Frontend
• 🔧 Entity Framework Migrations
• 📸 Screenshots
• 🤝 Contributing
• 📄 License
• ⭐ Show Your Support

✨ Features

• 📚 Book Management: Add, edit, delete, and search books with detailed information
• 📊 Inventory Tracking: Real-time inventory monitoring and stock level management
• 💰 Sales Management: Record and track sales transactions with PDF report generation
• 🛒 Purchase Management: Manage purchase orders and supplier transactions with PDF export
• 🏢 Supplier Management: Maintain supplier information and relationships
• 👤 User Authentication: Secure login system with role-based access control
• 📄 PDF Reports: Generate detailed PDF reports for sales and purchase records
• 🎨 Modern UI: Clean and responsive interface built with Angular Material
• 🔍 Advanced Search: Filter and search across all entities
• 📱 Responsive Design: Works seamlessly on desktop and mobile devices

🛠️ Tech Stack

• Backend: ASP.NET Core Web API 10.0
• Database: PostgreSQL 16 (migrated from SQL Server 2022)
• ORM: Dapper (primary) + Entity Framework Core (for migrations)
• Frontend: Angular 20
• UI Library: Angular Material
• State Management: NgRx Component Store & Signals
• Containerization: Docker & Docker Compose

📜 Project History

This project has evolved significantly since its inception:

Early 2024 - Initial Development

• Started with .NET 8 and Angular 17
• Originally maintained as two separate repositories (frontend & backend)
• Used SQL Server 2022 with stored procedures

Major Upgrades & Migrations

• ✅ Upgraded to .NET 10 and Angular 20
• ✅ Migrated from SQL Server to PostgreSQL - A challenging but rewarding experience that deepened my understanding of database migrations without relying solely on Entity Framework
• ✅ Consolidated into a single monorepo for better maintainability

Feature Additions

• ✅ Supplier management system
• ✅ User authentication and authorization
• ✅ PDF report generation for sales and purchases
• ✅ Enhanced UI with Angular Material

Technical Improvements

• ✅ Added Entity Framework Core for database migrations (maintaining dual databases across machines was challenging!)
• ✅ Implemented NgRx Component Store for state management
• ✅ Adopted Angular Signals for newer features
• ✅ Docker support for easy deployment

🚀 Quick Start with Docker

The easiest way to get started is using Docker:

1. Navigate to the src directory:

   cd src

2. Start the containers:

   docker compose up -d

3. Open your browser and visit: http://localhost:3001/

That's it! The application should be running with all dependencies configured.

💻 Development Setup

Prerequisites:

• .NET 10.0 SDK
• Node.js (latest LTS version)
• Angular CLI
• PostgreSQL 16

Installation Steps:

1. Clone the repository:

   git clone https://github.com/rd003/InventoryMgt.git

2. Navigate to the project directory:

   cd InventoryMgt

3. Open in VS Code (optional):

   code .

You'll need to set up both the backend and frontend separately:

A. Backend

1. Navigate to the backend API directory:

   cd backend/InventoryMgt.Api

2. Update the connection string in appsettings.json:

   "ConnectionStrings": {
     "DefaultConnection": "Host=localhost;Database=InventoryMgtDb;Username=your_user;Password=your_password"
   }

3. Run the application:

   dotnet run

   The database will be automatically created and seeded with initial data on first run.

B. Frontend

1. Open a new terminal and navigate to the frontend directory:

   cd frontend/InventoryMgt.Client

   (Keep the backend terminal running)

2. Install dependencies:

   npm install

3. Start the development server:

   ng serve --open

4. The application will open in your browser. Use these credentials to log in:

   Username: admin
   Password: Admin@123
   

🔧 Entity Framework Migrations

If you encounter issues running migrations with the .NET CLI (due to multiple projects), use these commands:

Common Error:

Unable to create a 'DbContext' of type 'RuntimeType'...

Solution:

Navigate to the backend directory first:

cd backend

Creating a Migration:

dotnet ef migrations add YourMigrationName --project InventoryMgt.Data --startup-project InventoryMgt.Api

Replace YourMigrationName with a descriptive name (e.g., AddSupplierTable)

Updating the Database:

dotnet ef database update --project InventoryMgt.Data --startup-project InventoryMgt.Api

Note: Migrations are automatically applied when you run the application, but you can manually execute them using the command above.

Tip: If using Visual Studio, you can use the Package Manager Console instead, which handles multi-project solutions more gracefully.

---

📸 Screenshots

---

🤝 Contributing

Contributions are welcome! If you'd like to contribute:

1. Fork the repository
2. Create a feature branch (git checkout -b feature/AmazingFeature)
3. Commit your changes (git commit -m 'Add some AmazingFeature')
4. Push to the branch (git push origin feature/AmazingFeature)
5. Open a Pull Request

📄 License

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

---

⭐ Show Your Support

If you found this project helpful, please consider giving it a star on GitHub! ⭐

Built with ❤️ by rd003