public AuctionAllBids GetAuctionWithAllBids(Guid id) { return(Auctions.Where(a => a.id == id) .Select(a => new AuctionAllBids { Auction = new PartialAuction { id = a.id, name = a.name, starting_price = a.starting_price, duration = a.duration, owner = a.owner, description = a.description, state = a.state, created = a.created, opened = a.opened, closed = a.closed, won = a.won }, Bids = a.Bids.OrderByDescending(b => b.amount).Select(bb => new PartialBid { bidder = bb.bidder, amount = bb.amount, firstName = bb.Bidder.first_name, lastName = bb.Bidder.last_name, created = bb.created }).ToList() }).SingleOrDefault()); }
public IEnumerable <Aukcje.Models.CommentWithAuction> SelectComments() { IEnumerable <Aukcje.Models.CommentWithAuction> list = new List <CommentWithAuction>(); IEnumerable <Aukcje.Auction> Auctions; IEnumerable <Aukcje.Comment> Comments; using (var ctx = new bazaEntities()) { Auctions = ctx.Auctions.ToList(); Comments = ctx.Comments.ToList(); } string sellerName = HttpContext.Current.Request.QueryString["UID"] ?? view.UName; Auctions = Auctions.Where(p => p.seller.Equals(sellerName) && p.status == "zakonczone"); list = from p in Auctions join c in Comments on p.commentID equals c.CommentID select new CommentWithAuction() { aukcja = p, Comment = c, ConsumerName = "asd" }; return(list); }
public IEnumerable <Models.CommentWithAuction> GetClosedAuctions(string UserName) { IEnumerable <Aukcje.Models.CommentWithAuction> list; IEnumerable <Aukcje.Auction> Auctions; IEnumerable <Aukcje.Comment> Comments; using (var ctx = new bazaEntities()) { Auctions = ctx.Auctions.ToList(); Comments = ctx.Comments.ToList(); } Auctions = Auctions.Where(p => p.seller.Equals(UserName) && p.status == "zakonczone"); list = from p in Auctions join c in Comments on p.commentID equals c.CommentID select new Models.CommentWithAuction() { aukcja = p, Comment = c, ConsumerName = "asd" }; return(list); }
// Full populate methods for DRY public Auction PopulateAuctionSingle(int auctionid) { return(Auctions.Where(x => x.Id == auctionid).Include(x => x.User).Include(x => x.Bids).ThenInclude(x => x.User).SingleOrDefault()); }