private void addWithSameConnectionDetailsToolStripMenuItem_Click(object sender, EventArgs e)
{
if (lvwQueries.SelectedItems.Count > 0 && lvwQueries.SelectedItems[0].Tag is QueryInstance)
{
EditSqlQueryInstance editSqlQueryInstance = new EditSqlQueryInstance();
QueryInstance masterToCopy = (QueryInstance)lvwQueries.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.SqlServer + "\\" + editSqlQueryInstance.SelectedQueryInstance.Database);
lvi.SubItems.Add(editSqlQueryInstance.SelectedQueryInstance.WarningValue);
lvi.SubItems.Add(editSqlQueryInstance.SelectedQueryInstance.ErrorValue);
lvi.Tag = editSqlQueryInstance.SelectedQueryInstance;
lvwQueries.Items.Add(lvi);
CheckOKEnabled();
CheckButtonsEnable();
}
}
}
private void editToolStripButton_Click(object sender, EventArgs e)
{
if (lvwQueries.SelectedItems.Count > 0 && lvwQueries.SelectedItems[0].Tag is QueryInstance)
{
EditSqlQueryInstance editSqlQueryInstance = new EditSqlQueryInstance();
editSqlQueryInstance.SelectedQueryInstance = (QueryInstance)lvwQueries.SelectedItems[0].Tag;
if (editSqlQueryInstance.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
ListViewItem lvi = lvwQueries.SelectedItems[0];
lvi.Text = editSqlQueryInstance.SelectedQueryInstance.Name;
lvi.SubItems[1].Text = editSqlQueryInstance.SelectedQueryInstance.SqlServer + "\\" + editSqlQueryInstance.SelectedQueryInstance.Database;
lvi.SubItems[2].Text = editSqlQueryInstance.SelectedQueryInstance.WarningValue;
lvi.SubItems[3].Text = editSqlQueryInstance.SelectedQueryInstance.ErrorValue;
lvi.Tag = editSqlQueryInstance.SelectedQueryInstance;
}
}
}
private void addToolStripButton_Click(object sender, EventArgs e)
{
EditSqlQueryInstance editSqlQueryInstance = new EditSqlQueryInstance();
editSqlQueryInstance.SelectedQueryInstance = new QueryInstance();
if (editSqlQueryInstance.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
ListViewItem lvi = new ListViewItem(editSqlQueryInstance.SelectedQueryInstance.Name);
lvi.SubItems.Add(editSqlQueryInstance.SelectedQueryInstance.SqlServer + "\\" + editSqlQueryInstance.SelectedQueryInstance.Database);
lvi.SubItems.Add(editSqlQueryInstance.SelectedQueryInstance.WarningValue);
lvi.SubItems.Add(editSqlQueryInstance.SelectedQueryInstance.ErrorValue);
lvi.Tag = editSqlQueryInstance.SelectedQueryInstance;
lvwQueries.Items.Add(lvi);
CheckOKEnabled();
CheckButtonsEnable();
}
}
