public List <AggregateDTO> AggregateSearch(int projectId, int status, int linkStrategy, bool onlyMine, string userName, Nullable <DateTime> startDate, Nullable <DateTime> endDate, bool includeNotInUse, int teamId, bool isActive)
{
List <AggregateDTO> aggregates = new List <AggregateDTO>();
ObjectResult <p1p.Data.sp_Links_Aggregates_Result2> aggregateResults;
using (P1PContext ctx = new P1PContext())
{
aggregateResults = ctx.sp_Links_Aggregates(projectId, status, linkStrategy, onlyMine, userName, startDate, endDate, includeNotInUse, teamId, isActive);
foreach (sp_Links_Aggregates_Result2 a in aggregateResults)
{
if (a.ProjectAggregate != null && a.ProjectAggregate > 0)
{
aggregates.Add(new AggregateDTO()
{
Name = a.Name,
Aggregate = (double)a.ProjectAggregate
});
}
}
}
return(aggregates);
}