Skip to content

itsy-Wency/ASP.NET-Store-Management-System

Repository files navigation

🛒 ASP.NET Core MVC Store Management System

A full-featured CRUD web application built using ASP.NET Core MVC, Entity Framework Core, and SQL Server.


🚀 Overview

BestStoreMVC is a structured and scalable ASP.NET Core MVC application that demonstrates complete CRUD operations for managing store products.

It follows industry-standard practices:

  • MVC Architecture
  • Entity Framework Core (Code First)
  • SQL Server Integration
  • Clean project layering

This project is ideal for:

  • Portfolio showcasing
  • Academic submission
  • ASP.NET MVC learning

✨ Features

Feature Description
➕ Create Add new products
📄 Read View product listings
✏️ Update Edit product details
❌ Delete Remove products
🗄️ Database EF Core + SQL Server
📁 Structure Clean MVC architecture

🧱 System Architecture

Client (Browser)
      ↓
Controller (Handles Requests)
      ↓
Service Layer (Business Logic)
      ↓
Entity Framework Core (ORM)
      ↓
SQL Server (Database)
🛠️ Tech Stack


Layer	Technology
Backend	ASP.NET Core MVC
Language	C#
ORM	Entity Framework Core
Database	SQL Server
Frontend	HTML, CSS, JavaScript
Architecture	MVC Pattern

📂 Project Structure
BestStoreMVC/
│── Controllers/        # Request handling
│── Models/             # Data entities
│── Services/           # Business logic
│── Views/              # Razor UI
│── Migrations/         # EF Core migrations
│── wwwroot/            # Static assets
│── Program.cs          # Entry point
│── appsettings.json    # Configuration
⚙️ Installation Guide
1. Clone Repository
git clone https://github.com/itsy-Wency/ASP.NET-Store-Management-System.git
2. Open in Visual Studio
BestStoreMVC.sln
3. Configure Database

Edit:

appsettings.json
"ConnectionStrings": {
  "DefaultConnection": "Server=YOUR_SERVER;Database=BestStoreDb;Trusted_Connection=True;TrustServerCertificate=True;"
}
4. Apply Migrations
Update-Database
5. Run the Application

🔄 CRUD Workflow
Create → Add product
Read   → Display products
Update → Edit product
Delete → Remove product
🎯 Learning Outcomes

This project demonstrates:

MVC architecture implementation
Entity Framework Core migrations
Database-driven application development
Clean code organization
Full-stack CRUD operations
🚀 Future Improvements
🔐 Authentication & Authorization
🔍 Search & filtering
📊 Admin dashboard
📄 Pagination
🖼️ Product image upload
📱 Responsive UI (Bootstrap / Tailwind)
👨‍💻 Author

Wency Jorda
GitHub: https://github.com/itsy-Wency

⭐ Support

If you find this project useful, consider giving it a ⭐ on GitHub.

📜 License

This project is for educational and portfolio purposes.

About

ASP.NET Core MVC project showcasing full CRUD functionality with Entity Framework and SQL Server integration.

Topics

Resources

Stars

0 stars

Watchers

0 watching

Forks

Releases

No releases published

Packages

 
 
 

Contributors