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();
}
private void cmdTest_Click(object sender, EventArgs e)
{
try
{
SqlDatabaseSizeCollectorEntry test = new SqlDatabaseSizeCollectorEntry();
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 void FromXml(string configurationString)
{
XmlDocument config = new XmlDocument();
config.LoadXml(configurationString);
XmlElement root = config.DocumentElement;
Entries.Clear();
foreach (XmlElement databaseNode in root.SelectNodes("databases/database"))
{
SqlDatabaseSizeCollectorEntry databaseEntry = new SqlDatabaseSizeCollectorEntry();
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);
}
}
//#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();
}
