The project being presented is a Inventory Management System desktop application. The goal is to improve the client's current inventory system. Our client is Rose hill foods inc located in Montreal, it was founded in 1983 by George Serbanis and his team of professionals. Rosehill inc foods manufactures and supplies the food service industry with quality soups, sauces, seasonings, and along with its Original 86 division, offers a wide range of premium grade, high-end products such as stock bases, liquid sauces, marinades and glazes. To make the prototype app we are determined to communicate every weekday and once every sunday. In these meetings each person provides a summary of what they are working on, progress updates and any blockers. We will closely keep track of individual progress and to make sure that no one is behind on the project schedule.
Client
-
Rose Hill Foods Inc
Located at 7171 Thimens Blvd.
Saint-Laurent (Montreal) , QC H4S 2A2
User Case
SOON
ERD diagram
SOON
Class Diagram
SOON
Features
4 types of users and each one has its own user privilege
User Authentication - user has to login with their credentials in order to use the application
The ability track and manage inventory in real-time
Built in time and date display functionality
The ability to create a new item and add it to the database
The ability to fetch all items in the database and display it in datagrid view which can be sorted in many ways.
The ability to search an item by product code or product name and displays it in datagrid view which can be sorted in many ways.
The ability to filter items by code, name, category, size, quantity, etc.
The ability to modify item information's
The ability to delete existing item
The ability to notify the user when a product is at low stock levels
The ability to produce report and the option to print
The ability to check the user guide in the help menu window
The ability to show confirmation messages to the user when performing action that affects the database
Input validation and robustness
Future improvements (Functionality / Design)
Add the ability to increment the item quantity if an item is returned
Optimization - implementation of multi threading or async
Redesign Report UI and add the ability to produce report by monthly or yearly
Add the ability to create new user
Add pagination when the datagrid contains 100 items