/// <summary> /// login window uses this method to authenticate user /// </summary> /// <param name="username">username supplied by user</param> /// <param name="password">password supplied by user</param> /// <returns> /// if authentication is successful, Candidate or Admin object is returned according to user type, /// otherwise null /// </returns> public static User authenticateUser(String username, String password) { //get user CTVIATBankDataSet.UsersDataTable table = usersAdapter.GetUserByUserNameAndPassword(username, password); //if no user with supplied credentials, return null if (table.Rows.Count == 0) { return(null); } //otherwise create user object else { DataRow row = table.Rows[0]; if (Convert.ToByte(row["userType"]) == 1) { return(new Admin(Convert.ToInt32(row["userID"]), Convert.ToString(row["userName"]), Convert.ToString(row["userPassword"]))); } else { return(new Candidate(Convert.ToInt32(row["userID"]), Convert.ToString(row["userName"]), Convert.ToString(row["userPassword"]))); } } }
/// <summary> /// Used to get information of all candidates /// </summary> /// <returns> /// Arraylist of candidate objects /// </returns> public static ArrayList getAllCandidates(String pattern) { CTVIATBankDataSet.UsersDataTable table = usersAdapter.GetCandidates("%" + pattern + "%"); ArrayList users = new ArrayList(); foreach (DataRow row in table) { users.Add(new Candidate(Convert.ToInt32(row["userID"]), Convert.ToString(row["userName"]), Convert.ToString(row["userPassword"]))); } return(users); }
/// <summary> /// Username is unique, user object is created by querying username /// </summary> /// <param name="userName">username of user</param> /// <returns> /// User object /// </returns> public static User getUserByUserName(String userName) { CTVIATBankDataSet.UsersDataTable userTable = usersAdapter.GetUserByUserName(userName); if (userTable.Count == 0) { return(null); } else { if (userTable[0]["userType"].ToString() == "1") { return(new Admin(Convert.ToInt32(userTable[0]["userID"]), Convert.ToString(userTable[0]["userName"]), Convert.ToString(userTable[0]["userPassword"]))); } else { return(new Candidate(Convert.ToInt32(userTable[0]["userID"]), Convert.ToString(userTable[0]["userName"]), Convert.ToString(userTable[0]["userPassword"]))); } } }
/// <summary> /// Used to get information of all users /// </summary> /// <returns> /// Arraylist of user objects /// </returns> public static ArrayList getAllUsers() { CTVIATBankDataSet.UsersDataTable allUsersTable = usersAdapter.GetAllUsers(); ArrayList users = new ArrayList(); foreach (DataRow row in allUsersTable) { if (row["userType"].ToString() == "1") { Admin temp = new Admin(Convert.ToInt32(row["userID"]), Convert.ToString(row["userName"]), Convert.ToString(row["userPassword"])); users.Add(temp); } else { Candidate temp = new Candidate(Convert.ToInt32(row["userID"]), Convert.ToString(row["userName"]), Convert.ToString(row["userPassword"])); users.Add(temp); } } return(users); }