public static List <SchedulerSettings> GetActiveSchedulerSettings()
{
SchedulerSettings schedulerSettings;
List <SchedulerSettings> schedulerSettingsList = null;
DataSet dsSchedulerSettings = SchedulerDao.GetActiveSchedulerSettings();
if (dsSchedulerSettings != null)
{
if (dsSchedulerSettings.Tables[0].Rows.Count > 0)
{
schedulerSettingsList = new List <SchedulerSettings>();
foreach (DataRow dr in dsSchedulerSettings.Tables[0].Rows)
{
schedulerSettings = new SchedulerSettings();
int.TryParse(dr["SchedulerSettingsId"].ToString(), out int iSchedulerSettingsId);
schedulerSettings.SchedulerSettingsId = iSchedulerSettingsId;
int.TryParse(dr["SchedulerId"].ToString(), out int iSchedulerId);
schedulerSettings.SchedulerId = iSchedulerId;
DateTime.TryParse(dr["ExecutionTimeStamp"].ToString(), out DateTime dExecutionTime);
schedulerSettings.ExecutionTime = dExecutionTime;
int.TryParse(dr["HourlyRecurrence"].ToString(), out int iHourlyRecurrence);
schedulerSettings.HourlyRecurrence = iHourlyRecurrence;
int.TryParse(dr["DailyRecurrence"].ToString(), out int iDailyRecurrence);
schedulerSettings.DailyRecurrence = iDailyRecurrence;
int.TryParse(dr["WeeklyRecurrence"].ToString(), out int iWeeklyRecurrence);
schedulerSettings.WeeklyRecurrence = iWeeklyRecurrence;
int.TryParse(dr["SelectedDayOfWeek"].ToString(), out int iSelectedDayOfWeek);
schedulerSettings.SelectedDayOfWeek = iSelectedDayOfWeek;
int.TryParse(dr["SelectedMonth"].ToString(), out int iSelectedMonth);
schedulerSettings.SelectedMonth = iSelectedMonth;
int.TryParse(dr["SelectedDayOfMonth"].ToString(), out int iSelectedDayOfMonth);
schedulerSettings.SelectedDayOfMonth = iSelectedDayOfMonth;
bool.TryParse(dr["Enabled"].ToString(), out bool bEnabled);
schedulerSettings.Enabled = bEnabled;
// Add scheduler settings to the list
schedulerSettingsList.Add(schedulerSettings);
}
}
}
return(schedulerSettingsList);
}
