public List <SystemUserEntity> FindAllInactiveProfiles(DateTime inactiveSinceDate) { NHibernateDynamicQueryGenerator <SystemUserEntity> queryGenerator = this.GetNewQueryBuilder(); queryGenerator.AddWhereClause(PROPERTY_LASTACTIVITYDATE.Lt(inactiveSinceDate)); return(this.FindListByQueryBuilder(queryGenerator)); }
/// <summary> /// /// </summary> /// <param name="checkDate"></param> /// <returns></returns> public int FindOnlineUsersCount(DateTime checkDate) { var criterions = new List <ICriterion> { PROPERTY_LASTACTIVITYDATE.Gt(checkDate) }; var pjs = new List <IProjection> { Projections.RowCount() }; return(ProjectionScalarQuery <int>(pjs.ToArray(), criterions.ToArray(), null)); }
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); }