public override IQueryable <AuctionItem> Query()
{
MobileServiceContext ctx = this.Context as MobileServiceContext;
var items = from ai in ctx.AuctionItems
select new AuctionItem
{
Id = ai.Id,
Description = ai.Description,
StartingBid = ai.StartingBid,
Name = ai.Name,
AuctionId = ai.AuctionId,
CurrentBid = ai.Bids.Count == 0 ? 0 : ai.Bids.Max(b => b.BidAmount)
};
return(items);
}
public override System.Web.Http.SingleResult <AuctionItem> Lookup(string id)
{
MobileServiceContext ctx = this.Context as MobileServiceContext;
var item = from ai in ctx.AuctionItems
where ai.Id == id
select new AuctionItem
{
Id = ai.Id,
Description = ai.Description,
StartingBid = ai.StartingBid,
Name = ai.Name,
AuctionId = ai.AuctionId,
Deleted = ai.Deleted,
CreatedAt = ai.CreatedAt,
UpdatedAt = ai.UpdatedAt,
Version = ai.Version,
CurrentBid = ai.Bids.Count == 0 ? 0 : ai.Bids.Max(b => b.BidAmount)
};
return(new System.Web.Http.SingleResult <AuctionItem>(item));
}