/// <summary>
/// Loads all jobs from SQLDB into a template List
/// </summary>
private void loadJobsFromDB()
{
templates = new List <JobTemplate>();
try
{
DBJob dbJob = new DBJob();
var dbJobQuery = from job in db.Jobs select job;
List <DBJob> dbJobs = dbJobQuery.ToList();
if (dbJobs != null)
{
foreach (DBJob job in dbJobs)
{
JobTemplate template = new JobTemplate();
template.ID = job.JobId;
template.Name = job.JobName;
template.Group = job.JobGroup;
template.processPathStringsFromDB(job.Process, job.WorkingDirectory);
template.Arguments = job.Arguments;
template.WorkingDirectory = job.WorkingDirectory;
template.CronSchedule = job.CronSchedule;
template.Timeout = job.TimeOut.ToString();
templates.Add(template);
}
}
}
catch (Exception ex)
{
QuartzService.log("Error loading Jobs from DB: " + "Exception\n" + ex.StackTrace);
}
}
/// <summary>
/// Load a single job from SQLDB by JobID
/// </summary>
/// <param name="JobID"></param>
/// <returns>Template</returns>
public JobTemplate loadJobFromDB(String JobID)
{
JobTemplate template = new JobTemplate();
try
{
int iJob = Int32.Parse(JobID);
DBJob dbJob = db.Jobs.FirstOrDefault(j => j.JobId == iJob);
template.ID = dbJob.JobId;
template.Name = dbJob.JobName;
template.Group = dbJob.JobGroup;
template.processPathStringsFromDB(dbJob.Process, dbJob.WorkingDirectory);
template.Arguments = dbJob.Arguments;
template.WorkingDirectory = dbJob.WorkingDirectory;
template.CronSchedule = dbJob.CronSchedule;
template.Timeout = dbJob.TimeOut.ToString();
}
catch (Exception ex)
{
QuartzService.log("Error loading Job from DB: " + "Exception\n" + ex.StackTrace);
}
return(template);
}
