private void SetupPromoterEvents() { if (CurrentPromoter != null) { this.NonEventSpecificDiv.Visible = true; Query promoterEventsQuery = new Query(new And(new Q(Promoter.Columns.K, CurrentPromoter.K), new Q(Event.Columns.DateTime, QueryOperator.GreaterThanOrEqualTo, DateTime.Today))); promoterEventsQuery.Columns = new ColumnSet(Event.Columns.Name, Event.Columns.K, Event.Columns.DateTime); promoterEventsQuery.TableElement = Event.PromoterJoinWithVenue; promoterEventsQuery.OrderBy = Event.FutureEventOrder; promoterEventsQuery.NoLock = true; promoterEventsQuery.Distinct = true; promoterEventsQuery.DistinctColumn = Event.Columns.K; EventSet promoterEvents = new EventSet(promoterEventsQuery); this.NoEventsPanel.Visible = promoterEvents.Count == 0; this.HasEventsPanel.Visible = !this.NoEventsPanel.Visible; this.AddEditTicketRunPanel.Visible = promoterEvents.Count > 0; List<Event> promoterEventList = new List<Event>(); promoterEvents.Reset(); foreach (Event promoterEvent in promoterEvents) promoterEventList.Add(promoterEvent); SetupEventDropDownList(promoterEventList); } }