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