public IList<Auction.Domain.Raffle> GetByEvent(long eventId,
ref IAuctionTransaction trans)
{
using (var records = new RaffleCollection())
{
var filter = new PredicateExpression(RaffleFields.EventId == eventId);
if (trans != null)
{
trans.Add(records);
}
records.GetMulti(filter);
return records.Select(
r =>
new Raffle()
{
CreatedBy = r.CreatedBy,
EventId = r.EventId,
Id = r.Id,
Name = r.Name,
Revenue = r.Total,
UpdatedBy = (long) r.UpdatedBy
}).ToList();
}
}
public void DeleteRaffle(long raffleId,
ref IAuctionTransaction trans)
{
using(var records = new RaffleCollection())
{
if(trans != null)
{
trans.Add(records);
}
records.DeleteMulti(new PredicateExpression(RaffleFields.Id == raffleId));
}
}
public double GetRaffleTotalRevenueByEvent(long eventId,
ref IAuctionTransaction trans)
{
using (var records = new RaffleCollection())
{
var filter = new PredicateExpression(RaffleFields.EventId == eventId);
if (trans != null)
{
trans.Add(records);
}
records.GetMulti(filter);
return (double) records.ToList().Sum(r => r.Total);
}
}
public Auction.Domain.Raffle Get(long id,
ref IAuctionTransaction trans)
{
using (var records = new RaffleCollection())
{
var filter = new PredicateExpression(RaffleFields.Id == id);
if (trans != null)
{
trans.Add(records);
}
records.GetMulti(filter, 1);
var b = records.ToList().FirstOrDefault();
return new Raffle() { Id = id, CreatedBy = b.CreatedBy, EventId = b.EventId, Name = b.Name, Revenue = b.Total, UpdatedBy = (long) b.UpdatedBy};
}
}
public void UpdateRaffle(ref Auction.Domain.Raffle raffle,
ref IAuctionTransaction trans)
{
using(var records = new RaffleCollection())
{
var r = new RaffleEntity()
{
Name = raffle.Name,
Total = (decimal)raffle.Revenue,
UpdatedBy = raffle.UpdatedBy,
EventId = raffle.EventId,
CreatedBy = raffle.CreatedBy
};
if (trans != null)
{
trans.Add(r);
}
records.UpdateMulti(r, new PredicateExpression(RaffleFields.Id == raffle.Id));
}
}
