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