//Password added to database when submit password button is clicked by user
private void SubmitPass_Click(object sender, EventArgs e)
{
string pass = encryptpass();
memberDataContext context = new memberDataContext();
Member m = new Member
{
Password = pass
};
}
private void Submit_Click(object sender, EventArgs e)
{
bool datapresent = checkdatapresent();
bool presentnumeric = checknumericinname();
bool validpc = validatepclength();
//If the method checking for numeric characters returns true, there is an
error
if (presentnumeric == true)
{
MessageBox.Show("Ensure your name contains no numeric characters");
}
else
if (validpc == false)
{
MessageBox.Show("Ensure your postcode is the correct number of
characters");
}
else
{
//When data is valid, details of user are added to data set
memberDataContext context = new memberDataContext();
Member m = new Member
{
Membership_No = generatemembnumber(),
FName = fNameTextBox.Text,
SName = sNameTextBox.Text,
Address = addressTextBox.Text,
Postcode = postcodeTextBox.Text
};
context.Members.InsertOnSubmit(m);
try
{
context.SubmitChanges();
}
catch (Exception e1)
{
Console.WriteLine(e1);
context.SubmitChanges();
}
//Once the user details have been added, the new member receives a
confirmation
this.Hide();
New_Member_Confirmation confirm = new
New_Member_Confirmation();
confirm.Closed += (s, args) => this.Close();
confirm.Show();
}
//New membership number generated for new member
public int generatemembnumber()
{
int maxnumber = 0;
int newnumb;
memberDataContext context = new memberDataContext();
var peopledata =
from person in context.Members
where person.Membership_No == maxnumber
select new { person.Membership_No };
foreach (var person in context.Members)
{
if (person.Membership_No > maxnumber)
{
person.Membership_No = maxnumber;
}
}
newnumb = maxnumber + 1;
return newnumb;
}
