Cafe Management System Readme

Overview

The Cafe Management System is a comprehensive project developed using SQL and C# to manage the operations of a cafe. This system incorporates a relational database with tables for managers, cashiers, customers, items, orders, payments, and inventory. It facilitates user logins for customers, cashiers, and managers, offering features such as order placement, inventory management, and basic administrative tasks. Additionally, the project includes a feedback system and sales report functionality.

Features

• User Authentication: Secure logins for customers, cashiers, and managers.
• Order Placement: Customers can place orders, and cashiers can process them.
• Inventory Management: Managers can update, delete, and view inventory details.
• Administrative Tasks: Basic management functions for customers and cashiers.
• Feedback System: Collect feedback from customers for improvement.
• Sales Report: Generate reports to analyze sales and performance.

Requirements

• Programming Languages: SQL, C#
• Database: SQL Server
• Operating System: Windows

Setup Instructions

1. Database Setup:

   • Execute the SQL script provided in the project to create and populate the necessary tables.
   • Ensure a running SQL Server instance with the appropriate permissions.

2. C# Application:

   • Open the C# project in a suitable development environment.
   • Update the database connection string in the code with your SQL Server details.

3. Run the Application:

   • Build and run the C# application.
   • Use the provided user interface to access different functionalities.

Usage

1. User Logins:

   • Access the system with respective credentials for customers, cashiers, and managers.

2. Order Placement:

   • Customers can place orders for items available in the menu.
   • Cashiers process orders and update the system.

3. Inventory Management:

   • Managers can manage inventory by updating, deleting, or viewing item details.

4. Administrative Tasks:

   • Perform basic management functions for customers and cashiers.

5. Feedback System:

   • Collect and analyze customer feedback to improve services.

6. Sales Report:

   • Generate sales reports to gain insights into cafe performance.

Contributors

• [AAIMLIK ABBASI]
• [MUHAMMAD HAMMAD]

CUSTOMER LOGIN

CUSTOMER SIGN UP

ORDER PLACEMENT

PAYMENT

FEEDBACK

SQL UPDATION

MANAGER LOGIN

MANAGER DASHBOARD

INVENTORY ITEM

INVENTORY UPDATE

CASHIER INSERTION

REPORTS

CASHIER DASHBOARD