public CategoryTreesGridViewModel <SiteSettingCategoryTreeViewModel> Execute(CategoryTreesFilter request)
{
request.SetDefaultSortingOptions("Title");
CategoryTree alias = null;
SiteSettingCategoryTreeViewModel modelAlias = null;
var query = UnitOfWork.Session.QueryOver(() => alias).Where(() => !alias.IsDeleted);
if (!string.IsNullOrWhiteSpace(request.SearchQuery))
{
var searchQuery = string.Format("%{0}%", request.SearchQuery);
query = query.Where(Restrictions.Disjunction().Add(Restrictions.InsensitiveLike(NHibernate.Criterion.Projections.Property(() => alias.Title), searchQuery)));
}
query =
query.SelectList(
select =>
select.Select(() => alias.Id)
.WithAlias(() => modelAlias.Id)
.Select(() => alias.Version)
.WithAlias(() => modelAlias.Version)
.Select(() => alias.Title)
.WithAlias(() => modelAlias.Title)).TransformUsing(Transformers.AliasToBean <SiteSettingCategoryTreeViewModel>());
var count = query.ToRowCountFutureValue();
var sitemaps = query.AddSortingAndPaging(request).Future <SiteSettingCategoryTreeViewModel>();
return(new CategoryTreesGridViewModel <SiteSettingCategoryTreeViewModel>(sitemaps.ToList(), request, count.Value));
}
public ActionResult CategoryTrees(CategoryTreesFilter request)
{
request.SetDefaultPaging();
var model = GetCommand <GetCategoryTreesListCommand>().ExecuteCommand(request);
var view = RenderView("CategoryTrees", model);
return(ComboWireJson(model != null, view, new {}, JsonRequestBehavior.AllowGet));
}
public ActionResult CategoryTrees(CategoryTreesFilter request)
{
request.SetDefaultPaging();
var model = GetCommand<GetCategoryTreesListCommand>().ExecuteCommand(request);
var view = RenderView("CategoryTrees", model);
return ComboWireJson(model != null, view, new {}, JsonRequestBehavior.AllowGet);
}
public CategoryTreesGridViewModel(IEnumerable <TModel> items, CategoryTreesFilter filter, int totalCount)
: base(items, filter, totalCount)
{
}