//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; }