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