private async void LoginCommand_Executed(object sender, ExecutedRoutedEventArgs e)
        {
            var connectionString = ConfigurationManager.ConnectionStrings["cs_login"].ConnectionString;
            var connection       = new MySqlConnection(connectionString);

            var commandString = $"SELECT count(*) FROM laboratory_books.users WHERE user_name = '{TbxLogin.Text}';";
            var sqlCommand    = new MySqlCommand(commandString, connection);

            try
            {
                await connection.OpenAsync();

                TbkConnectionStatus.Text = "trying to log in...";

                //Check if user exist
                var userCheckResult = (long)(await sqlCommand.ExecuteScalarAsync());
                if (userCheckResult > 0)
                {
                    commandString          = $"SELECT salt FROM laboratory_books.users WHERE user_name = '{TbxLogin.Text}'";
                    sqlCommand.CommandText = commandString;
                    var salt = (string)(await sqlCommand.ExecuteScalarAsync());

                    var generatedHash = LoginHelper.GenerateHash(salt, TbxPassword.Password);

                    commandString          = $"SELECT count(*) FROM laboratory_books.users WHERE user_name = '{TbxLogin.Text}' AND password_hash ='{generatedHash}';";
                    sqlCommand.CommandText = commandString;
                    var passwordAndUserCheckResult = (long)(await sqlCommand.ExecuteScalarAsync());

                    //Check if user and pasword match
                    if (passwordAndUserCheckResult > 0)
                    {
                        TbkConnectionStatus.Text = "Successfully connected";
                        var foregraundBrush = new SolidColorBrush(Colors.Green);
                        TbkConnectionStatus.Foreground = foregraundBrush;

                        //create user
                        var user = await LoginHelper.GetUserByNameAsync(TbxLogin.Text);

                        this.BookUser = user;

                        //get list of databases and fill combobox by their values
                        var dbList = await LoginHelper.GetAvailableLaboratoryBooksAsync(TbxLogin.Text);

                        CbxDataBases.DataContext   = dbList;
                        CbxDataBases.SelectedIndex = 0;
                        CbxDataBases.IsEnabled     = true;

                        //Disable login and password controls
                        TbxLogin.IsEnabled    = false;
                        TbxPassword.IsEnabled = false;

                        IsLogged = true;
                    }
                    else
                    {
                        TbkConnectionStatus.Text = $"Wrong password";
                        var foregraundBrush = new SolidColorBrush(Colors.Red);
                        TbkConnectionStatus.Foreground = foregraundBrush;
                    }
                }
                else
                {
                    var foregraundBrush = new SolidColorBrush(Colors.Red);
                    TbkConnectionStatus.Text       = "User does not exist";
                    TbkConnectionStatus.Foreground = foregraundBrush;
                }
            }
            finally
            {
                await connection.CloseAsync();

                sqlCommand?.Dispose();
            }
        }
示例#2
0
        private async void LoginCommandTwo_Executed(object sender, ExecutedRoutedEventArgs e)
        {
            //initialize report progress
            var progress = new Progress <string>(status =>
            {
                TbkConnectionStatus.Text = status;
            });
            var progressI = progress as IProgress <string>;

            var password = TbxPassword.Password;
            var userName = TbxLogin.Text;

            //initialize connection task
            var connectTask = new Task <User>(() =>
            {
                var connectionString = ConfigurationManager.ConnectionStrings["cs_login"].ConnectionString;
                var connection       = new MySqlConnection(connectionString);

                var commandString = $"SELECT count(*) FROM users WHERE user_name = '{userName}';";
                var sqlCommand    = new MySqlCommand(commandString, connection);

                connection.Open();
                progressI.Report("trying to log in...");
                //Check if user exist
                var userCheckResult = (long)(sqlCommand.ExecuteScalar());

                if (userCheckResult == 0)
                {
                    progressI.Report("User not found...");
                }
                if (userCheckResult > 0)
                {
                    progressI.Report("User found...checking password");
                    commandString          = $"SELECT salt FROM users WHERE user_name = '{userName}'";
                    sqlCommand.CommandText = commandString;
                    var salt = (string)sqlCommand.ExecuteScalar();

                    var generatedHash = LoginHelper.GenerateHash(salt, password);

                    commandString                  = $"SELECT count(*) FROM users WHERE user_name = '{userName}' AND password_hash ='{generatedHash}';";
                    sqlCommand.CommandText         = commandString;
                    var passwordAndUserCheckResult = (long)sqlCommand.ExecuteScalar();

                    //Check if user and pasword match
                    if (passwordAndUserCheckResult > 0)
                    {
                        progressI.Report("Password matched!");

                        //create user
                        var user = LoginHelper.GetUserByName(userName);
                        connection.Close();
                        sqlCommand?.Dispose();
                        return(user);
                        //this.BookUser = user;
                    }
                    else
                    {
                        progressI.Report("Incorrect password!");
                        connection.Close();
                        sqlCommand?.Dispose();
                    }
                }
                return(null);
            });

            try
            {
                connectTask.Start();
                var user = await connectTask;
                if (user != null)
                {
                    this.BookUser = user;
                    this.IsLogged = true;
                }
                else
                {
                    this.BookUser = null;
                    this.IsLogged = false;
                }
            }
            catch (Exception exception)
            {
                MessageBox.Show
                (
                    exception.Message,
                    "Loggin error",
                    MessageBoxButton.OK,
                    MessageBoxImage.Error
                );
            }
            if (!this.IsLogged)
            {
                return;
            }
            // GetAvailableLaboratoryBooks
            var getAvailableBooksTask = new Task <ObservableCollection <string> >(() =>
            {
                progressI.Report("Getting available books...");
                var result = LoginHelper.GetAvailableLaboratoryBooks(userName);
                progressI.Report("Available books recieved...");
                return(result);
            });

            try
            {
                getAvailableBooksTask.Start();

                var dbList = await getAvailableBooksTask;

                CbxDataBases.DataContext   = dbList;
                CbxDataBases.SelectedIndex = 0;
                CbxDataBases.IsEnabled     = true;
                TbkConnectionStatus.Text   = "Succesfully logged!";
                TbxLogin.IsEnabled         = false;
                TbxPassword.IsEnabled      = false;
                await Task.Run(() => LoginHelper.WriteLoginToFile(userName));
            }
            catch (Exception exception)
            {
                MessageBox.Show
                (
                    exception.Message,
                    "Getting books error",
                    MessageBoxButton.OK,
                    MessageBoxImage.Error
                );
            }
            CbxDataBases.Focus();
        }