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