public GetKpisResponse GetKpis(GetKpisRequest request)
{
IQueryable<Kpi> kpis;
//var kpis = new Queryable<Kpi>();
if (request.Take != 0)
{
kpis = DataContext.Kpis.Include(x => x.Pillar).OrderBy(x => x.Id).Skip(request.Skip).Take(request.Take);
}
else
{
kpis = DataContext.Kpis.Include(x => x.Pillar);
}
if (request.PillarId > 0)
{
kpis = kpis.Include(x => x.Pillar).Where(x => x.Pillar.Id == request.PillarId);
}
var response = new GetKpisResponse();
response.Kpis = kpis.ToList().MapTo<GetKpisResponse.Kpi>();
return response;
}
public GetKpisResponse GetKpis(GetKpisRequest request)
{
int totalRecords;
var data = SortData(request.Search, request.SortingDictionary, out totalRecords);
if (request.Take != -1)
{
data = data.Skip(request.Skip).Take(request.Take);
}
//var kpis = new Queryable<Kpi>();
/*if (request.Take != 0)
{
kpis = DataContext.Kpis.Include(x => x.Pillar).OrderBy(x => x.Id).Skip(request.Skip).Take(request.Take);
}
else
{
kpis = DataContext.Kpis.Include(x => x.Pillar);
}
if (request.PillarId > 0)
{
kpis = kpis.Include(x => x.Pillar).Where(x => x.Pillar.Id == request.PillarId);
}*/
var response = new GetKpisResponse();
response.TotalRecords = totalRecords;
response.Kpis = data.ToList().MapTo<GetKpisResponse.Kpi>();
return response;
}