private void AuditParamResultForm_Load(object sender, EventArgs e) { int selectedQueryId = AuditQueriesSession.Instance.SelectedQueryId; //Get the query from storage QueryStorage qStore = AuditQueriesSession.Instance.GetQueryStorage(); var qParams = qStore.GetQueryParams(selectedQueryId); //Setup the parameter objects if (CollectionUtilities.isNotEmpty(qParams)) { int idx = 0; foreach (var curKey in qParams.Keys) { if (string.IsNullOrEmpty(curKey)) { continue; } auditParameters[idx] = new AuditParamObject(); var curQParam = qParams[curKey]; auditParameters[idx].SetParameterNameAndType(curKey, curQParam.Left); auditParameters[idx].ParameterValue = curQParam.Right; ++idx; } } //If any parameters exist, set them into param data grid view this.populateDataGridWithAuditParameters(); //Disable the execute button this.executeQueryButton.Enabled = false; this.saveButton.Enabled = false; }
private void AuditQueriesForm_Load(object sender, EventArgs e) { //Populate the queries list from resources if (!AuditQueriesSession.Instance.Setup()) { MessageBox.Show("Audit queries session could not be started"); Application.Exit(); } //Disable fields that require specific order this.userNameTextBox.Enabled = true; this.passwordTextBox.Enabled = false; this.loginButton.Enabled = false; this.selectQueryButton.Enabled = false; this.queryListView.Visible = false; this.queryListView.Enabled = false; this.queriesGroupBox.Enabled = false; //Add queries to list box QueryStorage qStore = AuditQueriesSession.Instance.GetQueryStorage(); //queryListView.Items.Clear(); queryListView.BeginUpdate(); int idx = 0; var qStoreIds = qStore.GetQueryIds(); foreach (var curId in qStoreIds) { ListViewItem newListRow; if (this.queryListView.Items.Count < (idx + 1)) { newListRow = this.queryListView.Items.Add(string.Empty); newListRow.SubItems.Add(string.Empty); newListRow.SubItems.Add(string.Empty); } else { newListRow = this.queryListView.Items[0]; } //Set row id newListRow.Text = string.Format("{0}", curId); newListRow.SubItems[1].Text = qStore.GetQueryName(curId); newListRow.SubItems[2].Text = qStore.GetQueryDesc(curId); //Increment index ++idx; } queryListView.EndUpdate(); }
public AuditParamResultForm() { InitializeComponent(); QueryStorage qStore = AuditQueriesSession.Instance.GetQueryStorage(); //Get number of parameters var qParams = qStore.GetQueryParams(AuditQueriesSession.Instance.SelectedQueryId); if (qParams != null) { var numParams = qParams.Keys.Count; auditParameters = new AuditParamObject[numParams]; } cellEditMutex = new object(); resultTable = null; resultBindingSource = new BindingSource(); }