private void checkScheduledInspections(Object source, ElapsedEventArgs e)
{
DataBase db = new DataBase();
List <PlanDS> plans = db.getAllPlans();
foreach (PlanDS plan in plans)
{
DateTime now = DateTime.Now;
bool isShouldInspect = PlanDS.getTimeStringFormat(now).Equals(PlanDS.getTimeStringFormat(plan.time));
if (isShouldInspect)
{
Thread inspectThread = new Thread(new ThreadStart(
() => this.startInspection(plan)
));
inspectThread.Start();
}
}
}
public bool addPlan(PlanDS plan)
{
List <PlanDS> ps = this.getAllPlans();
foreach (PlanDS p in ps)
{
bool haveThisTime = PlanDS.getTimeStringFormat(p.time) == PlanDS.getTimeStringFormat(plan.time);
bool haveThisPath = p.path == plan.path;
if (haveThisTime && haveThisPath)
{
return(false);
}
}
connection.Open();
var command = connection.CreateCommand();
command.CommandText = $"insert into plans(path, time) values(\"{plan.path}\", \"{PlanDS.getTimeStringFormat(plan.time)}\")";
command.ExecuteScalar();
connection.Close();
return(true);
}
