private void btnAdd_Click_1(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(""))
{
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);
txtPhone.Text = "";
txtPhone.Focus();
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("A");
//INSERT Owner record into table
myOwners.regOwner();
//Display Confirmation Message
MessageBox.Show("Owner " + txtOwnerID.Text + " Registered", "Confirmation", MessageBoxButtons.OK, MessageBoxIcon.Information);
//reset UI
txtSurname.Text = "";
txtForename.Text = "";
txtBoxAdd1.Text = "";
txtBoxAdd2.Text = "";
txtBoxCounty.Text = "";
txtPhone.Text = "";
txtEmail.Text = "";
txtOwnerID.Text = PropertySysv2.Owner.getNextOwnerId().ToString("00000");
txtForename.Focus();
}
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();
}