public CreateNewQuery(XDocument xml, string name, string query, List <string> parameters, ListBox.ObjectCollection servers, List <string> chckedServers, bool dataBase, SQLGUI.Common.Query q)
{
InitializeComponent();
XML = xml;
editing = true;
uxQueryNameTextBox.Text = name;
uxQueryTextTextBox.Text = query;
uxDBChckBx.Checked = dataBase;
queryN = name;
uxServerListBx.Items.AddRange(servers);
Query = q;
origQuery = name;
for (int i = 0; i <= (uxServerListBx.Items.Count - 1); i++)
{
if (chckedServers.Contains(uxServerListBx.Items[i].ToString()))
{
uxServerListBx.SetItemCheckState(i, CheckState.Checked);
}
else
{
uxServerListBx.SetItemCheckState(i, CheckState.Unchecked);
}
}
indexes = new List <int>();
for (int i = 0; i < parameters.Count; i++)
{
if (parameters[i] != null)
{
uxParameterGrid.Rows.Add(i + 1, parameters[i]);
if (i == 0)
{
uxQueryTextTextBox.Text = uxQueryTextTextBox.Text.Insert(uxQueryTextTextBox.Text.IndexOf("[P]") + 2, (i + 1).ToString());
indexes.Add(uxQueryTextTextBox.Text.IndexOf("[P" + (i + 1) + "]"));
}
else
{
uxQueryTextTextBox.Text = uxQueryTextTextBox.Text.Insert(uxQueryTextTextBox.Text.IndexOf("[P]"), (i + 1).ToString());
indexes.Add(uxQueryTextTextBox.Text.IndexOf("[P" + (i + 1) + "]", indexes[i - 1] + 1));
}
}
}
index = parameters.Count + 1;
if (Properties.Settings.Default.customThemeSet)
{
themeClass.customTheme(this);//Sets the custom theme for the form
}
}
public CreateNewQuery(XDocument xml, ListBox.ObjectCollection servers, SQLGUI.Common.Query q)
{
InitializeComponent();
XML = xml;
editing = false;
uxServerListBx.Items.AddRange(servers);
Query = q;
if (Properties.Settings.Default.customThemeSet)
{
themeClass.customTheme(this);//Sets the custom theme for the form
}
}
