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);
}
}