Esempio n. 1
0
        public IQueryable <Category> GetCategories()
        {
            var _db = new ToyDemoProj.Models.ProductContext();
            IQueryable <Category> query = _db.Categories;

            return(query);
        }
        //

        public void UpdateShoppingCartDatabase(String cartId, ShoppingCartUpdates[] CartItemUpdates)
        {
            using (var db = new ToyDemoProj.Models.ProductContext())
            {
                try
                {
                    int             CartItemCount = CartItemUpdates.Count();
                    List <CartItem> myCart        = GetCartItems();
                    foreach (var cartItem in myCart)
                    {
                        for (int i = 0; i < CartItemCount; i++)
                        {
                            if (cartItem.Product.ProductID == CartItemUpdates[i].ProductId)
                            {
                                if (CartItemUpdates[i].PurchaseQuantity < 1 || CartItemUpdates[i].RemoveItem == true)
                                {
                                    RemoveItem(cartId, cartItem.ProductId);
                                }
                                else
                                {
                                    UpdateItem(cartId, cartItem.ProductId, CartItemUpdates[i].PurchaseQuantity);
                                }
                            }
                        }
                    }
                }
                catch (Exception exp)
                {
                    throw new Exception("ERROR: Unable to update Database -  "
                                        + exp.Message.ToString(), exp);
                }
            }
        }
        public IQueryable <Product> GetProducts([QueryString("id")] int?categoryId)
        {
            var _db = new ToyDemoProj.Models.ProductContext();
            IQueryable <Product> query = _db.Products;

            if (categoryId.HasValue && categoryId > 0)
            {
                query = query.Where(p => p.CategoryID == categoryId);
            }

            return(query);
        }
Esempio n. 4
0
        public IQueryable <Product> GetProduct([QueryString("productID")] int?productId)
        {
            var _db = new ToyDemoProj.Models.ProductContext();
            IQueryable <Product> query = _db.Products;

            if (productId.HasValue && productId > 0)
            {
                query = query.Where(p => p.ProductID == productId);
            }

            else
            {
                query = null;
            }
            return(query);
        }
 public void UpdateItem(string updateCartID, int updateProductID, int quantity)
 {
     using (var _db = new ToyDemoProj.Models.ProductContext())
     {
         try
         {
             var myItem = (from c in _db.ShoppingCartItems
                           where c.CartId == updateCartID &&
                           c.Product.ProductID == updateProductID
                           select c).FirstOrDefault();
             if (myItem != null)
             {
                 myItem.Quantity = quantity;
                 _db.SaveChanges();
             }
         }
         catch (Exception exp)
         {
             throw new Exception("ERROR: Unable to Update Cart Item - " + exp.Message.ToString(), exp);
         }
     }
 }
        public void RemoveItem(String removeCartID, int removeProductID)
        {
            using (var _db = new ToyDemoProj.Models.ProductContext())
            {
                try
                {
                    var myItem = (from c in _db.ShoppingCartItems
                                  where c.CartId == removeCartID &&
                                  c.Product.ProductID == removeProductID
                                  select c).FirstOrDefault();
                    if (myItem != null)
                    {
                        _db.ShoppingCartItems.Remove(myItem);
                        _db.SaveChanges();
                    }
                }

                catch (Exception exp)
                {
                    throw new Exception("ERROR: Unable to remove cart item - "
                                        + exp.Message.ToString(), exp);
                }
            }
        }