public static List <Buisness> getList() { string sql = "select * from BUISNESS"; DataTable dt = ConnectionDB.ExecuteQuery(sql); List <Buisness> lista = new List <Buisness>(); foreach (DataRow fila in dt.Rows) { Buisness b = new Buisness(); b.idbuisness = Convert.ToInt32(fila[0]); b.name = fila[1].ToString(); b.description = fila[2].ToString(); lista.Add(b); } return(lista); }
private void ReloadControls() { Buisness actual = (Buisness)cmbNegocio.SelectedItem; int idBuis = actual.idbuisness; var productos = ProductDAO.getListProductsFromStore(idBuis); var negocios = BuisnessDAO.getList(); var direcciones = AdressDAO.getListAdressUser(UserId); cmbNegocio.DataSource = null; cmbNegocio.ValueMember = "idbuisness"; cmbNegocio.DisplayMember = "name"; cmbNegocio.DataSource = negocios; cmbProducto.DataSource = null; cmbProducto.ValueMember = "idproduct"; cmbProducto.DisplayMember = "name"; cmbProducto.DataSource = productos; cmbLocation.DataSource = null; cmbLocation.ValueMember = "idproduct"; cmbLocation.DisplayMember = "name"; cmbLocation.DataSource = direcciones; }