private string GetQIValue(ListViewItem lvi, OLEDBQueryInstance queryInstance) { string results = ""; try { object value = queryInstance.RunQuery(); CollectorState currentstate = queryInstance.GetState(value); results = FormatUtils.N(value, "[null]"); if (currentstate == CollectorState.Error) { lvi.ImageIndex = 3; } else if (currentstate == CollectorState.Warning) { lvi.ImageIndex = 2; } else { lvi.ImageIndex = 1; } } catch (Exception ex) { results = ex.Message; } return(results); }
private void cmdTest_Click(object sender, EventArgs e) { if (DoValidate()) { string lastStep = "Initialize values"; try { Cursor.Current = Cursors.WaitCursor; OLEDBQueryInstance testQueryInstance = new OLEDBQueryInstance(); testQueryInstance.Name = txtName.Text; testQueryInstance.ConnectionString = txtConnectionString.Text; testQueryInstance.CmndTimeOut = (int)numericUpDownCmndTimeOut.Value; testQueryInstance.UseSPForSummary = chkUseSPForSummary.Checked; testQueryInstance.SummaryQuery = txtStateQuery.Text; if (cboReturnType.SelectedIndex == 0) { testQueryInstance.ReturnValueIsNumber = false; testQueryInstance.UseRowCountAsValue = false; testQueryInstance.UseExecuteTimeAsValue = false; } else { testQueryInstance.ReturnValueIsNumber = true; if (cboReturnType.SelectedIndex == 2) { testQueryInstance.UseRowCountAsValue = true; } else if (cboReturnType.SelectedIndex == 3) { testQueryInstance.UseExecuteTimeAsValue = true; chkReturnValueNotInverted.Checked = true; } } testQueryInstance.ReturnValueInverted = !chkReturnValueNotInverted.Checked; testQueryInstance.SuccessValue = cboSuccessValue.Text; testQueryInstance.WarningValue = cboWarningValue.Text; testQueryInstance.ErrorValue = cboErrorValue.Text; testQueryInstance.UseSPForDetail = chkUseSPForDetail.Checked; testQueryInstance.DetailQuery = txtDetailQuery.Text; lastStep = "Run summary query"; object returnValue = testQueryInstance.RunQuery(); if (!testQueryInstance.UseRowCountAsValue && !testQueryInstance.UseExecuteTimeAsValue && !returnValue.IsNumber()) { throw new Exception(string.Format("Return value is not an integer!\r\nValue returned: {0}", returnValue)); } //testing detail query List <DataColumn> columns = new List <DataColumn>(); lastStep = "Testing detail query"; DataSet ds = testQueryInstance.RunDetailQuery(); lastStep = "Testing detail query - Getting column names"; columns.AddRange((from DataColumn c in ds.Tables[0].Columns select c).ToArray()); MessageBox.Show(string.Format("Success!\r\nSummary value return: {0}\r\nDetail row count: {1}\r\nDetail columns returned: {2}", returnValue, ds.Tables[0].Rows.Count, columns.ToCSVString()), "Test", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { MessageBox.Show(string.Format("Failed!\r\nLast step: {0}\r\n{1}", lastStep, ex.Message), "Test", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } finally { Cursor.Current = Cursors.Default; } } }