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