public void AddToEvent(long donorId,
long eventId,
ref IAuctionTransaction trans)
{
var rec = new AuctionEventDonorEntity() {EventId = eventId, DonorId = donorId};
rec.Save();
}
public Validation ValidateNewBidder(Bidder bidder, ref IAuctionTransaction trans)
{
var val = new Validation();
if (string.IsNullOrEmpty(bidder.Name))
{
val.AddError("Name is empty");
}
if (string.IsNullOrEmpty(bidder.Phone))
{
val.AddError("Phone number is empty");
}
else if (!PhoneNumberIsFormattedCorrectly(bidder.Phone))
{
val.AddError("Phone number is not in the correct format");
}
if (!_eventRepo.EventExists(bidder.EventId, ref trans))
{
val.AddError("Must be in valid auction");
}
return val;
}
public IList<Auction.Domain.Package> GetByCategory(long categoryId,
ref IAuctionTransaction trans)
{
using (var records = new PackageCollection())
{
var filter = new PredicateExpression(PackageFields.CategoryId == categoryId);
if (trans != null)
{
trans.Add(records);
}
records.GetMulti(filter);
return records.Select(r => new Package()
{
BidderId = r.BidderId,
CategoryId = r.CategoryId,
ClosedOutBy = r.ClosedOutBy,
Code = r.Code,
CreatedBy = r.CreatedBy,
EndingBid = r.EndingBid,
EventId = r.EventId,
Id = r.Id,
Name = r.Name,
Notes = r.Notes,
Paid = (bool)r.Paid,
StartingBid = r.StartingBid,
UpdatedBy = r.UpdatedBy
}).ToList();
}
}
public IList<Auction.Domain.Event> GetByAccount(long accountId,
ref IAuctionTransaction trans)
{
using (var records = new AuctionEventCollection())
{
var filter = new PredicateExpression(AuctionEventFields.AccountId == accountId);
if (trans != null)
{
trans.Add(records);
}
records.GetMulti(filter, 0);
return
records.Select(
b =>
new Event()
{
Id = b.Id,
Date = b.Date,
Name = b.Name,
AccountId = b.AccountId,
CreatedBy = b.CreatedBy,
Locked = b.Locked,
Notes = b.Notes,
UpdatedBy = b.UpdatedBy
}).ToList();
}
}
public Event Get(long Id, ref IAuctionTransaction trans)
{
using (var records = new AuctionEventCollection())
{
var filter = new PredicateExpression(AuctionEventFields.Id == Id);
if (trans != null)
{
trans.Add(records);
}
records.GetMulti(filter, 1);
var b = records.ToList().FirstOrDefault();
return new Event()
{
Id = Id,
Date = b.Date,
Name = b.Name,
AccountId = b.AccountId,
CreatedBy = b.CreatedBy,
Locked = b.Locked,
Notes = b.Notes,
UpdatedBy = b.UpdatedBy
};
}
}
public Auction.Domain.Package Get(long Id, ref IAuctionTransaction trans)
{
using (var records = new PackageCollection())
{
var filter = new PredicateExpression(PackageFields.Id == Id);
if (trans != null)
{
trans.Add(records);
}
records.GetMulti(filter, 1);
var r = records.FirstOrDefault();
return new Package()
{
BidderId = r.BidderId,
CategoryId = r.CategoryId,
ClosedOutBy = r.ClosedOutBy,
Code = r.Code,
CreatedBy = r.CreatedBy,
EndingBid = r.EndingBid,
EventId = r.EventId,
Id = r.Id,
Name = r.Name,
Notes = r.Notes,
Paid = (bool) r.Paid,
StartingBid = r.StartingBid,
UpdatedBy = r.UpdatedBy
};
}
}
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 Delete(long donorId,
ref IAuctionTransaction trans)
{
using(var donors = new DonorCollection())
{
donors.DeleteMulti(new PredicateExpression {DonorFields.Id == donorId});
}
}
public void Delete(long Id, ref IAuctionTransaction trans)
{
using (var records = new CategoryCollection())
{
var filter = new PredicateExpression(CategoryFields.Id == Id);
if (trans != null)
{
trans.Add(records);
}
records.DeleteMulti(filter);
}
}
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 bool EventExists(long id, ref IAuctionTransaction trans)
{
using (var records = new AuctionEventCollection())
{
var filter = new PredicateExpression(AuctionEventFields.Id == id);
if (trans != null)
{
trans.Add(records);
}
return records.GetDbCount(filter) > 0;
}
}
public void Insert(ref Category category, ref IAuctionTransaction trans)
{
var c = new CategoryEntity
{
AccountId = category.AccountId,
Name = category.Name
};
if (trans != null)
{
trans.Add(c);
}
c.Save();
}
public int GetCountByAccount(long accountId,
ref IAuctionTransaction trans)
{
using (var records = new AuctionEventCollection())
{
var filter = new PredicateExpression(AuctionEventFields.AccountId == accountId);
if (trans != null)
{
trans.Add(records);
}
return records.GetDbCount(filter);
}
}
public IList<Category> GetByAccount(long accountId, ref IAuctionTransaction trans)
{
using (var records = new CategoryCollection())
{
var filter = new PredicateExpression(CategoryFields.AccountId == accountId);
if (trans != null)
{
trans.Add(records);
}
records.GetMulti(filter, 0);
return records.ToList().Select(c => new Category() { Id = c.Id, Name = c.Name, AccountId = c.AccountId }).ToList();
}
}
public int GetAllowableEventCount(long accountId,
ref IAuctionTransaction trans)
{
using (var records = new AccountCollection())
{
var filter = new PredicateExpression(AccountFields.Id == accountId);
if (trans != null)
{
trans.Add(records);
}
records.GetMulti(filter, 1);
return records.ToList().First().AllowableEvents;
}
}
public Category Get(long Id, ref IAuctionTransaction trans)
{
using (var records = new CategoryCollection())
{
var filter = new PredicateExpression(CategoryFields.Id == Id);
if (trans != null)
{
trans.Add(records);
}
records.GetMulti(filter, 1);
var c = records.ToList().FirstOrDefault();
return new Category() { Id = c.Id, Name = c.Name, AccountId = c.AccountId};
}
}
public Auction.Domain.Bidder Get(long Id, ref IAuctionTransaction trans)
{
using (var records = new BidderCollection())
{
var filter = new PredicateExpression(BidderFields.Id == Id);
if (trans != null)
{
trans.Add(records);
}
records.GetMulti(filter, 1);
var b = records.ToList().FirstOrDefault();
return new Bidder() { Id = b.Id, Number = b.Number, Name = b.Name, EventId = b.EventId, Phone = b.Phone };
}
}
public Auction.Domain.Donor GetDonor(long Id, ref IAuctionTransaction trans)
{
using (var donors = new DonorCollection())
{
donors.GetMulti(new PredicateExpression { DonorFields.Id == Id }, 1);
return donors.Select(d => new Donor()
{
Id = d.Id,
AccountId = d.AccountId,
Name = d.Name,
Notes = d.Notes,
Phone = d.Phone
}).First();
}
}
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 long GetMainUserId(long accountId,
ref IAuctionTransaction trans)
{
using (var records = new AccountCollection())
{
var filter = new PredicateExpression(AccountFields.Id == accountId);
if (trans != null)
{
trans.Add(records);
}
records.GetMulti(filter, 1);
return 1;
// return records.ToList().First().AdminUserId;
}
}
public IList<Auction.Domain.Bidder> GetByEvent(long eventId,
ref IAuctionTransaction trans)
{
using (var records = new BidderCollection())
{
var filter = new PredicateExpression(BidderFields.EventId == eventId);
if (trans != null)
{
trans.Add(records);
}
records.GetMulti(filter, 0);
return records.ToList().Select(b => new Bidder() { Id = b.Id, Number = b.Number, Name = b.Name, EventId = eventId, Phone = b.Phone }).ToList();
}
}
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 Update(ref Category category, ref IAuctionTransaction trans)
{
using (var records = new CategoryCollection())
{
var filter = new PredicateExpression(CategoryFields.Id == category.Id);
var c = new CategoryEntity
{
AccountId = category.AccountId,
Name = category.Name
};
if (trans != null)
{
trans.Add(records);
}
records.UpdateMulti(c, filter);
}
}
public void Insert(ref Bidder bidder,
ref IAuctionTransaction trans)
{
var b = new BidderEntity
{
Number = bidder.Number,
Name = bidder.Name,
Phone = bidder.Phone,
EventId = bidder.EventId,
CreatedBy = bidder.CreatedBy
};
if(trans != null)
{
trans.Add(b);
}
b.Save();
}
public IList<Auction.Domain.Donor> GetByAccount(long accountId,
ref IAuctionTransaction trans)
{
using (var donors = new DonorCollection())
{
var filter = new PredicateExpression { DonorFields.AccountId == accountId };
donors.GetMulti(filter);
return donors.Select(d => new Donor()
{
Id = d.Id,
AccountId = d.AccountId,
Name = d.Name,
Notes = d.Notes,
Phone = d.Phone
}).ToList();
}
}
public Validation ValidateExistingBidder(Bidder bidder, ref IAuctionTransaction trans)
{
var val = new Validation();
if (bidder.Id <= 0)
{
val.AddError("Bidder must have an id");
}
if (string.IsNullOrEmpty(bidder.Name))
{
val.AddError("Name is empty");
}
if (string.IsNullOrEmpty(bidder.Phone))
{
val.AddError("Phone number is empty");
}
else if (!PhoneNumberIsFormattedCorrectly(bidder.Phone))
{
val.AddError("Phone number is not in the correct format");
}
if (!_eventRepo.EventExists(bidder.EventId, ref trans))
{
val.AddError("Must be in valid auction");
}
else
{
if (bidder.Id > 0)
{
var bidderInSystem = _bidderRepo.GetByNumberAndEvent(bidder.Number,
bidder.EventId,
ref trans);
if (bidderInSystem.Id != bidder.Id)
{
val.AddError("Invalid bidder number");
}
}
}
return val;
}
public IList<Auction.Domain.Donor> GetByEvent(long eventId,
ref IAuctionTransaction trans)
{
using (var donors = new DonorCollection())
{
var relations = new RelationCollection {AuctionEventDonorEntity.Relations.DonorEntityUsingDonorId};
var filter = new PredicateExpression { AuctionEventDonorFields.EventId == eventId };
donors.GetMulti(filter, relations);
return donors.Select(d => new Donor()
{
Id = d.Id,
AccountId = d.AccountId,
Name = d.Name,
Notes = d.Notes,
Phone = d.Phone
}).ToList();
}
}
public Validation ValidateExistingEvent(Event auctionEvent, ref IAuctionTransaction trans)
{
var val = new Validation();
if (auctionEvent.Id <= 0)
{
val.AddError("Auction must have an id");
}
if (auctionEvent.Name == string.Empty)
{
val.AddError("Name is empty");
}
if (auctionEvent.Date == DateTime.MinValue)
{
val.AddError("Date is not set");
}
return val;
}
public Validation ValidateNewEvent(Event auctionEvent, ref IAuctionTransaction trans)
{
var val = new Validation();
if (String.IsNullOrEmpty(auctionEvent.Name))
{
val.AddError("Name is empty");
}
if(auctionEvent.Date == DateTime.MinValue)
{
val.AddError("Date is not set");
}
int accountLimit = _accountRepo.GetAllowableEventCount(auctionEvent.AccountId, ref trans);
int currentEventCount = _eventRepo.GetCountByAccount(auctionEvent.AccountId, ref trans);
if(currentEventCount + 1 > accountLimit)
{
val.AddError("Account has reached maximum number of licensed events");
}
return val;
}
public void Update(ref Auction.Domain.Item item,
ref IAuctionTransaction trans)
{
//throw new NotImplementedException();
}
