public GetConstantUsagesResponse GetConstantUsages(GetConstantUsagesRequest request)
{
var query = DataContext.ConstantUsages.Include(x => x.Constants);
if (!string.IsNullOrEmpty(request.Term))
{
query = query.Where(x => x.Role.ToLower().Contains(request.Term.ToLower()) || x.Group.ToLower().Contains(request.Term.ToLower()));
}
query.OrderByDescending(x => x.Id);
if (request.Skip != 0)
{
query = query.Skip(request.Skip);
}
if (request.Take != 0)
{
query = query.Take(request.Take);
}
if (request.OnlyCount)
{
return new GetConstantUsagesResponse { Count = query.Count() };
}
else
{
return new GetConstantUsagesResponse
{
ConstantUsages = query.ToList().MapTo<GetConstantUsagesResponse.ConstantUsageResponse>()
};
}
}
public GetConstantUsagesResponse GetConstantUsagesForGrid(GetConstantUsagesRequest 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 GetConstantUsagesResponse
{
TotalRecords = totalRecords,
ConstantUsages = data.ToList().MapTo<GetConstantUsagesResponse.ConstantUsageResponse>()
};
}