//retrieving cart information whether historical or current information public List <CART_INFORMATION> retrieve_cart_data(string type, string userid) { Database_Connection con = new Database_Connection(); List <CART_INFORMATION> cart_list = new List <CART_INFORMATION> (); string query = ""; SqlDataReader reader = null; //checking which base query data will be pulling from if (type == "his") { query = "SELECT * FROM [dbo].[VIEW_CART_HISTORY]('" + userid + "')"; //retrieving data reader = con.ExecuteQueries(query, userid); //reading data while (reader.Read()) { //storing information into a class model CART_INFORMATION cart = new CART_INFORMATION ( reader[0].ToString(), reader[1].ToString(), int.Parse(reader[2].ToString()), decimal.Parse(reader[3].ToString()), reader[4].ToString(), reader[5].ToString(), reader[6].ToString(), decimal.Parse(reader[7].ToString()), reader[8].ToString() ); //adding the model to a list of models cart_list.Add(cart); } } else { query = "SELECT * FROM [dbo].[VIEW_CART]('" + userid + "')"; //retrieving data reader = con.ExecuteQueries(query, userid); //reading data while (reader.Read()) { //storing information into a class model CART_INFORMATION cart = new CART_INFORMATION ( reader[0].ToString(), reader[1].ToString(), int.Parse(reader[2].ToString()), decimal.Parse(reader[3].ToString()), reader[4].ToString(), reader[5].ToString(), reader[6].ToString(), decimal.Parse(reader[7].ToString()) ); //adding the model to a list of models cart_list.Add(cart); } } reader.Close(); con.closeSqlData(); //closing sql data stream return(cart_list); // returning the list }
public System.Web.UI.HtmlControls.HtmlGenericControl generate_cart_summary_product_breakout(int i, CART_INFORMATION data) { System.Web.UI.HtmlControls.HtmlGenericControl newdiv = new System.Web.UI.HtmlControls.HtmlGenericControl("DIV"); newdiv.Attributes.Add("Style", "border:1px; border-color:blue; padding-bottom:2%"); newdiv.Attributes.Add("class", "col-md-4"); newdiv.ID = "cart_info_" + i.ToString() + "_" + data.get_cart_id(); string prod_image = "<img style='width:60%; height:200px;' src='" + data.get_prod_image() + "'/>"; string price = "<p>" + "Unit Cost: " + data.get_unit_cost_display() + "</p>"; string prod_name = "<p> Item Name: " + data.get_prod_name() + "<p>"; string description = "<p> Sub-Total: " + data.get_payment_display() + "</p>"; string quantity = "<p style = 'flex:1'> Amount Purchase: </p>"; //creating the section that holds the amount of available quantity is there per product System.Web.UI.HtmlControls.HtmlGenericControl avail_amt_host = new System.Web.UI.HtmlControls.HtmlGenericControl("DIV"); avail_amt_host.ID = "amt_avail" + i.ToString() + "_" + data.get_cart_id(); avail_amt_host.Attributes.Add("runat", "server"); //configuring the delete from cart button delete_from_cart.Text = "DELETE>>"; delete_from_cart.CssClass = "btn btn-default"; delete_from_cart.ID = "cart" + i.ToString() + "_" + data.get_cart_id(); newdiv.InnerHtml = prod_image + prod_name + price + description; System.Web.UI.HtmlControls.HtmlGenericControl quan_host = new System.Web.UI.HtmlControls.HtmlGenericControl("DIV"); System.Web.UI.HtmlControls.HtmlGenericControl avail_host = new System.Web.UI.HtmlControls.HtmlGenericControl("DIV"); avail_host.Attributes.Add("Style", "display:flex;"); avail_host.InnerHtml = quantity; quan_host.Attributes.Add("Style", "display:flex; width:30%"); TextBox quan = new TextBox(); //text box that will display the amount of quantity that is being selected //box that handles the displaying of the quantity quan.Attributes.Add("Style", "width:20%; flex:1"); quan.ReadOnly = true; quan.Text = data.get_qauntity().ToString(); quan.ID = "box" + i.ToString() + "_" + data.get_cart_id(); quan_host.Controls.Add(quan); avail_host.Controls.Add(avail_amt_host); newdiv.Controls.Add(avail_host); newdiv.Controls.Add(quan_host); newdiv.Controls.Add(delete_from_cart); return(newdiv);//returning all the product that will be displaying }