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