public int Update(Data.Models.MaintenanceRequest MR) { Data.Models.MaintenanceRequest oldMR = _MRepository.Table.FirstOrDefault(w => w.Id == MR.Id); if (oldMR != null) { oldMR.RequestDate = MR.RequestDate; oldMR.RequestTime = MR.RequestTime; oldMR.IsBreakdown = MR.IsBreakdown; oldMR.PlantId = MR.PlantId; oldMR.LineId = MR.LineId; oldMR.MachineId = MR.MachineId; oldMR.PriorityId = MR.PriorityId; oldMR.Problem = MR.Problem; oldMR.Description = MR.Description; oldMR.IsCritical = MR.IsCritical; oldMR.BreakdownType = MR.BreakdownType; _MRepository.Update(oldMR); return(oldMR.Id); } else { return(0); } }
public JsonResult GetMRForDashboard(int Id) { MaintenanceRequestViewModel model = new MaintenanceRequestViewModel(); Data.Models.MaintenanceRequest objMR = this._mrServices.GetForId(Id); if (objMR != null) { model.Id = objMR.Id; model.SerialNo = objMR.SerialNo; model.RequestDate = objMR.RequestDate; TimeSpan rtime = objMR.RequestTime; model.RequestTime = new DateTime() + rtime; model.Problem = objMR.Problem; model.Description = objMR.Description; model.IsBreakdown = objMR.IsBreakdown; model.IsCritical = objMR.IsCritical; model.PlantId = objMR.PlantId; model.LineId = objMR.LineId; model.MachineId = objMR.MachineId; model.StatusId = objMR.StatusId; model.PriorityId = objMR.PriorityId; model.BreakdownType = objMR.BreakdownType; model.Remarks = objMR.Remarks; model.Remarks = objMR.Remarks; model.WorkStartDate = objMR.WorkStartDate; TimeSpan?starttime = objMR.WorkStartTime; model.WorkStartTime = new DateTime() + starttime; model.WorkEndDate = objMR.WorkEndDate; TimeSpan?endtime = objMR.WorkEndTime; model.WorkEndTime = new DateTime() + endtime; } return(Json(model, JsonRequestBehavior.AllowGet)); }
public int Add(Data.Models.MaintenanceRequest MR) { _MRepository.Insert(MR); return(MR.Id); }
public int SaveRemarks(MaintenanceGridModel MR)// MR { Data.Models.MaintenanceRequest oldMR = _MRepository.Table.FirstOrDefault(w => w.Id == MR.Id); if (oldMR != null) { if (MR.StatusId == 1) { oldMR.PriorityId = MR.PriorityId; oldMR.StatusId = 2; oldMR.Problem = MR.Problem; oldMR.Description = MR.Description; oldMR.AssignTo = MR.AssignTo; oldMR.AssignBy = MR.AssignBy; oldMR.AssignDate = DateTime.Now; oldMR.Remarks = MR.Remarks; oldMR.RemarksBy = MR.RemarksBy; oldMR.BreakdownType = MR.BreakdownType; oldMR.RemarksDate = DateTime.Now; } else if (MR.StatusId == 2) //Progress { oldMR.StatusId = 3; oldMR.ProgressBy = MR.ProgressBy; oldMR.ProgressDate = DateTime.Now; oldMR.ProgressRemarks = MR.ProgressRemarks; oldMR.WorkStartDate = MR.WorkStartDate; oldMR.WorkStartTime = MR.WorkStartTime.Value.TimeOfDay; } else if (MR.StatusId == 3)//Complete { oldMR.StatusId = 4; oldMR.WorkEndDate = MR.WorkEndDate; oldMR.WorkEndTime = MR.WorkEndTime.Value.TimeOfDay; oldMR.CompleteBy = MR.CompleteBy; oldMR.CompleteDate = DateTime.Now; oldMR.CompleteRemarks = MR.CompleteRemarks; } else if (MR.StatusId == 4)//close { oldMR.StatusId = 5; oldMR.CloseDate = DateTime.Now; oldMR.CloseBy = MR.CloseBy; oldMR.CloseRemarks = MR.CloseRemarks; TimeSpan rtime = oldMR.RequestTime; DateTime requestDate = oldMR.RequestDate + rtime; var totaltime = (oldMR.WorkEndTime - rtime).Value.TotalMilliseconds; DateTime?endDate = oldMR.WorkEndDate + oldMR.WorkEndTime; var day = oldMR.WorkEndDate - oldMR.RequestDate; if (oldMR.IsBreakdown == true) { //if(oldMR.WorkEndDate > oldMR.RequestDate) //{ var endTime = new TimeSpan(23, 59, 59); totaltime = (endTime - rtime).TotalMilliseconds; for (int i = 0; i <= day.Value.Days; i++) { this._breakdownRepository.Insert(new Data.Models.BreakDown { PlantId = oldMR.PlantId ?? default(int), LineId = oldMR.LineId ?? default(int), MachineId = oldMR.MachineId ?? default(int), Date = requestDate, StartTime = rtime, //EndTime = oldMR.WorkEndTime ?? default(TimeSpan), EndTime = day.Value.Days == 0 ? oldMR.WorkEndTime ?? default(TimeSpan) : endTime, //TotalTime = unchecked((int)totaltime), TotalTime = day.Value.Days == 0 ? unchecked ((int)(oldMR.WorkEndTime - rtime).Value.TotalMilliseconds) : unchecked ((int)totaltime), ElectricalTime = oldMR.BreakdownType == 1 ? true : false, MechTime = oldMR.BreakdownType == 2 ? true : false, InstrTime = oldMR.BreakdownType == 3 ? true : false, FailureDescription = oldMR.Description, CreatedBy = oldMR.CreatedBy, CreatedDate = oldMR.CreatedDate, }); requestDate = requestDate.AddDays(1); if (i == (day.Value.Days - 1)) { rtime = new TimeSpan(00, 00, 00); endTime = oldMR.WorkEndTime ?? default(TimeSpan); totaltime = (endTime - rtime).TotalMilliseconds; } else { rtime = new TimeSpan(00, 00, 00); endTime = new TimeSpan(23, 59, 59); totaltime = (endTime - rtime).TotalMilliseconds; } } } } _MRepository.Update(oldMR); return(oldMR.Id); } else { return(0); } }