private void loadPolicyMetrics() { //string err_section = "Security Summary Information"; try { if (m_importing) { m_metrics = m_policy.GetExistingPolicyMetrics(Program.gController.Repository.ConnectionString); } else { m_metrics = m_policy.GetPolicyMetrics(Program.gController.Repository.ConnectionString); } if (m_metrics != null) { m_InternalUpdate = true; //save the current grid settings to restore after importing. GridSettings settings = GridSettings.GetSettings(ultraGridPolicyMetrics); ultraGridPolicyMetrics.DataSource = m_metrics; updateVulnerabilityLayout(); ultraGridPolicyMetrics.ActiveRow = null; ultraGridPolicyMetrics.Selected.Rows.Clear(); //restore the saved grid settings so it appears the same to the user settings.ApplySettingsToGrid(ultraGridPolicyMetrics); m_InternalUpdate = false; UltraGridRow[] rows = ultraGridPolicyMetrics.Rows.GetAllNonGroupByRows(); if (rows.GetLength(0) > 0) { ultraGridPolicyMetrics.Selected.Rows.Add(rows[0]); rows[0].Activate(); } } } catch (Exception ex) { logX.loggerX.Error("Error loading PolicyMetrics", ex); } UpdateEnabledCount(); }
private void button_ResetToDefaults_Click(object sender, EventArgs e) { Cursor = Cursors.WaitCursor; m_metrics = PolicyMetric.GetPolicyMetrics(Program.gController.Repository.ConnectionString, 0, 0); foreach (PolicyMetric m in m_metrics) { m.SetMetricChanged(); } if (m_metrics != null) { //save the current grid settings to restore after importing. GridSettings settings = GridSettings.GetSettings(ultraGridPolicyMetrics); ultraGridPolicyMetrics.DataSource = m_metrics; updateVulnerabilityLayout(); m_InternalUpdate = true; ultraGridPolicyMetrics.Selected.Rows.Clear(); //restore the saved grid settings so it appears the same to the user settings.ApplySettingsToGrid(ultraGridPolicyMetrics); m_InternalUpdate = false; UltraGridRow[] rows = ultraGridPolicyMetrics.Rows.GetAllNonGroupByRows(); if (rows.GetLength(0) > 0) { ultraGridPolicyMetrics.Selected.Rows.Add(rows[0]); rows[0].Activate(); } } UpdateEnabledCount(); Cursor = Cursors.Default; }
private void loadDataSource() { logX.loggerX.Info("Retrieve Policy Report Card"); try { _textBox_Description.Text = DisplayNoLog; // Open connection to repository and query permissions. using (SqlConnection connection = new SqlConnection(Program.gController.Repository.ConnectionString)) { // Open the connection. connection.Open(); // Setup parameters for all queries SqlParameter paramPolicyId = new SqlParameter(ParamPolicyId, m_policy.PolicyId); SqlParameter paramAssessmentId = new SqlParameter(ParamAssessmentId, m_policy.AssessmentId); // Get Change Log SqlCommand cmd = new SqlCommand(QueryGetChangeLog, connection); cmd.CommandType = CommandType.Text; cmd.CommandTimeout = SQLCommandTimeout.GetSQLCommandTimeoutFromRegistry(); cmd.Parameters.Add(paramPolicyId); cmd.Parameters.Add(paramAssessmentId); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); m_ChangeLogTable = ds.Tables[0]; // fix the time by converting to local for display foreach (DataRow row in m_ChangeLogTable.Rows) { row[colChangedDate] = ((DateTime)row[colChangedDate]).ToLocalTime(); } m_ChangeLogTable.DefaultView.Sort = colChangedDate; _grid_ChangeLog.SuspendLayout(); // Save the user configuration of the grid to restore it after setting the datasource again Utility.GridSettings gridSettings = GridSettings.GetSettings(_grid_ChangeLog); _label_ChangeLog.Text = string.Format(HeaderDisplay, m_ChangeLogTable.DefaultView.Count, m_ChangeLogTable.DefaultView.Count == 1 ? @"y" : @"ies"); _grid_ChangeLog.SetDataBinding(m_ChangeLogTable.DefaultView, null); // Reapply the user's settings after rebuilding the grid GridSettings.ApplySettingsToGrid(gridSettings, _grid_ChangeLog); if (!m_Initialized) { foreach (UltraGridColumn col in _grid_ChangeLog.DisplayLayout.Bands[0].Columns) { //if (col.Key != colSeverityCode) { col.PerformAutoResize(PerformAutoSizeType.AllRowsInBand, true); } } _grid_ChangeLog.DisplayLayout.Bands[0].SortedColumns.Add(colChangedDate, true, false); m_Initialized = true; } _grid_ChangeLog.ResumeLayout(); } } catch (Exception ex) { logX.loggerX.Error(@"Error - Unable to retrieve policy change log", ex); MsgBox.ShowError(string.Format(ErrorMsgs.CantGetPolicyInfoMsg, "Policy Change Log"), ErrorMsgs.ErrorProcessPolicyInfo, ex); initDataSources(); _grid_ChangeLog.ResumeLayout(); } }