private void button9_Click(object sender, EventArgs e)
        {
            try
            {
                if (textBox6.Text.Length > 0)
                {
                    AdressDAO.crearNuevo(appuser.iduser, textBox6.Text);

                    MessageBox.Show("¡Direccion ingresada exitosamente!",
                                    "SourceCode", MessageBoxButtons.OK, MessageBoxIcon.Information);

                    textBox5.Clear();
                    actualizarControles();
                }
                else
                {
                    MessageBox.Show("Favor no deje espacios en blanco",
                                    "SourceCode", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                }
            }
            catch (Exception)
            {
                MessageBox.Show("La Direccion que ha digitado, no se encuentra disponible.",
                                "SourceCode", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
        private void button12_Click(object sender, EventArgs e)
        {
            AdressDAO.actualizarDireccion(textBox7.Text, comboBox6.Text);

            MessageBox.Show("¡Adress  actualizada exitosamente!",
                            "SourceCode", MessageBoxButtons.OK, MessageBoxIcon.Information);

            actualizarControles();
        }
        private void button11_Click(object sender, EventArgs e)
        {
            if (MessageBox.Show("¿Seguro que desea eliminar la direccion " + comboBox6.SelectedItem + "?",
                                "SourceCode", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
            {
                AdressDAO.eliminar(comboBox6.Text);

                MessageBox.Show("¡Producto eliminado exitosamente!",
                                "SourceCode", MessageBoxButtons.OK, MessageBoxIcon.Information);

                actualizarControles();
            }
        }
        private void actualizarControles()
        {
            List <AppUser> lista = AppUserDAO.getLista();


            dataGridView1.DataSource = null;
            dataGridView1.DataSource = lista;

            comboBox1.DataSource    = null;
            comboBox1.DisplayMember = "iduser";
            comboBox1.DataSource    = lista;

            List <Business> list = BusinessDAO.getLista();

            comboBox2.DataSource    = null;
            comboBox2.DisplayMember = "idbusiness";
            comboBox2.DataSource    = list;

            List <Product> lis = ProductDAO.getLista();

            comboBox3.DataSource    = null;
            comboBox3.DisplayMember = "idbusiness";
            comboBox3.DataSource    = list;



            comboBox4.DataSource    = null;
            comboBox4.DisplayMember = "idbusiness";
            comboBox4.DataSource    = list;

            List <Adress> listAdress = AdressDAO.getLista();


            comboBox6.DataSource    = null;
            comboBox6.DisplayMember = "idbusiness";
            comboBox6.DataSource    = list;

            List <AppOrder> listOrders = AppOrderDAO.getLista();

            comboBox8.DataSource    = null;
            comboBox8.DisplayMember = "idorder";
            comboBox8.DataSource    = listOrders;

            dataGridView2.DataSource = null;
            dataGridView2.DataSource = listOrders;

            comboBox7.DataSource    = null;
            comboBox7.DisplayMember = "idproduct";
            comboBox7.DataSource    = lis;

            comboBox5.DataSource    = null;
            comboBox5.DisplayMember = "idadress";
            comboBox5.DataSource    = listAdress;

            List <Adress> listaAdress = AdressDAO.getListaAdress(appuser.iduser);

            dataGridView3.DataSource = null;
            dataGridView3.DataSource = listaAdress;

            List <AppOrder> listaAppOrders = AppOrderDAO.getListaAppOrder(appuser.iduser);

            dataGridView5.DataSource = null;
            dataGridView5.DataSource = listaAppOrders;
        }