Day-13

Today's Topics:

• Summary and recap of front end topics that are discussed till now

• Introduction to devops

• Fundamentals of ETL and Data Engineering

• Soft Skills - Emotional Intelligence

Task-13:

• Implement 'Add to Cart' functionality using below instructions

Implementing “Add to Cart” Functionality:

Database Side :

1. Create a table which holds the usercart information like the following:

CREATE TABLE Sb_user_cart(user_id varchar(500),product_id varchar(500) ,quantity int)

Web Application Side:

1. Develop a WebPage “SB_cart_summary.aspx” as above(slide #9)

2. When user Clicks on Buy in the cart page, he/she should be redirected to “SB_Product_Buy.aspx” where he/she can place order

3. In the Laptop Purchase Webpage , keep “Add to cart” button instead of “buy”.

4. In the button click event redirect to “SB_cart_summary.aspx” instead of “SB_Product_Buy.aspx”

5. Add a new tab in the menu “Cart” (Menu is there in “usercontrols” headermenu.ascx in “<div class="navbar">” (from line no. 84 to 89).

6. In “SB_Product_Buy.aspx” delete “Quantity” text box and its corresponding label (Delete the codes from line 51 to 60 in SB_Product_Buy.aspx )

Business Logic class :

1. Modification required in “Purchase_Item”

2. Only change in the function is query.

3. The query present in the “Purchase_Item” should be modified.

4. Psuedocode for the query.

Insert into SB_SalesDetails (user_id,product_id,Quantity,Delivery_Address)

Select user_id, product_id, quantity, ‘Address entered by user in SB_Product_Buy.aspx webpage”

From Sb_user_cart where user_id = ‘Convert.ToString(Session["user_id"])’

Rest of the code in the function remains unchanged.