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