Bug 978871

When creating a new Show or updating an existing one, the Section drop down list in the TicketPrice field displays all Sections, not just those that are relevant for the selected Venue. Consequently, incorrect Sections can be selected and stored. To work around this issue, add the following methods to the ShowBean class: public List<Venue> getAllVenues() { CriteriaQuery<Venue> criteria = this.entityManager .getCriteriaBuilder().createQuery(Venue.class); List<Venue> allVenues = this.entityManager.createQuery( criteria.select(criteria.from(Venue.class))).getResultList(); Venue defaultVenue = allVenues.get(0); if(this.getSelectedVenue() == null && defaultVenue != null) { this.setSelectedVenue(defaultVenue); } return allVenues; } public void setSelectedVenue(Venue venue) { this.show.setVenue(venue); } public Venue getSelectedVenue() { return this.show.getVenue(); } public List<Section> getVenueSections() { Venue venue = getSelectedVenue(); if(venue == null || venue.getSections() == null) { return new ArrayList<Section>(); } else { return new ArrayList<Section>(venue.getSections()); } } public void changeSelectedVenue(ValueChangeEvent event) { Venue newVenue = (Venue) event.getNewValue(); Venue oldVenue = (Venue) event.getOldValue(); if(!oldVenue.equals(newVenue)) { this.show.getTicketPrices().clear(); } this.setSelectedVenue(newVenue); } Then replace the Venue selector widget in the src/main/webapp/admin/show/create.xhtml file with the following code: <h:selectOneMenu converter="#{venueBean.converter}" id="showBeanShowVenue" required="true" value="#{showBean.selectedVenue}" onchange="submit()" valueChangeListener="#{showBean.changeSelectedVenue}"> <f:selectItems value="#{showBean.allVenues}"/> </h:selectOneMenu> And finally replace the Section selector widget in the same file with the code below: <h:selectOneMenu converter="#{sectionBean.converter}" id="ticketPriceBeanAddSection" value="#{ticketPriceBean.add.section}"> <f:selectItems value="#{showBean.venueSections}"/> </h:selectOneMenu> As a result of applying this workaround, only Sections valid for the chosen Venue will be displayed.