⚡ A modern stock management system with advanced filtering, export capabilities, and a real-time admin dashboard

A scalable and production-style stock tracking and management system built with ASP.NET Core MVC, Entity Framework Core, and SQL Server.

The application simulates a real-world business environment, enabling full control over inventory, suppliers, categories, and stock movements through a modern and responsive admin dashboard.

It focuses on data-driven decision making, clean and maintainable architecture, and high usability.

Overview of system features and real-time interactions

• 📦 Product Management (CRUD)
• 🏢 Supplier Management (CRUD + status toggle)
• 🗂️ Category Management
• 🔄 Stock In / Stock Out System
• 📊 Real-time Dashboard Statistics
• 📥 Export System (Excel / PDF with filtering support)
• ⚡ AJAX-based Status Updates (Active / Passive toggle)
• 🧾 Audit Log System (tracks all critical actions)
• 🔍 Advanced Filtering & Search
• 📅 Date-based filtering & sorting
• 🎨 Modern UI (Bootstrap 5 + custom styling)
• 📈 Stock analytics & insights

• Real-world business logic implementation
• Advanced filtering & reporting system
• Export functionality (Excel & PDF)
• Audit logging for traceability
• AJAX-powered dynamic UI

• ASP.NET Core MVC (Backend)
• Entity Framework Core (ORM)
• SQL Server (Database)
• Bootstrap 5 (UI Framework)
• JavaScript (AJAX, Fetch API)
• HTML5 / CSS3 (Frontend structure)

• Export filtered data directly from the admin panel
• Supports Excel (.xlsx) and PDF (.pdf) formats
• Preserves active filters during export operations

List	Create	Edit

List	Create	Details

List	Create	Edit

List	Create	Edit

Relational database structure designed for scalability

git clone https://github.com/MertcanKayirici/StockTrackingSystem.git

Open the project using Visual Studio / VS Code

Create a database named:

StockTrackingDb

Execute:

/Database/StockTrackingDb.sql

Update your appsettings.json:

"ConnectionStrings": {
  "DefaultConnection": "Server=.;Database=StockTrackingDb;Trusted_Connection=True;TrustServerCertificate=True;"
}

⚠️ You may need to adjust the server name depending on your local SQL Server configuration.

Run the project using Visual Studio (F5) 🚀

• Ensure SQL Server is running
• Update the connection string if needed
• Do not share sensitive credentials

• Controllers → Handle HTTP requests and business flow
• Models → Entity Framework data models
• Views → Razor UI components
• Database → SQL scripts and schema
• Screenshots → Project visuals & demos

• Layered MVC architecture
• Separation of concerns (Controller / Service / Data layers)
• Clear request flow (Controller → Service → Data access)
• Relational database design with constraints
• AJAX-driven dynamic UI
• Centralized Audit Log system
• Reusable UI components
• Business logic handled through structured layers

This project was built to simulate a real-world inventory management system and demonstrate:

• Scalable backend architecture
• Relational database design
• Business logic implementation
• Admin panel development

This project demonstrates the ability to build a real-world business application, not just a simple CRUD system.

It includes:

• Business logic handling (stock movements)
• Data consistency with relational database design
• Audit logging for traceability
• Dynamic UI with AJAX
• Reporting and export capabilities

This makes it closer to a real production system used in companies.

Mertcan Kayırıcı
Backend-focused Full Stack Developer ASP.NET Core & SQL Server

• GitHub: https://github.com/MertcanKayirici
• LinkedIn: https://www.linkedin.com/in/mertcankayirici

If you like this project, don't forget to star ⭐ the repository.