private PagedData<Task> GetTasks(IDataTablesRequest request, TaskFilter taskFilter)
{
var filter = (taskFilter ?? new TaskFilter()).ByString(request.Search.Value);
//.WithPaging(request.Length, request.Start / request.Length);
var query = Query.ForTask(filter).Include(x => x.Project().TaskSteps().SpentTimes());
var pageSize = request.Length;
var pageNumber = request.Start / request.Length;
PagedData<Task> tasks = null;
var sorting = request.Sortings<TaskListColumns>().FirstOrDefault();
if (sorting != null)
{
var column = sorting.Item1;
var direction = sorting.Item2;
if (columnsWithClientSorting.Contains(column))
{
tasks = this.GetSortedOnClientTasks(query, pageSize, pageNumber, column, direction);
}
else
{
tasks = this.GetSortedOnServerTasks(query, pageSize, pageNumber, column, direction);
}
}
else
{
tasks = this.GetTasksWithoutSorting(query, pageSize, pageNumber);
}
return tasks;
}
