//create SignUp here
//Create GetHashString here
public string SignUp(string Email, string Password, string PasswordConfirm)
//public method allowing the user to sign up for an account
{
//var to store any errors
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
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 bool SendEMail(string SenderEMail, string RecipientEMail, string SubjectLine, string Message)
{
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);
}
private void AddWishListItem(string WishListItem)
{
//this sub adds a wish list item to the database
//
//open the wish list table
clsDataConnection WishList = new clsDataConnection("select * from wishlist");
//set the description
WishList.NewRecord["Description"] = WishListItem;
//add the record
WishList.AddNewRecord();
//save the changes
WishList.SaveChanges();
}
private void AddSwap(string SwapTitle, string SwapDescription, string ImageFile)
{
//this sub adds a new swap to the swap table
//
//open a connection to the swap table
clsDataConnection Swaps = new clsDataConnection("select * from swap");
//set the title
Swaps.NewRecord["Title"] = SwapTitle;
//set the description
Swaps.NewRecord["Description"] = SwapDescription;
//set the name of the image file
Swaps.NewRecord["ImageFile"] = ImageFile;
//add the record
Swaps.AddNewRecord();
//save the changes
Swaps.SaveChanges();
}
private void SaveOffer(int SwapNo, int UserNo, string OfferTitle, string OfferDescription)
{
//this sub saves the offer to the database
//
//open a connection to the database table
clsDataConnection Offers = new clsDataConnection("select * from offer");
//save the swap no to the new record
Offers.NewRecord["SwapNo"] = SwapNo;
//save the user no to the new record
Offers.NewRecord["UserNo"] = UserNo;
//save the offer title to the new record
Offers.NewRecord["Title"] = OfferTitle;
//save the offer description to the new record
Offers.NewRecord["Description"] = OfferDescription;
//add the new record
Offers.AddNewRecord();
//save the new record
Offers.SaveChanges();
}
private void CreateAccount(string FirstName, string LastName, string EMail, string Password)
{
//this sub creates a new account for the user
//accepts four parameters FirstName LastName EMail and Password
//
//create a connection to the database table users
clsDataConnection Users = new clsDataConnection("select * from users");
//store the first name in the new record object
Users.NewRecord["FirstName"] = FirstName;
//store the last name in the new record object
Users.NewRecord["LastName"] = LastName;
//stor the email in the new record object
Users.NewRecord["EMail"] = EMail;
//store the password
Users.NewRecord["UserPassword"] = Password;
//add the new record
Users.AddNewRecord();
//save the changes (the new user is added to the database)
Users.SaveChanges();
}
