public List <SystemUserEntity> FindAllInactiveProfiles(DateTime inactiveSinceDate) { NHibernateDynamicQueryGenerator <SystemUserEntity> queryGenerator = this.GetNewQueryBuilder(); queryGenerator.AddWhereClause(PROPERTY_LASTACTIVITYDATE.Lt(inactiveSinceDate)); return(this.FindListByQueryBuilder(queryGenerator)); }
internal List <SystemUserEntity> FindAllInactiveProfiles(DateTime inactiveSinceDate, int pageIndex, int pageSize, out int totalRecords) { NHibernateDynamicQueryGenerator <SystemUserEntity> queryGenerator = this.GetNewQueryBuilder(); queryGenerator.AddWhereClause(PROPERTY_LASTACTIVITYDATE.Lt(inactiveSinceDate)); queryGenerator.SetFirstResult((pageIndex - 1) * pageSize); queryGenerator.SetMaxResults(pageSize); return(this.FindListByPageByQueryBuilder(queryGenerator, out totalRecords)); }
internal List <SystemUserEntity> FindAllInactiveProfiles(DateTime inactiveSinceDate, int pageIndex, int pageSize, out int totalRecords) { NHibernateDynamicQueryGenerator <SystemUserEntity> queryGenerator = this.GetNewQueryBuilder(); queryGenerator.AddWhereClause(PROPERTY_LASTACTIVITYDATE.Lt(inactiveSinceDate)); PageQueryParams pageQueryParams = new PageQueryParams(); pageQueryParams.PageIndex = pageIndex; pageQueryParams.PageSize = pageSize; List <SystemUserEntity> result = this.FindListByPageByQueryBuilder(queryGenerator, pageQueryParams); totalRecords = pageQueryParams.RecordCount; return(result); }