What this project does? It uses the following stored procedures to add, update, and delete customers and/ or orders. 1. spAddCustomerOptionallyWithOrder First adds the customer, then if order information is also supplied, adds updates order related tables. 2. spUpdateCustomer Uplades changes to customer fields and also checks for concourency error. 3. spDeleteCustomer First deletes any orders this customer may have and then deletes the customer itself. 4. spDeleteOrderItem It deletes the composite primary key SoftwareID and OrderID from tblOrderDetails. Then it checks to see if there are no other records in this table with the same OrderID. If there were none, it deletes the same record from tblOrders as well. 5. spAddOrderToExistingCustomer First it adds a new OrderDate (which defuals to todays date). Then, It captures the auto generated OrderID to add it to tblOrderDetails along with SoftwareID and its matching quantity to complete the process. 6. spAddNewSoftwareTitles It opens a popup form to get Title, Description, and UnitPrice data from the user.
From novice to tech pro — start learning today.