private void CityBox_DropDownOpened(object sender, EventArgs e) { CityBox.SelectedIndex = -1; if (CountryBox.Text != "") { SqlManager sqlManager = new SqlManager(); int num = sqlManager.ReturnNumber("SELECT Num_country FROM Countries WHERE Name_country = '" + CountryBox.Text + "'"); if (num != -2) { CityBox.ItemsSource = null; CityBox = DataManager.PushComboBox(CityBox, "Name_city", "SELECT Name_city FROM Cities WHERE Num_country = " + num); if (CityBox == null) { PagesManager.ShowConnectionError(); } } else if (num == -2) { PagesManager.ShowConnectionError(); } } else { CityBox = DataManager.PushComboBox(CityBox, "Name_city", "SELECT Name_city FROM Cities"); if (CityBox == null) { PagesManager.ShowConnectionError(); } } System.GC.Collect(); }
public PageFilterTrips() { InitializeComponent(); CountryBox = DataManager.PushComboBox(CountryBox, "Name_country", "SELECT Name_country FROM Countries"); if (CountryBox == null) { PagesManager.ShowConnectionError(); } }
public WindowAdmin() { InitializeComponent(); sqlManager = new SqlManager(); listRegexs = new Dictionary <string, string> { { "String", @"[А-яа-я0-9\ ]{2,50}" }, { "Int32", @"\d{1,10}" }, { "Date", @"^(?:(?:31(.)(?:0?[13578]|1[02]))\1|(?:(?:29|30)(.)(?:0?[1,3-9]|1[0-2])\2))(?:(?:1[6-9]|[2-9]\d)?\d{2})$|^(?:29(.)0?2\3(?:(?:(?:1[6-9]|[2-9]\d)?(?:0[48]|[2468][048]|[13579][26])|(?:(?:16|[2468][048]|[3579][26])00))))$|^(?:0?[1-9]|1\d|2[0-8])(.)(?:(?:0?[1-9])|(?:1[0-2]))\4(?:(?:1[6-9]|[2-9]\d)?\d{2})$" }, { "Decimal", @"^\d*(?(?=\d.{1}\d)\d*.{1}\d*)$" } }; if ((tables = DataManager.PushComboBox(tables, "name", "SELECT name FROM sys.tables " + "WHERE name != 'sysdiagrams' AND name != 'Trips' AND name != 'Accounts' AND name != 'Passwords'")) == null) { ShowConnectionError(); } }