public bool EditFB(int key, string Desc)
{
bool result = true;
try
{
if (Desc.Trim().Length == 0)
{
throw new Exception("Location description length must be greater than 0.");
}
var row = (from x in context.Maintenance_Flagboard where x.MFB_Id == key select x).FirstOrDefault();
if (row != null)
{
row.Loc_Description = Desc;
if (context.SaveChanges() < 1)
{
throw new Exception("failed to save changes");
}
}
else
{
throw new Exception("failed to retrieve existing data row");
}
} catch (Exception ex)
{
error = true;
errorMessage = ex.Message;
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
}
return(result);
}
public int Update(schedule record)
{
var MS_ID = record.MS_Id;
validateScheduleInputs(record);
if (MS_ID < 1)
{
throw new Exception("ScheduleId cannot be zero");
}
var scheduleRecord = (from x in context.Maintenance_Schedule where x.MS_Id == MS_ID select x).FirstOrDefault();
if (scheduleRecord == null)
{
throw new Exception("Schedule record not found in database.");
}
scheduleRecord.MM_Id = record.MM_Id;
scheduleRecord.MT_Id = record.MT_Id;
scheduleRecord.MS_Next_Main_Date = parseDate(record.MS_Next_Main_Date);
scheduleRecord.MS_Workorder = record.MS_Workorder;
scheduleRecord.MS_Frequency = ConvertToShort(record.MS_Frequency);
scheduleRecord.MS_Last_Main_Date = parseDate(record.MS_Last_Main_Date);
if (record.MS_Main_Comp_Date.ToUpper() == "TRUE")
{
scheduleRecord.MS_Main_Comp_Date = System.DateTime.Now.Date;
scheduleRecord.MS_WOClosed_Timestamp = DateTime.Now;
}
else if (record.MS_Main_Comp_Date.ToUpper() == "FALSE")
{
scheduleRecord.MS_Main_Comp_Date = null;
scheduleRecord.MS_WOClosed_Timestamp = null;
}
scheduleRecord.EMP_ID = record.EMP_ID;
scheduleRecord.MS_Maint_Code = record.MS_Maint_Code;
scheduleRecord.MS_Maint_Time_Alotted = ConvertToShort(record.MS_Maint_Time_Alotted);
scheduleRecord.MS_Main_Time_Required = ConvertToShort(record.MS_Maint_Time_Required);
scheduleRecord.MS_Machine_Hours = record.MS_Machine_Hours;
scheduleRecord.MS_Unscheduled_Reason = record.MS_Unscheduled_Reason;
scheduleRecord.MS_Notes = record.MS_Notes;
//scheduleRecord.MS_Total_Machine_Downtime = record.MS_Total_Machine_Downtime / 60;
scheduleRecord.MFB_Id = record.MFB_Id;
return(context.SaveChanges());
}