public ActionResult DeleteConfirmed(int id) { CellarProduct cellarProduct = db.CellarProducts.Find(id); db.CellarProducts.Remove(cellarProduct); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "CellarProductId,CellarId,ProductId,Stock,Minimum,Maximum,ReplacementDays,MinimumAmount,Location")] CellarProduct cellarProduct) { if (ModelState.IsValid) { db.Entry(cellarProduct).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CellarId = new SelectList(db.Cellars, "CellarId", "Description", cellarProduct.CellarId); ViewBag.ProductId = new SelectList(db.Products, "ProductId", "Description", cellarProduct.ProductId); return(View(cellarProduct)); }
// GET: CellarProducts/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } CellarProduct cellarProduct = db.CellarProducts.Find(id); if (cellarProduct == null) { return(HttpNotFound()); } return(View(cellarProduct)); }
// GET: CellarProducts/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } CellarProduct cellarProduct = db.CellarProducts.Find(id); if (cellarProduct == null) { return(HttpNotFound()); } ViewBag.CellarId = new SelectList(db.Cellars, "CellarId", "Description", cellarProduct.CellarId); ViewBag.ProductId = new SelectList(db.Products, "ProductId", "Description", cellarProduct.ProductId); return(View(cellarProduct)); }
public ActionResult Create(NewSaleView view) { if (ModelState.IsValid) { using (var transaction = db.Database.BeginTransaction()) { try { AccountingDocument dn = (from x in db.AccountingDocuments orderby x.InitialNumber descending select x).FirstOrDefault(); var docnumber = dn.InitialNumber + 1; var sale = new Sale { Datetime = view.Date, CellarId = view.CellarId, ClientId = view.ClientId, AccountingDocumentId = view.AccountingDocumentId, PaymentMethodId = view.PaymentMethodId, DocumentNumber = docnumber, }; db.Sales.Add(sale); db.SaveChanges(); var details = db.SaleDetailBkps.Where(pdb => pdb.User == User.Identity.Name).ToList(); foreach (var detail in details) { var saleDetail = new SaleDetail { SaleId = sale.SaleId, ProductId = detail.ProductId, Description = detail.Description, Price = detail.Price, Quantity = detail.Quantity, IVAPercentage = detail.IVAPercentage, DiscountRate = detail.DiscountRate }; db.SaleDetails.Add(saleDetail); db.SaleDetailBkps.Remove(detail); var status = true; if (status == true) { CellarProduct c = (from x in db.CellarProducts where x.ProductId == detail.ProductId select x).First(); c.Stock = c.Stock - detail.Quantity; db.SaveChanges(); } } db.SaveChanges(); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); ModelState.AddModelError(string.Empty, ex.Message); } } return(RedirectToAction("Index")); } ViewBag.CellarId = new SelectList(db.Cellars, "CellarId", "Description", view.CellarId); ViewBag.ClientId = new SelectList(db.Clients, "ClientId", "Cliente", view.ClientId); ViewBag.AccountingDocumentId = new SelectList(db.AccountingDocuments, "AccountingDocumentId", "Tipo de Documento", view.AccountingDocumentId); ViewBag.PaymentMethodId = new SelectList(db.PaymentMethods, "PaymentMethodId", "Metodo de Pago", view.PaymentMethodId); view.Details = db.SaleDetailBkps.Where(pdb => pdb.User == User.Identity.Name).ToList(); return(View(view)); }