Exemple #1
0
        private void check_User_login()
        {
            string          hashed_password = create_hash(txtPassword.Text);
            clsDBConnector  dbConnector     = new clsDBConnector();
            OleDbDataReader dr;
            string          sqlStr;

            dbConnector.Connect();
            sqlStr = "SELECT tblUsers.User_ID FROM ((tblSchools INNER JOIN tblTeachers ON tblSchools.School_ID = tblTeachers.School_ID) INNER JOIN tblUsers ON tblSchools.School_ID = tblUsers.School_ID AND tblTeachers.Teacher_ID = tblUsers.Teacher_ID) WHERE (tblUsers.UserName = '******') AND (tblUsers.pwdHash = '" + hashed_password + "') AND (tblSchools.School_Name = '" + txtSchool.Text.ToLower() + "')";
            dr     = dbConnector.DoSQL(sqlStr);
            if (dr.HasRows)                                                    // Checks if a student exists with that username, school and password
            {
                frmOperators frmOperator = new frmOperators(txtUsername.Text); //Shows the Operator form as the logged user
                frmOperator.ShowDialog();
                this.Close();
            }
            else
            {
                MessageBox.Show("Login Failed");//tells user their login failed
            }
        }
Exemple #2
0
        private void btnOperators_Click(object sender, EventArgs e)
        {
            frmOperators frmOperators = new frmOperators("teacher");

            frmOperators.ShowDialog();
        }