public static List <JobScheduler> GetActiveSchedulers() { JobScheduler scheduler; List <JobScheduler> schedulers = null; DataSet dsSchedulers = SchedulerDao.GetActiveSchedulers(); if (dsSchedulers != null) { if (dsSchedulers.Tables[0].Rows.Count > 0) { schedulers = new List <JobScheduler>(); foreach (DataRow dr in dsSchedulers.Tables[0].Rows) { scheduler = new JobScheduler(); int.TryParse(dr["SchedulerId"].ToString(), out int iSchedulerId); scheduler.SchedulerId = iSchedulerId; scheduler.Name = dr["Name"].ToString(); scheduler.Description = dr["description"].ToString(); int.TryParse(dr["Actiontype"].ToString(), out int iActionTye); scheduler.ActionTye = iActionTye; int.TryParse(dr["TransactionType"].ToString(), out int iTransactionType); scheduler.TransactionType = iTransactionType; int.TryParse(dr["PartnerType"].ToString(), out int iPartnerType); scheduler.PartnerType = iPartnerType; int.TryParse(dr["PartnerId"].ToString(), out int iPartnerId); scheduler.PartnerId = iPartnerId; DateTime.TryParse(dr["CreationDate"].ToString(), out DateTime dCreationDate); scheduler.CreationDate = dCreationDate; DateTime.TryParse(dr["StartDate"].ToString(), out DateTime dStartDate); scheduler.StartDate = dStartDate; DateTime.TryParse(dr["EndDate"].ToString(), out DateTime dEndDate); scheduler.EndDate = dEndDate; int.TryParse(dr["RecurrenceFrequency"].ToString(), out int iRecurrenceFrequency); scheduler.RecurrenceFrequency = iRecurrenceFrequency; bool.TryParse(dr["Enabled"].ToString(), out bool bEnabled); scheduler.Enabled = bEnabled; // Add scheduler to the list schedulers.Add(scheduler); } } } return(schedulers); }