Пример #1
0
        private void AddCartToUser(string email)
        {
            // Check if the user has a cart in cache
            if (Session["Cart"] != null)
            {
                ApplicationDbContext db = new ApplicationDbContext();

                var user = db.Users.Where(u => u.Email == email).FirstOrDefault();
         
                Cart currentCart = db.Carts.Include(c => c.User).Where(c => c.UserId == user.Id && c.Status == StatusEnum.PENDING).FirstOrDefault();
                List<CartProduct> cachedCartProducts = (List<CartProduct>)Session["Cart"];

                // Checks if the user already has a cart
                if (currentCart != null)
                {
                    // Add products to existing cart
                    List<CartProduct> cartProducts = db.CartProducts.Where(c => c.CartId == currentCart.CartId).ToList();
                    foreach (CartProduct cart in cachedCartProducts)
                    {
                        cart.CartId = currentCart.CartId;
                        cart.Product = null;
                        var cartProductToRemove = cartProducts.Where(c => c.ProductId == cart.ProductId).FirstOrDefault();
                        if (cartProductToRemove != null)
                        {
                            db.CartProducts.Remove(cartProductToRemove);
                            db.SaveChanges();
                        }
                        db.CartProducts.Add(cart);
                        db.SaveChanges();
                    }
                }
                else
                {
                    // Create a new cart
                    int latestCartId = db.Carts.Any() ? db.Carts.Max(c => c.CartId) : 1;
                    Cart cart = new Cart()
                    {
                        CartId = latestCartId + 1,
                        UserId = user.Id
                    };

                    // Add products to the new cart
                    foreach (CartProduct cartProduct in cachedCartProducts)
                    {
                        db.CartProducts.Add(new CartProduct()
                        {
                            Cart = cart,
                            CartId = cart.CartId,
                            ProductId = cartProduct.ProductId,
                            AmountOfProducts = cartProduct.AmountOfProducts
                        });
                        db.SaveChanges();
                    }
                }
                // Empty the session, because the cart has been stored in database.
                Session["Cart"] = null;
            }
        }
Пример #2
0
        private void AddToUserCart(CartProduct input)
        {
            Cart cart = db.Carts.Where(c => c.UserId == user.Id && c.Status == StatusEnum.PENDING).FirstOrDefault();

            // Check if the user already has a cart in db
            if (cart != null && cart.Status == StatusEnum.PENDING)
            {
                CartProduct cartProduct = new CartProduct()
                {
                    CartId = cart.CartId,
                    ProductId = input.ProductId,
                    AmountOfProducts = input.AmountOfProducts
                };

                // Check if the product already exists in the cart
                if (db.CartProducts.Where(c => c.ProductId == cartProduct.ProductId && c.CartId == cart.CartId).Any())
                {
                    db.Entry(cartProduct).State = EntityState.Modified;
                }
                else
                {
                    db.CartProducts.Add(cartProduct);
                }
            }
            else
            {
                cart = new Cart()
                {
                    CartId = db.Carts.Any() ? db.Carts.Max(c => c.CartId) + 1: 1,
                    UserId = user.Id,
                    Status = StatusEnum.PENDING
                };

                CartProduct cartProduct = new CartProduct()
                {
                    Cart = cart,
                    CartId = cart.CartId,
                    ProductId = input.ProductId,
                    AmountOfProducts = input.AmountOfProducts
                };
                db.Carts.Add(cart);
                db.CartProducts.Add(cartProduct);
            }
            db.SaveChanges();
        }