public ActionResult Create([Bind(Include = "Id,Name,Cost,Quantity,Category")] Inventory.Entities.Inventory item) { if (ModelState.IsValid) { db.Inventory.Add(item); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(item)); }
public ActionResult Create([Bind(Include = "ItemId,CartId,Quantity,DateCreated,ProductId")] CartItem cartItem) { if (ModelState.IsValid) { db.ShoppingCartItems.Add(cartItem); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ProductId = new SelectList(db.Inventory, "Id", "Name", cartItem.ProductId); return(View("Create", cartItem)); }
// GET: Home public ActionResult Index() { try { context.Database.CreateIfNotExists(); context.SaveChanges(); List <Models.Hammer> hammers = context.Hammers.ToList(); return(View(hammers)); } catch { return(View(new List <Models.Hammer>())); } }
public ActionResult ReduceQuantity(string removeCartID, int removeProductID) { // using (var _db = new WingtipToys.Models.ProductContext()) using (var _db = new InventoryDb()) { try { var myItem = (from item in _db.ShoppingCartItems where item.CartId == removeCartID && item.Product.Id == removeProductID select item).FirstOrDefault(); if (myItem != null) { // Remove Item. myItem.Quantity--; myItem.Product.Quantity++; _db.SaveChanges(); } } catch (Exception exp) { throw new Exception("ERROR: Unable to Remove Cart Item - " + exp.Message.ToString(), exp); } } return(RedirectToAction("Index")); }
public void UpdateStock(int inventoryItemID, short newStock) { var item = (from i in db.Inventories where i.ID == inventoryItemID select i).Single(); if (item.UnitsInStock != newStock) { item.UnitsInStock = newStock; db.SaveChanges(); } }
public ActionResult AddToCart(int id) { // Retrieve the product from the database. ShoppingCartId = GetCartId(); var cartItem = _db.ShoppingCartItems.SingleOrDefault( c => c.CartId == ShoppingCartId && c.ProductId == id); if (cartItem == null) { // Create a new cart item if no cart item exists. cartItem = new CartItem { ItemId = Guid.NewGuid().ToString(), ProductId = id, CartId = ShoppingCartId, Product = _db.Inventory.SingleOrDefault( p => p.Id == id), Quantity = 1, DateCreated = DateTime.Now }; _db.ShoppingCartItems.Add(cartItem); cartItem.Product.Quantity--; } else { // If the item does exist in the cart, // then add one to the quantity. cartItem.Quantity++; cartItem.Product.Quantity--; } _db.SaveChanges(); var Chicken = GetCartItems(); return(RedirectToAction("Index")); }