//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
}
