private void ChangePassword_Load(object sender, EventArgs e)
{
comboBox1.DataSource = null;
comboBox1.ValueMember = "password";
comboBox1.DisplayMember = "userName";
comboBox1.DataSource = AppUserDAO.getLista();
}
private void poblarControles()
{
// Actualizar ComboBox
comboBox1.DataSource = null;
comboBox1.ValueMember = "password";
comboBox1.DisplayMember = "userName";
comboBox1.DataSource = AppUserDAO.getLista();
}
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;
}