private void cmdOK_Click(object sender, EventArgs e) { SqlDatabaseSizeEntry selectedEntry; if (SelectedEntry != null) { selectedEntry = (SqlDatabaseSizeEntry)SelectedEntry; } else if (SelectedSqlDatabaseSizeEntry != null) { selectedEntry = (SqlDatabaseSizeEntry)SelectedSqlDatabaseSizeEntry; } else { selectedEntry = new SqlDatabaseSizeEntry(); SelectedEntry = selectedEntry; } selectedEntry.SqlServer = txtServer.Text; selectedEntry.IntegratedSecurity = chkIntegratedSec.Checked; selectedEntry.UserName = txtUserName.Text; selectedEntry.Password = txtPassword.Text; selectedEntry.SqlCmndTimeOutSec = (int)numericUpDownCmndTimeOut.Value; selectedEntry.Database = cboDatabase.Text; selectedEntry.WarningSizeMB = (int)warningNumericUpDown.Value; selectedEntry.ErrorSizeMB = (int)errorNumericUpDown.Value; DialogResult = System.Windows.Forms.DialogResult.OK; Close(); }
public override void OKClicked() { if (SelectedConfig == null) { SelectedConfig = new SqlDatabaseSizeCollectorConfig(); } SqlDatabaseSizeCollectorConfig sqlDbSizeConfig = (SqlDatabaseSizeCollectorConfig)SelectedConfig; sqlDbSizeConfig.Entries.Clear(); foreach (ListViewItem lvi in lvwEntries.Items) { SqlDatabaseSizeEntry sqlDBSizeEntry = (SqlDatabaseSizeEntry)lvi.Tag; sqlDbSizeConfig.Entries.Add(sqlDBSizeEntry); } DialogResult = System.Windows.Forms.DialogResult.OK; Close(); }
private void cmdTest_Click(object sender, EventArgs e) { try { SqlDatabaseSizeEntry test = new SqlDatabaseSizeEntry(); test.SqlServer = txtServer.Text; test.Database = cboDatabase.Text; test.IntegratedSecurity = chkIntegratedSec.Checked; test.UserName = txtUserName.Text; test.Password = txtPassword.Text; test.SqlCmndTimeOutSec = (int)numericUpDownCmndTimeOut.Value; test.WarningSizeMB = (int)warningNumericUpDown.Value; test.ErrorSizeMB = (int)errorNumericUpDown.Value; long currentSize = test.GetDBSize(); MessageBox.Show(string.Format("Current database size: {0} MB", currentSize), "Test", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { MessageBox.Show(ex.Message, "Test", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
//public List<SqlDatabaseSizeEntry> Entries = new List<SqlDatabaseSizeEntry>(); #region IAgentConfig Members public void ReadConfiguration(string configurationString) { XmlDocument config = new XmlDocument(); config.LoadXml(configurationString); XmlElement root = config.DocumentElement; Entries.Clear(); foreach (XmlElement databaseNode in root.SelectNodes("databases/database")) { SqlDatabaseSizeEntry databaseEntry = new SqlDatabaseSizeEntry(); databaseEntry.Database = databaseNode.ReadXmlElementAttr("name", ""); databaseEntry.SqlServer = databaseNode.ReadXmlElementAttr("server", ""); databaseEntry.IntegratedSecurity = databaseNode.ReadXmlElementAttr("integratedSec", true); databaseEntry.UserName = databaseNode.ReadXmlElementAttr("userName", ""); databaseEntry.Password = databaseNode.ReadXmlElementAttr("password", ""); databaseEntry.SqlCmndTimeOutSec = databaseNode.ReadXmlElementAttr("sqlCmndTimeOutSec", 30); databaseEntry.WarningSizeMB = databaseNode.ReadXmlElementAttr("warningValueMB", 1024); databaseEntry.ErrorSizeMB = databaseNode.ReadXmlElementAttr("errorValueMB", 4096); Entries.Add(databaseEntry); } }
public override void RefreshDisplayData() { try { lvwEntries.BeginUpdate(); Cursor.Current = Cursors.WaitCursor; foreach (ListViewItem lvi in lvwEntries.Items) { SqlDatabaseSizeEntry dbSizeEntry = (SqlDatabaseSizeEntry)lvi.Tag; long size = dbSizeEntry.GetDBSize(); lvi.SubItems[1].Text = size.ToString(); CollectorState currentState = dbSizeEntry.GetState(size); if (currentState == CollectorState.Good) { lvi.ImageIndex = 0; } else if (currentState == CollectorState.Warning) { lvi.ImageIndex = 1; } else { lvi.ImageIndex = 2; } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Refresh", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { Cursor.Current = Cursors.Default; lvwEntries.EndUpdate(); } base.RefreshDisplayData(); }