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); }