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; }
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; }
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); } }