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();
}
