示例#1
0
        private void button1_Click(object sender, EventArgs e)
        {
            string   own_fname, own_lname, own_address, pet_name, pet_type, description, status, city, state, own_tel;
            int      own_ID, zipCode, pet_num, clinicNum;
            DateTime dob, date_reg;

            if (!txtCity.Text.Equals("") || !txtDescription.Text.Equals("") || !txtOwn_Address.Text.Equals("") ||
                !txtOwn_FName.Text.Equals("") || !txtOwn_ID.Text.Equals("") || !txtOwn_LName.Text.Equals("") ||
                !txtOwn_tel.Text.Equals("") || !txtPet_name.Text.Equals("") || !txtPet_num.Text.Equals("") ||
                !txtPet_type.Text.Equals("") || !txtState.Text.Equals("") || !txtStatus.Text.Equals("") ||
                !txtZip.Text.Equals("") || cmbCliniNumber.SelectedValue != null)
            {
                //owner
                own_fname   = txtOwn_FName.Text;
                own_lname   = txtOwn_LName.Text;
                own_address = txtOwn_Address.Text;
                city        = txtCity.Text;
                state       = txtState.Text;
                clinicNum   = Convert.ToInt32(cmbCliniNumber.SelectedValue.ToString());
                zipCode     = Convert.ToInt32(txtZip.Text);
                own_ID      = Convert.ToInt32(txtOwn_ID.Text);
                own_tel     = txtOwn_tel.Text;

                //pet
                pet_name    = txtPet_name.Text;
                pet_type    = txtPet_type.Text;
                description = txtDescription.Text;
                status      = txtStatus.Text;
                pet_num     = Convert.ToInt32(txtPet_num.Text);
                dob         = dateTimePicker1.Value;
                date_reg    = dateTimePicker2.Value;

                //call methods
                database.insert_pet_owner(own_ID, own_lname, own_fname, own_address, city, state, zipCode, own_tel, pet_name, clinicNum);
                database.insert_pet(pet_num, pet_name, pet_type, description, dob, date_reg, status, own_ID, clinicNum);
                clear();
            }
            else
            {
                MessageBox.Show("Please enter values in all fields");
            }
        }