public DtoCapacity GetCapacityByEventureListId(int id)
{
var capacity = new DtoCapacity(0, 0);
var capacitySum = _contextProvider.Context.EventureLists.Where(ol => ol.Id == id).Sum(s => (Int32?)s.Capacity);
//var queryOwnerEventures = db.Eventures.Where(e => e.Id == id).Select(e => e.Id);
//var queryOwnersLists = db.EventureLists.Where(el => queryOwnerEventures.Contains(el.EventureId)).Select(l => l.Id);
var regcount = _contextProvider.Context.Registrations.Count(r => r.EventureListId == id && r.EventureOrder.Status == "Complete");
capacity.Regs = regcount;
capacity.Capacity = capacitySum ?? 0;
return(capacity);
}
public DtoCapacity GetCapacityByEventureId(int id)
{
//var rList = new List<DtoCapacity>();
var capacity = new DtoCapacity(0, 0);
var capacitySum = _contextProvider.Context.EventureLists.Where(ol => ol.EventureId == id).Sum(s => (int?)s.Capacity) ?? 0;
//.Sum(income => (decimal?)income.Amount) ?? 0;
var queryOwnerEventures = _contextProvider.Context.Eventures.Where(e => e.Id == id).Select(e => e.Id);
var queryOwnersLists = _contextProvider.Context.EventureLists.Where(el => queryOwnerEventures.Contains(el.EventureId)).Select(l => l.Id);
var regcount = _contextProvider.Context.Registrations.Count(r => queryOwnersLists.Contains(r.EventureListId) && r.EventureOrder.Status == "Complete");
//rList.Add(new DtoCapacity(regcount, capacitySum));
//rList.Add(new DtoCapacity(232, 666));
capacity.Regs = regcount;
capacity.Capacity = capacitySum;
return(capacity);
}
public DtoCapacity GetCapacityByOwnerId(int id)
{
var capacity = new DtoCapacity(0, 0);
var queryOwnerEventures = _contextProvider.Context.Eventures.Where(e => e.OwnerId == id).Select(e => e.Id);
var capacitySum = _contextProvider.Context.EventureLists.Where(ol => queryOwnerEventures.Contains(ol.Id)).Sum(s => s.Capacity);
var queryOwnersLists = _contextProvider.Context.EventureLists.Where(el => queryOwnerEventures.Contains(el.EventureId)).Select(l => l.Id);
var regcount = _contextProvider.Context.Registrations.Count(r => queryOwnersLists.Contains(r.EventureListId) && r.EventureOrder.Status == "Complete");
//var regcount = (from r in _contextProvider.Context.Registrations
// join o in _contextProvider.Context.Orders
// on r.EventureOrderId equals o.Id
// where r.EventureListId == id
// && o.Status == "Complete").Count()
// //select r.ParticipantId;
capacity.Regs = regcount;
capacity.Capacity = capacitySum;
return(capacity);
}
