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; }
private void OnCompleted(DumpResultSet resultSet) { if (resultSet != null) { if (resultSet.wasSuccessful) { List <int> locations = new List <int>(); //get schedule_save_location data table by schedule ID firedumpdbDataSetTableAdapters.schedule_save_locationsTableAdapter savelocAdapter = new firedumpdbDataSetTableAdapters.schedule_save_locationsTableAdapter(); firedumpdbDataSet.schedule_save_locationsDataTable saveloctable = new firedumpdbDataSet.schedule_save_locationsDataTable(); savelocAdapter.FillByScheduleId(saveloctable, schedulesRow.id); if (saveloctable.Count > 0) { //File.AppendAllText(@"servicelog.txt", "saveloctable.Count > 0"); //now get backuplocations by backuplocationID try { firedumpdbDataSetTableAdapters.backup_locationsTableAdapter backupAdapter = new firedumpdbDataSetTableAdapters.backup_locationsTableAdapter(); firedumpdbDataSet.backup_locationsDataTable backuptable = new firedumpdbDataSet.backup_locationsDataTable(); for (int i = 0; i < saveloctable.Count; i++) { firedumpdbDataSet.backup_locationsDataTable temp = backupAdapter.GetDataByID(saveloctable[i].backup_location_id); locations.Add((int)temp[0].id); //File.AppendAllText(@"servicelog.txt", "Addbackup_locationsRow " + temp[0].id + temp[0].name); } locationAdapterManager = new LocationAdapterManager(locations, resultSet.fileAbsPath); locationAdapterManager.SaveInit += onSaveInitHandler; locationAdapterManager.InnerSaveInit += onInnerSaveInitHandler; locationAdapterManager.LocationProgress += onLocationProgressHandler; locationAdapterManager.SaveProgress += setSaveProgressHandler; locationAdapterManager.SaveComplete += onSaveCompleteHandler; locationAdapterManager.SaveError += onSaveErrorHandler; locationAdapterManager.setProgress(); //File.AppendAllText(@"servicelog.txt", "locationAdapterManager.startSave"); locationAdapterManager.startSave(); }catch (Exception ex) { //File.AppendAllText(@"servicelog.txt", "Exception "+ex.ToString()); } } } } }
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex == -1) { return; } if (e.ColumnIndex == 1) { int scheduleId = 0; if (int.TryParse(dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString(), out scheduleId)) { if (scheduleId != -1) { DialogResult result = MessageBox.Show("Are you sure you want to delete this Job?", "Delete Schedule-Job", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (result == DialogResult.Yes) { //delete from userinfo, schedule_save_location and logs first //userinfo firedumpdbDataSetTableAdapters.userinfoTableAdapter userAdapter = new firedumpdbDataSetTableAdapters.userinfoTableAdapter(); userAdapter.DeleteQueryByScheduleid(scheduleId); //logs firedumpdbDataSetTableAdapters.logsTableAdapter logAdapter = new firedumpdbDataSetTableAdapters.logsTableAdapter(); logAdapter.DeleteQueryByScheduleid(scheduleId); //save_locations firedumpdbDataSetTableAdapters.schedule_save_locationsTableAdapter saveLocAdapter = new firedumpdbDataSetTableAdapters.schedule_save_locationsTableAdapter(); saveLocAdapter.DeleteQueryByScheduleId(scheduleId); //last delete from schedule schedulesTableAdapter.DeleteQueryById(scheduleId); firedumpdbDataSet.schedulesDataTable scheduleTable = new firedumpdbDataSet.schedulesDataTable(); schedulesTableAdapter.FillOrderByDate(scheduleTable); dataGridView1.DataSource = scheduleTable; } } } } else { int scheduleId = 0; if (int.TryParse(dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString(), out scheduleId)) { if (scheduleId != -1) { firedumpdbDataSetTableAdapters.schedule_save_locationsTableAdapter savelocAdapter = new firedumpdbDataSetTableAdapters.schedule_save_locationsTableAdapter(); firedumpdbDataSetTableAdapters.backup_locationsTableAdapter backAdapter = new firedumpdbDataSetTableAdapters.backup_locationsTableAdapter(); firedumpdbDataSet.schedule_save_locationsDataTable saveloctable = new firedumpdbDataSet.schedule_save_locationsDataTable(); savelocAdapter.FillByScheduleId(saveloctable, scheduleId); firedumpdbDataSet.backup_locationsDataTable backuptable = new firedumpdbDataSet.backup_locationsDataTable(); if (saveloctable.Count > 0) { backuptable = backAdapter.GetDataByID(saveloctable[0].backup_location_id); dataGridViewlocs.DataSource = backuptable; } //MessageBox.Show(scheduleId+" "+saveloctable.Count.ToString()); } } } }