private void poblarControles()
{
// Actualizar ComboBox
comboAdress.DataSource = null;
comboAdress.ValueMember = "Idadress";
comboAdress.DisplayMember = "address";
comboAdress.DataSource = ConsultarAddress.getLista();
cmbuser.DataSource = null;
cmbuser.ValueMember = "userid";
cmbuser.DisplayMember = "username";
cmbuser.DataSource = ConsultarAppuser.getLista();
comboBox1.DataSource = null;
comboBox1.ValueMember = "userid";
comboBox1.DisplayMember = "username";
comboBox1.DataSource = ConsultarAppuser.getLista();
combouserdirrecion.DataSource = null;
combouserdirrecion.ValueMember = "userid";
combouserdirrecion.DisplayMember = "username";
combouserdirrecion.DataSource = ConsultarAppuser.getLista();
combonegocio.DataSource = null;
combonegocio.ValueMember = "idBusiness";
combonegocio.DisplayMember = "name";
combonegocio.DataSource = ConsultarNegocio.getLista();
}
private void actualizarControles()
{
// Realizar consulta a la base de datos
List <Appuser> lista = ConsultarAppuser.getLista();
// Tabla (data grid view)
dgvEmpleados.DataSource = null;
dgvEmpleados.DataSource = lista;
List <Address> list = ConsultarAddress.getLista();
datagrid.DataSource = null;
datagrid.DataSource = list;
List <Negocio> listaa = ConsultarNegocio.getLista();
datanegocio.DataSource = null;
datanegocio.DataSource = listaa;
List <Producto> ayuda = ConsultarProducto.getLista();
dataproducto.DataSource = null;
dataproducto.DataSource = ayuda;
List <Orden> helpme = ConsultarOrden.getLista();
dateOrden.DataSource = null;
dateOrden.DataSource = helpme;
// Menu desplegable (combo box)
cmbuser.DataSource = null;
cmbuser.ValueMember = "userid";
cmbuser.DisplayMember = "username";
cmbuser.DataSource = ConsultarAppuser.getLista();
comboBox1.DataSource = null;
comboBox1.ValueMember = "userid";
comboBox1.DisplayMember = "username";
comboBox1.DataSource = ConsultarAppuser.getLista();
// Grafico con estadisticas
poblarGrafico();
}