// 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));
}
