public Shared.Export.Auction ExportAuctionData(int auctionId)
{
List <BidSoftware.Shared.Export.Bid> lb = new List <BidSoftware.Shared.Export.Bid>();
try
{
using (var ctx = new SI2_Entities())
{
var auc = ctx.vAuctions.Where(a => a.SaleId == auctionId).SingleOrDefault();
if (auc == null)
{
throw new ArgumentException("Não existe o leilão com id " + auctionId);
}
var bids = ctx.vBids.Where(b => b.SaleId == auctionId);
foreach (var bi in bids)
{
BidSoftware.Shared.Export.Bid newbid = new BidSoftware.Shared.Export.Bid();
newbid.UserId = bi.UserEmail;
newbid.Datetime = bi.Stamp.ToString();
lb.Add(newbid);
}
Shared.Export.Auction auctionExport = new Shared.Export.Auction()
{
Id = "cenas entity",
Info = new Info()
{
InitialDate = auc.StartDate.ToString(), MinimumBid = auc.MinIncrement.ToString(), ReservationPrice = auc.SaleValue.ToString()
},
Bids = new Bids()
{
Num = lb.Count().ToString(),
ArrayBid = lb.ToArray()
}
};
return(auctionExport);
}
}
catch (Exception ex) { throw new DisconnectException(ex.Message, ex); }
}
public Shared.Export.Auction ExportAuctionData(int auctionId)
{
var auction = (Shared.DTODefinition.Auction)Tables.TableFactory.GetTableAdapter(DatabaseTable.Auction, connection).GetRecord(auctionId);
if (auction == null)
{
throw new ArgumentException("Não existe o leilão com id " + auctionId);
}
var bids = Tables.TableFactory.GetTableAdapter(DatabaseTable.Bid, connection).GetTable(
new ConditionGroup(new Condition(new NameValuePair("SaleId", auction.SaleId.ToString(), NameValuePair.Operator.Equals))),
new SqlParameter[0]
).Cast <Shared.DTODefinition.Bid>();
var bidsToExport = from bid in bids
select new Shared.Export.Bid()
{
Datetime = bid.Stamp.ToString(),
UserId = bid.UserEmail
};
Shared.Export.Auction auctionExport = new Shared.Export.Auction()
{
Id = "cenas",
Info = new Info()
{
InitialDate = auction.StartDate.ToString(), MinimumBid = auction.MinIncrement.ToString(), ReservationPrice = auction.SaleValue.ToString()
},
Bids = new Bids()
{
Num = bidsToExport.Count().ToString(),
ArrayBid = bidsToExport.ToArray()
}
};
return(auctionExport);
}