// Written By James Hibbard
///
/// <summary>
/// Checks whether the validity of the password
/// </summary>
/// <param name="Username">The users Username</param>
/// <param name="Password">The input password to check</param>
/// <param name="userRole">Returns the role they're in (null if incorrect password)</param>
/// <returns>True if the password is accurate</returns>
static public bool authenticateUser(string Username, string Password, out string userRole)
{
if (!UsernameExists(Username))
{
userRole = null;
return(false);
}
UserTableAdapter userAdapter = new UserTableAdapter();
NuRacingDataSet.UserDataTable userTable = userAdapter.GetUser(Username);
NuRacingDataSet.UserRow userRow = (NuRacingDataSet.UserRow)userTable.Rows[0];
if (userRow.User_Active)
{
if (userRow.User_PasswordHash.SequenceEqual(HashPassword(Password, userRow.User_PasswordSalt)))
{
userRole = userRow.User_Role;
return(true);
}
}
else
{
userRole = null;
return(false);
}
userRole = null;
return(false);
}
static public void setPassword(string Username, string NewPassword, string OldPassword)
{
string UserRole;
if (!authenticateUser(Username, OldPassword, out UserRole))
{
throw new ArgumentException("Old Password was incorrect");
}
if (!validPassword(NewPassword))
{
throw new ArgumentException("Password wasn't valid");
}
if (UsernameExists(Username))
{
UserTableAdapter userAdapter = new UserTableAdapter();
NuRacingDataSet.UserDataTable userTable = userAdapter.GetUser(Username);
NuRacingDataSet.UserRow userRow = (NuRacingDataSet.UserRow)userTable.Rows[0];
byte[] salt = CreateSalt();
byte[] hash = HashPassword(NewPassword, salt);
userRow.User_PasswordHash = hash;
userRow.User_PasswordSalt = salt;
userAdapter.Update(userTable);
}
else
{
throw new ArgumentException("Username wasn't valid");
}
}
public static string GetUserRole(string Username)
{
UserTableAdapter userAdapter = new UserTableAdapter();
NuRacingDataSet.UserDataTable userTable = userAdapter.GetUser(Username);
NuRacingDataSet.UserRow userRow = (NuRacingDataSet.UserRow)userTable.Rows[0];
return(userRow.User_Role);
}
public void resetData()
{
if (!beenChanged)
{
UserTableAdapter userAdapter = new UserTableAdapter();
NuRacingDataSet.UserDataTable userTable = userAdapter.GetUser(username);
NuRacingDataSet.UserRow userRow = (NuRacingDataSet.UserRow)userTable.Rows[0];
setData(userRow);
}
}
// Written By James Hibbard
/// <summary>
/// Sets the Last Activity Date in the database for the given user
/// </summary>
/// <param name="Username">The User that was active</param>
static public void wasActive(string Username)
{
if (UsernameExists(Username))
{
UserTableAdapter userAdapter = new UserTableAdapter();
NuRacingDataSet.UserDataTable userTable = userAdapter.GetUser(Username);
NuRacingDataSet.UserRow userRow = (NuRacingDataSet.UserRow)userTable.Rows[0];
userRow.User_LastActivity = DateTime.Now;
userAdapter.Update(userTable);
}
}
//Written By Simon Davis
/// <summary>
/// Returns a UserInfo object for the specified user
/// </summary>
/// <param name="Username">User's username</param>
/// <returns></returns>
static public UserInfo getUser(string Username)
{
if (!User.UsernameExists(Username))
{
throw new ArgumentException("Username wasn't valid");
}
UserTableAdapter userAdapter = new UserTableAdapter();
NuRacingDataSet.UserDataTable userTable = userAdapter.GetUser(Username);
NuRacingDataSet.UserRow userRow = (NuRacingDataSet.UserRow)userTable.Rows[0];
UserInfo userInfo = new UserInfo(userRow);
return(userInfo);
}
public static void SetUserActiveStatus(string Username, bool active)
{
if (UsernameExists(Username))
{
UserTableAdapter userAdapter = new UserTableAdapter();
NuRacingDataSet.UserDataTable userTable = userAdapter.GetUser(Username);
NuRacingDataSet.UserRow userRow = userTable[0];
if (userRow.User_Active != active)
{
//avoid making the connection if possible
userRow.User_Active = active;
userAdapter.Update(userTable);
}
}
else
{
throw new ArgumentException("Username wasn't valid");
}
}
public void updateDatabase()
{
if (beenChanged)
{
UserTableAdapter userAdapter = new UserTableAdapter();
NuRacingDataSet.UserDataTable userTable = userAdapter.GetUser(username);
NuRacingDataSet.UserRow userRow = (NuRacingDataSet.UserRow)userTable.Rows[0];
userRow.User_GivenName = givenName;
userRow.User_Surname = surname;
userRow.User_Email = email;
userRow.User_Role = userRole;
userRow.User_StudentNumber = studentnumber;
userRow.User_EstGraduationYear = estimatedGraduationYear;
userRow.User_Degree = degree;
userRow.User_MedicareNo = medicareNumber;
userRow.User_Allergies = allergies;
userRow.User_MedicareNo = medicalConditions;
userRow.User_DietaryRequirements = dietaryRequirements;
userRow.User_IndemnityFormSigned = indemnityFormSigned;
userRow.User_SAE_MemberNo = saeMembershipNumber;
userRow.User_SAE_Expiry = saeMembershipExpiry;
userRow.User_CAMS_MemberNo = camsMembershipNumber;
userRow.User_CAMS_LicenseType = camsLicenseType;
userRow.User_LicenseNo = driversLicenseNumber;
userRow.User_LicenseState = driversLicenseState;
userRow.User_EmergencyContactName = emergencyContactName;
userRow.User_EmergencyContactNumber = emergencyContactPhoneNumber;
userRow.User_Created = dateCreated;
userRow.User_LastLogin = lastLoggedIn;
userRow.User_LastActivity = lastActivity;
userRow.User_LastPasswordChanged = passwordLastChanged;
userRow.User_LastLockoutDate = lastLockedOut;
userRow.User_Active = isActive;
userAdapter.Update(userTable);
}
}
private void setData(NuRacingDataSet.UserRow userRow)
{
givenName = userRow.User_GivenName;
surname = userRow.User_Surname;
username = userRow.User_Username;
email = userRow.User_Email;
userRole = userRow.User_Role;
studentnumber = userRow.User_StudentNumber;
estimatedGraduationYear = userRow.User_EstGraduationYear;
degree = userRow.User_Degree;
medicareNumber = userRow.User_MedicareNo;
allergies = userRow.User_Allergies;
medicalConditions = userRow.User_MedicareNo;
dietaryRequirements = userRow.User_DietaryRequirements;
indemnityFormSigned = userRow.User_IndemnityFormSigned;
saeMembershipNumber = userRow.User_SAE_MemberNo;
saeMembershipExpiry = userRow.User_SAE_Expiry;
camsMembershipNumber = userRow.User_CAMS_MemberNo;
camsLicenseType = userRow.User_CAMS_LicenseType;
driversLicenseNumber = userRow.User_LicenseNo;
driversLicenseState = userRow.User_LicenseState;
emergencyContactName = userRow.User_EmergencyContactName;
emergencyContactPhoneNumber = userRow.User_EmergencyContactNumber;
dateCreated = userRow.User_Created;
lastLoggedIn = userRow.User_LastLogin;
lastActivity = userRow.User_LastActivity;
passwordLastChanged = userRow.User_LastPasswordChanged;
lastLockedOut = userRow.User_LastLockoutDate;
isActive = userRow.User_Active;
}
static public UserInfo addUser(string Username, string Password, string UserRole, string GivenName, string Surname, string Email, string StudentNumber,
string YearOfGradutation, string DegreeName, string MedicareNumber, string Allergies, string MedicalConditions, string DietaryRequirements,
bool IndemnityFormSigned, string SAEMembershipNumber, DateTime SAEExpiryDate, string CAMSMembershipNumber, string CAMSLicenseType,
string DriversLicenseNumber, string DriversLicenseState, string EmergencyContactName, string EmergencyContactPhoneNumber, bool IsActive = true)
{
UserTableAdapter userAdapter = new UserTableAdapter();
NuRacingDataSet.UserDataTable userTable = userAdapter.GetData();
NuRacingDataSet.UserRow userRow = userTable.NewUserRow();
if (UsernameExists(Username))
{
throw new ArgumentException("Username already exists");
}
if (!isEmailValid(Email))
{
throw new ArgumentException("Email isn't in a valid format");
}
if (EmailExists(Email))
{
throw new ArgumentException("Email already exists");
}
if (Password == "")
{
StringBuilder builder = new StringBuilder();
byte[] ByteCode = getByteString(8);
foreach (byte b in ByteCode)
{
builder.Append(b.ToString("X2"));
}
Password = builder.ToString();
}
else if (!validPassword(Password))
{
throw new ArgumentException("Invalid Password");
}
if (!Role.UserRoles.Contains(UserRole))
{
throw new ArgumentException("Invalid Role");
}
byte[] Salt = CreateSalt();
byte[] HashedPassword = HashPassword(Password, Salt);
userRow.User_Username = Username;
userRow.User_PasswordHash = HashedPassword;
userRow.User_PasswordSalt = Salt;
userRow.User_Role = UserRole;
userRow.User_GivenName = GivenName;
userRow.User_Surname = Surname;
userRow.User_Email = Email;
userRow.User_StudentNumber = StudentNumber;
userRow.User_EstGraduationYear = YearOfGradutation;
userRow.User_Degree = DegreeName;
userRow.User_MedicareNo = MedicareNumber;
userRow.User_Allergies = Allergies;
userRow.User_MedicalConditions = MedicalConditions;
userRow.User_DietaryRequirements = DietaryRequirements;
userRow.User_IndemnityFormSigned = IndemnityFormSigned;
userRow.User_SAE_MemberNo = SAEMembershipNumber;
userRow.User_SAE_Expiry = SAEExpiryDate;
userRow.User_CAMS_MemberNo = CAMSMembershipNumber;
userRow.User_CAMS_LicenseType = CAMSLicenseType;
userRow.User_LicenseNo = DriversLicenseNumber;
userRow.User_LicenseState = DriversLicenseState;
userRow.User_EmergencyContactName = EmergencyContactName;
userRow.User_EmergencyContactNumber = EmergencyContactPhoneNumber;
userRow.User_Active = IsActive;
userRow.User_Created = DateTime.Now;
userRow.User_LastLogin = DateTime.Now;
userRow.User_LastActivity = DateTime.Now;
userRow.User_LastPasswordChanged = DateTime.Now;
userRow.User_LastLockoutDate = DateTime.Now;
userTable.AddUserRow(userRow);
userAdapter.Update(userTable);
EmailManager.newUser(Username, Password, Email);
return(UserInfo.getUser(Username));
}
//Written By Simon Davis
//Updated By James Hibbard
/// <summary>
/// Class constructor
/// </summary>
/// <param name="userRow">A row from the User table in the database</param>
private UserInfo(NuRacingDataSet.UserRow userRow)
{
setData(userRow);
}
