private void CleanDatabase(Schedule schedule)
{
// connect to the database
DatabaseDataContext db = new DatabaseDataContext();
// delete last 50 records for this schedule from the database
List<Information> toDelete = new List<Information>();
foreach (Information i in db.Informations.Where(z => z.ScheduleID == schedule.ID &&
db.Informations.Where(y => y.ScheduleID == schedule.ID).OrderByDescending(y => y.CreatedDate).Take(100).Contains(z) == false))
{
toDelete.Add(i);
}
// delete information from database
db.Informations.DeleteAllOnSubmit(toDelete);
db.SubmitChanges();
// close connection
db.Dispose();
}
private void LogInformation(HttpStatusCode result, string content)
{
// connect to the database
DatabaseDataContext db = new DatabaseDataContext();
// create new information
Information log = new Information();
// set information properties
log.ID = Guid.NewGuid();
log.ScheduleID = Schedule.ID;
log.Result = (int)result;
if (log.Result != 200)
log.Message = content;
log.CreatedDate = DateTime.UtcNow;
// insert information to database
db.Informations.InsertOnSubmit(log);
db.SubmitChanges();
// close connection
db.Dispose();
}
public override void Run()
{
while (true)
{
// connect to the database
DatabaseDataContext db = new DatabaseDataContext();
// fetch all scheduled jobs that are overdue and enabled
foreach (Schedule s in db.Schedules.Where(z => z.NextOccurrence <= DateTime.UtcNow &&
z.IsEnabled == true))
{
// execute job
Job job = new Job(s);
Thread jobThread = new Thread(new ThreadStart(job.Execute));
jobThread.Start();
// schedule next occurrence
CrontabSchedule schedule = CrontabSchedule.Parse(s.Occurrence);
DateTime nextOccurrence = schedule.GetNextOccurrence(DateTime.UtcNow); // calculate new next occurrence
s.NextOccurrence = nextOccurrence;
db.SubmitChanges();
}
// close connection
db.Dispose();
// sleep for fifteen seconds
Thread.Sleep(15000);
}
}