// GET: WasteDetails/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
I_WasteDetails i_WasteDetails = db.I_WasteDetails.Find(id);
if (i_WasteDetails == null)
{
return(HttpNotFound());
}
ViewBag.StoreId = new SelectList(db.Store_Details, "storeId", "storename", i_WasteDetails.StoreId);
List <SelectListItem> item = new List <SelectListItem>();
item = db.I_ItemMater.AsEnumerable().Where(x => x.MajorItemId != null).Select(y => new SelectListItem
{
Text = y.ItemName,
Value = y.Id.ToString()
}).ToList();
ViewBag.WasteGroupId = new SelectList(item, "Value", "Text", i_WasteDetails.WasteGroupId);
return(View(i_WasteDetails));
}
public ActionResult Create(I_WasteDetails i_WasteDetails)
{
if (ModelState.IsValid)
{
i_WasteDetails.CreatedBy = System.Web.HttpContext.Current.User.Identity.Name;
i_WasteDetails.CreatedOn = System.DateTime.Now;
i_WasteDetails.Status = 1;
i_WasteDetails.WasteNo = "WST";
db.I_WasteDetails.Add(i_WasteDetails);
db.SaveChanges();
I_WasteDetails obj = db.I_WasteDetails.Find(i_WasteDetails.Id);
obj.WasteNo = "WST" + System.DateTime.Now.Year + "/" + System.DateTime.Now.Month + "/" + i_WasteDetails.Id;
db.Entry(obj).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.StoreId = new SelectList(db.Store_Details, "storeId", "storename", i_WasteDetails.StoreId);
List <SelectListItem> item = new List <SelectListItem>();
item = db.I_ItemMater.AsEnumerable().Where(x => x.MajorItemId != null).Select(y => new SelectListItem
{
Text = y.ItemName,
Value = y.Id.ToString()
}).ToList();
ViewBag.WasteGroupId = new SelectList(item, "Value", "Text", i_WasteDetails.WasteGroupId);
return(View(i_WasteDetails));
}
public ActionResult DeleteConfirmed(int id)
{
I_WasteDetails i_WasteDetails = db.I_WasteDetails.Find(id);
db.I_WasteDetails.Remove(i_WasteDetails);
db.SaveChanges();
return(RedirectToAction("Index"));
}
// GET: WasteDetails/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
I_WasteDetails i_WasteDetails = db.I_WasteDetails.Find(id);
if (i_WasteDetails == null)
{
return(HttpNotFound());
}
i_WasteDetails.ModifiedBy = System.Web.HttpContext.Current.User.Identity.Name;
i_WasteDetails.ModifiedOn = System.DateTime.Now;
i_WasteDetails.Status = -99;
db.Entry(i_WasteDetails).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
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));
}
