private void cmdTest_Click(object sender, EventArgs e) { try { SqlDatabaseSizeCollectorEntry test = new SqlDatabaseSizeCollectorEntry(); string serverName = ApplyConfigVarsOnField(txtServer.Text); string databaseName = ApplyConfigVarsOnField(cboDatabase.Text); string username = ApplyConfigVarsOnField(txtUserName.Text); string password = ApplyConfigVarsOnField(txtPassword.Text); test.SqlServer = serverName; test.Database = databaseName; test.IntegratedSecurity = chkIntegratedSec.Checked; test.UserName = username; test.Password = password; 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); } }
private void cmdOK_Click(object sender, EventArgs e) { SqlDatabaseSizeCollectorEntry selectedEntry; if (SelectedEntry == null) { selectedEntry = new SqlDatabaseSizeCollectorEntry(); } selectedEntry = (SqlDatabaseSizeCollectorEntry)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(); }
//#region ICollectorConfigEntryEditWindow //public ICollectorConfigEntry SelectedEntry { get; set; } //public QuickMonDialogResult ShowEditEntry() //{ // return (QuickMonDialogResult)ShowDialog(); //} //#endregion #region Form events private void SqlDatabaseSizeCollectorEditEntry_Load(object sender, EventArgs e) { SqlDatabaseSizeCollectorEntry selectedEntry; if (SelectedEntry == null) { SelectedEntry = new SqlDatabaseSizeCollectorEntry() { SqlCmndTimeOutSec = 30, IntegratedSecurity = true } } ; selectedEntry = (SqlDatabaseSizeCollectorEntry)SelectedEntry; txtServer.Text = selectedEntry.SqlServer; cboDatabase.Text = selectedEntry.Database; chkIntegratedSec.Checked = selectedEntry.IntegratedSecurity; txtUserName.Text = selectedEntry.UserName; txtPassword.Text = selectedEntry.Password; numericUpDownCmndTimeOut.Value = selectedEntry.SqlCmndTimeOutSec; warningNumericUpDown.Value = selectedEntry.WarningSizeMB; errorNumericUpDown.Value = selectedEntry.ErrorSizeMB; LoadDatabases(); CheckOkEnabled(); }