Overview
This should be a DLL with two forms, which contains the following classes and methods.
Edit_Shortages class
This class handles all the database access.
This class should at least have the following functions:
1. Delete_Item
a.) This accepts an invoice number and an Item, then deletes the matches from the database
b.) The Item view should update when the item is deleted.
2. Edit_Item
a. This function accepts an invoice number and an Item, and allows the user to edit the quantity of that item.
b. The item View should update when the item is deleted.
View_Shortages form
This is the main form, and should present the user with a datagrid view of all of the items on the shortage table, along with controls for the edit and delete functions.
1.) Double clicking on a row in the datagrid should bring up the Edit_Item form for that item.
2.) Clicking the Edit button should also bring up the Edit_Item form, allowing the user to manually enter the Invoice number.
3.) Clicking the delete button should prompt the user whether they want to delete the currently selected row in the datagrid.
Edit_Items form
This form should present the user with a field to enter the invoice number, and a search button. Once the invoice is entered, and the search button is pressed, the user should then be given a datagrid with the items which correspond to that invoice. Double clicking on one of the rows should present the user with a box which will allow the user to edit the quantity.
1.) There should be error handling for invoices not in the database.
2.) A delete button on this form would also be nifty.