public IPagedList<MediaFile> GetFilesForFolder(MediaCategorySearchModel searchModel)
{
IQueryOver<MediaFile, MediaFile> query = _session.QueryOver<MediaFile>();
query = searchModel.Id.HasValue
? query.Where(file => file.MediaCategory.Id == searchModel.Id)
: query.Where(file => file.MediaCategory == null);
if (!string.IsNullOrWhiteSpace(searchModel.SearchText))
{
query = query.Where(file =>
file.FileName.IsInsensitiveLike(searchModel.SearchText, MatchMode.Anywhere)
||
file.Title.IsInsensitiveLike(searchModel.SearchText, MatchMode.Anywhere)
||
file.Description.IsInsensitiveLike(searchModel.SearchText, MatchMode.Anywhere)
);
}
query = query.OrderBy(searchModel.SortBy);
return query.Paged(searchModel.Page, _mediaSettings.MediaPageSize);
}
public List<SelectListItem> GetSortByOptions(MediaCategorySearchModel searchModel)
{
return EnumHelper<MediaCategorySortMethod>.GetOptions();
}
public MediaCategory GetCategory(MediaCategorySearchModel searchModel)
{
return searchModel.Id.HasValue
? _session.Get<MediaCategory>(searchModel.Id.Value)
: null;
}
public IList<MediaCategory> GetSubFolders(MediaCategorySearchModel searchModel)
{
IQueryOver<MediaCategory, MediaCategory> queryOver =
_session.QueryOver<MediaCategory>().Where(x => !x.HideInAdminNav);
queryOver = searchModel.Id.HasValue
? queryOver.Where(x => x.Parent.Id == searchModel.Id)
: queryOver.Where(x => x.Parent == null);
if (!string.IsNullOrWhiteSpace(searchModel.SearchText))
{
queryOver =
queryOver.Where(
category => category.Name.IsInsensitiveLike(searchModel.SearchText, MatchMode.Anywhere));
}
queryOver = queryOver.OrderBy(searchModel.SortBy);
return queryOver.Cacheable().List();
}
public PartialViewResult Manage(MediaCategorySearchModel searchModel)
{
ViewData["category"] = _fileAdminService.GetCategory(searchModel);
ViewData["files"] = _fileAdminService.GetFilesForFolder(searchModel);
ViewData["folders"] = _fileAdminService.GetSubFolders(searchModel);
ViewData["sort-by-options"] = _fileAdminService.GetSortByOptions(searchModel);
return PartialView(searchModel);
}
public ViewResult Index(MediaCategorySearchModel searchModel)
{
return View(searchModel);
}
public ActionResult Show(MediaCategorySearchModel searchModel)
{
if (searchModel == null || searchModel.Id == null)
return RedirectToAction("Index");
ViewData["category"] = _fileAdminService.GetCategory(searchModel);
return View(searchModel);
}
