public void searchItem(AuctionItem ai)
        {
            string queryItems = " ORDER BY itemId DESC LIMIT 20 ";

            auctionItems.Clear();
            var ais = new ObservableCollection <AuctionItem>(AuctionItemTableData.getAuctionItems(ai, queryItems));

            foreach (AuctionItem aiTemp in ais)
            {
                auctionItems.Add(aiTemp);
            }
            Console.WriteLine(auctionItems.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));
        }