public IQueryable <Message> GetOrderedQuery(IQueryable <Message> all, BootstrapTableInput input) { switch (input.sort) { case "title": return(input.order == "desc" ? all.OrderByDescending(a => a.Title) : all.OrderBy(a => a.Title)); default: return(input.order == "desc" ? all.OrderByDescending(a => a.CreationTime) : all.OrderBy(a => a.CreationTime)); } }
public PagedResultDto <MessageDto> GetAll(BootstrapTableInput input) { var all = _repository.GetAllIncluding(); var filtered = GetFilteredQuery(all, input); var ordered = GetOrderedQuery(filtered, input); var paged = ordered.Skip(input.offset).Take(input.limit).ToList(); return(new PagedResultDto <MessageDto>(filtered.Count(), BuildModel(paged))); }
public IQueryable <Student> GetOrderedQuery(IQueryable <Student> all, BootstrapTableInput input) { switch (input.sort) { case "name": return(input.order == "desc" ? all.OrderByDescending(a => a.Name) : all.OrderBy(a => a.Name)); default: return(input.order == "desc" ? all.OrderByDescending(a => a.CreationTime) : all.OrderBy(a => a.CreationTime)); } }
public PagedResultDto <AcademicUnitDto> GetAll(BootstrapTableInput input) { var all = _repository.GetAll(); var filtered = GetFilteredQuery(all, input); var ordered = GetOrderedQuery(filtered, input); var paged = ordered.Skip(input.offset).Take(input.limit).ToList(); return(new PagedResultDto <AcademicUnitDto>(filtered.Count(), paged.Select(a => a.MapTo <AcademicUnitDto>()).ToList())); }
public PagedResultDto <StudentDto> GetAll(BootstrapTableInput input) { var all = _repository.GetAllIncluding(a => a.PhoneInfos); var filtered = GetFilteredQuery(all, input); var ordered = GetOrderedQuery(filtered, input); var paginated = ordered.Skip(input.offset).Take(input.limit).ToList(); return(new PagedResultDto <StudentDto>(filtered.Count(), paginated.Select(a => a.MapTo <StudentDto>()).ToList())); }
public IQueryable <AcademicUnit> GetFilteredQuery(IQueryable <AcademicUnit> all, BootstrapTableInput input) { all = all.WhereIf(!string.IsNullOrEmpty(input.search), a => a.Name.Contains(input.search)); return(all); }
public IQueryable <Message> GetFilteredQuery(IQueryable <Message> all, BootstrapTableInput input) { all = all.WhereIf(!string.IsNullOrEmpty(input.search), a => a.Title.Contains(input.search)); return(all); }
public IQueryable <Feed> GetFilteredQuery(IQueryable <Feed> all, BootstrapTableInput input) { all = all.WhereIf(!string.IsNullOrEmpty(input.search), a => a.Title.Contains(input.search) || a.Publisher.Name.Contains(input.search) ); return(input.active.HasValue ? all.Where(a => a.IsActive == input.active.Value) : all); }
public IQueryable <FeedPublisher> GetFilteredQuery(IQueryable <FeedPublisher> query, BootstrapTableInput input) { query = query.WhereIf(!string.IsNullOrEmpty(input.search), a => a.Description.Contains(input.search) || a.Name.Contains(input.search)); return(query); }