RestaurantMS 🍽️

A simple Restaurant Management System built with ASP.NET Core MVC and Entity Framework Core.
The project is designed to demonstrate the basic workflow of managing a restaurant's products, categories, ingredients, and orders.

---

📌 Project Overview

This system allows restaurant staff to:

• Manage Products and Categories.
• Track Ingredients used in each product.
• Create and manage Orders.
• Relate Orders with specific Products.

The goal is to build a simple, clean system that represents a real-life restaurant scenario.

---

🗄️ Database Design

The database follows a relational model to cover all entities of the restaurant:

• Category ↔ Product: One-to-Many (each product belongs to one category).
• Product ↔ Ingredient: Many-to-Many (through ProductIngredient).
• Order ↔ Product: Many-to-Many (through OrderItem).
• User ↔ Order: One-to-Many (each user can place multiple orders).

ER Diagram:

---

Technologies Used

• C# / ASP.NET Core MVC
• Entity Framework Core
• SQL Server
• Bootstrap, HTML, CSS

---

Project Structure

RestaurantMS/
├── Areas/
│   └── Identity/       # Identity (Authentication & Authorization) scaffolding
│       ├── Pages/      # Razor Pages for login, register, manage account, etc.
│       └── Data/       # IdentityDbContext & migrations related to Identity
├── Controllers/        # MVC Controllers (Product, Category, Ingredient, Order, etc.)
├── Models/             # Entity Models (Product, Category, Ingredient, Order, ApplicationUser)
├── ViewModel/          # ViewModels like OrderVM for passing combined data to Views
├── Data/               # DbContext, Repositories, and EF Core Migrations
├── Views/              # Razor Views for each controller
├── wwwroot/            # Static files (CSS, JS, images, ER Diagram, etc.)
├── Program.cs          # Application entry point & service configuration
└── appsettings.json    # Database connection strings & app configuration