Restaurant Management System

A role-based C# Windows Forms restaurant management application built with .NET Framework and SQL Server.
The system supports multiple user roles — Admin, Manager, Chef, and Customer — and covers key restaurant operations such as ordering, kitchen workflow, refunds, feedback handling, wallet management, reporting, and account administration. This is a group project with 3 other people, I did the chef functionality in the code and also compiling the code overall. This was a group project completed with three other team members. My main contribution was developing the chef-side functionality of the application, and I also played a major role in integrating and compiling the overall codebase to ensure the system worked properly as a whole.

Demo Youtube Link

https://youtu.be/Dk-7s9YHzKw

Features

Customer

• Sign up and log in
• Browse menu items
• Sort menu items by name, price, category, and duration
• View menu item details
• Place and manage orders
• View current orders
• View order history
• Submit feedback
• Request refunds
• Access wallet / top-up related functionality
• Manage account settings

Chef

• View incoming orders
• Filter orders by today
• View order details
• Monitor order-related workflow
• View top-selling items today
• View top-selling items overall
• Access food/menu-related forms
• Manage profile/settings

Manager

• Review customer feedback
• Handle top-up related processes
• Handle refund requests
• View restaurant statistics
• Access settings/profile

Admin

• Access dashboard
• Manage users
• View chef reports
• View customer reports
• Manage money-related data
• Access profile/settings

---

Key Strengths

• Multi-role system architecture with different interfaces and responsibilities
• Database-backed application using SQL Server
• Role-based login redirection after authentication
• Covers both customer-facing and staff-facing workflows
• Includes operational features such as refunds, feedback, and wallet handling
• Uses structured folders for clearer organization, such as:
  • LoginPage
  • RoleCustomer
  • RoleChef
  • RoleManager
  • roleadmin

---

Tech Stack

• Language: C#
• Framework: Windows Forms / .NET Framework 4.7.2
• Database: SQL Server
• Database Access: ADO.NET / System.Data.SqlClient
• IDE: Visual Studio

---

Database Setup

This project requires SQL Server to run.

A setup script is included:

database-setup.sql

This file contains:

• the database schema

• required tables

• sample seed data for testing/demo purposes

Steps

• Open SQL Server Management Studio.

• Run database-setup.sql.

• Update the connection string in DatabaseHelper.cs to match your SQL Server instance

• Open the solution in Visual Studio and run the app

Notes

• The current database connection is machine-specific and may need to be changed before running on another computer.

• This project is intended for learning, demonstration, and portfolio purposes.