public int CreateCart()
 {
     using (var db = new ShoppingCartContext())
     {
         // Create new shopping cart
         var shoppingCart = new ShoppingCart { Created = DateTime.Now, Modified = DateTime.Now };
         db.ShoppingCarts.Add(shoppingCart);
         db.SaveChanges();
         return shoppingCart.ShoppingCartId;
     }
 }
예제 #2
0
 public int CreateCart()
 {
     using (var db = new ShoppingCartContext())
     {
         // Create new shopping cart
         var shoppingCart = new ShoppingCart {
             Created = DateTime.Now, Modified = DateTime.Now
         };
         db.ShoppingCarts.Add(shoppingCart);
         db.SaveChanges();
         return(shoppingCart.ShoppingCartId);
     }
 }
예제 #3
0
 public bool RemoveCart(int shoppingCartId)
 {
     using (var db = new ShoppingCartContext())
     {
         var shoppingCart = (from c in db.ShoppingCarts.Include("CartItems")
                             where c.ShoppingCartId == shoppingCartId
                             select c).FirstOrDefault();
         if (shoppingCart != null)
         {
             db.ShoppingCarts.Remove(shoppingCart);
         }
         return(db.SaveChanges() > 0);
     }
 }
예제 #4
0
 public bool DeleteItemFromCart(int shoppingCartId, int cartItemId)
 {
     using (var db = new ShoppingCartContext())
     {
         var q = from i in db.CartItems.Include("ShoppingCart")
                 where i.CartItemId == cartItemId && i.ShoppingCartId == shoppingCartId
                 select i;
         var cartItem = q.FirstOrDefault();
         if (cartItem == null)
         {
             return(false);
         }
         cartItem.ShoppingCart.Modified = DateTime.Now;
         db.CartItems.Remove(cartItem);
         return(db.SaveChanges() > 0);
     }
 }
예제 #5
0
 public bool ModifyItemInCart(int shoppingCartId, int cartItemId, int quantity)
 {
     using (var db = new ShoppingCartContext())
     {
         var q = from i in db.CartItems.Include("ShoppingCart")
                 where i.CartItemId == cartItemId && i.ShoppingCartId == shoppingCartId
                 select i;
         var cartItem = q.FirstOrDefault();
         if (cartItem == null)
         {
             return(false);
         }
         cartItem.Quantity = quantity;
         cartItem.Modified = DateTime.Now;
         cartItem.ShoppingCart.Modified = DateTime.Now;
         return(db.SaveChanges() > 0);
     }
 }
예제 #6
0
 public bool ClearCart(int shoppingCartId)
 {
     using (var db = new ShoppingCartContext())
     {
         var shoppingCart = (from c in db.ShoppingCarts.Include("CartItems")
                             where c.ShoppingCartId == shoppingCartId
                             select c).FirstOrDefault();
         if (shoppingCart != null)
         {
             if (shoppingCart.CartItems != null)
             {
                 foreach (var cartItem in shoppingCart.CartItems.ToArray())
                 {
                     db.CartItems.Remove(cartItem);
                 }
             }
             shoppingCart.Modified = DateTime.Now;
         }
         return(db.SaveChanges() > 0);
     }
 }
 public bool ClearCart(int shoppingCartId)
 {
     using (var db = new ShoppingCartContext())
     {
         var shoppingCart = (from c in db.ShoppingCarts.Include("CartItems")
                             where c.ShoppingCartId == shoppingCartId
                             select c).FirstOrDefault();
         if (shoppingCart != null)
         {
             if (shoppingCart.CartItems != null)
             {
                 foreach (var cartItem in shoppingCart.CartItems.ToArray())
                 {
                     db.CartItems.Remove(cartItem);
                 }
             }
             shoppingCart.Modified = DateTime.Now;
         }
         return db.SaveChanges() > 0;
     }
 }
 public bool AddItemToCartByUsername(string username, string item, int quantity)
 {
     using (var db = new ShoppingCartContext())
     {
         var shoppingCart = (from c in db.ShoppingCarts
                             where c.Username == username
                             select c).FirstOrDefault();
         if (shoppingCart != null)
         {
             var cartItem = new CartItem
             {
                 ShoppingCartId = shoppingCart.ShoppingCartId,
                 Created = DateTime.Now,
                 Modified = DateTime.Now,
                 Item = item,
                 Quantity = quantity,
                 Price = 5.0
             };
             db.CartItems.Add(cartItem);
             shoppingCart.Modified = DateTime.Now;
         }
         return db.SaveChanges() > 0;
     }
 }
