Пример #1
0
        private void btnRmv_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(""))
            {
                MessageBox.Show("All fields must be entered", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                return;
            }

            // Save data in Owners File

            //Display Confirmation message
            MessageBox.Show("Owner Removed From System", "Confirmation", MessageBoxButtons.OK, MessageBoxIcon.Information);

            //instantiate Owner Object
            Owner myOwners = new Owner();

            myOwners.setOwnerId(Convert.ToInt32(txtOwnerID.Text));
            myOwners.setForename(txtForename.Text);
            myOwners.setSurname(txtSurname.Text);
            myOwners.setStreet(txtBoxAdd1.Text);
            myOwners.setTown(txtBoxAdd2.Text);
            myOwners.setCounty(txtBoxCounty.Text);
            myOwners.setPhone(txtPhone.Text);
            myOwners.setEmail(txtEmail.Text);

            //Set Owner Activity as Inactive
            myOwners.rmvOwner();

            //reset UI
            txtOwnerSearch.Text = "";
            txtSurname.Text     = "";
            txtForename.Text    = "";
            txtBoxAdd1.Text     = "";
            txtBoxAdd2.Text     = "";
            txtBoxCounty.Text   = "";
            txtPhone.Text       = "";
            txtEmail.Text       = "";

            txtOwnerSearch.Focus();

            grpOwners.Visible = false;
            grdOwners.Visible = false;
        }
        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();
        }
Пример #3
0
        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();
        }