public ActionResult CreateWoTas(long id) { ScheduleMaintenanceTbl schdl = _context.ScheduleMaintenanceTbl.Where(x => x.ScheduleMainId == id).First(); WorkOrderTbl wo = new WorkOrderTbl(); wo.AssetId = schdl.AssetId; wo.SiteId = schdl.SiteId; wo.TechnicianId = schdl.TechnicianId; wo.WoDesc = schdl.MaintenanceDesc; wo.MaentenanceId = schdl.ScheduleMainId; wo.RequestId = null; wo.Date = DateTime.Now; wo.CreatedAtWo = DateTime.Now; wo.EstimatedWorking = schdl.EstimatedTime; wo.TaskDetail = schdl.TaskDetail; wo.EntityId = _context.TaskTbl.Where(x => x.TaskId == schdl.TaskId).First().TaskCode; _context.WorkOrderTbl.Add(wo); _context.SaveChanges(); ScheduleMaintenanceTbl schdl2 = _context.ScheduleMaintenanceTbl.Where(x => x.ScheduleMainId == id).First(); schdl2.Sended = true; schdl2.LastMaintenance = DateTime.Now; _context.Update(schdl2); _context.SaveChanges(); return(Json(new { success = true })); }
public async Task <IActionResult> Edit(long id, ScheduleMaintenanceTbl scheduleMaintenanceTbl) { scheduleMaintenanceTbl.ScheduleMainId = id; //if (id != scheduleMaintenanceTbl.ScheduleMainId) //{ // return NotFound(); //} if (ModelState.IsValid) { scheduleMaintenanceTbl.AssetName = scheduleMaintenanceTbl.AssetName; _context.Update(scheduleMaintenanceTbl); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(scheduleMaintenanceTbl)); }
public async Task <IActionResult> Create(ScheduleMaintenanceTbl scheduleMaintenanceTbl) { var assetnamess = _context.AssetTbl.Where(x => x.AssetId == scheduleMaintenanceTbl.AssetId).First().AssetName; var period = _context.PeriodTbl.Where(x => x.PeriodId == scheduleMaintenanceTbl.PeriodId).First().Days; if (ModelState.IsValid) { scheduleMaintenanceTbl.LastMaintenance = DateTime.Now; scheduleMaintenanceTbl.AssetName = assetnamess; scheduleMaintenanceTbl.NextMaintenance = DateTime.Now.AddDays((double)period); //if(scheduleMaintenanceTbl.) //{ //} // scheduleMaintenanceTbl.LastEditedBy = DateTime.Now; _context.Add(scheduleMaintenanceTbl); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(scheduleMaintenanceTbl)); }