protected void CartsGridView_RowDataBound(object sender, GridViewRowEventArgs e)
{
//called when loading the gridview, mostly just changing names of headers and decoding html.
e.Row.Cells[4].Visible = false;
if (e.Row.RowType == DataControlRowType.Header)
{
e.Row.Cells[0].Text = "Remove from cart";
e.Row.Cells[1].Text = "Book Title";
e.Row.Cells[2].Text = "Quantity";
e.Row.Cells[3].Text = "Price";
}
for (int i = 1; i < e.Row.Cells.Count; i++)
{
e.Row.Cells[i].Text = HttpContext.Current.Server.HtmlDecode(e.Row.Cells[i].Text);
}
}
protected void RemoveFromCart(object sender, EventArgs e)
{
//how to remove an item from the cart (and also from the database)
localhost.WebService w = new localhost.WebService();
Connect db = new Connect("userDB.accdb");
LinkButton lb = (LinkButton)sender;
int id = int.Parse(lb.CommandArgument.ToString());
string deletesql = "DELETE FROM cart WHERE orderId=" + id + ";";
string getinfo = "SELECT * FROM cart WHERE orderId = " + id;
DataTable dt = db.MakeConnection(getinfo, "cart");
int quantity = int.Parse(dt.Rows[0]["quantity"].ToString());
int productId = int.Parse(dt.Rows[0]["productId"].ToString());
DataTable dt1 = w.GetDataById(productId);
int stock = int.Parse(dt1.Rows[0]["stock"].ToString());
stock = stock + quantity;
w.Update(stock, productId, "Stock");
db.ConnectInsert(deletesql, "cart");
Response.Redirect("Cart.aspx");
}
