private IQueryable<Category> GetUnorderedCategories( RockContext rockContext = null )
{
rockContext = rockContext ?? new RockContext();
var queryable = new CategoryService( rockContext ).Queryable().Where( c => c.EntityTypeId == _entityTypeId );
if (_parentCategoryId.HasValue)
{
queryable = queryable.Where( c => c.ParentCategoryId == _parentCategoryId );
}
else
{
queryable = queryable.Where( c => c.ParentCategoryId == null );
}
return queryable;
}
private IQueryable<Category> GetUnorderedCategories()
{
string selectedValue = rFilter.GetUserPreference( "EntityType" );
var attributeEntityTypeId = EntityTypeCache.Read( typeof( Rock.Model.Attribute ) ).Id;
var queryable = new CategoryService( new RockContext() ).Queryable()
.Where( c => c.EntityTypeId == attributeEntityTypeId );
if ( !string.IsNullOrWhiteSpace( selectedValue ) )
{
if ( selectedValue == "0" )
{
queryable = queryable
.Where( c =>
c.EntityTypeQualifierColumn == "EntityTypeId" &&
c.EntityTypeQualifierValue == null );
}
else
{
queryable = queryable
.Where( c =>
c.EntityTypeQualifierColumn == "EntityTypeId" &&
c.EntityTypeQualifierValue == selectedValue );
}
}
return queryable;
}
private IQueryable<Category> GetUnorderedCategories()
{
var queryable = new CategoryService().Queryable().Where( c => c.EntityTypeId == _entityTypeId );
if (_parentCategoryId.HasValue)
{
queryable = queryable.Where( c => c.ParentCategoryId == _parentCategoryId );
}
else
{
queryable = queryable.Where( c => c.ParentCategoryId == null );
}
return queryable;
}
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 IEnumerable<Category> GetUnorderedCategories( RockContext rockContext = null )
{
rockContext = rockContext ?? new RockContext();
var queryable = new CategoryService( rockContext )
.Queryable()
.Where( c => c.EntityTypeId == _entityTypeId )
.ToList()
.Where( c =>
( c.EntityTypeQualifierColumn ?? "" ) == ( _entityCol ?? "" ) &&
( c.EntityTypeQualifierValue ?? "" ) == ( _entityVal ?? "" ) );
if (_parentCategoryId.HasValue)
{
queryable = queryable.Where( c => c.ParentCategoryId == _parentCategoryId );
}
else
{
queryable = queryable.Where( c => c.ParentCategoryId == null );
}
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;
}
private IEnumerable<Category> GetUnorderedCategories( RockContext rockContext = null )
{
rockContext = rockContext ?? new RockContext();
var queryable = new CategoryService( rockContext )
.Queryable();
if ( _hasEntityTypeBlockSetting )
{
queryable = queryable.Where(c => c.EntityTypeId == _entityTypeId );
}
else
{
int? filterEntityTypeId = entityTypeFilter.SelectedValueAsInt();
if ( filterEntityTypeId.HasValue )
{
queryable = queryable.Where( c => c.EntityTypeId == filterEntityTypeId.Value );
}
}
var queryableFiltered = queryable.ToList()
.Where( c =>
( c.EntityTypeQualifierColumn ?? "" ) == ( _entityCol ?? "" ) &&
( c.EntityTypeQualifierValue ?? "" ) == ( _entityVal ?? "" ) );
if (_parentCategoryId.HasValue)
{
queryableFiltered = queryableFiltered.Where( c => c.ParentCategoryId == _parentCategoryId );
}
else
{
queryableFiltered = queryableFiltered.Where( c => c.ParentCategoryId == null );
}
return queryableFiltered;
}