private void ToolStripMenuItem4_Click(object sender, EventArgs e)
        {
            AuthorizationForm authorizationForm = new AuthorizationForm();

            authorizationForm.Show();
            this.Hide();
        }
Пример #2
0
        private async void RegistrationButton_Click(object sender, EventArgs e)
        {
            bool checkPassword = CheckPass(passwordTextBox.Text.ToString(), loginTextBox.Text.ToString());

            if (checkPassword == true)
            {
                sqlConnection = new SqlConnection(connectionPathMain);
                await sqlConnection.OpenAsync();

                SqlDataReader sdr       = null;
                SqlCommand    cmdSelect = new SqlCommand("SELECT * FROM [Users]", sqlConnection);
                SqlCommand    cmdInsert = new SqlCommand("INSERT INTO [Users] (Login, Pass, Role, Id)VALUES(@Login, @Password, @Role, 10)", sqlConnection);
                cmdInsert.Parameters.AddWithValue("Login", loginTextBox.Text);
                cmdInsert.Parameters.AddWithValue("Password", passwordTextBox.Text);
                cmdInsert.Parameters.AddWithValue("Role", "Заказчик");
                bool   regCheck     = true; //Проверка логина на повтор в базе данных.
                bool   checkLogin   = true; //Проверка логина на символы русского алфавита.
                char[] loginLetters = loginTextBox.Text.ToCharArray();

                for (int i = 0; i < loginLetters.Length; i++)
                {
                    if (loginLetters[i] >= 'А' && loginLetters[i] <= 'ё' && loginLetters.Length != 0)
                    {
                        checkLogin = false;
                        MessageBox.Show("Логин не должен содержать символы русского алфавита!");
                        break;
                    }
                }
                if (checkPassword == true && checkLogin == true)
                {
                    try
                    {
                        sdr = await cmdSelect.ExecuteReaderAsync();

                        while (await sdr.ReadAsync())
                        {
                            if (loginTextBox.Text == Convert.ToString(sdr["Login"]))
                            {
                                MessageBox.Show("Такой логин уже существует!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
                                regCheck             = false;
                                loginTextBox.Text    = "";
                                passwordTextBox.Text = "";
                                break;
                            }
                        }
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show(ex.Message.ToString(), ex.Source.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error);
                    }
                    finally
                    {
                        if (sdr != null)
                        {
                            sdr.Close();
                        }
                        if (regCheck == true)
                        {
                            //cmdInsert.Connection.Open();
                            await cmdInsert.ExecuteNonQueryAsync();

                            //cmdInsert.Connection.Close();
                            loginTextBox.Text    = "";
                            passwordTextBox.Text = "";
                            //Здесь надо сделать выход!!!!!!!!!!!!!!!!!!!!!!
                        }
                    }
                    sqlConnection.Close();
                    AuthorizationForm authorizationForm = new AuthorizationForm();
                    authorizationForm.Size = this.Size;
                    authorizationForm.Left = this.Left;
                    authorizationForm.Top  = this.Top;
                    authorizationForm.Show();
                    this.Hide();
                }
            }
        }