private void UserRoutes_MouseDown(object sender, MouseEventArgs e) { var userRoutesPage = new UserRoutesPage(); userRoutesPage.connectionString = connectionString; ContentFrame.Navigate(userRoutesPage); }
private void LogInButton_Click(object sender, RoutedEventArgs e) { ErrorLabel.Content = ""; string login = LoginBox.Text; string password = PasswordBox.Password; if (login != "") { try { connectionString = "Server=(LocalDB)\\MSSQLLocalDB;Database=PassengerTransportationDB;User Id=" + login + ";Password="******";"; owner.connectionString = connectionString; var connection = new SqlConnection(connectionString); string expression = "IF IS_MEMBER ('db_ddladmin') = 1 SELECT 1 ELSE SELECT 0"; connection.Open(); var command = new SqlCommand(expression, connection); var isAdmin = command.ExecuteScalar(); if ((int)isAdmin == 1) { owner.ContentFrame.Navigate(new WelcomeAdminPage()); owner.AdminMenu.Visibility = Visibility.Visible; } else { var userRoutesPage = new UserRoutesPage(); userRoutesPage.connectionString = connectionString; owner.ContentFrame.Navigate(userRoutesPage); owner.UserMenu.Visibility = Visibility.Visible; } connection.Close(); } catch { ErrorLabel.Content = "Неверный логин или пароль"; } } }