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