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))); } }