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