public ActionResult DeleteConfirmed(int id) { MndStkIn mndStkIn = db.mndStkIns.Find(id); db.mndStkIns.Remove(mndStkIn); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "Id,MndId,MndName,OrderDate")] MndStkIn mndStkIn) { if (ModelState.IsValid) { db.Entry(mndStkIn).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(mndStkIn)); }
public ActionResult Create([Bind(Include = "Id,MndId,MndName,OrderDate")] MndStkIn mndStkIn) { if (ModelState.IsValid) { db.mndStkIns.Add(mndStkIn); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(mndStkIn)); }
// GET: MndStkIns/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } MndStkIn mndStkIn = db.mndStkIns.Find(id); if (mndStkIn == null) { return(HttpNotFound()); } return(View(mndStkIn)); }
public JsonResult AddMndStockDetials(OrderViewModel orderViewModel) { bool status = true; var isValidModel = TryUpdateModel(orderViewModel); if (isValidModel) { using (ApplicationDbContext db = new ApplicationDbContext()) { var mndname = db.MND_TBLs.Find(orderViewModel.Cust_TBLId); MndStkIn order = new MndStkIn() { OrderDate = System.DateTime.Now, MndId = orderViewModel.Cust_TBLId, MndName = mndname.MND_NAME }; db.mndStkIns.Add(order); if (db.SaveChanges() > 0) { int orderID = db.mndStkIns.Max(o => o.Id); foreach (var item in orderViewModel.Items) { MainStore orderDetails = new MainStore() { MndStkInId = orderID, Product_TbleId = item.ProductID, Price = item.Price, QtyOut = item.Quantity, QtyIn = 0, Date = DateTime.Now, Amount = item.TotalPrice }; Stock stock = new Stock() { Prod_Id = item.ProductID, MndId = mndname.Id, StQty = item.Quantity, Date = DateTime.Now, Case = "منصرف لمندوب", Cust_Id = 0 }; var stck = db.product_Tbles.Where(p => p.Id == item.ProductID).FirstOrDefault(); stck.SQty = stck.SQty - item.Quantity; db.mainStores.Add(orderDetails); db.stocks.Add(stock); } if (db.SaveChanges() > 0) { return(new JsonResult { Data = new { status = status, message = "Order Added Successfully" } }); } } } } status = false; return(new JsonResult { Data = new { status = status, message = "Error !" } }); }