Order process:

[cjdomacena]

• Calculate Cart Items
• Verify the current product price against the Products table
  - Since our Cart is table based it can be long lived so if a user added a Product at a sale and they attempt to purchase afterwards, it should pull the true Product cost
• Verify desired product and desired quantity are still available in the Products table
• Make an entry into the Orders table
• Get last Order ID from Orders table
• Copy the cart details into the OrderItems tables with the Order ID from the previous step
• Update the Products table Stock for each item to deduct the Ordered Quantity
• Clear out the user’s cart after successful order
• Redirect user to Order Confirmation Page