Description

Development of Canteen Management System using VB.net and MySQL

This project focuses on the development of a Canteen Management System using VB.net and MySQL database. We will provide student-friendly programming examples for this project. The primary goal of this system is to offer efficient services to company employees by utilizing their saved records. The system is designed to manage details related to Food, Items, Sales, Products, and Canteen. It facilitates the management of information regarding Food, Orders, Canteen, and more. Customers can easily access their account status, services availed, bills paid, and any due amounts. This project provides basic VB codes that students can easily configure and learn from. We offer free downloads of the VB project along with the database.

Below the description, you will find attached screens and a demo video of the Canteen Management System project for further clarification.

Modules and Description of Canteen Management System:

Employee Module:

The Employee Module is designed to handle all functionalities related to employees. It tracks employee information and supports CRUD operations. This role-based module allows the admin to perform all operations on data, while employees can only view their own data, ensuring access level restrictions are implemented.

Features of Employee Module:

• Admin can add new employee records
• Admin can view the list of employee details
• Admin can edit and update employee records
• Admin can delete employee records
• Client-side validation of all employee forms using JavaScript

Item Module:

The Item Module is developed to manage items within the Canteen Management System project. Admin has control over all items.

Features of Item Module:

• Admin can manage items
• Admin can edit/delete items
• Admin can view the list of all items
• Employees can view their assigned items

Stock Module:

The Stock Module is created to manage stock within the system. Admin has the authority to manage all stock items.

Features of Stock Module:

• Admin can manage stock
• Admin can edit/delete stock items
• Admin can view the list of all stock items
• Employees can view their assigned stock items

Sales Module:

The Sales Module focuses on functionalities related to sales. It tracks sales information and details.

Features of Sales Module:

• Admin can add new sales records
• Admin can view the list of sales details
• Admin can edit and update sales records
• Admin can delete sales records
• Client-side validation of all sales forms using JavaScript

Functionality of the Canteen Management System Project:

The project includes the following functionalities:

• Login for Admin
• Forgot password for Admin
• Edit Profile for Admin
• Change Password for Admin
• Logout Functionality
• Dashboard for Admin User
• Manage Employee
  • Add New Employee
  • Edit Existing Employee
  • View Employee Details
  • List all Employees
• Manage Item
  • Add New Item
  • Edit Existing Item
  • View Item Details
  • List all Items
• Manage Stock
  • Add New Stock
  • Edit Existing Stock
  • View Stock Details
  • List all Stock
• Manage Sales
  • Add New Sales
  • Edit Existing Sales
  • View Sales Details
  • List all Sales
• Reports of the Canteen Management System Project
  • Employee Reports
  • Item Reports
  • Stock Reports
  • Sales Reports

Technology Used in the Canteen Management System Project:

The project is developed using the following technologies:

• VB.net: Front end and business logic are written in VB.net
• MySQL Server: MySQL Database is used for data storage
• Operating System: The project runs on Windows operating system
• Database Portability (MS Access): The project can also be set up with MS Access Database