/// <summary> /// Binds the grid for defined types. /// </summary> private void gDefinedType_Bind() { var queryable = new DefinedTypeService( new RockContext() ).Queryable().Select( a => new { a.Id, a.Category, a.Name, a.Description, a.IsSystem, FieldTypeName = a.FieldType.Name } ); string categoryFilter = tFilter.GetUserPreference( "Category" ); if ( !string.IsNullOrWhiteSpace(categoryFilter) && categoryFilter != Rock.Constants.All.Text ) { queryable = queryable.Where( a => a.Category == categoryFilter ); } SortProperty sortProperty = gDefinedType.SortProperty; if ( sortProperty != null ) { queryable = queryable.Sort( sortProperty ); } else { queryable = queryable.OrderBy( a => a.Category ).ThenBy( a => a.Name ); } gDefinedType.DataSource = queryable.ToList(); gDefinedType.DataBind(); }
/// <summary> /// Binds the grid for defined types. /// </summary> private void rGridType_Bind() { var queryable = new DefinedTypeService().Queryable(). Where( a => a.Category != "" && a.Category != null ); if ( ddlCategoryFilter.SelectedValue != "[All]" ) queryable = queryable. Where( a => a.Category == ddlCategoryFilter.SelectedValue ); SortProperty sortProperty = rGridType.SortProperty; if ( sortProperty != null ) queryable = queryable. Sort( sortProperty ); else queryable = queryable. OrderBy( a => a.Category ); rGridType.DataSource = queryable.ToList(); rGridType.DataBind(); }