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