private void btnReport_Click(object sender, EventArgs e)
{
if (profileDataGridView.SelectedRows.Count > 0)
{
int[] profileIds = new int[profileDataGridView.SelectedRows.Count];
int i = 0;
foreach (DataGridViewRow row in profileDataGridView.SelectedRows)
{
profileIds[i] = Convert.ToInt32(row.Cells["Id"].Value);
i++;
}
DataTable profiles = QueryDb.SelectProfilesByIds(profileIds);
DataTable recentJobs = QueryDb.SelectJobsByProfileIds(profileIds);
List <ProfileJobs> profJobList = new List <ProfileJobs>();
foreach (var profile in profiles.AsEnumerable())
{
ProfileJobs pj = new ProfileJobs();
pj.Profile = new Profile(profile);
DataTable jobs = recentJobs.AsEnumerable()
.Where(r => r.Field <int>("ProfileId") == pj.Profile.Id).CopyToDataTable();
foreach (var job in jobs.AsEnumerable())
{
RecentJob rj = new RecentJob(job);
pj.AddRecentJob(rj);
}
profJobList.Add(pj);
}
ReportForm report = new ReportForm(profJobList);
report.Show();
}
}
private void btnReport_Click(object sender, EventArgs e)
{
if (profileDataGridView.SelectedRows.Count > 0)
{
int[] profileIds = new int[profileDataGridView.SelectedRows.Count];
int i = 0;
foreach (DataGridViewRow row in profileDataGridView.SelectedRows)
{
profileIds[i] = Convert.ToInt32(row.Cells["Id"].Value);
i++;
}
DataTable profiles = QueryDb.SelectProfilesByIds(profileIds);
DataTable recentJobs = QueryDb.SelectJobsByProfileIds(profileIds);
List<ProfileJobs> profJobList = new List<ProfileJobs>();
foreach (var profile in profiles.AsEnumerable())
{
ProfileJobs pj = new ProfileJobs();
pj.Profile = new Profile(profile);
DataTable jobs = recentJobs.AsEnumerable()
.Where(r => r.Field<int>("ProfileId") == pj.Profile.Id).CopyToDataTable();
foreach (var job in jobs.AsEnumerable())
{
RecentJob rj = new RecentJob(job);
pj.AddRecentJob(rj);
}
profJobList.Add(pj);
}
ReportForm report = new ReportForm(profJobList);
report.Show();
}
}
private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
if (Convert.ToInt32(((DataTable)dataGridView1.DataSource).Rows[e.RowIndex]["Id"]) > 0)
{
RecentJob job = new RecentJob(((DataTable)dataGridView1.DataSource).Rows[e.RowIndex]);
JobForm jForm = new JobForm(job, workerName);
jForm.Show();
jForm.updateDGW += this.updateDGVfromDb;
}
}
private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
if (Convert.ToInt32(((DataTable)dataGridView1.DataSource).Rows[e.RowIndex]["Id"]) > 0)
{
RecentJob job = new RecentJob(((DataTable)dataGridView1.DataSource).Rows[e.RowIndex]);
JobForm jForm = new JobForm(job, workerName);
jForm.Show();
jForm.updateDGW += this.updateDGVfromDb;
}
}
public JobForm(RecentJob job, string worker)
{
currentJob = job;
InitializeComponent();
this.Text = worker;
tBxJobName.Text = currentJob.JobName;
dTPReceiptDate.Value = currentJob.ReceiptDate;
if (currentJob.DismissDate != DateTime.MinValue)
{
dTPDissmissDate.Value = currentJob.DismissDate;
}
else
{
dTPDissmissDate.Value = DateTime.Today;
checkBox1.Checked = true;
}
tBxDismissReason.Text = currentJob.DismissReason;
}
public JobForm(RecentJob job, string worker)
{
currentJob = job;
InitializeComponent();
this.Text = worker;
tBxJobName.Text = currentJob.JobName;
dTPReceiptDate.Value = currentJob.ReceiptDate;
if (currentJob.DismissDate != DateTime.MinValue)
{
dTPDissmissDate.Value = currentJob.DismissDate;
}
else
{
dTPDissmissDate.Value = DateTime.Today;
checkBox1.Checked = true;
}
tBxDismissReason.Text = currentJob.DismissReason;
}
public static void InsertRecentJob(RecentJob job)
{
string sql = "insert into RecentJobs " +
"(ProfileId, JobName, ReceiptDate, DismissDate, DismissReason) " +
"values (@ProfileId, @JobName, @ReceiptDate, @DismissDate, @DismissReason)";
Dictionary <string, object> parameters = new Dictionary <string, object>();
parameters.Add("ProfileId", job.ProfileId);
parameters.Add("JobName", job.JobName);
parameters.Add("ReceiptDate", job.ReceiptDate);
if (job.DismissDate != DateTime.MinValue)
{
parameters.Add("DismissDate", job.DismissDate);
}
else
{
parameters.Add("DismissDate", DBNull.Value);
}
parameters.Add("DismissReason", job.DismissReason ?? Convert.DBNull);
QueryWParams(sql, parameters, false);
}
public static void UpdateRecentJob(RecentJob job)
{
string sql = "UPDATE RecentJobs SET JobName = @JobName, ReceiptDate = @ReceiptDate, " +
"DismissDate = @DismissDate, DismissReason = @DismissReason WHERE " +
"Id = @Id";
Dictionary <string, object> parameters = new Dictionary <string, object>();
parameters.Add("JobName", job.JobName);
parameters.Add("ReceiptDate", job.ReceiptDate);
if (job.DismissDate != DateTime.MinValue)
{
parameters.Add("DismissDate", job.DismissDate);
}
else
{
parameters.Add("DismissDate", DBNull.Value);
}
parameters.Add("DismissReason", job.DismissReason ?? Convert.DBNull);
parameters.Add("Id", job.Id);
QueryWParams(sql, parameters, false);
}
static void InsertRecentJob(RecentJob recentJob, SqlCeConnection cn)
{
SqlCeCommand cmd;
string sql = "insert into RecentJobs " +
"(ProfileId, JobName, ReceiptDate, DismissDate, " +
" DismissReason) " +
"values (@ProfileId, @JobName, @ReceiptDate, @DismissDate," +
" @DismissReason)";
try
{
cmd = new SqlCeCommand(sql, cn);
cmd.Parameters.AddWithValue("@ProfileId", recentJob.ProfileId);
cmd.Parameters.AddWithValue("@JobName", recentJob.JobName);
cmd.Parameters.AddWithValue("@ReceiptDate", recentJob.ReceiptDate);
if (recentJob.DismissDate != DateTime.MinValue)
{
cmd.Parameters.AddWithValue("@DismissDate", recentJob.DismissDate);
}
else
{
cmd.Parameters.AddWithValue("@DismissDate", DBNull.Value);
}
cmd.Parameters.AddWithValue("@DismissReason", recentJob.DismissReason ?? Convert.DBNull);
cmd.ExecuteNonQuery();
}
catch (SqlCeException sqlexception)
{
MessageBox.Show(sqlexception.Message, "Sql Exception"
, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Exception"
, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public static void DisplayJobScheduleLong(ITestOutputHelper testOutputHelper, CloudJobSchedule curWI)
{
// job schedule top level simple properties
testOutputHelper.WriteLine("Id: " + curWI.Id);
testOutputHelper.WriteLine(" State: " + curWI.State.ToString());
testOutputHelper.WriteLine(" " + "URL: " + curWI.Url);
testOutputHelper.WriteLine(" " + "LastModified: " + (curWI.LastModified.HasValue ? curWI.LastModified.Value.ToLongDateString() : "<null>"));
// execution INFO
{
JobScheduleExecutionInformation wiExInfo = curWI.ExecutionInformation;
testOutputHelper.WriteLine(" ExeInfo:");
testOutputHelper.WriteLine(" LastUpdateTime: " + (wiExInfo.EndTime.HasValue ? wiExInfo.EndTime.Value.ToLongDateString() : "<null>"));
testOutputHelper.WriteLine(" NextRuntime: " + (wiExInfo.NextRunTime.HasValue ? wiExInfo.NextRunTime.Value.ToLongDateString() : "<null>"));
testOutputHelper.WriteLine(" RecentJob:");
// RecentJob
RecentJob rj = wiExInfo.RecentJob;
if (null == rj)
{
testOutputHelper.WriteLine(" <null>");
}
else
{
testOutputHelper.WriteLine(" Id: " + rj.Id);
testOutputHelper.WriteLine(" Url: " + rj.Url);
}
}
// JobSpecification
JobSpecification jobSpec = curWI.JobSpecification;
testOutputHelper.WriteLine(" JobSpecification:");
if (null == jobSpec)
{
testOutputHelper.WriteLine(" <null>");
}
else
{
testOutputHelper.WriteLine("");
testOutputHelper.WriteLine(" Priority: " + (jobSpec.Priority.HasValue ? jobSpec.Priority.ToString() : "<null>"));
JobConstraints jobCon = jobSpec.Constraints;
testOutputHelper.WriteLine(" Constraints: ");
if (null == jobCon)
{
testOutputHelper.WriteLine("null");
}
else
{
testOutputHelper.WriteLine("");
testOutputHelper.WriteLine(" MaxTaskRetryCount: " + (jobCon.MaxTaskRetryCount.HasValue ? jobSpec.Constraints.MaxTaskRetryCount.Value.ToString() : "<null>"));
testOutputHelper.WriteLine(" MaxWallClockTime: " + (jobCon.MaxWallClockTime.HasValue ? jobSpec.Constraints.MaxWallClockTime.Value.TotalMilliseconds.ToString() : "<null>"));
}
JobManagerTask ijm = jobSpec.JobManagerTask;
if (null == ijm)
{
testOutputHelper.WriteLine("<null>");
}
else
{
testOutputHelper.WriteLine(" JobManagerTask:");
testOutputHelper.WriteLine(" CommandLine : " + ijm.CommandLine);
testOutputHelper.WriteLine(" KillJobOnCompletion: " + (ijm.KillJobOnCompletion.HasValue ? ijm.KillJobOnCompletion.Value.ToString() : "<null>"));
testOutputHelper.WriteLine(" Id : " + ijm.Id);
testOutputHelper.WriteLine(" RunExclusive : " + (ijm.RunExclusive.HasValue ? ijm.RunExclusive.Value.ToString() : "<null>"));
IEnumerable <EnvironmentSetting> envSettings = ijm.EnvironmentSettings;
if (null != envSettings)
{
List <EnvironmentSetting> envSettingsList = new List <EnvironmentSetting>(ijm.EnvironmentSettings);
testOutputHelper.WriteLine(" EnvironmentSettings.count:" + envSettingsList.Count);
}
else
{
testOutputHelper.WriteLine(" EnvironmentSettings: <null>");
}
IEnumerable <ResourceFile> resFilesProp = ijm.ResourceFiles;
if (null != resFilesProp)
{
List <ResourceFile> resFiles = new List <ResourceFile>();
testOutputHelper.WriteLine(" ResourceFiles.count:" + resFiles.Count);
}
else
{
testOutputHelper.WriteLine(" ResourceFiles: <null>");
}
TaskConstraints tc = ijm.Constraints;
if (null == tc)
{
testOutputHelper.WriteLine(" TaskConstraints: <null>");
}
else
{
testOutputHelper.WriteLine(" TaskConstraints: ");
testOutputHelper.WriteLine(" MaxTaskRetryCount: " + (tc.MaxTaskRetryCount.HasValue ? tc.MaxTaskRetryCount.Value.ToString() : "<null>"));
testOutputHelper.WriteLine(" MaxWallClockTime: " + (tc.MaxWallClockTime.HasValue ? tc.MaxWallClockTime.Value.TotalMilliseconds.ToString() : "<null>"));
testOutputHelper.WriteLine(" RetentionTime: " + (tc.RetentionTime.HasValue ? tc.RetentionTime.Value.TotalMilliseconds.ToString() : "<null>"));
}
if (ijm.UserIdentity != null)
{
testOutputHelper.WriteLine(" UserIdentity: ");
testOutputHelper.WriteLine(" UserName: "******" ElevationLevel: ", ijm.UserIdentity.AutoUser?.ElevationLevel);
testOutputHelper.WriteLine(" Scope: ", ijm.UserIdentity.AutoUser?.Scope);
}
}
}
// metadata
{
IEnumerable <MetadataItem> mdis = curWI.Metadata;
testOutputHelper.WriteLine(" Metadata: ");
if (null == mdis)
{
testOutputHelper.WriteLine("<null>");
}
else
{
List <MetadataItem> meta = new List <MetadataItem>(curWI.Metadata);
testOutputHelper.WriteLine(" count:" + meta.Count);
}
}
// schedule
Schedule sched = curWI.Schedule;
if (null == sched)
{
testOutputHelper.WriteLine(" Schedule: <null>");
}
else
{
testOutputHelper.WriteLine(" Schedule:");
testOutputHelper.WriteLine(" DoNotRunAfter:" + (sched.DoNotRunAfter.HasValue ? sched.DoNotRunAfter.Value.ToLongDateString() : "<null>"));
testOutputHelper.WriteLine(" DoNotRunUntil: " + (sched.DoNotRunUntil.HasValue ? sched.DoNotRunUntil.Value.ToLongDateString() : "<null>"));
testOutputHelper.WriteLine(" RecurrenceInterval: " + (sched.RecurrenceInterval.HasValue ? sched.RecurrenceInterval.Value.TotalMilliseconds.ToString() : "<null>"));
testOutputHelper.WriteLine(" StartWindow :" + (sched.StartWindow.HasValue ? sched.StartWindow.Value.TotalMilliseconds.ToString() : "<null>"));
}
// stats
JobScheduleStatistics stats = curWI.Statistics;
if (null == stats)
{
testOutputHelper.WriteLine(" Stats: <null>");
}
else
{
testOutputHelper.WriteLine(" Stats:");
testOutputHelper.WriteLine(" LastUpdateTime: " + stats.LastUpdateTime.ToLongDateString());
testOutputHelper.WriteLine(" KernelCPUTime: " + stats.KernelCpuTime.TotalMilliseconds.ToString());
testOutputHelper.WriteLine(" NumFailedTasks: " + stats.FailedTaskCount.ToString());
testOutputHelper.WriteLine(" NumTimesCalled : " + stats.TaskRetryCount);
testOutputHelper.WriteLine(" NumSucceededTasks: " + stats.SucceededTaskCount);
testOutputHelper.WriteLine(" ReadIOGiB : " + stats.ReadIOGiB);
testOutputHelper.WriteLine(" ReadIOps : " + stats.ReadIOps);
testOutputHelper.WriteLine(" StartTime : " + stats.StartTime.ToLongDateString());
testOutputHelper.WriteLine(" Url : " + stats.Url);
testOutputHelper.WriteLine(" UserCpuTime : " + stats.UserCpuTime.TotalMilliseconds.ToString());
testOutputHelper.WriteLine(" WaitTime : " + stats.WaitTime.TotalMilliseconds.ToString());
testOutputHelper.WriteLine(" WallClockTime : " + stats.WallClockTime.TotalMilliseconds.ToString());
testOutputHelper.WriteLine(" WriteIOGiB : " + stats.WriteIOGiB);
testOutputHelper.WriteLine(" WriteIOps : " + stats.WriteIOps);
}
}
public static void InsertRecentJob(RecentJob job)
{
string sql = "insert into RecentJobs " +
"(ProfileId, JobName, ReceiptDate, DismissDate, DismissReason) " +
"values (@ProfileId, @JobName, @ReceiptDate, @DismissDate, @DismissReason)";
Dictionary<string, object> parameters = new Dictionary<string, object>();
parameters.Add("ProfileId", job.ProfileId);
parameters.Add("JobName", job.JobName);
parameters.Add("ReceiptDate", job.ReceiptDate);
if (job.DismissDate != DateTime.MinValue)
{
parameters.Add("DismissDate", job.DismissDate);
}
else
{
parameters.Add("DismissDate", DBNull.Value);
}
parameters.Add("DismissReason", job.DismissReason ?? Convert.DBNull);
QueryWParams(sql, parameters, false);
}
public static void UpdateRecentJob(RecentJob job)
{
string sql = "UPDATE RecentJobs SET JobName = @JobName, ReceiptDate = @ReceiptDate, " +
"DismissDate = @DismissDate, DismissReason = @DismissReason WHERE " +
"Id = @Id";
Dictionary<string, object> parameters = new Dictionary<string, object>();
parameters.Add("JobName", job.JobName);
parameters.Add("ReceiptDate", job.ReceiptDate);
if (job.DismissDate != DateTime.MinValue)
{
parameters.Add("DismissDate", job.DismissDate);
}
else
{
parameters.Add("DismissDate", DBNull.Value);
}
parameters.Add("DismissReason", job.DismissReason ?? Convert.DBNull);
parameters.Add("Id", job.Id);
QueryWParams(sql, parameters, false);
}
static void InsertRecentJob(RecentJob recentJob, SqlCeConnection cn)
{
SqlCeCommand cmd;
string sql = "insert into RecentJobs " +
"(ProfileId, JobName, ReceiptDate, DismissDate, " +
" DismissReason) " +
"values (@ProfileId, @JobName, @ReceiptDate, @DismissDate," +
" @DismissReason)";
try
{
cmd = new SqlCeCommand(sql, cn);
cmd.Parameters.AddWithValue("@ProfileId", recentJob.ProfileId);
cmd.Parameters.AddWithValue("@JobName", recentJob.JobName);
cmd.Parameters.AddWithValue("@ReceiptDate", recentJob.ReceiptDate);
if (recentJob.DismissDate != DateTime.MinValue)
{
cmd.Parameters.AddWithValue("@DismissDate", recentJob.DismissDate);
}
else
{
cmd.Parameters.AddWithValue("@DismissDate", DBNull.Value);
}
cmd.Parameters.AddWithValue("@DismissReason", recentJob.DismissReason ?? Convert.DBNull);
cmd.ExecuteNonQuery();
}
catch (SqlCeException sqlexception)
{
MessageBox.Show(sqlexception.Message, "Sql Exception"
, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Exception"
, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void AddRecentJob(RecentJob job)
{
recentJobs.Add(job);
}