예제 #9
0
 public bool AddItemToCart(int shoppingCartId, string item, int quantity)
 {
     using (var db = new ShoppingCartContext())
     {
         var shoppingCart = (from c in db.ShoppingCarts.Include("CartItems")
                             where c.ShoppingCartId == shoppingCartId
                             select c).FirstOrDefault();
         if (shoppingCart != null)
         {
             var cartItem = new CartItem
             {
                 ShoppingCartId = shoppingCartId,
                 Created        = DateTime.Now,
                 Modified       = DateTime.Now,
                 Item           = item,
                 Quantity       = quantity,
                 Price          = 5.0
             };
             db.CartItems.Add(cartItem);
             shoppingCart.Modified = DateTime.Now;
         }
         return(db.SaveChanges() > 0);
     }
 }
 public int CreateCart(string username)
 {
     using (var db = new ShoppingCartContext())
     {
         var q = from c in db.ShoppingCarts
                 where c.Username == username
                 select c;
         ShoppingCart shoppingCart = q.FirstOrDefault();
         if (shoppingCart == null)
         {
             // Create new shopping cart
             shoppingCart = new ShoppingCart
                                {Username = username, Created = DateTime.Now, Modified = DateTime.Now};
             db.ShoppingCarts.Add(shoppingCart);
             db.SaveChanges();
         }
         return shoppingCart.ShoppingCartId;
     }
 }
 public bool RemoveCartByUsername(string username)
 {
     using (var db = new ShoppingCartContext())
     {
         var shoppingCart = (from c in db.ShoppingCarts.Include("CartItems")
                             where c.Username == username
                             select c).FirstOrDefault();
         if (shoppingCart != null)
         {
             db.ShoppingCarts.Remove(shoppingCart);
         }
         return db.SaveChanges() > 0;
     }
 }
 public bool RemoveCart(int shoppingCartId)
 {
     using (var db = new ShoppingCartContext())
     {
         var shoppingCart = (from c in db.ShoppingCarts.Include("CartItems")
                             where c.ShoppingCartId == shoppingCartId
                             select c).FirstOrDefault();
         if (shoppingCart != null)
         {
             db.ShoppingCarts.Remove(shoppingCart);
         }
         return db.SaveChanges() > 0;
     }
 }
 public bool ModifyItemInCart(int shoppingCartId, int cartItemId, int quantity)
 {
     using (var db = new ShoppingCartContext())
     {
         var q = from i in db.CartItems.Include("ShoppingCart")
                 where i.CartItemId == cartItemId && i.ShoppingCartId == shoppingCartId
                 select i;
         var cartItem = q.FirstOrDefault();
         if (cartItem == null)
         {
             return false;
         }
         cartItem.Quantity = quantity;
         cartItem.Modified = DateTime.Now;
         cartItem.ShoppingCart.Modified = DateTime.Now;
         return db.SaveChanges() > 0;
     }
 }
 public bool DeleteItemFromCart(int shoppingCartId, int cartItemId)
 {
     using (var db = new ShoppingCartContext())
     {
         var q = from i in db.CartItems.Include("ShoppingCart")
                 where i.CartItemId == cartItemId && i.ShoppingCartId == shoppingCartId
                 select i;
         var cartItem = q.FirstOrDefault();
         if (cartItem == null)
         {
             return false;
         }
         cartItem.ShoppingCart.Modified = DateTime.Now;
         db.CartItems.Remove(cartItem);
         return db.SaveChanges() > 0;
     }
 }