示例#1
0
        private void AuthorizationButton_Click(object sender, EventArgs e)
        {
            if (string.IsNullOrEmpty(loginTextBox.Text))
            {
                MessageBox.Show("Введите логин!");
                return;
            }
            if (string.IsNullOrEmpty(passwordTextBox.Text))
            {
                MessageBox.Show("Введите пароль!");
                return;
            }
            Program.cn.Open();
            Program.cmd             = new MySql.Data.MySqlClient.MySqlCommand();
            Program.cmd.Connection  = Program.cn;
            Program.cmd.CommandText = string.Format("SELECT userLogin FROM turbostyle.users" +
                                                    " WHERE userLogin = '******' AND userPassword = '******'", loginTextBox.Text, passwordTextBox.Text);
            Program.cmd.Prepare();
            Program.cmd.ExecuteNonQuery();
            string resultLogin = (string)Program.cmd.ExecuteScalar();

            if (resultLogin == loginTextBox.Text)
            {
                Hide();
                Program.cmd.CommandText = string.Format("SELECT userType FROM turbostyle.users" +
                                                        " WHERE userLogin = '******'", resultLogin);
                Program.cmd.Prepare();
                Program.cmd.ExecuteNonQuery();
                resultUserType = (string)Program.cmd.ExecuteScalar();
                if (resultUserType == "s")
                {
                    menuForm = new MainMenuForm();
                    menuForm.Show();
                }
                else if (resultUserType == "a")
                {
                    inWorkForm = new RequestsInWorkForm();
                    inWorkForm.Show();
                }
                Program.cn.Close();
            }
            else
            {
                MessageBox.Show("Неправильный логин или пароль!");
                Program.cn.Close();
                return;
            }
        }
示例#2
0
 private void requestsInWorkButton_Click(object sender, EventArgs e)
 {
     inWorkForm = new RequestsInWorkForm();
     inWorkForm.Show();
 }