private void buttonBack_Click(object sender, EventArgs e)
        {
            ClientMenuForm cfm = new ClientMenuForm();

            cfm.Show();
            Close();
        }
Exemplo n.º 2
0
        private void btnLogin_Click(object sender, EventArgs e)
        {
            using (SqlConnection connection = new SqlConnection(Properties.Settings.Default.connectionString)) {
                string login, password;
                try
                {
                    login    = textBoxLogin.Text;
                    password = textBoxPas.Text;
                    connection.Open();
                    string loginQuery = "SELECT [Роль],[id_Пользователь] FROM [Пользователь] WHERE [Логин]='" +
                                        login + "' AND [Пароль] COLLATE Cyrillic_General_CS_AS = '" + password + "'";
                    SqlCommand    loginCmd    = new SqlCommand(loginQuery, connection);
                    SqlDataReader loginReader = loginCmd.ExecuteReader();
                    if (loginReader.HasRows)
                    {
                        loginReader.Read();
                        Properties.Settings.Default.roleUser = loginReader.GetString(0);
                        Properties.Settings.Default.idUser   = loginReader.GetInt32(1);
                        Form f = null;
                        switch (Properties.Settings.Default.roleUser)
                        {
                        case "dir":
                            f = new DirectorMenuForm();
                            break;

                        case "mas":
                            f = new MasterMenuForm();
                            break;

                        case "cli":
                            f = new ClientMenuForm();
                            break;

                        default:
                            break;
                        }
                        f.Show();
                        Close();
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show("Database Error" + ex);
                }
            }
        }