public JsonResult DeleteConfirmed(List <int> id)
{
foreach (int item in id)
{
I_WasteItemCatalog i_WasteItemCatalog = db.I_WasteItemCatalog.Find(item);
db.I_WasteItemCatalog.Remove(i_WasteItemCatalog);
db.SaveChanges();
}
return(Json("Success"));
}
public ActionResult AddItems(List <I_WasteItemCatalog> WasteItems)
{
foreach (I_WasteItemCatalog item in WasteItems)
{
if (item.Status == 2)
{
I_WasteDetails obj = new I_WasteDetails();
obj = db.I_WasteDetails.Find(item.WasteNo);
obj.ModifiedBy = System.Web.HttpContext.Current.User.Identity.Name;
obj.ModifiedOn = System.DateTime.Now;
obj.Status = 2;
db.Entry(obj).State = EntityState.Modified;
db.SaveChanges();
break;
}
}
foreach (I_WasteItemCatalog item in WasteItems)
{
I_WasteItemCatalog obj = new I_WasteItemCatalog();
obj = db.I_WasteItemCatalog.Where(x => x.WasteNo.ToString() == item.WasteNo.ToString() && x.ItemId == item.ItemId).SingleOrDefault();
if (obj != null)
{
db.I_WasteItemCatalog.Remove(obj);
db.SaveChanges();
}
item.CreatedBy = System.Web.HttpContext.Current.User.Identity.Name;
item.CreatedOn = System.DateTime.Now;
item.Cost = (db.I_StockInventory.Where(x => x.ItemId == item.ItemId).Select(Y => Y.Price).Average());
item.Total = item.Qty * item.Cost;
db.I_WasteItemCatalog.Add(item);
db.SaveChanges();
}
return(Json(new
{
success = true,
data = ""
},
JsonRequestBehavior.AllowGet));
}
