Shopping Cart

For this solution, you create the core features of a shopping cart. The solution should work as follows:

The user needs to buy some teabags for his mobile café. He goes to a popular online shop. He clicks the Beverages category and sees the list of teabags. He clicks the Buy link and is taken to another page, where he can choose the quantity. He selects 10 boxes of teabags and adds them to his shopping cart. The page now refreshes, and he sees the contents of his shopping cart.

The user then buys coffee, and his cart is updated again. The user realizes he does not need the coffee after all, so he clicks the X link to delete the coffee from his cart.

The user finishes choosing items, clicks Go, and is taken to the Checkout link. He is prompted for his forename, surname, address, postcode, phone, and email address, which he fills in, and is taken to the payment screen. The user can choose to pay with Credit Cards-Visa or Master Card.

Create a small web site to implement the functionalities of the above use case. You can add your own ideas.

Database Specification
customer_addresses table
id
forename
surname
address
postcode
phone
email

orders table
id
customer_id
payment_type
date
status
total

order_items table
id
order_id
product_id
quantity

products table
id
cat_id
name
description
price

categories table
id
name
description

Notes:

1. Database used should be SQL Server 2012
2. Develop solution using Visual Studio 2012
3. Languages used should be C# Web Forms, HTML and CSS
4. Validation should be created for all input fields, for example quantity purchased must be numeric.
5. Code should be clear and well commented