public void AddWithSameConnection()
{
if (lvwEntries.SelectedItems.Count > 0 && lvwEntries.SelectedItems[0].Tag is QueryInstance)
{
SqlQueryCollectorEditEntry editSqlQueryInstance = new SqlQueryCollectorEditEntry();
QueryInstance masterToCopy = (QueryInstance)lvwEntries.SelectedItems[0].Tag;
QueryInstance sqlQueryInstanceCopy = new QueryInstance()
{
SqlServer = masterToCopy.SqlServer,
Database = masterToCopy.Database,
IntegratedSecurity = masterToCopy.IntegratedSecurity,
UserName = masterToCopy.UserName,
Password = masterToCopy.Password,
CmndTimeOut = masterToCopy.CmndTimeOut
};
editSqlQueryInstance.SelectedQueryInstance = sqlQueryInstanceCopy;
if (editSqlQueryInstance.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
ListViewItem lvi = new ListViewItem(editSqlQueryInstance.SelectedQueryInstance.Name);
lvi.SubItems.Add(editSqlQueryInstance.SelectedQueryInstance.ToServerDBName());
lvi.SubItems.Add(editSqlQueryInstance.SelectedQueryInstance.WarningValue);
lvi.SubItems.Add(editSqlQueryInstance.SelectedQueryInstance.ErrorValue);
lvi.Tag = editSqlQueryInstance.SelectedQueryInstance;
lvwEntries.Items.Add(lvi);
CheckOKEnabled();
CheckEnableButtons();
}
}
}
public override void EditItem()
{
if (lvwEntries.SelectedItems.Count > 0 && lvwEntries.SelectedItems[0].Tag is QueryInstance)
{
SqlQueryCollectorEditEntry editSqlQueryInstance = new SqlQueryCollectorEditEntry();
editSqlQueryInstance.SelectedQueryInstance = (QueryInstance)lvwEntries.SelectedItems[0].Tag;
if (editSqlQueryInstance.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
ListViewItem lvi = lvwEntries.SelectedItems[0];
lvi.Text = editSqlQueryInstance.SelectedQueryInstance.Name;
lvi.SubItems[1].Text = editSqlQueryInstance.SelectedQueryInstance.ToServerDBName();
lvi.SubItems[2].Text = editSqlQueryInstance.SelectedQueryInstance.WarningValue;
lvi.SubItems[3].Text = editSqlQueryInstance.SelectedQueryInstance.ErrorValue;
lvi.Tag = editSqlQueryInstance.SelectedQueryInstance;
}
}
}
public override void AddItem()
{
SqlQueryCollectorEditEntry editSqlQueryInstance = new SqlQueryCollectorEditEntry();
editSqlQueryInstance.SelectedQueryInstance = new QueryInstance();
if (editSqlQueryInstance.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
ListViewItem lvi = new ListViewItem(editSqlQueryInstance.SelectedQueryInstance.Name);
lvi.SubItems.Add(editSqlQueryInstance.SelectedQueryInstance.ToServerDBName());
lvi.SubItems.Add(editSqlQueryInstance.SelectedQueryInstance.WarningValue);
lvi.SubItems.Add(editSqlQueryInstance.SelectedQueryInstance.ErrorValue);
lvi.Tag = editSqlQueryInstance.SelectedQueryInstance;
lvwEntries.Items.Add(lvi);
CheckOKEnabled();
CheckEnableButtons();
}
}
