public async Task <IActionResult> SaveWoExeTask(WoExeAndWoExeTask woExeTask) { // var data = _db.WoExeTaskTbl.Where(m => m.Id == woExeTask.noListWoTask.Id).First(); if (ModelState.IsValid) { //woExeTask.noListWoTask.WoExeId = data.WoExeId; //woExeTask.noListWoTask.TaskCode = data.TaskCode; //woExeTask.noListWoTask.Detail = data.Detail; //woExeTask.noListWoTask.TaskType = data.TaskType; _db.Update(woExeTask.noListWoTask); _db.SaveChanges(); } return(new EmptyResult()); }
public async Task <IActionResult> Run(long id, WoExeAndWoExeTask woexe) { if (id != woexe.WoExecution.Id) { return(NotFound()); } if (ModelState.IsValid) { woexe.WoExecution.Status = "Complete"; _db.Update(woexe.WoExecution); _db.SaveChanges(); return(RedirectToAction(nameof(Index))); } return(View(woexe)); }
//======================================================================== public async Task <IActionResult> Run(int?id) //public IActionResult Create() { var wo = await _db.WoExecutionTbl.SingleOrDefaultAsync(m => m.Id == id); ViewBag.Aidi = id.ToString(); //menggunakan 2model untuk 1 view, dari tabel wo exe dan wo exe task WoExeAndWoExeTask vm = new WoExeAndWoExeTask(); vm.WoExecution = wo; vm.WoExeTask = _db.WoExeTaskTbl.Where(x => x.WoExeId == wo.Id).ToList(); ViewBag.status = new List <SelectListItem> { new SelectListItem { Text = "Normal", Value = "General" }, new SelectListItem { Text = "In Approval", Value = "In Approval" }, new SelectListItem { Text = "Approved", Value = "Approved" }, new SelectListItem { Text = "In Execution", Value = "In Execution" }, new SelectListItem { Text = "Complete", Value = "Complete" } }; ViewBag.priority = new List <SelectListItem> { new SelectListItem { Text = "Normal", Value = "General" }, new SelectListItem { Text = "Urgent", Value = "Urgent" } }; var customerData = from a in _db.ScheduleSparepartLinesTbl join b in _db.SparepartTbl on a.SparepartId equals b.SparepartId select new { a.SparepartId, a.Quantity, b.SparepartDesc }; //var Sparepart = from a in _db.ScheduleMaintenanceTbl // join b in _db.ScheduleSparepartLinesTbl on a.ScheduleMainId equals b.ScheduleMainId // join c in _db.SparepartTbl on b.SparepartId equals c.SparepartId // select new { c.SparepartDesc, b.Quantity }; // var schee = _db.SparepartTbl; //ViewBag.SparepartLines = _db.ScheduleSparepartLinesTbl.Where(x => x.ScheduleMainId == sche_id).Join(schee, x =>x.SparepartId, s=>s.SparepartId,(x,s) => s.SparepartDesc).ToList(); // ViewBag.SparepartLines2 = Sparepart.Include(x=>x.SparepartDesc).ToList(); //ViewBag.SparepartLines3 = _db.ScheduleSparepartLinesTbl.Include(d => d.Sparepart).Where(x => x.ScheduleMainId == sche_id).ToList(); //ViewBag.taskline = _db.TaskLineTbl.Where(x => x.TaskCode == task_code.ToString()).ToList(); //================================================================================= ViewBag.Task = _db.WoExeTaskTbl.Where(x => x.WoExeId == wo.Id); ViewBag.Sparepart = _db.WoExeSparepartTbl.Where(x => x.WoExeId == wo.Id); ViewBag.TECHNICIANID = _db.TechnicianTbl.ToList(); ViewBag.SITEID = _db.SiteMasterTbl.ToList(); ViewBag.typetask = new List <SelectListItem> { new SelectListItem { Text = "Yes", Value = "Yes" }, new SelectListItem { Text = "No", Value = "No" } }; //================================================================================= return(View(vm)); }