private void onJobSetDetails(JobDetail jobDetails) { Random rnd = new Random(); int sec = rnd.Next(10, 50); jobDetails.Second = sec; newJobs.Add(jobDetails); Console.WriteLine(jobDetails.DayOfWeek); firedumpdbDataSetTableAdapters.schedulesTableAdapter scheduleAdapter = new firedumpdbDataSetTableAdapters.schedulesTableAdapter(); scheduleAdapter.Insert((int)jobDetails.Server.id, jobDetails.Name, DateTime.Now, jobDetails.Activate, jobDetails.Hour, jobDetails.Database, "-", jobDetails.Minute, jobDetails.Second, jobDetails.DayOfWeek); firedumpdbDataSet.schedulesDataTable scheduleTable = new firedumpdbDataSet.schedulesDataTable(); scheduleAdapter.FillIdByName(scheduleTable, jobDetails.Name); int scheduleId = (int)scheduleTable[0].id; int locId = jobDetails.LocationId; firedumpdbDataSetTableAdapters.schedule_save_locationsTableAdapter savelocAdapter = new firedumpdbDataSetTableAdapters.schedule_save_locationsTableAdapter(); savelocAdapter.Insert(scheduleId, locId); firedumpdbDataSetTableAdapters.backup_locationsTableAdapter backAdapter = new firedumpdbDataSetTableAdapters.backup_locationsTableAdapter(); firedumpdbDataSet.backup_locationsDataTable backuptable = new firedumpdbDataSet.backup_locationsDataTable(); backuptable = backAdapter.GetDataByID(locId); dataGridViewlocs.DataSource = backuptable; scheduleAdapter.FillOrderByDate(scheduleTable); dataGridView1.DataSource = scheduleTable; }
public SchedulerForm() { InitializeComponent(); firedumpdbDataSetTableAdapters.schedulesTableAdapter scheduleAdapter = new firedumpdbDataSetTableAdapters.schedulesTableAdapter(); firedumpdbDataSet.schedulesDataTable scheduleTable = new firedumpdbDataSet.schedulesDataTable(); scheduleAdapter.FillOrderByDate(scheduleTable); dataGridView1.DataSource = scheduleTable; }
private void setUpScheduleList() { scheduleQueue?.Clear(); scheduleQueue = new Queue <ScheduleManager>(); schedules = new firedumpdbDataSet.schedulesDataTable(); schedulesAdapter = new firedumpdbDataSetTableAdapters.schedulesTableAdapter(); //FillByDateOrder schedulesAdapter.FillOrderByDate(schedules); scheduleRowList = new List <firedumpdbDataSet.schedulesRow>(); //copy schedules to List<>scheduleRowList for (int i = 0; i < schedules.Count; i++) { scheduleRowList.Add(schedules[i]); } }
private bool isTimeValid(int day, int hour, int minute) { firedumpdbDataSetTableAdapters.schedulesTableAdapter scheduleAdapter = new firedumpdbDataSetTableAdapters.schedulesTableAdapter(); firedumpdbDataSet.schedulesDataTable scheduletable = new firedumpdbDataSet.schedulesDataTable(); scheduleAdapter.FillOrderByDate(scheduletable); if (scheduletable.Count > 0) { foreach (firedumpdbDataSet.schedulesRow row in scheduletable) { if (isScheduleOverLap(row, day, hour, minute)) { return(false); } } } return(true); }