EcomProject

A modular E-Commerce learning project built using ASP.NET Core Web API, ASP.NET Core MVC, and Entity Framework Core with SQL Server. This solution is structured into independent API, Data, and MVC layers following clean, maintainable practices.

🚀 Tech Stack

ASP.NET Core 10 (Web API + MVC)

Entity Framework Core + SQL Server

EF Core Migrations (Category & Product tables)

Repository Pattern

Swagger / OpenAPI

JWT Authentication (Implemented inside Ecom.API only)

📂 Solution Structure EcomProject │ ├── Ecom.API → REST API (Category & Product CRUD + JWT Auth) │ ├── Controllers │ ├── JWT authentication (local to this project) │ ├── Swagger documentation │ ├── Ecom.Data → Data Access Layer │ ├── DbContext (EcomDbContext) │ ├── Entities (Category, Product) │ ├── Repositories (Interface + Implementation) │ ├── Migrations (EF Core) │ └── Ecom.MVC → MVC Frontend (to consume API later) ├── Controllers ├── Views ├── Models

🔐 Authentication

JWT Authentication is implemented only inside Ecom.API

Login endpoint returns a JWT token

API endpoints validate the token

AuthService.API is NOT integrated yet (planned future step)

🗄️ Database

Using SQL Server

EF Core migrations executed successfully

Tables created:

Categories

Products

Products have a foreign key referencing Categories

📘 Current Features ✅ Category API

Get all categories

Get category by ID

Create category

Update category

Delete category

✅ Product API

Get all products

CRUD operations

Category relationship included

✅ Database Layer

Fully implemented repository pattern

EF Core migrations applied

SQL Server connection configured

⚠️ MVC Project

MVC created

API integration (calling Ecom.API) coming soon

📌 Upcoming Features

Full integration of MVC UI ↔ Ecom.API

Move Authentication to AuthService.API (external microservice)

Add custom JWT middleware

Product image upload

Pagination / filtering / sorting

Admin & user roles

Deployment

🧪 Testing the API (Swagger)

Run API and open:

https://localhost:/swagger

▶️ How to Run Locally 1️⃣ Update DB Connection

In appsettings.json of Ecom.API:

"ConnectionStrings": { "DefaultConnection": "your SQL Server connection string" }

2️⃣ Apply Migration (already done but for future updates) dotnet ef database update --project Ecom.Data

3️⃣ Run API dotnet run --project Ecom.API

4️⃣ Run MVC (UI) dotnet run --project Ecom.MVC

🤝 Contributions

This is a learning project — improvements and suggestions are welcome.

⭐ Support

If this project helps you in interviews or learning, please ⭐ the repository!