For this solution, you create the core features of a shopping cart

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