protected void lnkRemoveItem_Click(object sender, EventArgs e) { using (ecommerceEntities context = new ecommerceEntities()) { string pagemode = Session["PageMode"].ToString(); int Status = 1; if (pagemode == "addToWishlist") { Status = 3; } else { Status = 1; } //Get the reference of the clicked button. LinkButton button = (sender as LinkButton); //Get the Repeater Item reference RepeaterItem item = button.NamingContainer as RepeaterItem; //Get the repeater item index int index = item.ItemIndex; string id = ((Label)(Repeater1.Items[index].FindControl("lblHiddenCartID"))).Text; int cartid = Convert.ToInt16(id); ProductOrderStatu cr = context.ProductOrderStatus.Where(i => i.ProductOrderStatusId == cartid && i.StatusId == Status).FirstOrDefault(); context.ProductOrderStatus.Remove(cr); context.SaveChanges(); string notifyTitle = "One item removed"; string message = "One item was removed from your "; if (Status == 1) { message = message + "cart!"; } else { message = message + "wish list!"; } string notification = string.Format("?notifyTitle={0}¬ificationDescription={1}", notifyTitle, message); Response.Redirect("~/ProductCollection.aspx" + notification); } }
private void ProductOrderStatus(int CustID, int Quantity, int StatusId, ecommerceEntities context, string Querystring) { int ProdID = Convert.ToInt16(Request.QueryString[Querystring]); //Check if product is already in cart ProductOrderStatu cr = context.ProductOrderStatus.Where(i => i.ProductId == ProdID && i.CustomerId == CustID && i.StatusId == 1 /*is already in cart*/).FirstOrDefault(); //If not in the DB add it. if (cr == null) { context.ProductOrderStatus.Add(new ProductOrderStatu { CustomerId = CustID, ProductId = ProdID, StatusId = StatusId,//Add to cart Quantity = Quantity, CreatedDate = DateTime.Now }); context.SaveChanges(); } }