// GET: InventoryOrders/Details/5 public JsonResult AcceptOrder(int? id) { if (id == null) { //return new HttpStatusCodeResult(HttpStatusCode.BadRequest); } inv_Stror_to_Store_order inv_Stror_to_Store_order = db.inv_Stror_to_Store_order.Find(id); if (inv_Stror_to_Store_order == null) { //return HttpNotFound(); } ViewBag.Invertory = inv_Stror_to_Store_order; ViewBag.Items = inv_Stror_to_Store_order.orderItemName == null ? "" : inv_Stror_to_Store_order.orderItemName ; var x = new { inv_Stror_to_Store_order = inv_Stror_to_Store_order, inv_from_order = new SelectList( db.inv_Inventory.Where( invent => (invent.InvertoryID != inv_Stror_to_Store_order.ordernTOventoryID) && ( inv_Stror_to_Store_order.orderItemQuantity <= ( db.inv_Items.Where(item => item.InventoryID == invent.InvertoryID && item.ItemID == inv_Stror_to_Store_order.orderItemID && item.ItemQuantity - inv_Stror_to_Store_order.orderItemQuantity > item.ItemMinimumQuantity).Sum(s => s.ItemQuantity) ) ) ), "InvertoryID", "InvertoryNameAr") //new SelectList(db.inv_Inventory.Where(Itmes => (Itmes.InvertoryID != inv_Stror_to_Store_order.ordernTOventoryID)), "InvertoryID", "InvertoryNameAr") }; return Json(x, JsonRequestBehavior.AllowGet); }
public async Task<ActionResult> DeleteConfirmed(int id) { inv_Stror_to_Store_order inv_Stror_to_Store_order = await db.inv_Stror_to_Store_order.FindAsync(id); db.inv_Stror_to_Store_order.Remove(inv_Stror_to_Store_order); await db.SaveChangesAsync(); return RedirectToAction("Index"); }
public async Task<ActionResult> Edit([Bind(Include = "Stror_to_Store_orderID,orderItemID,ordernTOventoryID,orderFromnventoryID,orderItemName,orderItemQuantity,orderStaus,orderUserName,fromOrderDate,toOrdeererDate")] inv_Stror_to_Store_order inv_Stror_to_Store_order) { if (ModelState.IsValid) { db.Entry(inv_Stror_to_Store_order).State = EntityState.Modified; await db.SaveChangesAsync(); return RedirectToAction("Index"); } return View(inv_Stror_to_Store_order); }
// GET: InventoryOrders/Delete/5 public async Task<ActionResult> Delete(int? id) { if (id == null) { return new HttpStatusCodeResult(HttpStatusCode.BadRequest); } inv_Stror_to_Store_order inv_Stror_to_Store_order = await db.inv_Stror_to_Store_order.FindAsync(id); if (inv_Stror_to_Store_order == null) { return HttpNotFound(); } return View(inv_Stror_to_Store_order); }
public JsonResult DeleteCartItem(int id) { int status = 0; inv_Stror_to_Store_order pur_PurchaseCart = db.inv_Stror_to_Store_order.Find(id); db.inv_Stror_to_Store_order.Remove(pur_PurchaseCart); db.SaveChanges(); status = 1; return(new JsonResult { Data = new { status = status } });; }
public JsonResult InsertPurchaseCart(inv_Stror_to_Store_order Stror_to_Store_order) { var v = db.inv_Stror_to_Store_order.Where(I => I.ordernTOventoryID == Stror_to_Store_order.ordernTOventoryID && I.orderItemID == Stror_to_Store_order.orderItemID && I.orderStaus == 0).FirstOrDefault(); if (v != null) { v.orderItemQuantity = Stror_to_Store_order.orderItemQuantity; v.toOrdeererDate = DateTime.Now; v.orderStaus = 0; db.SaveChanges(); } else { Stror_to_Store_order.orderStaus = 0; Stror_to_Store_order.toOrdeererDate = DateTime.Now; db.inv_Stror_to_Store_order.Add(Stror_to_Store_order); db.SaveChanges(); } return Json(1); }
public JsonResult UpdateGoodExchangesCart(inv_Stror_to_Store_order store_ex) { var v = db.inv_Stror_to_Store_order.Where(I => I.orderItemName == store_ex.orderItemName && I.orderFromnventoryID == store_ex.orderFromnventoryID).FirstOrDefault(); if (v != null) { v.orderItemQuantity = store_ex.orderItemQuantity; //status = 1; // 1 for update db.SaveChanges(); return(Json(1)); } else { return(Json(0)); } return(Json(0)); }
/// <summary> /// /////////////////// /// [] public JsonResult AcceptOrderConfirme(string InvetoryfromListID,string InvetoryToID, string orderItemQuantity,int ID_todelete, int itemIdOconfirme) { int x = int.Parse(InvetoryfromListID); int? toInventory = int.Parse(InvetoryToID); int orderQuantity = int.Parse(orderItemQuantity); var results = db.inv_Items.Where(st => st.InventoryID == x && st.ItemID == itemIdOconfirme) .Select(st => new InvTransactionResult{ item_id = st.ItemID,quanity = st.ItemQuantity, batch = st.ItemBatch }) .OrderBy(r => r.item_id) .Take(orderQuantity).ToList(); foreach(InvTransactionResult item in results) { if (item.quanity > 0) { var updateItem = db.inv_Items.Where(i => i.ItemBatch == item.batch && i.ItemID == item.item_id).First(); if (item.quanity >= orderQuantity) { updateItem.ItemQuantity -= orderQuantity; db.SaveChanges(); var updateToInventory = db.inv_Items.Where(i => i.ItemID == item.item_id).First(); updateToInventory.ItemQuantity += orderQuantity; db.SaveChanges(); break; } if (item.quanity < orderQuantity) { updateItem.InventoryID = x; orderQuantity = (int)orderQuantity - (int)item.quanity; db.SaveChanges(); } } } #region inv_Stror_to_Store_order inv_Stror_Card_to_delete = db.inv_Stror_to_Store_order.Find(ID_todelete); db.inv_Stror_to_Store_order.Remove(inv_Stror_Card_to_delete); db.SaveChanges(); #endregion return Json(1, JsonRequestBehavior.AllowGet); }
public JsonResult InsertGoodExchanges(inv_Stror_to_Store_order GoodSExchange) { if (ModelState.IsValid) { //################### Edit Item ###################// var v = db.inv_Stror_to_Store_order.Where(t => t.Stror_to_Store_orderID == GoodSExchange.Stror_to_Store_orderID || (t.orderItemName == GoodSExchange.orderItemName && t.orderFromnventoryID == GoodSExchange.orderFromnventoryID)).FirstOrDefault(); if (v != null) { v.orderItemQuantity = GoodSExchange.orderItemQuantity; db.SaveChanges(); } else { GoodSExchange.UpLoaded = false; db.inv_Stror_to_Store_order.Add(GoodSExchange); db.SaveChanges(); } } return(Json(1, JsonRequestBehavior.AllowGet)); }