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