public clsUser(string EMail, string Password)
{
//get the details for this user
//this line of code became obsolete due to introduction clsDataConnectionOLDB
//Users = new clsDataConnection("select * from Users where EMail = '" + EMail + "' and UserPassword = '******'");
//get the details of the user using stored procedure
oldbUsers = new clsDataConnectionOLDB();
//add the stored procedure parameter and parameter name for the email
oldbUsers.AddParameter("@EMail", EMail);
//add the stored procedure parameter and parameter name for the hash password
oldbUsers.AddParameter("@Password", Password);
//execute the stored procedure
oldbUsers.Execute("query_User");
//if there is one user found
if (oldbUsers.Count > 0)
{
//flag authenticated as true
mAuthenticated = true;
//store the email address
mEMail = Convert.ToString(oldbUsers.DataTable.Rows[0]["EMail"]);
//store the first name
mFirstName = Convert.ToString(oldbUsers.DataTable.Rows[0]["FirstName"]);
//store the User no
mUserNo = Convert.ToInt32(oldbUsers.DataTable.Rows[0]["UserNo"]);
//mLastName = Users.RecordNumber(0).Item("LastName")
mAdmin = Convert.ToBoolean(oldbUsers.DataTable.Rows[0]["Administrator"]);
}
else
{
//else flag authenticated as false
mAuthenticated = false;
}
}
public Boolean Login(string EMail, string Password)
{
//convert the plain text password to a hash code
Password = GetHashString(Password + EMail);
//find the record matching the users email address and password
//this code is now obsolete because the of the introduction of clsDataConnectionOLDB
//clsDataConnection UserAccount = new clsDataConnection("select * from Users where EMail='" + EMail + "' and UserPassword= '******'");
clsDataConnectionOLDB oldbDBConnect = new clsDataConnectionOLDB();
//add the stored procedure parameter and parameter name for the email
oldbDBConnect.AddParameter("@EMail", EMail);
//add the stored procedure parameter and parameter name for the hash password
oldbDBConnect.AddParameter("@Password", Password);
//execute the stored procedure
oldbDBConnect.Execute("query_Login");
//if there is only one record found then return true
if (oldbDBConnect.Count == 1)
{
return(true);
}
else //otherwise return false
{
return(false);
}
}
public bool SendEMail(string SenderEMail, string RecipientEMail, string SubjectLine, string Message)
{
//create a new clsDataConnectionOLDB object
clsDataConnectionOLDB oldbDB = new clsDataConnectionOLDB();
//add the stored procedure parameter and parameter name for the sender email
oldbDB.AddParameter("@SenderEMail", SenderEMail);
//add the stored procedure parameter and parameter name for the recipeint email
oldbDB.AddParameter("@RecipientEMail", RecipientEMail);
//add the stored procedure parameter and parameter name for the subjectline
oldbDB.AddParameter("@SubjectLine", SubjectLine);
//add the stored procedure parameter and parameter name for the message
oldbDB.AddParameter("@Message", Message);
//execute the stored procedure
oldbDB.Execute("query_SendEmail");
//oldcode using old clsDataConnection
//clsDataConnection DB = new clsDataConnection("select * from tblEmail");
//DB.NewRecord["SenderEMail"] = SenderEMail;
//DB.NewRecord["RecipientEMail"] = RecipientEMail;
//DB.NewRecord["SubjectLine"] = SubjectLine;
//DB.NewRecord["Message"] = Message;
//DB.AddNewRecord();
//DB.SaveChanges();
return(true);
}
public Boolean IsEmailUnique(string EMail)
{
clsDataConnectionOLDB DBManager = new clsDataConnectionOLDB();
DBManager.AddParameter("@EMail", EMail);
DBManager.Execute("qry_Users_EmailExists");
if (DBManager.Count >= 1)
{
return(false);
}
else
{
return(true);
}
}
public Boolean Login(string EMail, string Password)
{
Password = GetHashString(Password + EMail);
clsDataConnectionOLDB UserAccount = new clsDataConnectionOLDB();
UserAccount.AddParameter("@EMail", EMail);
UserAccount.AddParameter("@UserPassword", Password);
UserAccount.Execute("qry_Users_FilterByEmailAndPassword");
if (UserAccount.Count >= 1)
{
return(true);
}
else
{
return(false);
}
}
public Boolean Login(string EMail, string Password)
{
//convert the plain text password to a hash code
Password = GetHashString(Password + EMail);
//find the record mataching the users email address and password
clsDataConnectionOLDB UserAccount = new clsDataConnectionOLDB();
//add the parmeters
UserAccount.AddParameter("@EMail", EMail);
UserAccount.AddParameter("@UserPassword", Password);
//execute the query
UserAccount.Execute("qry_Users_FilterByEmailAndPassword");
//if there is only one record found then return true
if (UserAccount.Count >= 1)
{
return(true);
}
else //otherwise reutn false
{
return(false);
}
}
public string SignUp(string EMail, string Password, string PasswordConfirm)
{
//public method allowing the user to sign up for an account
//string variable to store error messages
string ErrorMsg = "";
//if the two passwords match
if (Password == PasswordConfirm)
{
//get the hash of the plain text password
string HashPassword = GetHashString(Password + EMail);
//add the record to the database
//create an instance of the class clsDataConnection
clsDataConnectionOLDB oldbDBConnection = new clsDataConnectionOLDB();
//add the stored procedure parameter and parameter name for the email
oldbDBConnection.AddParameter("@Email", EMail);
//add the stored procedure parameter and parameter name for the hash password
oldbDBConnection.AddParameter("@HashPassword", HashPassword);
//execute the stored procedure
oldbDBConnection.Execute("query_SignUp");
//old obsolete code due to the new clsDataConnectionOLDB
//clsDataConnection DB = new clsDataConnection("select * from Users");
//DB.NewRecord["Email"] = EMail;
//DB.NewRecord["UserPassword"] = HashPassword;
//DB.AddNewRecord();
//DB.SaveChanges();
}
//if the passwords do not match
else
{
//generate an error message
ErrorMsg = "The passwords do not match.";
}
//return the error message (if there is one)
return(ErrorMsg);
}
public string SignUp(string EMail, string Password, string PasswordConfirm)
{
string ErrorMsg = "";
if (!IsEmailUnique(EMail))
{
ErrorMsg = "Account with this email is already registered.";
}
else if (Password == PasswordConfirm)
{
string HashPassword = GetHashString(Password + EMail);
clsDataConnectionOLDB DB = new clsDataConnectionOLDB();
DB.AddParameter("@EMail", EMail);
DB.AddParameter("@userPassword", HashPassword);
DB.Execute("qry_Users_AddUser");
}
else
{
ErrorMsg = "The passwords do not match.";
}
return(ErrorMsg);
}