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