// Inserts Auction Location // And Returns the Selected Index public int submitLocation(AuctionLocation auctionLocation, int auctionLocationSelectedIndex) { int executeQueryRowCount = -1; if (auctionLocation.locationId < 1) { auctionLocationSelectedIndex = 0; executeQueryRowCount = AuctionLocationTableData.insertAuctionLocation(auctionLocation); if (executeQueryRowCount > 0) { auctionLocations.Insert(auctionLocationSelectedIndex, auctionLocation); } } else { executeQueryRowCount = AuctionLocationTableData.updateAuctionLocation(auctionLocation); if (executeQueryRowCount > 0) { auctionLocations.Insert(auctionLocationSelectedIndex, auctionLocation); auctionLocations.RemoveAt(auctionLocationSelectedIndex + 1); } } if (executeQueryRowCount < 1) { return(-1); } searchEvent(); return(auctionLocationSelectedIndex + 1); }
public void searchLocation(AuctionLocation al) { string queryItems = " ORDER BY locationId DESC LIMIT 20 "; auctionLocations.Clear(); ObservableCollection <AuctionLocation> als; als = new ObservableCollection <AuctionLocation>(AuctionLocationTableData.getAuctionLocations(al, queryItems)); foreach (AuctionLocation alTemp in als) { auctionLocations.Add(alTemp); } 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)); }