private void btnUpdate_Click(object sender, EventArgs e) { // validate data if (txtSurname.Text.Equals("") || txtForename.Text.Equals("") || txtPhone.Text.Equals("") || txtEmail.Text.Equals("") || txtBoxAdd1.Text.Equals("") || txtBoxAdd2.Text.Equals("") || txtActivity.Text.Equals("")) { MessageBox.Show("All fields must be entered", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } String phone = txtPhone.Text; foreach (char c in phone) { if (c < '0' || c > '9') { MessageBox.Show("Phone must be numeric!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } } if (txtActivity.Text.ToUpper() != "A" && txtActivity.Text.ToUpper() != "I") { MessageBox.Show("Activity must be A or I!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } //instantiate Owner Object Owner myOwners = new Owner(); myOwners.setOwnerId(Convert.ToInt32(txtOwnerID.Text)); if (PropertySysv2.Owner.validText(txtForename.Text)) { myOwners.setForename(txtForename.Text); } else { MessageBox.Show("Forename must be letters only", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); txtForename.Text = ""; txtForename.Focus(); return; } if (PropertySysv2.Owner.validText(txtSurname.Text)) { myOwners.setSurname(txtSurname.Text); } else { MessageBox.Show("Surname must be letters only", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); txtSurname.Text = ""; txtSurname.Focus(); return; } if (PropertySysv2.Owner.validTextWithNumbers(txtBoxAdd1.Text)) { myOwners.setStreet(txtBoxAdd1.Text); } else { MessageBox.Show("Address Line 1 must be numbers and letters only", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); txtBoxAdd1.Text = ""; txtBoxAdd1.Focus(); return; } if (PropertySysv2.Owner.validText(txtBoxAdd2.Text)) { myOwners.setTown(txtBoxAdd2.Text); } else { MessageBox.Show("Address Line 2 must be letters only", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); txtBoxAdd2.Text = ""; txtBoxAdd2.Focus(); return; } if (PropertySysv2.Owner.validText(txtBoxCounty.Text)) { myOwners.setCounty(txtBoxCounty.Text); } else { MessageBox.Show("County must be letters only", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); txtBoxCounty.Text = ""; txtBoxCounty.Focus(); return; } myOwners.setPhone(txtPhone.Text); if (PropertySysv2.Owner.validEmail(txtEmail.Text)) { myOwners.setEmail(txtEmail.Text); } else { MessageBox.Show("Email must be correct format!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); txtEmail.Text = ""; txtEmail.Focus(); return; } myOwners.setActivity(txtActivity.Text); //UPDATE Owner record in Owner table myOwners.updOwner(); //Display Confirmation message MessageBox.Show("Owner Updated In System", "Confirmation", MessageBoxButtons.OK, MessageBoxIcon.Information); //reset UI txtOwnerSearch.Text = ""; txtSurname.Text = ""; txtForename.Text = ""; txtBoxAdd1.Text = ""; txtBoxAdd2.Text = ""; txtBoxCounty.Text = ""; txtPhone.Text = ""; txtEmail.Text = ""; grpOwners.Visible = false; grdOwners.Visible = false; txtOwnerSearch.Focus(); }