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