private void AddMemberButton_Click(object sender, EventArgs e)
{
Regex isValidEmail = new Regex(@"^(?("")("".+?(?<!\\)""@)|(([0-9a-zA-Z]((\.(?!\.))|[-!#\$%&'\*\+/=\?\^`\{\}\|~\w])*)(?<=[0-9a-zA-Z])@))" +
@"(?(\[)(\[(\d{1,3}\.){3}\d{1,3}\])|(([0-9A-Za-z][-\w]*[0-9A-Za-z]*\.)+[a-zA-Z0-9][\-a-zA-Z0-9]{0,22}[a-zA-Z0-9]))$");
if (FirstNameTxtBox.Text == "")
{
MessageBox.Show("Please input a First Name.");
}
else if (GenderComboBox.SelectedIndex <= 0)
{
MessageBox.Show("Please input Gender.");
}
else if (MobileTextBox.MaskedTextProvider.AssignedEditPositionCount < 8)
{
MessageBox.Show("Please input a valid Mobile number.");
}
else if (EmailTextBox.Text == "" || !isValidEmail.IsMatch(EmailTextBox.Text))
{
MessageBox.Show("Please input a valid Email Address.");
}
else if (EmergencyNameTextBox.Text == "")
{
MessageBox.Show("Please input an Emergency Contact Name.");
}
else if (EmergencyNumberTextBox.MaskedTextProvider.AssignedEditPositionCount < 8)
{
MessageBox.Show("Please input a valid Emergency Contact Number.");
}
else
{
foreach (Member m in ctx.Members)
{
if ((m.FirstName == FirstNameTxtBox.Text) && (m.LastName == LNameTextBox.Text) && (m.DateOfBirth == DOBPicker.Value) && (m.Email == EmailTextBox.Text))
{
MessageBox.Show("Member already exists!");
flag = 1;
break;
}
this.Close();
}
if (flag == 0)
{
flag = 0;
Member newMember = new Member
{
FirstName = FirstNameTxtBox.Text,
LastName = LNameTextBox.Text,
Email = EmailTextBox.Text,
DateOfBirth = DOBPicker.Value,
Active = 1,
Mobile = MobileTextBox.Text,
EmergencyContact = EmergencyNumberTextBox.Text,
EmergencyName = EmergencyNameTextBox.Text,
EmergencyRelation = MemberRelationTextBox.Text
};
if (SalutationComboBox.SelectedItem == null)
{
newMember.Salutations = "";
}
else
{
newMember.Salutations = SalutationComboBox.SelectedItem.ToString();
}
if (GenderComboBox.SelectedItem.ToString() == "Male")
{
newMember.Gender = "M";
}
else
{
newMember.Gender = "F";
}
ctx.Members.Add(newMember);
ctx.SaveChanges();
MessageBox.Show(String.Format("New member {0} {1} with Member ID: {2} has been added!", newMember.FirstName, newMember.LastName, newMember.MemberID));
if (memberTab.SearchTextBox.Text != "")
{
if (memberTab.HideInactiveCheckbox.Checked == true)
{
memberTab.SearchActiveMembers();
}
else
{
memberTab.SearchAllMembers();
}
}
else
{
if (memberTab.HideInactiveCheckbox.Checked == true)
{
memberTab.ViewActiveMembers();
}
else
{
memberTab.ViewAllMembers();
}
}
int selectedIndex = memberTab.MemberInfoTable.Rows.Count - 1;
memberTab.MemberInfoTable.Rows[selectedIndex].Selected = true;
memberTab.MemberInfoTable.FirstDisplayedScrollingRowIndex = selectedIndex;
this.Close();
}
}
}
private void UpdateMemberButton_Click(object sender, EventArgs e)
{
Regex isValidEmail = new Regex(@"^(?("")("".+?(?<!\\)""@)|(([0-9a-zA-Z]((\.(?!\.))|[-!#\$%&'\*\+/=\?\^`\{\}\|~\w])*)(?<=[0-9a-zA-Z])@))" +
@"(?(\[)(\[(\d{1,3}\.){3}\d{1,3}\])|(([0-9a-zA-Z][-\w]*[0-9a-z]*\.)+[a-zA-Z0-9][\-a-zA-Z0-9]{0,22}[a-zA-Z0-9]))$");
if (FirstNameTxtBox.Text == "")
{
MessageBox.Show("Please input First Name.");
}
else if (GenderComboBox.SelectedIndex <= 0)
{
MessageBox.Show("Please input Gender.");
}
else if (MobileTextBox.MaskedTextProvider.AssignedEditPositionCount < 8)
{
MessageBox.Show("Please input a valid Mobile Number.");
}
else if (EmailTextBox.Text == "" || !isValidEmail.IsMatch(EmailTextBox.Text))
{
MessageBox.Show("Please input a valid Email Address.");
}
else if (EmergencyNameTextBox.Text == "")
{
MessageBox.Show("Please input an Emergency Contact Name.");
}
else if (EmergencyNumberTextBox.MaskedTextProvider.AssignedEditPositionCount < 8)
{
MessageBox.Show("Please input a valid Emergency Contact Number.");
}
else
{
Member memberToEdit = (Member)(from x in ctx.Members where x.MemberID == memberId select x).First();
memberToEdit.FirstName = FirstNameTxtBox.Text;
memberToEdit.LastName = LNameTextBox.Text;
memberToEdit.Email = EmailTextBox.Text;
memberToEdit.DateOfBirth = DOBPicker.Value;
memberToEdit.Mobile = MobileTextBox.Text;
memberToEdit.EmergencyContact = EmergencyNumberTextBox.Text;
memberToEdit.EmergencyName = EmergencyNameTextBox.Text;
memberToEdit.EmergencyRelation = MemberRelationTextBox.Text;
if (SalutationComboBox.SelectedItem == null)
{
memberToEdit.Salutations = "";
}
else
{
memberToEdit.Salutations = SalutationComboBox.SelectedItem.ToString();
}
if (GenderComboBox.SelectedItem.ToString() == "Male")
{
memberToEdit.Gender = "M";
}
else
{
memberToEdit.Gender = "F";
}
ctx.SaveChanges();
MessageBox.Show(String.Format("The details of {0} {1} with Member ID: {2} has been updated!", memberToEdit.FirstName, memberToEdit.LastName, memberToEdit.MemberID));
if (memberTab.SearchTextBox.Text != "")
{
if (memberTab.HideInactiveCheckbox.Checked == true)
{
memberTab.SearchActiveMembers();
}
else
{
memberTab.SearchAllMembers();
}
}
else
{
if (memberTab.HideInactiveCheckbox.Checked == true)
{
memberTab.ViewActiveMembers();
}
else
{
memberTab.ViewAllMembers();
}
}
memberTab.MemberInfoTable.Rows[selectedIndex].Selected = true;
this.Close();
}
}