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);
}
}
