Example #1
0
    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}&notificationDescription={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();
        }
    }