private void CboCountry_SelectionChangeCommitted(object sender, EventArgs e)
        {
            AlmacenDisecWS.country c = new AlmacenDisecWS.country();
            c = (AlmacenDisecWS.country)cboCountry.SelectedItem;
            int a = c.id_country;

            cboCity.DataSource = serviceDA.queryAllCitybyId(c.id_country);

            //El nombre del  atributo a mostrar
            cboCity.DisplayMember = "name_city";
            cboCity.ValueMember   = "id_city";
        }
        private void BtnSave_Click(object sender, EventArgs e)
        {
            if (flag == true)
            {
                if (String.IsNullOrEmpty(txtName.Text) || String.IsNullOrEmpty(txtRuc.Text) || String.IsNullOrEmpty(txtAddress.Text) ||
                    String.IsNullOrEmpty(txtEmail.Text) || String.IsNullOrEmpty(txtPhone.Text) || cboCountry.SelectedIndex == -1 || cboCity.SelectedIndex == -1)
                {
                    frmMessageBoxFillNull frm = new frmMessageBoxFillNull();
                    frm.ShowDialog();
                }

                else
                {
                    frmMessageBoxSave frm = new frmMessageBoxSave();
                    if (frm.ShowDialog() == DialogResult.OK)
                    {
                        AlmacenDisecWS.supplier s  = new AlmacenDisecWS.supplier();
                        AlmacenDisecWS.city     ci = new AlmacenDisecWS.city();
                        AlmacenDisecWS.country  co = new AlmacenDisecWS.country();
                        s.email         = txtEmail.Text;
                        s.ruc           = txtRuc.Text;
                        s.adress        = txtAddress.Text;
                        s.phone_number  = Int32.Parse(txtPhone.Text);
                        s.supplier_name = txtName.Text;
                        s.city          = (AlmacenDisecWS.city)cboCity.SelectedItem;
                        s.city.country  = (AlmacenDisecWS.country)cboCountry.SelectedItem;
                        int result = serviceDA.insertSupplier(s);


                        reiniciar();
                        frmSearchSupplier fm = Owner as frmSearchSupplier;
                        fm.dgvSearch.AutoGenerateColumns = false;
                        fm.dgvSearch.DataSource          = "";

                        this.Close();
                    }
                }
            }


            else
            {
                if (String.IsNullOrEmpty(txtCode.Text) || String.IsNullOrEmpty(txtName.Text) || String.IsNullOrEmpty(txtRuc.Text) || String.IsNullOrEmpty(txtAddress.Text) ||
                    String.IsNullOrEmpty(txtEmail.Text) || String.IsNullOrEmpty(txtPhone.Text))
                {
                    frmMessageBoxFillNull frm2 = new frmMessageBoxFillNull();
                    frm2.ShowDialog();
                }
                else
                {
                    frmMessageBoxSave frm = new frmMessageBoxSave();
                    if (frm.ShowDialog() == DialogResult.OK)
                    {
                        AlmacenDisecWS.supplier s = new AlmacenDisecWS.supplier();
                        //falta que le quiten el pais al actualizar
                        s.id_supplier   = Int32.Parse(txtCode.Text);
                        s.email         = txtEmail.Text;
                        s.ruc           = txtRuc.Text;
                        s.adress        = txtAddress.Text;
                        s.phone_number  = Int32.Parse(txtPhone.Text);
                        s.supplier_name = txtName.Text;

                        int result = serviceDA.updateSupplier(s);

                        reiniciar();
                        frmSearchSupplier fm = Owner as frmSearchSupplier;
                        fm.txtSearch.Clear();
                        fm.dgvSearch.AutoGenerateColumns = false;
                        fm.dgvSearch.DataSource          = "";

                        this.Close();
                    }
                }
            }
        }