private void uxCreateNewQuery_Click(object sender, EventArgs e)
{
uxNullQueryError.Clear();
var newQuery = new CreateNewQuery(theXML, uxServersListBox.Items, queries[0]);
newQuery.ShowDialog();
reloadData();
}
private void uxEditQueryBtn_Click(object sender, EventArgs e)
{
if (uxQueryListBox.SelectedItem == null)
{
uxNullQueryError.Dispose(); //removes Query error if displayed
uxNullQueryError.SetError(lblQueries, "You need to select a query!");
return;
}
else
{
uxNullQueryError.Clear();
}
var query = queries[0];
for (int i = 0; i < queries.Count; i++)
{
if (queries[i].queryName == uxQueryListBox.SelectedItem.ToString())
{
query = queries[i];
}
}
List <string> param = new List <string>();
List <string> chckedServers = new List <string>();
for (int i = 0; i < query.paramList.Count; i++)
{
param.Add(query.paramList[i]);
}
for (int i = 0; i < query.sqlServers.Count; i++)
{
chckedServers.Add(query.sqlServers[i]);
}
bool database;
if (query.database != null)
{
database = true;
}
else
{
database = false;
}
var editQuery = new CreateNewQuery(theXML, uxQueryListBox.SelectedItem.ToString(), query.queryText, param, uxServersListBox.Items, chckedServers, database, query);
editQuery.ShowDialog();
reloadData();
}
