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 loadlocationsCombobox()
{
firedumpdbDataSetTableAdapters.backup_locationsTableAdapter locAdapter = new firedumpdbDataSetTableAdapters.backup_locationsTableAdapter();
loctable = new firedumpdbDataSet.backup_locationsDataTable();
locAdapter.Fill(loctable);
cblocation.DataSource = loctable;
cblocation.DisplayMember = "name";
cblocation.ValueMember = "id";
if (cblocation.Items.Count > 0)
{
cblocation.SelectedIndex = 0;
}
}
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)
{
Console.WriteLine(ex.ToString());
//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());
}
}
}
}
