private void authButton_Click(object sender, RoutedEventArgs e) { try { ThrowLogin = loginBox.Text; Connected = new MySqlConnection("Database =" + Properties.PersonalData.Default.Database + "; " + "DataSource = " + Properties.PersonalData.Default.DataSource + "; " + "User Id = " + ThrowLogin + "; charset=cp866; SslMode=none; Password ="******"#####"; MySqlCommand checkrolecommand = new MySqlCommand("Select current_role", Connected); MySqlDataReader r = checkrolecommand.ExecuteReader(); r.Read(); try { CheckRole = r.GetString(0); r.Close(); } catch (System.Exception) { } if (CheckRole == "user") { Menu menu = new Menu(); menu.SetConnected = Connected; menu.SetLogin = ThrowLogin; mainGrid.Children.Clear(); mainGrid.Children.Add(menu); menu.BoxesFiling(); return; } else if (CheckRole == "Blocked") { AL.MessageErrorShow("Ваш аккаунт заблокирован", "Ошибка"); return; } else if (CheckRole == "RZD_Dispatcher") { Dispatcher_Interface_In_To_Face DITF = new Dispatcher_Interface_In_To_Face(); DITF.SetConnected = Connected; DITF.SetLogin = ThrowLogin; mainGrid.Children.Clear(); mainGrid.Children.Add(DITF); AL.MessageShow("Привет, диспетчер " + ThrowLogin, "Привет!"); return; } else if (CheckRole == "Admin") { Admin_Interface_In_To_Face AIITF = new Admin_Interface_In_To_Face(); AIITF.SetConnected = Connected; AIITF.SetLogin = ThrowLogin; mainGrid.Children.Clear(); mainGrid.Children.Add(AIITF); AL.MessageShow("Здравствуйте, администратор " + ThrowLogin, "Здравствуйте"); return; } else { AL.MessageErrorShow("Ваш аккаунт неправильно настроен. Обратитесь к администратору", "Ошибка"); return; } } catch (MySqlException ex) { AL.MessageErrorShow("Вы ввели неправильный логин или пароль", "Ошибка"); return; } }