Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.
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.
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.