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