public GetEconomicSummariesResponse GetEconomicSummaries(GetEconomicSummariesRequest request)
{
if (request.OnlyCount)
{
var query = DataContext.EconomicSummaries.AsQueryable();
if (!string.IsNullOrEmpty(request.Term))
{
query = query.Where(x => x.Name.ToLower().Contains(request.Term.ToLower()));
}
return new GetEconomicSummariesResponse { Count = query.Count() };
}
else
{
var query = DataContext.EconomicSummaries.AsQueryable();
if (!string.IsNullOrEmpty(request.Term))
{
query = query.Where(x => x.Name.ToLower().Contains(request.Term.ToLower()));
}
query = query.OrderByDescending(x => x.Id);
if (request.Skip != 0)
{
query = query.Skip(request.Skip);
}
if (request.Take != 0)
{
query = query.Take(request.Take);
}
return new GetEconomicSummariesResponse
{
EconomicSummaries = query.ToList()
.MapTo<GetEconomicSummariesResponse.EconomicSummary>()
};
}
}
public GetEconomicSummariesResponse GetEconomicSummariesForGrid(GetEconomicSummariesRequest request)
{
int totalRecords;
var data = SortData(request.Search, request.SortingDictionary, out totalRecords);
if (request.Take != -1)
{
data = data.Skip(request.Skip).Take(request.Take);
}
return new GetEconomicSummariesResponse
{
TotalRecords = totalRecords,
EconomicSummaries = data.ToList().MapTo<GetEconomicSummariesResponse.EconomicSummary>()
};
}