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