public PaginatedList <TaskGetModel> GetAll(DateTime?from, DateTime?to, int page)
{
IQueryable <Taskk> result = context
.Tasks
.OrderBy(f => f.Id)
.Include(f => f.Comments);
PaginatedList <TaskGetModel> paginatedResult = new PaginatedList <TaskGetModel>();
paginatedResult.CurrentPage = page;
if (from != null)
{
result = result.Where(f => f.Deadline >= from);
}
if (to != null)
{
result = result.Where(f => f.Deadline <= to);
}
paginatedResult.NumberOfPages = (result.Count() - 1) / PaginatedList <TaskGetModel> .EntriesPerPage + 1;
result = result
.Skip((page - 1) * PaginatedList <TaskGetModel> .EntriesPerPage)
.Take(PaginatedList <TaskGetModel> .EntriesPerPage);
paginatedResult.Entries = result.Select(f => TaskGetModel.FromTask(f)).ToList();
return(paginatedResult);
}
public IEnumerable<TaskGetModel> GetAll(DateTime? from=null, DateTime? to=null)
{
IQueryable<Task> result = context
.Tasks
.Include(t => t.Comments);
if (from == null & to == null)
{
return result.Select(t => TaskGetModel.FromTask(t));
}
if (from != null)
{
result = result.Where(t => t.Deadline >= from);
}
if (to != null)
{
result = result.Where(t => t.Deadline <= to);
}
return result.Select(t => TaskGetModel.FromTask(t));
}
public IEnumerable <TaskGetModel> GetAll(DateTime?from, DateTime?to)
{
{
IQueryable <Taskk> result = context
.Tasks
.Include(f => f.Comments);
if (from == null && to == null)
{
return(result.Select(f => TaskGetModel.FromTask(f)));
}
if (from != null)
{
result = result.Where(f => f.Deadline >= from);
}
if (to != null)
{
result = result.Where(f => f.Deadline <= to);
}
return(result.Select(f => TaskGetModel.FromTask(f)));
}
}
