示例#1
0
        public void actualizarControles()
        {
            List <AppUser>  lista  = AppUserDAO.getListaP(usuario.idUser);
            List <Order>    listO  = OrderDAO.getOListP(usuario.idUser);
            List <Address>  listA  = AddressDAO.getPList(usuario.idUser);
            List <Business> listaB = BusinessDAO.getBList();
            List <Product>  listaP = ProductDAO.getPList(Convert.ToInt32(comboBox2.SelectedValue));

            comboBox3.DataSource    = null;
            comboBox3.ValueMember   = "idProduct";
            comboBox3.DisplayMember = "name";
            comboBox3.DataSource    = listaP;

            comboBox1.DataSource    = null;
            comboBox1.ValueMember   = "idUser";
            comboBox1.DisplayMember = "userName";
            comboBox1.DataSource    = lista;

            comboBox2.DataSource    = null;
            comboBox2.ValueMember   = "idBusiness";
            comboBox2.DisplayMember = "name";
            comboBox2.DataSource    = listaB;

            comboBox5.DataSource    = null;
            comboBox5.ValueMember   = "idOrder";
            comboBox5.DisplayMember = "idProduct";
            comboBox5.DataSource    = listO;

            dataGridView1.DataSource = null;
            dataGridView1.DataSource = listO;

            dataGridView2.DataSource = null;
            dataGridView2.DataSource = listA;
        }
示例#2
0
 private void button5_Click(object sender, EventArgs e)
 {
     try
     {
         OrderDAO.eliminarOrden(Convert.ToInt32(comboBox5.SelectedValue));
         MessageBox.Show("¡Orden ELIMINADA exitosamente!",
                         "Hugo App", MessageBoxButtons.OK, MessageBoxIcon.Information);
         actualizarControles();
     }
     catch (Exception exp)
     {
         MessageBox.Show("No fue posible eliminar la orden",
                         "Hugo App", MessageBoxButtons.OK, MessageBoxIcon.Error);
     }
 }
        private void actualizarControles()
        {
            // Realizar consulta a la base de datos
            List <AppUser>  lista   = AppUserDAO.getLista();
            List <Business> listaB  = BusinessDAO.getBList();
            List <Product>  listaP  = ProductDAO.getPList(Convert.ToInt32(comboBox3.SelectedValue));
            List <Product>  listaPP = ProductDAO.getPList(Convert.ToInt32(comboBox4.SelectedValue));

            List <Order> listaO = OrderDAO.getOList();

            // Tabla (data grid view)
            dataGridView1.DataSource = null;
            dataGridView1.DataSource = lista;
            // Menu desplegable (combo box)
            comboBox1.DataSource    = null;
            comboBox1.ValueMember   = "password";
            comboBox1.DisplayMember = "userName";
            comboBox1.DataSource    = lista;

            comboBox2.DataSource    = null;
            comboBox2.ValueMember   = "name";
            comboBox2.DisplayMember = "name";
            comboBox2.DataSource    = listaB;

            comboBox3.DataSource    = null;
            comboBox3.ValueMember   = "idBusiness";
            comboBox3.DisplayMember = "name";
            comboBox3.DataSource    = listaB;

            comboBox4.DataSource    = null;
            comboBox4.ValueMember   = "idBusiness";
            comboBox4.DisplayMember = "name";
            comboBox4.DataSource    = listaB;

            comboBox5.DataSource    = null;
            comboBox5.ValueMember   = "idProduct";
            comboBox5.DisplayMember = "name";
            comboBox5.DataSource    = listaPP;

            dataGridView2.DataSource = null;
            dataGridView2.DataSource = listaB;

            dataGridView3.DataSource = null;
            dataGridView3.DataSource = listaP;

            dataGridView4.DataSource = null;
            dataGridView4.DataSource = listaO;
        }
示例#4
0
 private void button4_Click(object sender, EventArgs e)
 {
     try
     {
         OrderDAO.crearOrder(DateTime.Now, Convert.ToInt32(comboBox3.SelectedValue.ToString()),
                             Convert.ToInt32(comboBox4.SelectedValue.ToString()));
         MessageBox.Show("¡Orden agregada exitosamente!",
                         "Hugo App", MessageBoxButtons.OK, MessageBoxIcon.Information);
         actualizarControles();
     }
     catch (Exception exp)
     {
         MessageBox.Show("No fue posible registrar la orden",
                         "Hugo App", MessageBoxButtons.OK, MessageBoxIcon.Error);
     }
 }