public Auction FindBy(Guid Id)
{
AuctionDTO auctionDTO;
using (var connection = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["AuctionDB"].ConnectionString))
{
auctionDTO = connection.Query <AuctionDTO>("Select * From Auctions Where Id = CAST(@Id AS uniqueidentifier)", new { Id = Id }).FirstOrDefault();
}
var auctionSnapshot = new AuctionSnapshot();
auctionSnapshot.Id = auctionDTO.Id;
auctionSnapshot.EndsAt = auctionDTO.AuctionEnds;
auctionSnapshot.StartingPrice = auctionDTO.StartingPrice;
auctionSnapshot.Version = auctionDTO.Version;
if (auctionDTO.BidderMemberId.HasValue)
{
var bidSnapshot = new WinningBidSnapshot();
bidSnapshot.AuctionId = auctionDTO.Id;
bidSnapshot.BiddersMaximumBid = auctionDTO.MaximumBid.Value;
bidSnapshot.CurrentPrice = auctionDTO.CurrentPrice.Value;
bidSnapshot.BiddersId = auctionDTO.BidderMemberId.Value;
bidSnapshot.TimeOfBid = auctionDTO.TimeOfBid.Value;
auctionSnapshot.WinningBid = bidSnapshot;
}
return(Auction.CreateFrom(auctionSnapshot));
}
public Auction FindBy(Guid Id)
{
var auctionDTO = _auctionExampleContext.Auctions.Find(Id);
var auctionSnapshot = new AuctionSnapshot();
auctionSnapshot.Id = auctionDTO.Id;
auctionSnapshot.EndsAt = auctionDTO.AuctionEnds;
auctionSnapshot.StartingPrice = auctionDTO.StartingPrice;
auctionSnapshot.Version = auctionDTO.Version;
if (auctionDTO.BidderMemberId.HasValue)
{
var bidSnapshot = new WinningBidSnapshot();
bidSnapshot.BiddersMaximumBid = auctionDTO.MaximumBid.Value;
bidSnapshot.CurrentPrice = auctionDTO.CurrentPrice.Value;
bidSnapshot.BiddersId = auctionDTO.BidderMemberId.Value;
bidSnapshot.TimeOfBid = auctionDTO.TimeOfBid.Value;
auctionSnapshot.WinningBid = bidSnapshot;
}
return(Auction.CreateFrom(auctionSnapshot));
}
