// Fyller cart-listview med produkterna som finns i cartProducts. private void ListProductsInCart() { ListViewCart.Items.Clear(); ListViewCart.BeginUpdate(); foreach (Product product in cartProducts) { string[] productValues = new string[3]; productValues[0] = product.name; productValues[1] = product.price.ToString(); productValues[2] = product.productType.ToString(); ListViewCart.Items.Add(new ListViewItem(productValues)); } ListViewCart.EndUpdate(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DataTable dt = new DataTable(); DataRow dr; dt.Columns.Add("ProductId"); dt.Columns.Add("ProductName"); dt.Columns.Add("Price"); dt.Columns.Add("Link"); dt.Columns.Add("UnitPriceNew"); dt.Columns.Add("Quantity"); dt.Columns.Add("TotalPrice"); dt.Columns.Add("TotalPriceAll"); if (Request.QueryString["id"] != null) { if (Session["buyitems"] == null) { dr = dt.NewRow(); String mycon = constr; SqlConnection scon = new SqlConnection(mycon); String myquery = "select * from Product where ProductId=" + Request.QueryString["id"]; SqlCommand cmd = new SqlCommand(); cmd.CommandText = myquery; cmd.Connection = scon; SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = cmd; DataSet ds = new DataSet(); da.Fill(ds); dr["ProductId"] = ds.Tables[0].Rows[0]["ProductId"].ToString(); dr["ProductName"] = ds.Tables[0].Rows[0]["ProductName"].ToString(); dr["Link"] = ds.Tables[0].Rows[0]["Link"].ToString(); dr["UnitPriceNew"] = ds.Tables[0].Rows[0]["UnitPriceNew"].ToString(); dr["Quantity"] = ds.Tables[0].Rows[0]["Quantity"].ToString(); //dr["TotalPriceAll"] = grandtotal().ToString(); //dr["Quantity"] = ds.Tables[0].Rows[0]["Quantity"].ToString(); //int quantity = Convert.ToInt16(Request.QueryString["Quantity"].ToString()); int unitpricenew = Convert.ToInt32(ds.Tables[0].Rows[0]["UnitPriceNew"].ToString()); int quantity = Convert.ToInt16(ds.Tables[0].Rows[0]["Quantity"].ToString()); int Totalprice = unitpricenew * quantity; dr["TotalPrice"] = Totalprice; dt.Rows.Add(dr); ListViewCart.DataSource = dt; ListViewCart.DataBind(); Session["buyitems"] = dt; //ListViewCart.FooterRow.Cells[5].Text = "Total Amount"; //ListViewCart.FooterRow.Cells[6].Text = grandtotal().ToString(); //Response.Redirect("AddToCart.aspx"); } else { dt = (DataTable)Session["buyitems"]; int sr; sr = dt.Rows.Count; dr = dt.NewRow(); String mycon = constr; SqlConnection scon = new SqlConnection(mycon); String myquery = "select * from Product where ProductId=" + Request.QueryString["id"]; SqlCommand cmd = new SqlCommand(); cmd.CommandText = myquery; cmd.Connection = scon; SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = cmd; DataSet ds = new DataSet(); da.Fill(ds); dr["ProductId"] = ds.Tables[0].Rows[0]["ProductId"].ToString(); dr["ProductName"] = ds.Tables[0].Rows[0]["productname"].ToString(); dr["Link"] = ds.Tables[0].Rows[0]["Link"].ToString(); dr["UnitPriceNew"] = ds.Tables[0].Rows[0]["UnitPriceNew"].ToString(); dr["Quantity"] = ds.Tables[0].Rows[0]["Quantity"].ToString(); //dr["TotalPriceAll"] = grandtotal().ToString(); //dr["Quantity"] = ds.Tables[0].Rows[0]["Quantity"].ToString(); //int Quantity = Convert.ToInt16(Request.QueryString["Quantity"].ToString()); int unitpricenew = Convert.ToInt32(ds.Tables[0].Rows[0]["UnitPriceNew"].ToString()); int quantity = Convert.ToInt16(ds.Tables[0].Rows[0]["Quantity"].ToString()); int Totalprice = unitpricenew * quantity; dr["TotalPrice"] = Totalprice; dt.Rows.Add(dr); ListViewCart.DataSource = dt; ListViewCart.DataBind(); Session["buyitems"] = dt; } } else { dt = (DataTable)Session["buyitems"]; ListViewCart.DataSource = dt; ListViewCart.DataBind(); } } }