Skip to content

zyrridian/restaurant-management-system

Repository files navigation

Restaurant Management App

This is a Windows Forms-based Restaurant Management App developed using VB.NET and SQL Server. It features role-based access for Admins and Cashiers to manage restaurant operations like menus, orders, payments, and reports.

Features

  • Admins: Manage menu items, member info, orders, and generate reports.
  • Cashiers: Handle payment processing.

How to Install

Prerequisites

  • SQL Server installed on your system.
  • Visual Studio (or similar IDE supporting VB.NET development).

Step-by-Step Instructions

  1. Clone the Repository:
    Download or clone the repository from GitHub to your local machine.

  2. Setup the Database:

    • Ensure SQL Server is installed on your computer.
    • Refer to the database structure diagram provided in the repository.
    • Using SQL Server Management Studio (SSMS) or a similar tool, create a new database with the exact structure shown in the diagram.
      • Make sure to match the Primary Key, Foreign Key, Allow Null, etc.
      • Set MenuID, MemberID, and OrderDetailID fields to auto-increment (Identity).
      • The database structure must be 100% identical. Any discrepancies will require manual changes in the code.
  3. Database Structure: alt text

  4. Configure User Roles:
    The two roles provided are:

    • Admin
    • Cashier

    If you wish to change these roles, you will need to modify the code accordingly.

  5. Run the Application:
    Open the project in Visual Studio, ensure that the database connection string in the code matches your SQL Server setup, and run the app.

Screenshots

ss1 ss2 ss3 ss4 ss5 ss6 ss7 ss8 ss9

About

Restaurant App using VB .NET & SQL Server DB

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published