public GetKpiToSeriesResponse GetKpiToSeries(GetKpiToSeriesRequest request)
{
if (request.MeasurementId != 0)
{
return new GetKpiToSeriesResponse
{
KpiList = DataContext.Kpis
.Include(x => x.Measurement)
.Where(x => x.Name.Contains(request.Term) && x.Measurement.Id == request.MeasurementId).Take(20).ToList()
.MapTo<GetKpiToSeriesResponse.Kpi>()
};
}
else
{
return new GetKpiToSeriesResponse
{
KpiList = DataContext.Kpis
.Include(x => x.Measurement)
.Where(x => x.Name.Contains(request.Term)).Take(20).ToList()
.MapTo<GetKpiToSeriesResponse.Kpi>()
};
}
}
public GetKpiToSeriesResponse GetKpiToSeries(GetKpiToSeriesRequest request)
{
if (request.MeasurementId != 0)
{
var query = DataContext.Kpis
.Include(x => x.Measurement)
.Where(x => x.Name.Contains(request.Term) && x.Measurement.Id == request.MeasurementId);
if(request.OnlyCorporate){
query = query.Where(x => x.Type.Name == "Corporate Portfolio");
}
return new GetKpiToSeriesResponse
{
KpiList =query.Take(20).ToList()
.MapTo<GetKpiToSeriesResponse.Kpi>()
};
}
else
{
var query = DataContext.Kpis
.Include(x => x.Measurement)
.Where(x => x.Name.Contains(request.Term));
if(request.OnlyCorporate){
query = query.Where(x => x.Type.Name == "Corporate Portfolio");
}
return new GetKpiToSeriesResponse
{
KpiList =query.Take(20).ToList()
.MapTo<GetKpiToSeriesResponse.Kpi>()
};
}
}