public static List <SchedulerExecution> GetCurrentExecutions()
{
SchedulerExecution schedulerExecution;
List <SchedulerExecution> schedulerExecutionList = null;
DataSet dsSchedulerExecutions = SchedulerDao.GetCurrentExecutions();
if (dsSchedulerExecutions != null)
{
if (dsSchedulerExecutions.Tables[0].Rows.Count > 0)
{
schedulerExecutionList = new List <SchedulerExecution>();
foreach (DataRow dr in dsSchedulerExecutions.Tables[0].Rows)
{
schedulerExecution = new SchedulerExecution();
int.TryParse(dr["SchedulerExecutionId"].ToString(), out int iSchedulerExecutionId);
schedulerExecution.SchedulerExecutionId = iSchedulerExecutionId;
int.TryParse(dr["SchedulerSettingsId"].ToString(), out int iSchedulerSettingsId);
schedulerExecution.SchedulerSettingsId = iSchedulerSettingsId;
DateTime.TryParse(dr["ExecutionTimeStamp"].ToString(), out DateTime dExecutionTimeStamp);
schedulerExecution.ExecutionTimeStamp = dExecutionTimeStamp;
int.TryParse(dr["Status"].ToString(), out int iStatus);
schedulerExecution.Status = iStatus;
// Add scheduler settings to the list
schedulerExecutionList.Add(schedulerExecution);
}
}
}
return(schedulerExecutionList);
}
