public ActionResult Create([Bind(Include = "ID,Plant,Department,Location,Phase,Machine,MaxQuantity,DeviceType,CreateBy,UpdateBy,DateCreate,DateUpdate")] LimitDeviceQuantity limitdevicequantity)
{
if (db.LimitDeviceQuantities.Any(d => d.Machine == limitdevicequantity.Machine && d.DeviceType == limitdevicequantity.DeviceType))
{
ModelState.AddModelError("Machine", " ");
}
if (ModelState.IsValid)
{
limitdevicequantity.Plant = db.Machines.Where(m => m.MachineName == limitdevicequantity.Machine).Select(m => m.Plant.PlantName).DefaultIfEmpty().First();
limitdevicequantity.Department = db.Machines.Where(m => m.MachineName == limitdevicequantity.Machine).Select(m => m.Department.DepartmentName).DefaultIfEmpty().First();
limitdevicequantity.Location = db.Machines.Where(m => m.MachineName == limitdevicequantity.Machine).Select(m => m.Location.LocationName).DefaultIfEmpty().First();
limitdevicequantity.Phase = db.Machines.Where(m => m.MachineName == limitdevicequantity.Machine).Select(m => m.Phase.PhaseName).DefaultIfEmpty().First();
limitdevicequantity.CreateBy = System.Web.HttpContext.Current.User.Identity.Name;
limitdevicequantity.UpdateBy = System.Web.HttpContext.Current.User.Identity.Name;
limitdevicequantity.DateCreate = DateTime.Now;
limitdevicequantity.DateUpdate = DateTime.Now;
db.LimitDeviceQuantities.Add(limitdevicequantity);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Duplicate = "Y";
return(View(limitdevicequantity));
}
public ActionResult DeleteConfirmed(int id)
{
LimitDeviceQuantity limitdevicequantity = db.LimitDeviceQuantities.Find(id);
db.LimitDeviceQuantities.Remove(limitdevicequantity);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "ID,Plant,Department,Location,Phase,Machine,MaxQuantity,DeviceType,CreateBy,UpdateBy,DateCreate,DateUpdate")] LimitDeviceQuantity limitdevicequantity)
{
if (ModelState.IsValid)
{
limitdevicequantity.CreateBy = System.Web.HttpContext.Current.User.Identity.Name;
limitdevicequantity.UpdateBy = System.Web.HttpContext.Current.User.Identity.Name;
limitdevicequantity.DateCreate = DateTime.Now;
limitdevicequantity.DateUpdate = DateTime.Now;
db.Entry(limitdevicequantity).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(limitdevicequantity));
}
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
LimitDeviceQuantity limitdevicequantity = db.LimitDeviceQuantities.Find(id);
if (limitdevicequantity == null)
{
return(HttpNotFound());
}
return(View(limitdevicequantity));
}
