private IQueryable<Category> GetUnorderedCategories( RockContext rockContext = null )
{
rockContext = rockContext ?? new RockContext();
string selectedValue = rFilter.GetUserPreference( "EntityType" );
var attributeEntityTypeId = EntityTypeCache.Read( typeof( Rock.Model.Attribute ) ).Id;
var queryable = new CategoryService( rockContext ).Queryable()
.Where( c =>
c.EntityTypeId == attributeEntityTypeId &&
c.EntityTypeQualifierColumn == "EntityTypeId" );
if ( !string.IsNullOrWhiteSpace( selectedValue ) )
{
if ( selectedValue == "0" )
{
queryable = queryable.Where( c => c.EntityTypeQualifierValue == null );
}
else
{
queryable = queryable.Where( c => c.EntityTypeQualifierValue == selectedValue );
}
}
else
{
// Exclude the categories for block and service job attributes, since they are controlled through code attribute decorations
var exclusions = new List<Guid>();
exclusions.Add( Rock.SystemGuid.EntityType.BLOCK.AsGuid() );
exclusions.Add( Rock.SystemGuid.EntityType.SERVICE_JOB.AsGuid() );
var entities = new EntityTypeService( rockContext ).GetEntities()
.Where( t => !exclusions.Contains( t.Guid ) )
.Select( e => e.Id )
.ToList()
.Select( e => e.ToString() )
.ToList();
queryable = queryable.Where( c => entities.Contains( c.EntityTypeQualifierValue ) );
}
return queryable;
}
private IQueryable<Category> GetUnorderedCategories( int? entityTypeId, RockContext rockContext = null )
{
rockContext = rockContext ?? new RockContext();
var attributeEntityTypeId = EntityTypeCache.Read( typeof( Rock.Model.Attribute ) ).Id;
var queryable = new CategoryService( rockContext ).Queryable()
.Where( c =>
c.EntityTypeId == attributeEntityTypeId &&
c.EntityTypeQualifierColumn == "EntityTypeId" );
if ( entityTypeId.HasValue )
{
var stringValue = entityTypeId.Value.ToString();
queryable = queryable.Where( c =>
( entityTypeId.Value == 0 && c.EntityTypeQualifierValue == null ) ||
( entityTypeId.Value != 0 && c.EntityTypeQualifierValue != null && c.EntityTypeQualifierValue == stringValue ) );
}
else
{
// Exclude the categories for block and service job attributes, since they are controlled through code attribute decorations
var exclusions = new List<Guid>();
exclusions.Add( Rock.SystemGuid.EntityType.BLOCK.AsGuid() );
exclusions.Add( Rock.SystemGuid.EntityType.SERVICE_JOB.AsGuid() );
var entities = new EntityTypeService( rockContext ).GetEntities()
.Where( t => !exclusions.Contains( t.Guid ) )
.Select( e => e.Id )
.ToList()
.Select( e => e.ToString() )
.ToList();
queryable = queryable.Where( c =>
c.EntityTypeQualifierValue == null ||
entities.Contains( c.EntityTypeQualifierValue ) );
}
return queryable;
}
