Penny Ahlstrom Logo
Back to All Demos

Smart Inventory Management System 1

Developed a full-stack inventory management system to help small businesses track products, manage orders, and monitor stock levels, with support for search, filtering, and guest order functionality.

C#JavaScriptASP.NET Core.NETEntity FrameworkBootstrapPostgreSQL

This project is a database-driven web application designed to support inventory management for small businesses. The system allows users to manage products and categories, track inventory levels, and create basic orders without requiring user authentication. Core functionality includes full CRUD operations for products, including tracking stock quantities and low-stock thresholds. The interface was styled using Bootstrap to create a responsive and user-friendly layout. The application also supports dynamic search, filtering, and sorting, allowing users to quickly locate products by category, price range, or stock status. A guest order system was implemented to allow users to create and review orders, including product selection and total price calculation. The application was built using the ASP.NET Core MVC architecture, separating concerns across models, views, and controllers to ensure maintainability and scalability. The database was designed with relational structure and data integrity in mind, including normalized tables for products, categories, and orders, with appropriate relationships and constraints. Entity Framework Core migrations were used to manage schema changes and support reproducibility. This project demonstrates the ability to design and implement full-stack, database-driven applications with a focus on usability, structured data management, and real-world business functionality.