public ActionResult DeleteConfirmed(int id) { MndStkOut mndStkOut = db.mndStkOuts.Find(id); db.mndStkOuts.Remove(mndStkOut); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "Id,MndId,MndName,OrderDate")] MndStkOut mndStkOut) { if (ModelState.IsValid) { db.Entry(mndStkOut).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(mndStkOut)); }
public ActionResult Create([Bind(Include = "Id,MndId,MndName,OrderDate")] MndStkOut mndStkOut) { if (ModelState.IsValid) { db.mndStkOuts.Add(mndStkOut); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(mndStkOut)); }
// GET: MndStkOuts/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } MndStkOut mndStkOut = db.mndStkOuts.Find(id); if (mndStkOut == null) { return(HttpNotFound()); } return(View(mndStkOut)); }
public JsonResult OutMndStockDetials(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); MndStkOut order = new MndStkOut() { OrderDate = System.DateTime.Now, MndId = orderViewModel.Cust_TBLId, MndName = mndname.MND_NAME }; db.mndStkOuts.Add(order); if (db.SaveChanges() > 0) { int orderID = db.mndStkOuts.Max(o => o.Id); foreach (var item in orderViewModel.Items) { MainStore orderDetails = new MainStore() { MndStkOutId = orderID, Product_TbleId = item.ProductID, Price = item.Price, QtyIn = item.Quantity, QtyOut = 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 stk = db.product_Tbles.Where(x => x.Id == item.ProductID).FirstOrDefault(); stk.SQty = stk.SQty + item.Quantity; db.stocks.Add(stock); db.mainStores.Add(orderDetails); } 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 !" } }); }
public JsonResult AddOrderAndOrderDetials(OrderViewModel orderViewModel) { bool status = true; var isValidModel = TryUpdateModel(orderViewModel); if (isValidModel) { using (ApplicationDbContext db = new ApplicationDbContext()) { var cusname = db.CUST_TBLs.Find(orderViewModel.Cust_TBLId); MndStkOut order = new MndStkOut() { OrderDate = System.DateTime.Now, MndId = orderViewModel.Cust_TBLId, MndName = cusname.CUST_NAME }; db.mndStkOuts.Add(order); if (db.SaveChanges() > 0) { int orderID = db.mndStkOuts.Max(o => o.Id); foreach (var item in orderViewModel.Items) { MainStore orderDetails = new MainStore() { MndStkOutId = orderID, Product_TbleId = item.ProductID, Price = item.Quantity, QtyIn = Convert.ToInt32(item.Price), QtyOut = 0, Amount = item.TotalPrice }; Stock stock = new Stock() { Prod_Id = item.ProductID, StQty = -Convert.ToInt32(item.Price), Case = "مرتجع مندوب", Date = System.DateTime.Now, MndId = cusname.MND_TBLId, Cust_Id = 0 }; 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 !" } }); }