protected void UpdateProgressStatus(AssessmentStatus status)
{
Status = status;
priorityChart.Titles[0].Text = String.Format("{0} Workorders by Priority", AssessmentStatuses.GetStatusDescription(status));
priorityChart.Visible = true;
DataSet prio = Datalayer.Instance.GetPrioritySummary(status);
foreach (DataPoint dp in priorityChart.Series[0].Points)
{
// Reset all points first
dp.YValues[0] = 0;
}
foreach (DataRow row in prio.Tables["Priority"].Rows)
{
int woPriority = int.Parse(row["WoPriority"].ToString());
DataPoint dp = priorityChart.Series[0].Points[woPriority - 1];
dp.YValues[0] = int.Parse(row["WoCount"].ToString());
}
priorityChart.ChartAreas[0].RecalculateAxesScale();
priorityChart.Invalidate();
priorityChart.Update();
}
public static PSSecurityAssessmentStatus ConvertToPSType(this AssessmentStatus value)
{
return(new PSSecurityAssessmentStatus()
{
Code = value.Code,
Cause = value.Cause,
Description = value.Description
});
}
public StartCentre()
{
InitializeComponent();
Datalayer dl = Datalayer.Instance;
dl.Open();
lblSite.Text = String.Format("{0} Workorder Backlog Prioritisation", dl.Site);
DataPointCollection pc = progressPie.Series[0].Points;
DataPoint p = null;
Button b = null;
DataSet prog = dl.GetProgressSummary();
foreach (DataRow row in prog.Tables["Progress"].Rows)
{
AssessmentStatus status = AssessmentStatuses.GetStatus(row["AssessmentStatus"].ToString());
switch (status)
{
case AssessmentStatus.New:
p = pc[0];
p.Color = Color.Orange;
b = btnNew;
break;
case AssessmentStatus.Completed:
p = pc[1];
p.Color = Color.SeaGreen;
b = btnComp;
break;
case AssessmentStatus.Cancelled:
p = pc[2];
p.Color = Color.Crimson;
b = btnCan;
break;
}
p.AxisLabel = AssessmentStatuses.GetStatusDescription(status);
p.YValues[0] = double.Parse(row["WoCount"].ToString());
b.Text = p.AxisLabel;
b.BackColor = p.Color;
b.Tag = p.Tag = status;
}
progressPie.Invalidate();
progressPie.Update();
priorityChart.Series[0].Points[0].Color = Color.PaleTurquoise;
priorityChart.Series[0].Points[1].Color = Color.MediumAquamarine;
priorityChart.Series[0].Points[2].Color = Color.Teal;
priorityChart.Series[0].Points[3].Color = Color.DarkSlateGray;
}
public static string GetStatusDescription(AssessmentStatus status)
{
switch (status)
{
case AssessmentStatus.Completed:
return("Completed");
case AssessmentStatus.Cancelled:
return("Cancelled");
}
return("New");
}
public static string GetStatusCode(AssessmentStatus status)
{
switch (status)
{
case AssessmentStatus.Completed:
return(CompletedStatus);
case AssessmentStatus.Cancelled:
return(CancelledStatus);
}
return(NewStatus);
}
public override void ExecuteCmdlet()
{
if (ShouldProcess(Name, VerbsCommon.Set))
{
var status = new AssessmentStatus(StatusCode, StatusCause, StatusDescription);
var resourceDetails = new AzureResourceDetails();
var assesssment = new SecurityAssessment(resourceDetails: resourceDetails, status: status, additionalData: AdditionalData);
var result = SecurityCenterClient.Assessments.CreateOrUpdateWithHttpMessagesAsync(AssessedResourceId ?? $"/subscriptions/{DefaultContext.Subscription.Id}", Name, assesssment).GetAwaiter().GetResult().Body;
WriteObject(result.ConvertToPSType(), enumerateCollection: true);
}
}
public DataSet GetPrioritySummary(AssessmentStatus status)
{
string sSQL = "SELECT WOPriority, WoCount " +
"FROM V_Priority " +
"WHERE AssessmentStatus='" + AssessmentStatuses.GetStatusCode(status) + "'";
OleDbCommand cmd = new OleDbCommand(sSQL, _conn);
OleDbDataAdapter da = new OleDbDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds, "Priority");
cmd.Dispose();
da.Dispose();
return(ds);
}
