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);
}
public GetKpisResponse GetKpis(List <int> kpiIds)
{
GetKpisResponse response = new GetKpisResponse();
response.Kpis = new List <GetKpisResponse.Kpi>();
var kpis = DataContext.Kpis
.Include(x => x.Measurement)
.Where(x => kpiIds.Contains(x.Id))
.ToList();
foreach (var kpi in kpis)
{
response.Kpis.Add(new GetKpisResponse.Kpi
{
Id = kpi.Id,
Name = kpi.Name,
Measurement = new GetKpisResponse.Measurement {
Name = kpi.Measurement.Name
}
});
}
response.IsSuccess = true;
return(response);
}
