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