/// <summary> /// Returns nurse /// </summary> /// <param name="userName">The UserName</param> /// <param name="password">The Password</param> /// <returns>Nurse Object</returns> public static Nurse GetNurse( string userName, string password) { Nurse nurse = null; String selectStatement = " SELECT n.UserName, u.Password, n.NurseID " + " FROM Nurses n JOIN UserSecurity u ON n.UserName = u.UserName "+ " WHERE n.UserName = @UserName AND u.Password = @Password "; try { using (SqlConnection connection = MedassistDB.GetConnection()) { connection.Open(); using (SqlCommand cmnd = new SqlCommand(selectStatement, connection)) { cmnd.Parameters.AddWithValue("@UserName", userName); cmnd.Parameters.AddWithValue("@Password", password); using (SqlDataReader reader = cmnd.ExecuteReader()) { while (reader.Read()) { nurse = new Nurse(); nurse.UserName = reader["UserName"].ToString(); nurse.Password = reader["Password"].ToString(); nurse.NurseID = (int)reader["NurseID"]; } } } } } catch (SqlException ex) { throw ex; } catch (Exception ex) { throw ex; } return nurse; }
/// <summary> /// The method manages a nurse login, so that he/she can get access to other /// applications after login button is clicked /// </summary> /// <param name="sender"></param> /// <param name="e"></param> public void button1_Click(object sender, EventArgs e) { string userName = textBoxUserName.Text; string password = MD5Hash(textBoxPassword.Text); if (Validator.IsPresent(textBoxUserName) && Validator.IsPresent(textBoxPassword)); { try { this.nurse = this.controllerNurse.GetNurse(userName, password); this.admin = this.adminController.GetAdmin(userName, password); UserSecurityController.AdminLoggedIn = this.admin; UserSecurityController.NurseLoggedIn = this.nurse; if (this.nurse != null || this.admin != null) { this.mainForm = new MainForm(); this.mainForm.Text = "You are logged in as " + userName; if (this.mainForm.ShowDialog() == DialogResult.OK) { this.mainForm.Show(); } else { this.Close(); } } else { MessageBox.Show("Invalid user name or password."); } } catch (Exception ex) { MessageBox.Show(ex.Message); } } }