InventoryManager

using C#, MS sql server

.Net Framework 4.7.2 Microsoft.Office.Interop.Excel 15.0.4795.1000 System.Data.SqlClient 4.8.2

Purpose

• an inventory management system for a home pantry
• can keep track of quantity, storage, expiry date of food
• CRUD features for items

Features

• login form
• acquire data using SQL server
• sort/search + CRUD
• error handling
• export function to download an Excel file

login

Inventory - view

add/update/delete

Search by name

group by freshness

group by food type

group by stock quantity

export to excel