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