public void update_bill() { total_cost = 0; string items_list = string.Empty; for (int i = 0; i < this.Parent.Controls.Find("ucCartItem", true).Length; i++) { ucCartItem uc = (ucCartItem)this.Parent.Controls.Find("ucCartItem", true)[i]; total_cost += uc.getCost(); if (!uc.getQty().Equals(0)) { items_list += uc.getQty() + " " + uc.getItemName() + "s ,"; } } items_list = items_list.Trim(','); this.Controls.Find("lblTotalCost", true)[0].Text = total_cost.ToString() + ".0 PKR"; this.Controls.Find("lblCartItems", true)[0].Text = items_list; }
private void UpdateCart() { flpCart.Controls.Clear(); int totalCost = 0; OleDbDataAdapter adap = new OleDbDataAdapter("select Cart from UsersTable where Username='******'", conn); DataSet DS = new DataSet(); conn.Open(); adap.Fill(DS, "UsersTable"); conn.Close(); if (DS.Tables["UsersTable"].Rows.Count != 0) { string[] cart = DS.Tables["UsersTable"].Rows[0]["Cart"].ToString().Split(','); string ItemName; int ItemPrice; string ItemDescription; string ItemImage; for (int i = 0; i < cart.Length; i++) { if (!cart[i].Equals(string.Empty)) { DS.Clear(); adap = new OleDbDataAdapter("select * from ItemsTable where Item='" + cart[i] + "'", conn); conn.Open(); adap.Fill(DS, "ItemsTable"); conn.Close(); ItemName = DS.Tables["ItemsTable"].Rows[0]["Item"].ToString(); ItemPrice = Convert.ToInt32(DS.Tables["ItemsTable"].Rows[0]["Price"].ToString()); ItemDescription = DS.Tables["ItemsTable"].Rows[0]["Description"].ToString(); ItemImage = DS.Tables["ItemsTable"].Rows[0]["Image"].ToString(); ucCartItem uc = new ucCartItem(username, ItemName, ItemPrice, ItemDescription, ItemImage); flpCart.Controls.Add(uc); } } ucTotalBill ucBill = new ucTotalBill(username); flpCart.Controls.Add(ucBill); } }