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