Admin Menu

1. Add a new product: Using this option, the admin can update the database with a new product. The programme prompts the administrator to enter the product name, category, price, and quantity after selection. The new product is then added to the database, and the programme shows a success message.

2. Update an existing product: The admin can use this option to change a product's details that are already stored in the database. When this option is chosen, the programme prompts the administrator to provide the product ID of the item that needs to be updated together with the amended name, category, price, and quantity. The product is then updated in the database, and the programme shows a success message.

3. Delete a product: The administrator can remove a product from the database using this option. After choosing, the programme prompts the administrator to provide the product ID of the deleted product. The product is subsequently deleted from the database, and a success message is then shown.

4. View all products: The admin can view every item in the database with this option. Upon selection, the programme presents all available goods in a tabular format after retrieving them all from the database.

5. Search for a product: The admin can use this option to search the database for a certain product by providing its name. Following that, the programme retrieves every item that matches the search term and shows it in a table manner.

Employee Menu

1. Place an order: This option allows the employee to place an order for a product. The programme prompts the worker to enter the product ID and amount after selection. After adding the order to the database, the programme shows a success message.

2. View orders: This option allows the employee to view all the orders placed. Upon selection, the programme displays all orders in table format after retrieving them from the database.

3. Update order status: This option allows the employee to update the status of an order. When this option is chosen, the programme asks the worker to input the order ID and the updated status. The programme then displays a success message and updates the order status in the database.

4. View Cart: This option allows the customer to view all the products added to the cart. When chosen, the programme pulls every item from the shopping basket and arranges it in a table.

5. Place an order: This option allows the customer to place an order for the products in the cart. The customer is asked to confirm the order when the option is selected by the programme. The programme then uploads the order to the database and displays a success message if the customer confirms the order.

6. View order history: This option allows the customer to view their order history. When selected, the program prompts the customer to login. After the customer logs in, the program retrieves all the orders placed by the customer and displays them in a table format.

Common Funtionalities

1. Login: The user can log in as an administrator, an employee, or a customer using this option. The programme asks the user to input their login and password when they make their choice. The programme logs the user in and displays a success message if the credentials are valid. The programme displays an error notice and asks the user to try again if the credentials are entered incorrectly.

2. Register: The user can sign up to become a customer using this option. The user must input their name, username, password, email address, and phone number when the option is selected by the user. The customer is then added to the database, and a success message is then shown.

3. Logout: The user can log out of their account using this option. As soon as this option is chosen, the programme logs the user out and shows a success message.

4. Exit: This option allows the user to exit the program.