public void searchEvent()
        {
            string queryEvents = " ORDER BY eventId DESC LIMIT 20 ";
            var    aEvents     = new ObservableCollection <AuctionEvent>(AuctionEventTableData.getAuctionEvent(queryEvents));

            auctionEvents.Clear();
            foreach (AuctionEvent aEvent in aEvents)
            {
                auctionEvents.Add(aEvent);
            }
            Console.WriteLine(auctionLocations.Count);
        }
        public ControlFunctions(int userType)
        {
            //controlsUtil = new ControlsUtil(userType);
            // controlsUtil.chkControlItemSold(chkItem_Sold);

            string queryItems = " ORDER BY itemId DESC LIMIT 20 ";

            auctionItems = new ObservableCollection <AuctionItem>(AuctionItemTableData.getAuctionItems(queryItems));

            string queryLocations = " ORDER BY locationId DESC LIMIT 20 ";

            auctionLocations = new ObservableCollection <AuctionLocation>(AuctionLocationTableData.getAuctionLocations(queryLocations));

            string queryEvents = " ORDER BY eventId DESC LIMIT 20 ";

            auctionEvents = new ObservableCollection <AuctionEvent>(AuctionEventTableData.getAuctionEvent(queryEvents));
        }