private void btnRemoveFromCart_Click(object sender, EventArgs e) { OleDbDataAdapter adap = new OleDbDataAdapter("select Cart from UsersTable where Username='******'", conn); DataSet DS = new DataSet(); conn.Open(); adap.Fill(DS, "UsersTable"); conn.Close(); string cart = DS.Tables["UsersTable"].Rows[0]["Cart"].ToString(); if (cart.Contains(ItemName)) { cart = cart.Replace(ItemName, ""); OleDbCommand com = new OleDbCommand("update UsersTable set Cart='" + cart + "' where Username='******'", conn); conn.Open(); com.ExecuteNonQuery(); conn.Close(); } ucTotalBill uc = (ucTotalBill)this.Parent.Controls.Find("ucTotalBill", true)[0]; Parent.Controls.Remove(this); uc.update_bill(); }
private void btnPlus_Click(object sender, EventArgs e) { qty += 1; cost = ItemPrice * qty; txtQty.Text = qty.ToString(); lblCost.Text = cost.ToString() + ".0 PKR"; ucTotalBill uc = (ucTotalBill)this.Parent.Controls.Find("ucTotalBill", true)[0]; uc.update_bill(); }
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); } }