public static void SaveWorkScheduleTemplate(string targetFullPathFile) { try { WorkScheduleData.SaveWorkScheduleTemplate(targetFullPathFile); Data.WorkSchedule.ImportableWorkScheduleData.UpdateWorkScheduleSheets(targetFullPathFile, WorkScheduleBusiness.GetParameter(Properties.Settings.Default.PASSWORD_KEY_NAME)); } catch (Exception exception) { logger.Error(exception); throw exception; } }
private static void UpdateSheets(IExcelDataProvider appXlsProvider) { List <string> sheetNamesList = new List <string>() { Properties.Settings.Default.SHEET_NAME_STATION, Properties.Settings.Default.SHEET_NAME_UNIT, Properties.Settings.Default.SHEET_NAME_EMPLOYEE }; foreach (string sheet in sheetNamesList) { DataTable dt = WorkScheduleData.GetDataTableToFillWorkScheduleSheet(sheet); appXlsProvider.WriteSheet(sheet, dt); } }