protected void removeMember(object sender, EventArgs e)
{
if (this.datepicker.Text.Equals(""))
{
this.errorDiv.Visible = true;
this.errorMsg.Text = "Please select a date.";
}
else
{
Member member = new Member();
member.id = this.searchMembers.SelectedRow.Cells[6].Text;
member.status = "INACTIVE";
member.dateRemoved = this.datepicker.Text;
MemberDAO memberDAO = new MemberDAO();
this.removeMemberForm.Visible = false;
this.responseForm.Visible = true;
this.responseText.Text = memberDAO.removeMember(member);
}
}
protected void activateMember(object sender, EventArgs e)
{
if(this.datepicker.Text.Equals("")){
this.errorDiv.Visible = true;
this.errorMsg.Text = "Please select the date of activation!";
}
else
{
Member member = new Member();
MemberDAO memberDAO = new MemberDAO();
member.id = this.searchMembers.SelectedRow.Cells[6].Text;
member.dateLastActivated = this.datepicker.Text;
member.status = "ACTIVE";
this.mainForm.Visible = false;
this.response.Visible = true;
this.responseText.Text = memberDAO.activateMember(member);
}
}
protected void insertNewMember(object sender, EventArgs e)
{
MemberDAO memberDAO = new MemberDAO();
if (this.accountNumber.Text.Equals("") || this.memberName.Text.Equals("") ||
this.datepicker.Text.Equals("") || this.city.Text.Equals("") ||
this.province.SelectedValue.Equals("Select...") || this.postalCode.Text.Equals(""))
{
this.errorMsg.Text = "One or more of the required fields are blank. Please review all the fields before continuing.";
}
else
{
if (memberDAO.alreadyExists(this.accountNumber.Text))
{
this.errorMsg.Text = "This account number already exists. Please choose another one.";
}
else
{
member.accountNumber = this.accountNumber.Text.Trim();
member.doctor = this.doctorName.Text.Trim();
member.name = this.memberName.Text.Trim();
member.dateJoined = this.datepicker.Text;
member.address = this.address.Text.Trim();
member.city = this.city.Text.Trim();
member.province = this.province.SelectedValue;
member.region = this.region.Text;
member.postalCode = this.postalCode.Text.ToUpper();
member.website = this.website.Text.Trim();
member.emailAddress = this.emailAddress.Text.Trim();
member.phoneNumber = this.phoneNumber.Text;
member.faxNumber = this.faxNumber.Text;
member.contactPerson = this.contactPerson.Text.Trim();
member.dateModified = System.DateTime.Today.ToShortDateString();
member.dateCreated = System.DateTime.Today.ToShortDateString();
member.modifiedBy = this.Page.User.Identity.Name.ToString();
member.dateLastActivated = System.DateTime.Today.ToShortDateString();
this.insertNewMemberForm.Visible = false;
this.response.Visible = true;
this.responseText.Text = memberDAO.insertNewMember(member);
}
}
}
protected void updateMember(object sender, EventArgs e)
{
this.enableFieldsBtt.Visible = false;
Member member = new Member();
string databaseResponse = "";
MemberDAO memberDAO = new MemberDAO();
if (this.searchMembers.SelectedIndex == -1)
{
this.errorMsg.Text = "Select one member to be updated.";
this.errorDiv.Visible = true;
}
else
{
if (accountNumber.Text.ToString() == "" || memberName.Text.ToString() == "" || this.datepicker.Text.Equals("") || address.Text.ToString() == "" ||
city.Text.ToString() == "" || province.SelectedValue.ToString() == "Select..." || postalCode.Text.ToString() == "")
{
this.errorMsg.Text = "One or more of the required fields are blank!";
this.errorDiv.Visible = true;
}
else
{
if (memberDAO.alreadyExists(this.accountNumber.Text))
{
this.errorMsg.Text = "This account number already exists. Please choose another one.";
}
else
{
//Loads the form content into the member object
member.id = this.searchMembers.SelectedRow.Cells[6].Text;
member.idGroup = this.searchMembers.SelectedRow.Cells[7].Text;
member.accountNumber = accountNumber.Text.ToString().Trim();
member.dateJoined = this.datepicker.Text;
member.doctor = doctorName.Text.ToString().Trim();
member.name = memberName.Text.ToString().Trim();
member.address = address.Text.ToString().Trim();
member.city = city.Text.ToString().Trim();
member.province = province.SelectedItem.ToString();
member.region = region.Text.ToString();
member.postalCode = postalCode.Text.ToString();
member.website = website.Text.ToString().Trim();
member.emailAddress = emailAddress.Text.ToString().Trim();
member.phoneNumber = phoneNumber.Text.ToString();
member.faxNumber = faxNumber.Text.ToString();
member.contactPerson = contactPerson.Text.ToString().Trim();
member.dateLastActivated = this.datepicker.Text;
//Sends the member object to the updateMember method in MemberDAO..
databaseResponse = memberDAO.updateMember(member);
clearAllFields();
this.responseText.Text = databaseResponse;
this.editMemberForm.Visible = false;
this.response.Visible = true;
}
}
}
}
