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 } }