/// <summary> /// Binds the grid. /// </summary> private void BindGrid() { using ( var rockContext = new RockContext() ) { // limit to show only GroupTypes that have a group type purpose of Checkin Template int groupTypePurposeCheckInTemplateId = DefinedValueCache.Read( new Guid( Rock.SystemGuid.DefinedValue.GROUPTYPE_PURPOSE_CHECKIN_TEMPLATE ) ).Id; var qry = new GroupTypeService( rockContext ) .Queryable().AsNoTracking() .Where( a => a.GroupTypePurposeValueId == groupTypePurposeCheckInTemplateId ); SortProperty sortProperty = gGroupType.SortProperty; if ( sortProperty != null ) { gGroupType.DataSource = qry.Sort( sortProperty ).ToList(); } else { gGroupType.DataSource = qry.OrderBy( p => p.Name ).ToList(); } gGroupType.DataBind(); } }
/// <summary> /// Gets the group types. /// </summary> /// <returns></returns> private IQueryable<GroupType> GetGroupTypes( RockContext rockContext ) { var qry = new GroupTypeService( rockContext ).Queryable(); int? purposeId = rFilter.GetUserPreference( "Purpose" ).AsIntegerOrNull(); if ( purposeId.HasValue ) { qry = qry.Where( t => t.GroupTypePurposeValueId == purposeId.Value ); } var isSystem = rFilter.GetUserPreference( "System Group Types" ); if ( isSystem == "Yes" ) { qry = qry.Where( t => t.IsSystem ); } else if ( isSystem == "No" ) { qry = qry.Where( t => !t.IsSystem ); } var isShownInNavigation = rFilter.GetUserPreference("Shown in Navigation").AsBooleanOrNull(); if (isShownInNavigation.HasValue) { if (isShownInNavigation.Value) { qry = qry.Where(t => t.ShowInNavigation); } else if (!isShownInNavigation.Value) { qry = qry.Where(t => !t.ShowInNavigation); } } return qry.OrderBy( g => g.Order ); }
/// <summary> /// Creates the control(s) necessary for prompting user for a new value /// </summary> /// <param name="configurationValues">The configuration values.</param> /// <param name="id"></param> /// <returns> /// The control /// </returns> public override System.Web.UI.Control EditControl( Dictionary<string, ConfigurationValue> configurationValues, string id ) { var editControl = new GroupTypePicker { ID = id }; var qryGroupTypes = new GroupTypeService( new RockContext() ).Queryable(); if ( configurationValues.ContainsKey( GROUP_TYPE_PURPOSE_VALUE_GUID ) ) { var groupTypePurposeValueGuid = ( configurationValues[GROUP_TYPE_PURPOSE_VALUE_GUID] ).Value.AsGuidOrNull(); if ( groupTypePurposeValueGuid.HasValue ) { qryGroupTypes = qryGroupTypes.Where( a => a.GroupTypePurposeValue.Guid == groupTypePurposeValueGuid.Value ); } } editControl.GroupTypes = qryGroupTypes.OrderBy( a => a.Name ).ToList(); return editControl; }
/// <summary> /// Gets the group types. /// </summary> /// <returns></returns> private IQueryable<GroupType> GetGroupTypes() { var qry = new GroupTypeService( new RockContext() ).Queryable(); int? purposeId = rFilter.GetUserPreference( "Purpose" ).AsIntegerOrNull(); if ( purposeId.HasValue ) { qry = qry.Where( t => t.GroupTypePurposeValueId == purposeId.Value ); } var isSystem = rFilter.GetUserPreference( "System Group Types" ); if ( isSystem == "Yes" ) { qry = qry.Where( t => t.IsSystem ); } else if ( isSystem == "No" ) { qry = qry.Where( t => !t.IsSystem ); } return qry.OrderBy( g => g.Order ); }
/// <summary> /// Gets the group types. /// </summary> /// <returns></returns> private IQueryable<GroupType> GetGroupTypes() { var qry = new GroupTypeService().Queryable(); int purposeId = int.MinValue; if ( int.TryParse( rFilter.GetUserPreference( "Purpose" ), out purposeId ) ) { qry = qry.Where( t => t.GroupTypePurposeValueId == purposeId ); } var isSystem = rFilter.GetUserPreference( "System Group Types" ); if ( isSystem == "Yes" ) { qry = qry.Where( t => t.IsSystem ); } else if (isSystem == "No") { qry = qry.Where( t => !t.IsSystem); } return qry.OrderBy( g => g.Order ); }