public Paginator<User> GetUsersInRolePaginator(Role role, int pageSize) { IDetachedQuery query = new DetachedQuery("from User u where :role in elements(u.Roles) and u.Site = :site and u.IsLogicallyDeleted = 0"); query.SetEntity("role", role); query.SetEntity("site", role.Site); return Repository<User>.GetPaginator(query, pageSize); }
//public IList<Domain.User> GetAllSiteUsers(Site site) //{ // using (ISession session = RepositoryHelper.GetSession()) // { // string hql = "from User u where u.Site = :site and u.IsLogicallyDeleted = 0 and u.IsActive = 1"; // IQuery query = session.CreateQuery(hql); // query.SetEntity("site", site); // return query.List<Domain.User>(); // } //} public Paginator<User> GetUserPaginatorBySite(Site site, int pageSize) { if (site == null) throw new ArgumentNullException("site"); IDetachedQuery query = new DetachedQuery("from User u where u.Site = :site and u.IsLogicallyDeleted = 0"); query.SetEntity("site", site); return Repository<User>.GetPaginator(query, pageSize); }
public IList<User> GetUsersInRole(Role role) { IDetachedQuery dq = new DetachedQuery("from User u where :role in elements(u.Roles) and u.Site = :site and u.IsLogicallyDeleted = 0"); dq.SetEntity("role", role); dq.SetEntity("site", role.Site); using (ISession session = Session){ IQuery query = dq.GetExecutableQuery(session); return query.List<User>(); } }
public Paginator<Role> GetRolePaginatorBySite(Site site, int pageSize) { IDetachedQuery query = new DetachedQuery("from Role r where r.Site = :site"); query.SetEntity("site", site); return Repository<Role>.GetPaginator(query, pageSize); }