public GetCategoryTreeResponse Get(GetCategoryTreeRequest request) { var response = new GetCategoryTreeResponse(); CategoryTree alias = null; var query = Repository.AsQueryOver(() => 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))); } if (request.WithOrder) { query = query.AddOrder(request); } if (request.WithPaging) { query = query.AddPaging(request); } response.Items = query.AddSortingAndPaging(request).Future<CategoryTree>(); response.TotalCount = query.ToRowCountFutureValue().Value; return response; }
public GetCategoryTreeResponse Get(GetCategoryTreeRequest request) { var response = new GetCategoryTreeResponse(); CategoryTree alias = null; var query = Repository.AsQueryOver(() => 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))); } if (request.WithOrder) { query = query.AddOrder(request); } if (request.WithPaging) { query = query.AddPaging(request); } response.Items = query.AddSortingAndPaging(request).Future <CategoryTree>(); response.TotalCount = query.ToRowCountFutureValue().Value; return(response); }