// GET: EntrySlipItems/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } EntrySlipItem entrySlipItem = db.EntrySlipItems.Find(id); if (entrySlipItem == null) { return(HttpNotFound()); } return(View(entrySlipItem)); }
// GET: EntrySlipItems/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } EntrySlipItem entrySlipItem = db.EntrySlipItems.Find(id); if (entrySlipItem == null) { return(HttpNotFound()); } ViewBag.EntrySlipId = new SelectList(db.EntrySlips, "Id", "Name", entrySlipItem.EntrySlipId); ViewBag.ProductId = new SelectList(db.Products, "Id", "Name", entrySlipItem.ProductId); return(View(entrySlipItem)); }
public ActionResult DeleteConfirmed(int id) { EntrySlipItem entrySlipItem = db.EntrySlipItems.Find(id); db.EntrySlipItems.Remove(entrySlipItem); var stockitem = db.StockItems.Where(x => x.ProductId == entrySlipItem.ProductId) .FirstOrDefault(); stockitem.Quantity -= entrySlipItem.Quantity; db.SaveChanges(); db.Entry(stockitem).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Create( [Bind(Include = "Id,Quantity,Price,Description,RpsId,ProductId")] EntrySlipItem entrySlipItem, FormCollection collection) { if (ModelState.IsValid) { #region Conticue Click if (Request.Form["btnContinue"] != null) { GetEntrySlipId(); entrySlipItem.EntrySlipId = int.Parse(Session["EntrySlipId"].ToString()); DoStock(entrySlipItem); return(RedirectToAction("Create")); } #endregion #region Save Click if (Request.Form["btnSave"] != null) { GetEntrySlipId(); entrySlipItem.EntrySlipId = int.Parse(Session["EntrySlipId"].ToString()); DoStock(entrySlipItem); return(RedirectToAction("Edit", "EntrySlips", new { Id = int.Parse(Session["EntrySlipId"].ToString()) })); } #endregion #region Cancel Click if (Request.Form["btnCancel"] != null) { Session["EntrySlipId"] = null; return(RedirectToAction("Index", "EntrySlips")); } #endregion } ViewBag.EntrySlipId = new SelectList(db.EntrySlips, "Id", "CreatedDate", entrySlipItem.EntrySlipId); ViewBag.ProductId = new SelectList(db.Products, "Id", "Name", entrySlipItem.ProductId); return(View(entrySlipItem)); }
public ActionResult Edit([Bind(Include = "Id,Quantity,Price,Description,EntrySlipId,RpsId,ProductId")] EntrySlipItem entrySlipItem) { if (ModelState.IsValid) { db.Entry(entrySlipItem).State = EntityState.Modified; int dif = entrySlipItem.Quantity - db.EntrySlipItems. Where(x => x.Id == entrySlipItem.Id) .Select(x => x.Quantity).FirstOrDefault(); db.SaveChanges(); var stockitem = db.StockItems. FirstOrDefault(x => x.ProductId == entrySlipItem.ProductId); stockitem.Quantity += dif; db.Entry(stockitem).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.EntrySlipId = new SelectList(db.EntrySlips, "Id", "Name", entrySlipItem.EntrySlipId); ViewBag.ProductId = new SelectList(db.Products, "Id", "Name", entrySlipItem.ProductId); return(View(entrySlipItem)); }
private void DoStock(EntrySlipItem entrySlipItem) { db.EntrySlipItems.Add(entrySlipItem); db.SaveChanges(); var stockItem = db.StockItems.Where(x => x.ProductId == entrySlipItem.ProductId).FirstOrDefault(); if (stockItem != null) { stockItem.Quantity += entrySlipItem.Quantity; db.Entry(stockItem).State = EntityState.Modified; db.SaveChanges(); } else { StockItem st = new StockItem() { ProductId = entrySlipItem.ProductId, Quantity = entrySlipItem.Quantity }; db.StockItems.Add(st); db.SaveChanges(); } }