xaoijin / bakery-ordering-inventory-system

Bakery Ordering/Inventory System

Using Microsoft Access as Database
Capstone Project Making A Database
Code Contributors: Johnson Li-FullStack Developer Role and Cyril Thomas-FrontEnd Developer Role

Code Displays on Console

The BOSS system is a comprehensive software solution intended for bakeries to allow ordering to be done on a system. The days of paper and pencil or over. The BOSS systems help bakeries manage their orders, invoices, and customer data. Customers are allowed to access the system through a login menu and are presented options to view the bakery, create an order, check an order’s status, cancel an order, and view their order history. The Employees view of the system allows the employee to view the current offerings of the bakery, views the orders, change the status of the orders and access to a customer’s contacts to notify the customer for completion or changes to their order. The system allows all users to create an account with the system and assigns them a unique userID. The Create Account methods queries the user for personal data and performs a check if the user is a customer or employee through an input of an employee access code. Accounts are created and stored in a vector and updates into the database allowing created accounts to be used immediately. Unique IDs are created for user creation and order ID’s. The system verifies if the user already exists and prompts the user for valid inputs. The system utilizes vectors data structures to manage invoices, customer information and product offerings and update into the database. The system is integrated with an Access Database and SQL injections. The searching method searches orders through a unique userID – matching customer orders to customers. The searching method also searches for “In-Progress” and “Started Orders” to display existing in progress orders. The searching method utilizes the vector data structure to iterate through products, user information, and orders. While placing orders, customers are able to view the bakery – select a product and enter the quantity they wish to order. The system will capture this data and calculate the total cost for this customer on their invoice. Employees are able to check order information and change the status of the order for transparency as the order gets processed. Customers will be able to check their status and contact the bakery for any additional concerns Testing with multiple cases have been completed to assure validity of user inserts and issues. The BOSS system can later be implemented as a framework for a POS system that can accept and process payment for a bakery environment. Also plans for a delivery and SMS service are intended for future updates. The system can be scalable to adapt to future needs of the bakery business.