/// <summary>
/// Adds the attribute columns.
/// </summary>
private void AddDynamicControls()
{
// Clear the filter controls
phAttributeFilters.Controls.Clear();
// Remove attribute columns
foreach ( var column in gGroupMembers.Columns.OfType<AttributeField>().ToList() )
{
gGroupMembers.Columns.Remove( column );
}
if ( AvailableAttributes != null )
{
foreach ( var attribute in AvailableAttributes )
{
var control = attribute.FieldType.Field.FilterControl( attribute.QualifierValues, "filter_" + attribute.Id.ToString(), false, Rock.Reporting.FilterMode.SimpleFilter );
if ( control != null )
{
if ( control is IRockControl )
{
var rockControl = (IRockControl)control;
rockControl.Label = attribute.Name;
rockControl.Help = attribute.Description;
phAttributeFilters.Controls.Add( control );
}
else
{
var wrapper = new RockControlWrapper();
wrapper.ID = control.ID + "_wrapper";
wrapper.Label = attribute.Name;
wrapper.Controls.Add( control );
phAttributeFilters.Controls.Add( wrapper );
}
string savedValue = rFilter.GetUserPreference( MakeKeyUniqueToGroup( attribute.Key ) );
if ( !string.IsNullOrWhiteSpace( savedValue ) )
{
try
{
var values = JsonConvert.DeserializeObject<List<string>>( savedValue );
attribute.FieldType.Field.SetFilterValues( control, attribute.QualifierValues, values );
}
catch
{
// intentionally ignore
}
}
}
string dataFieldExpression = attribute.Key;
bool columnExists = gGroupMembers.Columns.OfType<AttributeField>().FirstOrDefault( a => a.DataField.Equals( dataFieldExpression ) ) != null;
if ( !columnExists )
{
AttributeField boundField = new AttributeField();
boundField.DataField = dataFieldExpression;
boundField.HeaderText = attribute.Name;
boundField.SortExpression = string.Empty;
var attributeCache = Rock.Web.Cache.AttributeCache.Read( attribute.Id );
if ( attributeCache != null )
{
boundField.ItemStyle.HorizontalAlign = attributeCache.FieldType.Field.AlignValue;
}
gGroupMembers.Columns.Add( boundField );
}
}
}
// Add Place Elsewhere column if the group or group type has any Place Elsewhere member triggers
if ( _group != null && _group.GroupType != null )
{
if ( _group.GetGroupMemberWorkflowTriggers().Where( a => a.TriggerType == GroupMemberWorkflowTriggerType.MemberPlacedElsewhere ).Any() )
{
AddPlaceElsewhereColumn();
}
}
// Add Link to Profile Page Column
if ( !string.IsNullOrEmpty( GetAttributeValue( "PersonProfilePage" ) ) )
{
AddPersonProfileLinkColumn();
}
// Add delete column
var deleteField = new DeleteField();
gGroupMembers.Columns.Add( deleteField );
deleteField.Click += DeleteGroupMember_Click;
}
protected void AddColumns( ContentChannel channel)
{
// Remove all columns
gContentChannelItems.Columns.Clear();
if ( channel != null )
{
// Add Title column
var titleField = new BoundField();
titleField.DataField = "Title";
titleField.HeaderText = "Title";
titleField.SortExpression = "Title";
gContentChannelItems.Columns.Add( titleField );
// Add Attribute columns
int entityTypeId = EntityTypeCache.Read( typeof( Rock.Model.ContentChannelItem ) ).Id;
string channelId = channel.Id.ToString();
string channelTypeId = channel.ContentChannelTypeId.ToString();
foreach ( var attribute in new AttributeService( new RockContext() ).Queryable()
.Where( a =>
a.EntityTypeId == entityTypeId &&
a.IsGridColumn && ( (
a.EntityTypeQualifierColumn.Equals( "ContentChannelTypeId", StringComparison.OrdinalIgnoreCase ) &&
a.EntityTypeQualifierValue.Equals( channelTypeId )
) || (
a.EntityTypeQualifierColumn.Equals( "ContentChannelId", StringComparison.OrdinalIgnoreCase ) &&
a.EntityTypeQualifierValue.Equals( channelId )
) ) )
.OrderBy( a => a.Order )
.ThenBy( a => a.Name ) )
{
string dataFieldExpression = attribute.Key;
bool columnExists = gContentChannelItems.Columns.OfType<AttributeField>().FirstOrDefault( a => a.DataField.Equals( dataFieldExpression ) ) != null;
if ( !columnExists )
{
AttributeField boundField = new AttributeField();
boundField.DataField = dataFieldExpression;
boundField.HeaderText = attribute.Name;
boundField.SortExpression = string.Empty;
var attributeCache = Rock.Web.Cache.AttributeCache.Read( attribute.Id );
if ( attributeCache != null )
{
boundField.ItemStyle.HorizontalAlign = attributeCache.FieldType.Field.AlignValue;
}
gContentChannelItems.Columns.Add( boundField );
}
}
// Add Start column
var startField = new DateTimeField();
startField.DataField = "StartDateTime";
startField.HeaderText = channel.ContentChannelType.DateRangeType == ContentChannelDateType.DateRange ? "Start" : "Date";
startField.SortExpression = "StartDateTime";
gContentChannelItems.Columns.Add( startField );
// Expire column
if ( channel.ContentChannelType.DateRangeType == ContentChannelDateType.DateRange )
{
var expireField = new DateTimeField();
expireField.DataField = "ExpireDateTime";
expireField.HeaderText = "Expire";
expireField.SortExpression = "ExpireDateTime";
gContentChannelItems.Columns.Add( expireField );
}
// Priority column
var priorityField = new BoundField();
priorityField.DataField = "Priority";
priorityField.HeaderText = "Priority";
priorityField.SortExpression = "Priority";
priorityField.DataFormatString = "{0:N0}";
priorityField.ItemStyle.HorizontalAlign = HorizontalAlign.Right;
gContentChannelItems.Columns.Add( priorityField );
// Status column
if ( channel.RequiresApproval )
{
var statusField = new BoundField();
gContentChannelItems.Columns.Add( statusField );
statusField.DataField = "Status";
statusField.HeaderText = "Status";
statusField.SortExpression = "Status";
statusField.HtmlEncode = false;
}
bool canEditChannel = channel.IsAuthorized( Rock.Security.Authorization.EDIT, CurrentPerson );
gContentChannelItems.Actions.ShowAdd = canEditChannel;
gContentChannelItems.IsDeleteEnabled = canEditChannel;
if ( canEditChannel )
{
var deleteField = new DeleteField();
gContentChannelItems.Columns.Add( deleteField );
deleteField.Click += gContentChannelItems_Delete;
}
}
}
protected void AddAttributeColumns()
{
// Remove attribute columns
foreach ( var column in gItems.Columns.OfType<AttributeField>().ToList() )
{
gItems.Columns.Remove( column );
}
// Add attribute columns
int entityTypeId = EntityTypeCache.Read( typeof( Rock.Model.ContentChannelItem ) ).Id;
foreach ( var attribute in new AttributeService( new RockContext() ).Queryable()
.Where( a =>
a.EntityTypeId == entityTypeId &&
a.IsGridColumn && ( (
a.EntityTypeQualifierColumn.Equals( "ContentChannelTypeId", StringComparison.OrdinalIgnoreCase ) &&
a.EntityTypeQualifierValue.Equals( _typeId.ToString() )
) || (
a.EntityTypeQualifierColumn.Equals( "ContentChannelId", StringComparison.OrdinalIgnoreCase ) &&
a.EntityTypeQualifierValue.Equals( _channelId.ToString() )
) ) )
.OrderBy( a => a.Order )
.ThenBy( a => a.Name ) )
{
string dataFieldExpression = attribute.Key;
bool columnExists = gItems.Columns.OfType<AttributeField>().FirstOrDefault( a => a.DataField.Equals( dataFieldExpression ) ) != null;
if ( !columnExists )
{
AttributeField boundField = new AttributeField();
boundField.DataField = dataFieldExpression;
boundField.AttributeId = attribute.Id;
boundField.HeaderText = attribute.Name;
var attributeCache = Rock.Web.Cache.AttributeCache.Read( attribute.Id );
if ( attributeCache != null )
{
boundField.ItemStyle.HorizontalAlign = attributeCache.FieldType.Field.AlignValue;
}
gItems.Columns.Add( boundField );
}
}
}
protected void AddDynamicControls( ContentChannel channel)
{
// Remove all columns
gContentChannelItems.Columns.Clear();
phAttributeFilters.Controls.Clear();
if ( channel != null )
{
// Add Title column
var titleField = new BoundField();
titleField.DataField = "Title";
titleField.HeaderText = "Title";
titleField.SortExpression = "Title";
gContentChannelItems.Columns.Add( titleField );
// Add Attribute columns
int entityTypeId = EntityTypeCache.Read( typeof( Rock.Model.ContentChannelItem ) ).Id;
string channelId = channel.Id.ToString();
string channelTypeId = channel.ContentChannelTypeId.ToString();
foreach ( var attribute in AvailableAttributes )
{
var control = attribute.FieldType.Field.FilterControl( attribute.QualifierValues, "filter_" + attribute.Id.ToString(), false, Rock.Reporting.FilterMode.SimpleFilter );
if ( control != null )
{
if ( control is IRockControl )
{
var rockControl = (IRockControl)control;
rockControl.Label = attribute.Name;
rockControl.Help = attribute.Description;
phAttributeFilters.Controls.Add( control );
}
else
{
var wrapper = new RockControlWrapper();
wrapper.ID = control.ID + "_wrapper";
wrapper.Label = attribute.Name;
wrapper.Controls.Add( control );
phAttributeFilters.Controls.Add( wrapper );
}
string savedValue = gfFilter.GetUserPreference( MakeKeyUniqueToChannel( channel.Id, attribute.Key ) );
if ( !string.IsNullOrWhiteSpace( savedValue ) )
{
try
{
var values = JsonConvert.DeserializeObject<List<string>>( savedValue );
attribute.FieldType.Field.SetFilterValues( control, attribute.QualifierValues, values );
}
catch
{
// intentionally ignore
}
}
}
string dataFieldExpression = attribute.Key;
bool columnExists = gContentChannelItems.Columns.OfType<AttributeField>().FirstOrDefault( a => a.DataField.Equals( dataFieldExpression ) ) != null;
if ( !columnExists )
{
AttributeField boundField = new AttributeField();
boundField.DataField = dataFieldExpression;
boundField.HeaderText = attribute.Name;
boundField.SortExpression = string.Empty;
boundField.ItemStyle.HorizontalAlign = attribute.FieldType.Field.AlignValue;
gContentChannelItems.Columns.Add( boundField );
}
}
if ( channel.ContentChannelType.IncludeTime )
{
// Add Start column
var startField = new DateTimeField();
startField.DataField = "StartDateTime";
startField.HeaderText = channel.ContentChannelType.DateRangeType == ContentChannelDateType.DateRange ? "Start" : "Date";
startField.SortExpression = "StartDateTime";
gContentChannelItems.Columns.Add( startField );
// Expire column
if ( channel.ContentChannelType.DateRangeType == ContentChannelDateType.DateRange )
{
var expireField = new DateTimeField();
expireField.DataField = "ExpireDateTime";
expireField.HeaderText = "Expire";
expireField.SortExpression = "ExpireDateTime";
gContentChannelItems.Columns.Add( expireField );
}
}
else
{
// Add Start column
var startField = new DateField();
startField.DataField = "StartDateTime";
startField.HeaderText = channel.ContentChannelType.DateRangeType == ContentChannelDateType.DateRange ? "Start" : "Date";
startField.SortExpression = "StartDateTime";
gContentChannelItems.Columns.Add( startField );
// Expire column
if ( channel.ContentChannelType.DateRangeType == ContentChannelDateType.DateRange )
{
var expireField = new DateField();
expireField.DataField = "ExpireDateTime";
expireField.HeaderText = "Expire";
expireField.SortExpression = "ExpireDateTime";
gContentChannelItems.Columns.Add( expireField );
}
}
// Priority column
var priorityField = new BoundField();
priorityField.DataField = "Priority";
priorityField.HeaderText = "Priority";
priorityField.SortExpression = "Priority";
priorityField.DataFormatString = "{0:N0}";
priorityField.ItemStyle.HorizontalAlign = HorizontalAlign.Right;
gContentChannelItems.Columns.Add( priorityField );
// Status column
if ( channel.RequiresApproval )
{
var statusField = new BoundField();
gContentChannelItems.Columns.Add( statusField );
statusField.DataField = "Status";
statusField.HeaderText = "Status";
statusField.SortExpression = "Status";
statusField.HtmlEncode = false;
}
// Add occurrences Count column
var occurrencesField = new BoolField();
occurrencesField.DataField = "Occurrences";
occurrencesField.HeaderText = "Event Occurrences";
gContentChannelItems.Columns.Add( occurrencesField );
bool canEditChannel = channel.IsAuthorized( Rock.Security.Authorization.EDIT, CurrentPerson );
gContentChannelItems.Actions.ShowAdd = canEditChannel;
gContentChannelItems.IsDeleteEnabled = canEditChannel;
if ( canEditChannel )
{
var deleteField = new DeleteField();
gContentChannelItems.Columns.Add( deleteField );
deleteField.Click += gContentChannelItems_Delete;
}
}
}
/// <summary>
/// Binds the defined values grid.
/// </summary>
protected void BindDefinedValuesGrid()
{
AttributeService attributeService = new AttributeService();
int definedTypeId = hfDefinedTypeId.ValueAsInt();
// add attributes with IsGridColumn to grid
string qualifierValue = hfDefinedTypeId.Value;
var qryDefinedTypeAttributes = attributeService.GetByEntityTypeId( new DefinedValue().TypeId ).AsQueryable()
.Where( a => a.EntityTypeQualifierColumn.Equals( "DefinedTypeId", StringComparison.OrdinalIgnoreCase )
&& a.EntityTypeQualifierValue.Equals( qualifierValue ) );
qryDefinedTypeAttributes = qryDefinedTypeAttributes.Where( a => a.IsGridColumn );
List<Attribute> gridItems = qryDefinedTypeAttributes.ToList();
foreach ( var item in gDefinedValues.Columns.OfType<AttributeField>().ToList() )
{
gDefinedValues.Columns.Remove( item );
}
foreach ( var item in gridItems.OrderBy( a => a.Order ).ThenBy( a => a.Name ) )
{
string dataFieldExpression = item.Key;
bool columnExists = gDefinedValues.Columns.OfType<AttributeField>().FirstOrDefault( a => a.DataField.Equals( dataFieldExpression ) ) != null;
if ( !columnExists )
{
AttributeField boundField = new AttributeField();
boundField.DataField = dataFieldExpression;
boundField.HeaderText = item.Name;
boundField.SortExpression = string.Empty;
int insertPos = gDefinedValues.Columns.IndexOf( gDefinedValues.Columns.OfType<DeleteField>().First());
gDefinedValues.Columns.Insert(insertPos, boundField );
}
}
var queryable = new DefinedValueService().Queryable().Where( a => a.DefinedTypeId == definedTypeId ).OrderBy( a => a.Order );
var result = queryable.ToList();
gDefinedValues.DataSource = result;
gDefinedValues.DataBind();
}
/// <summary>
/// Adds the filter controls and grid columns for all of the registration template's form fields
/// that were configured to 'Show on Grid'
/// </summary>
private void AddDynamicRegistrantControls()
{
phRegistrantFormFieldFilters.Controls.Clear();
// Remove any of the dynamic person fields
var dynamicColumns = new List<string> {
"PersonAlias.Person.BirthDate",
};
foreach ( var column in gRegistrants.Columns
.OfType<BoundField>()
.Where( c => dynamicColumns.Contains( c.DataField ) )
.ToList() )
{
gRegistrants.Columns.Remove( column );
}
// Remove any of the dynamic attribute fields
foreach ( var column in gRegistrants.Columns
.OfType<AttributeField>()
.ToList() )
{
gRegistrants.Columns.Remove( column );
}
// Remove the fees field
foreach ( var column in gRegistrants.Columns
.OfType<TemplateField>()
.Where( c => c.HeaderText == "Fees" )
.ToList() )
{
gRegistrants.Columns.Remove( column );
}
// Remove the delete field
foreach ( var column in gRegistrants.Columns
.OfType<DeleteField>()
.ToList() )
{
gRegistrants.Columns.Remove( column );
}
if ( RegistrantFields != null )
{
foreach ( var field in RegistrantFields )
{
if ( field.FieldSource == RegistrationFieldSource.PersonField && field.PersonFieldType.HasValue )
{
switch ( field.PersonFieldType.Value )
{
case RegistrationPersonFieldType.Campus:
{
var ddlCampus = new RockDropDownList();
ddlCampus.ID = "ddlCampus";
ddlCampus.Label = "Home Campus";
ddlCampus.DataValueField = "Id";
ddlCampus.DataTextField = "Name";
ddlCampus.DataSource = CampusCache.All();
ddlCampus.DataBind();
ddlCampus.Items.Insert( 0, new ListItem( "", "" ) );
ddlCampus.SetValue( fRegistrants.GetUserPreference( "Home Campus" ) );
phRegistrantFormFieldFilters.Controls.Add( ddlCampus );
var templateField = new TemplateField();
templateField.ItemTemplate = new LiteralFieldTemplate( "lCampus" );
templateField.HeaderText = "Campus";
gRegistrants.Columns.Add( templateField );
break;
}
case RegistrationPersonFieldType.Email:
{
var tbEmailFilter = new RockTextBox();
tbEmailFilter.ID = "tbEmailFilter";
tbEmailFilter.Label = "Email";
tbEmailFilter.Text = fRegistrants.GetUserPreference( "Email" );
phRegistrantFormFieldFilters.Controls.Add( tbEmailFilter );
string dataFieldExpression = "PersonAlias.Person.Email";
var emailField = new BoundField();
emailField.DataField = dataFieldExpression;
emailField.HeaderText = "Email";
emailField.SortExpression = dataFieldExpression;
gRegistrants.Columns.Add( emailField );
break;
}
case RegistrationPersonFieldType.Birthdate:
{
var drpBirthdateFilter = new DateRangePicker();
drpBirthdateFilter.ID = "drpBirthdateFilter";
drpBirthdateFilter.Label = "Birthdate Range";
drpBirthdateFilter.DelimitedValues = fRegistrants.GetUserPreference( "Birthdate Range" );
phRegistrantFormFieldFilters.Controls.Add( drpBirthdateFilter );
string dataFieldExpression = "PersonAlias.Person.BirthDate";
var birthdateField = new DateField();
birthdateField.DataField = dataFieldExpression;
birthdateField.HeaderText = "Birthdate";
birthdateField.SortExpression = dataFieldExpression;
gRegistrants.Columns.Add( birthdateField );
break;
}
case RegistrationPersonFieldType.Gender:
{
var ddlGenderFilter = new RockDropDownList();
ddlGenderFilter.BindToEnum<Gender>( true );
ddlGenderFilter.ID = "ddlGenderFilter";
ddlGenderFilter.Label = "Gender";
ddlGenderFilter.SetValue( fRegistrants.GetUserPreference( "Gender" ) );
phRegistrantFormFieldFilters.Controls.Add( ddlGenderFilter );
string dataFieldExpression = "PersonAlias.Person.Gender";
var genderField = new EnumField();
genderField.DataField = dataFieldExpression;
genderField.HeaderText = "Gender";
genderField.SortExpression = dataFieldExpression;
gRegistrants.Columns.Add( genderField );
break;
}
case RegistrationPersonFieldType.MaritalStatus:
{
var ddlMaritalStatusFilter = new RockDropDownList();
ddlMaritalStatusFilter.BindToDefinedType( DefinedTypeCache.Read( Rock.SystemGuid.DefinedType.PERSON_MARITAL_STATUS.AsGuid() ), true );
ddlMaritalStatusFilter.ID = "ddlMaritalStatusFilter";
ddlMaritalStatusFilter.Label = "Marital Status";
ddlMaritalStatusFilter.SetValue( fRegistrants.GetUserPreference( "Marital Status" ) );
phRegistrantFormFieldFilters.Controls.Add( ddlMaritalStatusFilter );
string dataFieldExpression = "PersonAlias.Person.MaritalStatusValue.Value";
var maritalStatusField = new BoundField();
maritalStatusField.DataField = dataFieldExpression;
maritalStatusField.HeaderText = "MaritalStatus";
maritalStatusField.SortExpression = dataFieldExpression;
gRegistrants.Columns.Add( maritalStatusField );
break;
}
case RegistrationPersonFieldType.MobilePhone:
{
var tbPhoneFilter = new RockTextBox();
tbPhoneFilter.ID = "tbPhoneFilter";
tbPhoneFilter.Label = "Phone";
tbPhoneFilter.Text = fRegistrants.GetUserPreference( "Phone" );
phRegistrantFormFieldFilters.Controls.Add( tbPhoneFilter );
var templateField = new TemplateField();
templateField.ItemTemplate = new LiteralFieldTemplate( "lPhone" );
templateField.HeaderText = "Phone(s)";
gRegistrants.Columns.Add( templateField );
break;
}
}
}
else if ( field.Attribute != null )
{
var attribute = field.Attribute;
var control = attribute.FieldType.Field.FilterControl( attribute.QualifierValues, "filter_" + attribute.Id.ToString(), false, Rock.Reporting.FilterMode.SimpleFilter );
if ( control != null )
{
if ( control is IRockControl )
{
var rockControl = (IRockControl)control;
rockControl.Label = attribute.Name;
rockControl.Help = attribute.Description;
phRegistrantFormFieldFilters.Controls.Add( control );
}
else
{
var wrapper = new RockControlWrapper();
wrapper.ID = control.ID + "_wrapper";
wrapper.Label = attribute.Name;
wrapper.Controls.Add( control );
phRegistrantFormFieldFilters.Controls.Add( wrapper );
}
string savedValue = fRegistrants.GetUserPreference( attribute.Key );
if ( !string.IsNullOrWhiteSpace( savedValue ) )
{
try
{
var values = JsonConvert.DeserializeObject<List<string>>( savedValue );
attribute.FieldType.Field.SetFilterValues( control, attribute.QualifierValues, values );
}
catch { }
}
}
string dataFieldExpression = attribute.Id.ToString() + attribute.Key;
bool columnExists = gRegistrants.Columns.OfType<AttributeField>().FirstOrDefault( a => a.DataField.Equals( dataFieldExpression ) ) != null;
if ( !columnExists )
{
AttributeField boundField = new AttributeField();
boundField.DataField = dataFieldExpression;
boundField.HeaderText = attribute.Name;
boundField.SortExpression = string.Empty;
var attributeCache = Rock.Web.Cache.AttributeCache.Read( attribute.Id );
if ( attributeCache != null )
{
boundField.ItemStyle.HorizontalAlign = attributeCache.FieldType.Field.AlignValue;
}
gRegistrants.Columns.Add( boundField );
}
}
}
}
// Add fee column
var feeField = new TemplateField();
feeField.HeaderText = "Fees";
feeField.ItemTemplate = new LiteralFieldTemplate( "lFees" );
gRegistrants.Columns.Add( feeField );
var deleteField = new DeleteField();
gRegistrants.Columns.Add( deleteField );
deleteField.Click += gRegistrants_Delete;
}
private void CreateGrids( RockContext rockContext )
{
if ( ContentChannels.Any() )
{
this.Visible = true;
// TODO: security
bool canEdit = true;
phContentChannelGrids.Controls.Clear();
foreach ( var contentChannel in ContentChannels )
{
var pwItems = new PanelWidget();
phContentChannelGrids.Controls.Add( pwItems );
pwItems.ID = string.Format( "pwItems_{0}", contentChannel.Id );
pwItems.Title = contentChannel.Name;
pwItems.Expanded = ExpandedPanels.Contains( contentChannel.Id );
var divItems = new HtmlGenericControl( "div" );
pwItems.Controls.Add( divItems );
divItems.ID = string.Format( "divItems_{0}", contentChannel.Id );
divItems.AddCssClass( "grid" );
divItems.AddCssClass( "grid-panel" );
Grid gItems = new Grid();
divItems.Controls.Add( gItems );
gItems.ID = string.Format( "gItems_{0}", contentChannel.Id );
gItems.DataKeyNames = new string[] { "Id" };
gItems.EmptyDataText = "No Items Found";
gItems.RowItemText = "Item";
gItems.AllowSorting = true;
gItems.Actions.ShowAdd = canEdit;
gItems.IsDeleteEnabled = canEdit;
gItems.Actions.AddClick += gItems_Add;
gItems.RowSelected += gItems_Edit;
gItems.GridRebind += gItems_GridRebind;
gItems.Columns.Add( new RockBoundField
{
DataField = "Title",
HeaderText = "Title",
SortExpression = "Title"
} );
gItems.Columns.Add( new DateTimeField
{
DataField = "StartDateTime",
HeaderText = contentChannel.ContentChannelType.DateRangeType == ContentChannelDateType.DateRange ? "Start" : "Active",
SortExpression = "StartDateTime"
} );
if ( contentChannel.ContentChannelType.DateRangeType == ContentChannelDateType.DateRange )
{
gItems.Columns.Add( new DateTimeField
{
DataField = "ExpireDateTime",
HeaderText = "Expire",
SortExpression = "ExpireDateTime"
} );
}
if ( !contentChannel.ContentChannelType.DisablePriority )
{
var priorityField = new RockBoundField
{
DataField = "Priority",
HeaderText = "Priority",
SortExpression = "Priority",
DataFormatString = "{0:N0}",
};
priorityField.ItemStyle.HorizontalAlign = HorizontalAlign.Right;
gItems.Columns.Add( priorityField );
}
// Add attribute columns
int entityTypeId = EntityTypeCache.Read( typeof( Rock.Model.ContentChannelItem ) ).Id;
string qualifier = contentChannel.ContentChannelTypeId.ToString();
foreach ( var attribute in new AttributeService( rockContext ).Queryable()
.Where( a =>
a.EntityTypeId == entityTypeId &&
a.IsGridColumn &&
a.EntityTypeQualifierColumn.Equals( "ContentChannelTypeId", StringComparison.OrdinalIgnoreCase ) &&
a.EntityTypeQualifierValue.Equals( qualifier ) )
.OrderBy( a => a.Order )
.ThenBy( a => a.Name ) )
{
string dataFieldExpression = attribute.Key;
bool columnExists = gItems.Columns.OfType<AttributeField>().FirstOrDefault( a => a.DataField.Equals( dataFieldExpression ) ) != null;
if ( !columnExists )
{
AttributeField boundField = new AttributeField();
boundField.DataField = dataFieldExpression;
boundField.HeaderText = attribute.Name;
boundField.SortExpression = string.Empty;
var attributeCache = Rock.Web.Cache.AttributeCache.Read( attribute.Id );
if ( attributeCache != null )
{
boundField.ItemStyle.HorizontalAlign = attributeCache.FieldType.Field.AlignValue;
}
gItems.Columns.Add( boundField );
}
}
if ( contentChannel.RequiresApproval )
{
var statusField = new BoundField();
gItems.Columns.Add( statusField );
statusField.DataField = "Status";
statusField.HeaderText = "Status";
statusField.SortExpression = "Status";
statusField.HtmlEncode = false;
}
var deleteField = new DeleteField();
gItems.Columns.Add( deleteField );
deleteField.Click += gItems_Delete;
}
}
else
{
this.Visible = false;
}
}
private void AddDynamicControls()
{
if ( AvailableAttributes != null )
{
foreach ( var attribute in AvailableAttributes )
{
var control = attribute.FieldType.Field.FilterControl( attribute.QualifierValues, "filter_" + attribute.Id.ToString(), false, Rock.Reporting.FilterMode.SimpleFilter );
if ( control != null )
{
if ( control is IRockControl )
{
var rockControl = (IRockControl)control;
rockControl.Label = attribute.Name;
rockControl.Help = attribute.Description;
phAttributeFilters.Controls.Add( control );
}
else
{
var wrapper = new RockControlWrapper();
wrapper.ID = control.ID + "_wrapper";
wrapper.Label = attribute.Name;
wrapper.Controls.Add( control );
phAttributeFilters.Controls.Add( wrapper );
}
string savedValue = rFilter.GetUserPreference( attribute.Key);
if ( !string.IsNullOrWhiteSpace( savedValue ) )
{
try
{
var values = JsonConvert.DeserializeObject<List<string>>( savedValue );
attribute.FieldType.Field.SetFilterValues( control, attribute.QualifierValues, values );
}
catch
{
// intentionally ignore
}
}
}
bool columnExists = gList.Columns.OfType<AttributeField>().FirstOrDefault( a => a.AttributeId == attribute.Id ) != null;
if ( !columnExists )
{
AttributeField boundField = new AttributeField();
boundField.DataField = attribute.Key;
boundField.AttributeId = attribute.Id;
boundField.HeaderText = attribute.Name;
var attributeCache = Rock.Web.Cache.AttributeCache.Read( attribute.Id );
if ( attributeCache != null )
{
boundField.ItemStyle.HorizontalAlign = attributeCache.FieldType.Field.AlignValue;
}
gList.Columns.Add( boundField );
}
}
}
// Add delete column
var deleteField = new DeleteField();
gList.Columns.Add( deleteField );
deleteField.Click += gList_Delete;
}
/// <summary>
/// Adds the attribute columns.
/// </summary>
private void AddDynamicControls()
{
// Clear the filter controls
phAttributeFilters.Controls.Clear();
// Remove attribute columns
foreach ( var column in gConnectionOpportunities.Columns.OfType<AttributeField>().ToList() )
{
gConnectionOpportunities.Columns.Remove( column );
}
if ( AvailableAttributes != null )
{
foreach ( var attribute in AvailableAttributes )
{
var control = attribute.FieldType.Field.FilterControl( attribute.QualifierValues, "filter_" + attribute.Id.ToString(), false, Rock.Reporting.FilterMode.SimpleFilter );
if ( control != null )
{
if ( control is IRockControl )
{
var rockControl = (IRockControl)control;
rockControl.Label = attribute.Name;
rockControl.Help = attribute.Description;
phAttributeFilters.Controls.Add( control );
}
else
{
var wrapper = new RockControlWrapper();
wrapper.ID = control.ID + "_wrapper";
wrapper.Label = attribute.Name;
wrapper.Controls.Add( control );
phAttributeFilters.Controls.Add( wrapper );
}
string savedValue = rFilter.GetUserPreference( MakeKeyUniqueToConnectionType( attribute.Key ) );
if ( !string.IsNullOrWhiteSpace( savedValue ) )
{
try
{
var values = JsonConvert.DeserializeObject<List<string>>( savedValue );
attribute.FieldType.Field.SetFilterValues( control, attribute.QualifierValues, values );
}
catch { }
}
}
string dataFieldExpression = attribute.Key;
bool columnExists = gConnectionOpportunities.Columns.OfType<AttributeField>().FirstOrDefault( a => a.DataField.Equals( dataFieldExpression ) ) != null;
if ( !columnExists )
{
AttributeField boundField = new AttributeField();
boundField.DataField = dataFieldExpression;
boundField.HeaderText = attribute.Name;
boundField.SortExpression = string.Empty;
var attributeCache = Rock.Web.Cache.AttributeCache.Read( attribute.Id );
if ( attributeCache != null )
{
boundField.ItemStyle.HorizontalAlign = attributeCache.FieldType.Field.AlignValue;
}
gConnectionOpportunities.Columns.Add( boundField );
}
}
}
}
/// <summary>
/// Builds the dynamic controls.
/// </summary>
private void BuildDynamicControls()
{
// Clear attribute filter controls and recreate
phFilterControls.Controls.Clear();
string ScheduleFilters = GetAttributeValue( "ScheduleFilters" );
if ( !string.IsNullOrEmpty( ScheduleFilters ) )
{
if ( ScheduleFilters.Contains( "Day" ) )
{
var control = FieldTypeCache.Read( Rock.SystemGuid.FieldType.DAY_OF_WEEK ).Field.FilterControl( null, "filter_dow", false );
AddFilterControl( control, "Day of Week", "The day of week that group meets on." );
}
if ( ScheduleFilters.Contains( "Time" ) )
{
var control = FieldTypeCache.Read( Rock.SystemGuid.FieldType.TIME ).Field.FilterControl( null, "filter_time", false );
AddFilterControl( control, "Time of Day", "The time of day that group meets." );
}
}
if ( AttributeFilters != null )
{
foreach ( var attribute in AttributeFilters )
{
var control = attribute.FieldType.Field.FilterControl( attribute.QualifierValues, "filter_" + attribute.Id.ToString(), false );
AddFilterControl( control, attribute.Name, attribute.Description );
}
}
// Build attribute columns
foreach ( var column in gGroups.Columns.OfType<AttributeField>().ToList() )
{
gGroups.Columns.Remove( column );
}
if ( AttributeColumns != null )
{
foreach ( var attribute in AttributeColumns )
{
string dataFieldExpression = attribute.Key;
bool columnExists = gGroups.Columns.OfType<AttributeField>().FirstOrDefault( a => a.DataField.Equals( dataFieldExpression ) ) != null;
if ( !columnExists )
{
AttributeField boundField = new AttributeField();
boundField.DataField = dataFieldExpression;
boundField.HeaderText = attribute.Name;
boundField.SortExpression = string.Empty;
var attributeCache = AttributeCache.Read( attribute.Id );
if ( attributeCache != null )
{
boundField.ItemStyle.HorizontalAlign = attributeCache.FieldType.Field.AlignValue;
}
gGroups.Columns.Add( boundField );
}
}
}
// Add Register Column
foreach ( var column in gGroups.Columns.OfType<EditField>().ToList() )
{
gGroups.Columns.Remove( column );
}
var registerPage = new PageReference( GetAttributeValue( "RegisterPage" ) );
if ( registerPage.PageId > 0 )
{
var registerColumn = new EditField();
registerColumn.HeaderText = "Register";
registerColumn.Click += registerColumn_Click;
gGroups.Columns.Add( registerColumn );
}
}
/// <summary>
/// Binds the group members grid.
/// </summary>
protected void BindGroupMembersGrid()
{
if ( _group != null )
{
pnlGroupMembers.Visible = true;
using ( new UnitOfWorkScope() )
{
lHeading.Text = string.Format( "{0} {1}", _group.GroupType.GroupTerm, _group.GroupType.GroupMemberTerm.Pluralize() );
if ( _group.GroupType.Roles.Any() )
{
nbRoleWarning.Visible = false;
rFilter.Visible = true;
gGroupMembers.Visible = true;
// Remove attribute columns
foreach ( var column in gGroupMembers.Columns.OfType<AttributeField>().ToList() )
{
gGroupMembers.Columns.Remove( column );
}
// Add attribute columns
int entityTypeId = new GroupMember().TypeId;
string groupQualifier = _group.Id.ToString();
string groupTypeQualifier = _group.GroupTypeId.ToString();
foreach ( var attribute in new AttributeService().Queryable()
.Where( a =>
a.EntityTypeId == entityTypeId &&
a.IsGridColumn &&
( a.EntityTypeQualifierColumn.Equals( "GroupId", StringComparison.OrdinalIgnoreCase ) && a.EntityTypeQualifierValue.Equals( groupQualifier ) ||
a.EntityTypeQualifierColumn.Equals( "GroupTypeId", StringComparison.OrdinalIgnoreCase ) && a.EntityTypeQualifierValue.Equals( groupTypeQualifier ) )
)
.OrderBy( a => a.Order )
.ThenBy( a => a.Name ) )
{
string dataFieldExpression = attribute.Key;
bool columnExists = gGroupMembers.Columns.OfType<AttributeField>().FirstOrDefault( a => a.DataField.Equals( dataFieldExpression ) ) != null;
if ( !columnExists )
{
AttributeField boundField = new AttributeField();
boundField.DataField = dataFieldExpression;
boundField.HeaderText = attribute.Name;
boundField.SortExpression = string.Empty;
int insertPos = gGroupMembers.Columns.IndexOf( gGroupMembers.Columns.OfType<DeleteField>().First() );
gGroupMembers.Columns.Insert( insertPos, boundField );
}
}
GroupMemberService groupMemberService = new GroupMemberService();
var qry = groupMemberService.Queryable( "Person,GroupRole" )
.Where( m => m.GroupId == _group.Id );
// Filter by First Name
string firstName = rFilter.GetUserPreference( "First Name" );
if ( !string.IsNullOrWhiteSpace( firstName ) )
{
qry = qry.Where( m => m.Person.FirstName.StartsWith( firstName ) );
}
// Filter by Last Name
string lastName = rFilter.GetUserPreference( "Last Name" );
if ( !string.IsNullOrWhiteSpace( lastName ) )
{
qry = qry.Where( m => m.Person.LastName.StartsWith( lastName ) );
}
// Filter by role
var roles = new List<int>();
foreach ( string role in rFilter.GetUserPreference( "Role" ).Split( ';' ) )
{
if ( !string.IsNullOrWhiteSpace( role ) )
{
int roleId = int.MinValue;
if ( int.TryParse( role, out roleId ) )
{
roles.Add( roleId );
}
}
}
if ( roles.Any() )
{
qry = qry.Where( m => roles.Contains( m.GroupRoleId ) );
}
// Filter by Sttus
var statuses = new List<GroupMemberStatus>();
foreach ( string status in rFilter.GetUserPreference( "Status" ).Split( ';' ) )
{
if ( !string.IsNullOrWhiteSpace( status ) )
{
statuses.Add( status.ConvertToEnum<GroupMemberStatus>() );
}
}
if ( statuses.Any() )
{
qry = qry.Where( m => statuses.Contains( m.GroupMemberStatus ) );
}
SortProperty sortProperty = gGroupMembers.SortProperty;
if ( sortProperty != null )
{
gGroupMembers.DataSource = qry.Sort( sortProperty ).ToList();
}
else
{
gGroupMembers.DataSource = qry.OrderBy( a => a.Person.LastName ).ThenBy( a => a.Person.FirstName ).ToList();
}
gGroupMembers.DataBind();
}
else
{
nbRoleWarning.Text = string.Format( "{0} cannot be added to this {1} because the '{2}' group type does not have any roles defined.",
_group.GroupType.GroupMemberTerm.Pluralize(), _group.GroupType.GroupTerm, _group.GroupType.Name );
nbRoleWarning.Visible = true;
rFilter.Visible = false;
gGroupMembers.Visible = false;
}
}
}
else
{
pnlGroupMembers.Visible = false;
}
}
/// <summary>
/// Binds the defined values grid.
/// </summary>
protected void AddAttributeColumns()
{
// Remove attribute columns
foreach ( var column in gWorkflows.Columns.OfType<AttributeField>().ToList() )
{
gWorkflows.Columns.Remove( column );
}
if ( _workflowType != null )
{
// Add attribute columns
int entityTypeId = new Workflow().TypeId;
string qualifier = _workflowType.Id.ToString();
foreach ( var attribute in new AttributeService( new RockContext() ).Queryable()
.Where( a =>
a.EntityTypeId == entityTypeId &&
a.IsGridColumn &&
a.EntityTypeQualifierColumn.Equals( "WorkflowTypeId", StringComparison.OrdinalIgnoreCase ) &&
a.EntityTypeQualifierValue.Equals( qualifier ) )
.OrderBy( a => a.Order )
.ThenBy( a => a.Name ) )
{
string dataFieldExpression = attribute.Key;
bool columnExists = gWorkflows.Columns.OfType<AttributeField>().FirstOrDefault( a => a.DataField.Equals( dataFieldExpression ) ) != null;
if ( !columnExists )
{
AttributeField boundField = new AttributeField();
boundField.DataField = dataFieldExpression;
boundField.HeaderText = attribute.Name;
boundField.SortExpression = string.Empty;
var attributeCache = Rock.Web.Cache.AttributeCache.Read( attribute.Id );
if ( attributeCache != null )
{
boundField.ItemStyle.HorizontalAlign = attributeCache.FieldType.Field.AlignValue;
}
gWorkflows.Columns.Add( boundField );
}
}
}
}
/// <summary>
/// Adds the attribute columns.
/// </summary>
private void AddDynamicControls()
{
// Clear the filter controls
phAttributeFilters.Controls.Clear();
// Remove attribute columns
foreach ( var column in gEventCalendarItems.Columns.OfType<AttributeField>().ToList() )
{
gEventCalendarItems.Columns.Remove( column );
}
// Remove status columns
foreach ( var column in gEventCalendarItems.Columns.OfType<BoundField>()
.Where( c =>
c.DataField == "Instances" ||
c.DataField == "Status" ||
c.DataField == "ApprovalStatus" )
.ToList() )
{
gEventCalendarItems.Columns.Remove( column );
}
// Remove Delete column
foreach ( var column in gEventCalendarItems.Columns.OfType<DeleteField>().ToList() )
{
gEventCalendarItems.Columns.Remove( column );
}
if ( AvailableAttributes != null )
{
foreach ( var attribute in AvailableAttributes )
{
var control = attribute.FieldType.Field.FilterControl( attribute.QualifierValues, "filter_" + attribute.Id.ToString(), false, Rock.Reporting.FilterMode.SimpleFilter );
if ( control != null )
{
if ( control is IRockControl )
{
var rockControl = (IRockControl)control;
rockControl.Label = attribute.Name;
rockControl.Help = attribute.Description;
phAttributeFilters.Controls.Add( control );
}
else
{
var wrapper = new RockControlWrapper();
wrapper.ID = control.ID + "_wrapper";
wrapper.Label = attribute.Name;
wrapper.Controls.Add( control );
phAttributeFilters.Controls.Add( wrapper );
}
string savedValue = rFilter.GetUserPreference( MakeKeyUniqueToEventCalendar( attribute.Key ) );
if ( !string.IsNullOrWhiteSpace( savedValue ) )
{
try
{
var values = JsonConvert.DeserializeObject<List<string>>( savedValue );
attribute.FieldType.Field.SetFilterValues( control, attribute.QualifierValues, values );
}
catch { }
}
}
string dataFieldExpression = attribute.Key;
bool columnExists = gEventCalendarItems.Columns.OfType<AttributeField>().FirstOrDefault( a => a.DataField.Equals( dataFieldExpression ) ) != null;
if ( !columnExists )
{
AttributeField boundField = new AttributeField();
boundField.DataField = dataFieldExpression;
boundField.HeaderText = attribute.Name;
boundField.SortExpression = string.Empty;
var attributeCache = Rock.Web.Cache.AttributeCache.Read( attribute.Id );
if ( attributeCache != null )
{
boundField.ItemStyle.HorizontalAlign = attributeCache.FieldType.Field.AlignValue;
}
gEventCalendarItems.Columns.Add( boundField );
}
}
}
// Add occurrences Count column
var occurrencesField = new BadgeField();
occurrencesField.ImportantMin = int.MaxValue;
occurrencesField.WarningMin = 0;
occurrencesField.WarningMax = 0;
occurrencesField.InfoMin = 1;
occurrencesField.InfoMax = int.MaxValue;
occurrencesField.DataField = "Occurrences";
occurrencesField.HeaderText = "Occurrences";
occurrencesField.HtmlEncode = false;
gEventCalendarItems.Columns.Add( occurrencesField );
// Add Status column
var statusField = new BoundField();
statusField.DataField = "Status";
statusField.SortExpression = "EventItem.IsActive";
statusField.HeaderText = "Status";
statusField.HtmlEncode = false;
gEventCalendarItems.Columns.Add( statusField );
// Add Approval Status column
var approvalStatusField = new BoundField();
approvalStatusField.DataField = "ApprovalStatus";
approvalStatusField.SortExpression = "EventItem.IsApproved";
approvalStatusField.HeaderText = "Approval Status";
approvalStatusField.HtmlEncode = false;
gEventCalendarItems.Columns.Add( approvalStatusField );
// Add delete column
if ( _canEdit )
{
var deleteField = new DeleteField();
gEventCalendarItems.Columns.Add( deleteField );
deleteField.Click += DeleteEventCalendarItem_Click;
}
}
/// <summary>
/// Builds the dynamic controls.
/// </summary>
private void BuildDynamicControls()
{
// Clear attribute filter controls and recreate
phFilterControls.Controls.Clear();
string ScheduleFilters = GetAttributeValue( "ScheduleFilters" );
if ( !string.IsNullOrEmpty( ScheduleFilters ) )
{
if ( ScheduleFilters.Contains( "Day" ) )
{
var control = FieldTypeCache.Read( Rock.SystemGuid.FieldType.DAY_OF_WEEK ).Field.FilterControl( null, "filter_dow", false, Rock.Reporting.FilterMode.SimpleFilter );
AddFilterControl( control, "Day of Week", "The day of week that group meets on." );
}
if ( ScheduleFilters.Contains( "Time" ) )
{
var control = FieldTypeCache.Read( Rock.SystemGuid.FieldType.TIME ).Field.FilterControl( null, "filter_time", false, Rock.Reporting.FilterMode.SimpleFilter );
AddFilterControl( control, "Time of Day", "The time of day that group meets." );
}
}
if ( AttributeFilters != null )
{
foreach ( var attribute in AttributeFilters )
{
var control = attribute.FieldType.Field.FilterControl( attribute.QualifierValues, "filter_" + attribute.Id.ToString(), false, Rock.Reporting.FilterMode.SimpleFilter );
if ( control != null )
{
AddFilterControl( control, attribute.Name, attribute.Description );
}
}
}
// Build attribute columns
foreach ( var column in gGroups.Columns.OfType<AttributeField>().ToList() )
{
gGroups.Columns.Remove( column );
}
if ( AttributeColumns != null )
{
foreach ( var attribute in AttributeColumns )
{
string dataFieldExpression = attribute.Key;
bool columnExists = gGroups.Columns.OfType<AttributeField>().FirstOrDefault( a => a.DataField.Equals( dataFieldExpression ) ) != null;
if ( !columnExists )
{
AttributeField boundField = new AttributeField();
boundField.DataField = dataFieldExpression;
boundField.AttributeId = attribute.Id;
boundField.HeaderText = attribute.Name;
var attributeCache = AttributeCache.Read( attribute.Id );
if ( attributeCache != null )
{
boundField.ItemStyle.HorizontalAlign = attributeCache.FieldType.Field.AlignValue;
}
gGroups.Columns.Add( boundField );
}
}
}
// Add Register Column
foreach ( var column in gGroups.Columns.OfType<EditField>().ToList() )
{
gGroups.Columns.Remove( column );
}
var registerPage = new PageReference( GetAttributeValue( "RegisterPage" ) );
if ( _targetPersonGuid != Guid.Empty )
{
registerPage.Parameters = _urlParms;
}
if ( registerPage.PageId > 0 )
{
var registerColumn = new EditField();
registerColumn.HeaderText = "Register";
registerColumn.Click += registerColumn_Click;
gGroups.Columns.Add( registerColumn );
}
var pageSizes = new List<int>();
if ( !String.IsNullOrWhiteSpace( GetAttributeValue( "PageSizes" ) ) )
{
pageSizes = GetAttributeValue( "PageSizes" ).Split( ',' ).AsIntegerList();
}
ddlPageSize.Items.Clear();
ddlPageSize.Items.AddRange( pageSizes.Select( a => new ListItem( a.ToString(), a.ToString() ) ).ToArray() );
ddlPageSize.Items.Add( new ListItem( "All", "0" ) );
if ( pageSizes.Any() )
{
// set default PageSize to whatever is first in the PageSize setting
ddlPageSize.Visible = true;
ddlPageSize.SelectedValue = pageSizes[0].ToString();
}
else
{
ddlPageSize.Visible = false;
}
// if the SortByDistance is enabled, prevent them from sorting by ColumnClick
if ( GetAttributeValue( "SortByDistance" ).AsBoolean() )
{
gGroups.AllowSorting = false;
}
}
/// <summary>
/// Binds the grid.
/// </summary>
private void BindGrid()
{
WorkflowService workflowService = new WorkflowService();
SortProperty sortProperty = gWorkflows.SortProperty;
var qry = workflowService.Queryable();
WorkflowType workflowType = this.ContextEntity<WorkflowType>();
if ( workflowType == null )
{
pnlWorkflowList.Visible = false;
return;
}
// if this isn't currently a persisted workflow type, and there are no records, hide the panel
if ( !workflowType.IsPersisted )
{
if ( qry.Count() == 0 )
{
pnlWorkflowList.Visible = false;
return;
}
}
if (!string.IsNullOrWhiteSpace(workflowType.WorkTerm))
{
gWorkflows.RowItemText = workflowType.WorkTerm;
lGridTitle.Text = workflowType.WorkTerm.Pluralize();
}
AttributeService attributeService = new AttributeService();
// add attributes with IsGridColumn to grid
string qualifierValue = workflowType.Id.ToString();
var qryWorkflowTypeAttributes = attributeService.GetByEntityTypeId( new Workflow().TypeId ).AsQueryable()
.Where( a => a.EntityTypeQualifierColumn.Equals( "WorkflowTypeId", StringComparison.OrdinalIgnoreCase )
&& a.EntityTypeQualifierValue.Equals( qualifierValue ) );
qryWorkflowTypeAttributes = qryWorkflowTypeAttributes.Where( a => a.IsGridColumn );
List<Attribute> gridItems = qryWorkflowTypeAttributes.ToList();
foreach ( var item in gWorkflows.Columns.OfType<AttributeField>().ToList() )
{
gWorkflows.Columns.Remove( item );
}
foreach ( var item in gridItems.OrderBy( a => a.Order ).ThenBy( a => a.Name ) )
{
string dataFieldExpression = item.Key;
bool columnExists = gWorkflows.Columns.OfType<AttributeField>().FirstOrDefault( a => a.DataField.Equals( dataFieldExpression ) ) != null;
if ( !columnExists )
{
AttributeField boundField = new AttributeField();
boundField.DataField = dataFieldExpression;
boundField.HeaderText = item.Name;
boundField.SortExpression = string.Empty;
int insertPos = gWorkflows.Columns.IndexOf( gWorkflows.Columns.OfType<DeleteField>().First() );
gWorkflows.Columns.Insert( insertPos, boundField );
}
}
pnlWorkflowList.Visible = true;
qry = qry.Where( a => a.WorkflowTypeId.Equals( workflowType.Id ) );
if ( sortProperty != null )
{
gWorkflows.DataSource = qry.Sort( sortProperty ).ToList();
}
else
{
gWorkflows.DataSource = qry.OrderBy( s => s.Name ).ToList();
}
gWorkflows.DataBind();
}
/// <summary>
/// Adds the attribute columns.
/// </summary>
private void AddDynamicControls()
{
// Clear the filter controls
phAttributeFilters.Controls.Clear();
// Remove attribute columns
foreach ( var column in gWorkflows.Columns.OfType<AttributeField>().ToList() )
{
gWorkflows.Columns.Remove( column );
}
if ( AvailableAttributes != null )
{
foreach ( var attribute in AvailableAttributes )
{
var control = attribute.FieldType.Field.FilterControl( attribute.QualifierValues, "filter_" + attribute.Id.ToString(), false, Rock.Reporting.FilterMode.SimpleFilter );
if ( control is IRockControl )
{
var rockControl = (IRockControl)control;
rockControl.Label = attribute.Name;
rockControl.Help = attribute.Description;
phAttributeFilters.Controls.Add( control );
}
else
{
var wrapper = new RockControlWrapper();
wrapper.ID = control.ID + "_wrapper";
wrapper.Label = attribute.Name;
wrapper.Controls.Add( control );
phAttributeFilters.Controls.Add( wrapper );
}
string savedValue = gfWorkflows.GetUserPreference( MakeKeyUniqueToType( attribute.Key ) );
if ( !string.IsNullOrWhiteSpace( savedValue ) )
{
try
{
var values = JsonConvert.DeserializeObject<List<string>>( savedValue );
attribute.FieldType.Field.SetFilterValues( control, attribute.QualifierValues, values );
}
catch { }
}
string dataFieldExpression = attribute.Key;
bool columnExists = gWorkflows.Columns.OfType<AttributeField>().FirstOrDefault( a => a.DataField.Equals( dataFieldExpression ) ) != null;
if ( !columnExists )
{
AttributeField boundField = new AttributeField();
boundField.DataField = dataFieldExpression;
boundField.HeaderText = attribute.Name;
boundField.SortExpression = string.Empty;
boundField.Condensed = false;
var attributeCache = Rock.Web.Cache.AttributeCache.Read( attribute.Id );
if ( attributeCache != null )
{
boundField.ItemStyle.HorizontalAlign = attributeCache.FieldType.Field.AlignValue;
}
gWorkflows.Columns.Add( boundField );
}
}
}
var dateField = new DateTimeField();
gWorkflows.Columns.Add( dateField );
dateField.DataField = "CreatedDateTime";
dateField.SortExpression = "CreatedDateTime";
dateField.HeaderText = "Created";
dateField.FormatAsElapsedTime = true;
var statusField = new BoundField();
gWorkflows.Columns.Add( statusField );
statusField.DataField = "Status";
statusField.SortExpression = "Status";
statusField.HeaderText = "Status";
statusField.DataFormatString = "<span class='label label-info'>{0}</span>";
statusField.HtmlEncode = false;
var stateField = new CallbackField();
gWorkflows.Columns.Add( stateField );
stateField.DataField = "IsCompleted";
stateField.SortExpression = "CompletedDateTime";
stateField.HeaderText = "State";
stateField.HtmlEncode = false;
stateField.OnFormatDataValue += ( sender, e ) =>
{
if ( (bool)e.DataValue )
{
e.FormattedValue = "<span class='label label-default'>Completed</span>";
}
else
{
e.FormattedValue = "<span class='label label-success'>Active</span>";
}
};
if ( _canView )
{
var manageField = new LinkButtonField();
gWorkflows.Columns.Add( manageField );
manageField.CssClass = "btn btn-default btn-sm fa fa-file-text-o";
manageField.Click += gWorkflows_Manage;
}
if ( _canEdit )
{
var deleteField = new DeleteField();
gWorkflows.Columns.Add( deleteField );
deleteField.Click += gWorkflows_Delete;
}
}
/// <summary>
/// Adds the filter controls and grid columns for all of the registration template's form fields
/// that were configured to 'Show on Grid'
/// </summary>
private void AddDynamicControls()
{
phRegistrantFormFieldFilters.Controls.Clear();
phWaitListFormFieldFilters.Controls.Clear();
ClearGrid( gGroupPlacements );
ClearGrid( gRegistrants );
ClearGrid( gWaitList );
if ( RegistrantFields != null )
{
foreach ( var field in RegistrantFields )
{
if ( field.FieldSource == RegistrationFieldSource.PersonField && field.PersonFieldType.HasValue )
{
switch ( field.PersonFieldType.Value )
{
case RegistrationPersonFieldType.Campus:
{
var ddlCampus = new RockDropDownList();
ddlCampus.ID = "ddlCampus";
ddlCampus.Label = "Home Campus";
ddlCampus.DataValueField = "Id";
ddlCampus.DataTextField = "Name";
ddlCampus.DataSource = CampusCache.All();
ddlCampus.DataBind();
ddlCampus.Items.Insert( 0, new ListItem( "", "" ) );
ddlCampus.SetValue( fRegistrants.GetUserPreference( "Home Campus" ) );
phRegistrantFormFieldFilters.Controls.Add( ddlCampus );
var ddlCampus2 = new RockDropDownList();
ddlCampus2.ID = "ddlCampus";
ddlCampus2.Label = "Home Campus";
ddlCampus2.DataValueField = "Id";
ddlCampus2.DataTextField = "Name";
ddlCampus2.DataSource = CampusCache.All();
ddlCampus2.DataBind();
ddlCampus2.Items.Insert( 0, new ListItem( "", "" ) );
ddlCampus2.SetValue( fRegistrants.GetUserPreference( "WL-Home Campus" ) );
phWaitListFormFieldFilters.Controls.Add( ddlCampus2 );
var templateField = new RockLiteralField();
templateField.ID = "lCampus";
templateField.HeaderText = "Campus";
gRegistrants.Columns.Add( templateField );
var templateField2 = new RockLiteralField();
templateField2.ID = "lCampus";
templateField2.HeaderText = "Campus";
gGroupPlacements.Columns.Add( templateField2 );
var templateField3 = new RockLiteralField();
templateField3.ID = "lCampus";
templateField3.HeaderText = "Campus";
gWaitList.Columns.Add( templateField3 );
break;
}
case RegistrationPersonFieldType.Email:
{
var tbEmailFilter = new RockTextBox();
tbEmailFilter.ID = "tbEmailFilter";
tbEmailFilter.Label = "Email";
tbEmailFilter.Text = fRegistrants.GetUserPreference( "Email" );
phRegistrantFormFieldFilters.Controls.Add( tbEmailFilter );
var tbEmailFilter2 = new RockTextBox();
tbEmailFilter2.ID = "tbEmailFilter";
tbEmailFilter2.Label = "Email";
tbEmailFilter2.Text = fRegistrants.GetUserPreference( "WL-Email" );
phWaitListFormFieldFilters.Controls.Add( tbEmailFilter2 );
string dataFieldExpression = "PersonAlias.Person.Email";
var emailField = new RockBoundField();
emailField.DataField = dataFieldExpression;
emailField.HeaderText = "Email";
emailField.SortExpression = dataFieldExpression;
gRegistrants.Columns.Add( emailField );
var emailField2 = new RockBoundField();
emailField2.DataField = dataFieldExpression;
emailField2.HeaderText = "Email";
emailField2.SortExpression = dataFieldExpression;
gGroupPlacements.Columns.Add( emailField2 );
var emailField3 = new RockBoundField();
emailField3.DataField = dataFieldExpression;
emailField3.HeaderText = "Email";
emailField3.SortExpression = dataFieldExpression;
gWaitList.Columns.Add( emailField3 );
break;
}
case RegistrationPersonFieldType.Birthdate:
{
var drpBirthdateFilter = new DateRangePicker();
drpBirthdateFilter.ID = "drpBirthdateFilter";
drpBirthdateFilter.Label = "Birthdate Range";
drpBirthdateFilter.DelimitedValues = fRegistrants.GetUserPreference( "Birthdate Range" );
phRegistrantFormFieldFilters.Controls.Add( drpBirthdateFilter );
var drpBirthdateFilter2 = new DateRangePicker();
drpBirthdateFilter2.ID = "drpBirthdateFilter";
drpBirthdateFilter2.Label = "Birthdate Range";
drpBirthdateFilter2.DelimitedValues = fRegistrants.GetUserPreference( "WL-Birthdate Range" );
phWaitListFormFieldFilters.Controls.Add( drpBirthdateFilter2 );
string dataFieldExpression = "PersonAlias.Person.BirthDate";
var birthdateField = new DateField();
birthdateField.DataField = dataFieldExpression;
birthdateField.HeaderText = "Birthdate";
birthdateField.SortExpression = dataFieldExpression;
gRegistrants.Columns.Add( birthdateField );
var birthdateField2 = new DateField();
birthdateField2.DataField = dataFieldExpression;
birthdateField2.HeaderText = "Birthdate";
birthdateField2.SortExpression = dataFieldExpression;
gGroupPlacements.Columns.Add( birthdateField2 );
var birthdateField3 = new DateField();
birthdateField3.DataField = dataFieldExpression;
birthdateField3.HeaderText = "Birthdate";
birthdateField3.SortExpression = dataFieldExpression;
gWaitList.Columns.Add( birthdateField3 );
break;
}
case RegistrationPersonFieldType.Grade:
{
var gpGradeFilter = new GradePicker();
gpGradeFilter.ID = "gpGradeFilter";
gpGradeFilter.Label = "Grade";
gpGradeFilter.UseAbbreviation = true;
gpGradeFilter.UseGradeOffsetAsValue = true;
gpGradeFilter.CssClass = "input-width-md";
gpGradeFilter.SetValue( fRegistrants.GetUserPreference( "Grade" ).AsIntegerOrNull() );
phRegistrantFormFieldFilters.Controls.Add( gpGradeFilter );
var gpGradeFilter2 = new GradePicker();
gpGradeFilter2.ID = "gpGradeFilter";
gpGradeFilter2.Label = "Grade";
gpGradeFilter2.UseAbbreviation = true;
gpGradeFilter2.UseGradeOffsetAsValue = true;
gpGradeFilter2.CssClass = "input-width-md";
gpGradeFilter2.SetValue( fRegistrants.GetUserPreference( "WL-Grade" ).AsIntegerOrNull() );
phWaitListFormFieldFilters.Controls.Add( gpGradeFilter2 );
string dataFieldExpression = "PersonAlias.Person.GraduationYear";
var gradeField = new RockBoundField();
gradeField.DataField = dataFieldExpression;
gradeField.HeaderText = "Graduation Year";
gradeField.SortExpression = dataFieldExpression;
gRegistrants.Columns.Add( gradeField );
var gradeField2 = new RockBoundField();
gradeField2.DataField = dataFieldExpression;
gradeField2.HeaderText = "Graduation Year";
gradeField2.SortExpression = dataFieldExpression;
gGroupPlacements.Columns.Add( gradeField2 );
var gradeField3 = new RockBoundField();
gradeField3.DataField = dataFieldExpression;
gradeField3.HeaderText = "Graduation Year";
gradeField3.SortExpression = dataFieldExpression;
gWaitList.Columns.Add( gradeField3 );
break;
}
case RegistrationPersonFieldType.Gender:
{
var ddlGenderFilter = new RockDropDownList();
ddlGenderFilter.BindToEnum<Gender>( true );
ddlGenderFilter.ID = "ddlGenderFilter";
ddlGenderFilter.Label = "Gender";
ddlGenderFilter.SetValue( fRegistrants.GetUserPreference( "Gender" ) );
phRegistrantFormFieldFilters.Controls.Add( ddlGenderFilter );
var ddlGenderFilter2 = new RockDropDownList();
ddlGenderFilter2.BindToEnum<Gender>( true );
ddlGenderFilter2.ID = "ddlGenderFilter";
ddlGenderFilter2.Label = "Gender";
ddlGenderFilter2.SetValue( fRegistrants.GetUserPreference( "WL-Gender" ) );
phWaitListFormFieldFilters.Controls.Add( ddlGenderFilter2 );
string dataFieldExpression = "PersonAlias.Person.Gender";
var genderField = new EnumField();
genderField.DataField = dataFieldExpression;
genderField.HeaderText = "Gender";
genderField.SortExpression = dataFieldExpression;
gRegistrants.Columns.Add( genderField );
var genderField2 = new EnumField();
genderField2.DataField = dataFieldExpression;
genderField2.HeaderText = "Gender";
genderField2.SortExpression = dataFieldExpression;
gGroupPlacements.Columns.Add( genderField2 );
var genderField3 = new EnumField();
genderField3.DataField = dataFieldExpression;
genderField3.HeaderText = "Gender";
genderField3.SortExpression = dataFieldExpression;
gWaitList.Columns.Add( genderField3 );
break;
}
case RegistrationPersonFieldType.MaritalStatus:
{
var ddlMaritalStatusFilter = new RockDropDownList();
ddlMaritalStatusFilter.BindToDefinedType( DefinedTypeCache.Read( Rock.SystemGuid.DefinedType.PERSON_MARITAL_STATUS.AsGuid() ), true );
ddlMaritalStatusFilter.ID = "ddlMaritalStatusFilter";
ddlMaritalStatusFilter.Label = "Marital Status";
ddlMaritalStatusFilter.SetValue( fRegistrants.GetUserPreference( "Marital Status" ) );
phRegistrantFormFieldFilters.Controls.Add( ddlMaritalStatusFilter );
var ddlMaritalStatusFilter2 = new RockDropDownList();
ddlMaritalStatusFilter2.BindToDefinedType( DefinedTypeCache.Read( Rock.SystemGuid.DefinedType.PERSON_MARITAL_STATUS.AsGuid() ), true );
ddlMaritalStatusFilter2.ID = "ddlMaritalStatusFilter";
ddlMaritalStatusFilter2.Label = "Marital Status";
ddlMaritalStatusFilter2.SetValue( fRegistrants.GetUserPreference( "WL-Marital Status" ) );
phWaitListFormFieldFilters.Controls.Add( ddlMaritalStatusFilter2 );
string dataFieldExpression = "PersonAlias.Person.MaritalStatusValue.Value";
var maritalStatusField = new RockBoundField();
maritalStatusField.DataField = dataFieldExpression;
maritalStatusField.HeaderText = "MaritalStatus";
maritalStatusField.SortExpression = dataFieldExpression;
gRegistrants.Columns.Add( maritalStatusField );
var maritalStatusField2 = new RockBoundField();
maritalStatusField2.DataField = dataFieldExpression;
maritalStatusField2.HeaderText = "MaritalStatus";
maritalStatusField2.SortExpression = dataFieldExpression;
gGroupPlacements.Columns.Add( maritalStatusField2 );
var maritalStatusField3 = new RockBoundField();
maritalStatusField3.DataField = dataFieldExpression;
maritalStatusField3.HeaderText = "MaritalStatus";
maritalStatusField3.SortExpression = dataFieldExpression;
gWaitList.Columns.Add( maritalStatusField3 );
break;
}
case RegistrationPersonFieldType.MobilePhone:
{
var tbPhoneFilter = new RockTextBox();
tbPhoneFilter.ID = "tbPhoneFilter";
tbPhoneFilter.Label = "Phone";
tbPhoneFilter.Text = fRegistrants.GetUserPreference( "Phone" );
phRegistrantFormFieldFilters.Controls.Add( tbPhoneFilter );
var tbPhoneFilter2 = new RockTextBox();
tbPhoneFilter2.ID = "tbPhoneFilter";
tbPhoneFilter2.Label = "Phone";
tbPhoneFilter2.Text = fRegistrants.GetUserPreference( "WL-Phone" );
phWaitListFormFieldFilters.Controls.Add( tbPhoneFilter2 );
var phoneNumbersField = new PhoneNumbersField();
phoneNumbersField.DataField = "PersonAlias.Person.PhoneNumbers";
phoneNumbersField.HeaderText = "Phone(s)";
gRegistrants.Columns.Add( phoneNumbersField );
var phoneNumbersField2 = new PhoneNumbersField();
phoneNumbersField2.DataField = "PersonAlias.Person.PhoneNumbers";
phoneNumbersField2.HeaderText = "Phone(s)";
gGroupPlacements.Columns.Add( phoneNumbersField2 );
var phoneNumbersField3 = new PhoneNumbersField();
phoneNumbersField3.DataField = "PersonAlias.Person.PhoneNumbers";
phoneNumbersField3.HeaderText = "Phone(s)";
gWaitList.Columns.Add( phoneNumbersField3 );
break;
}
}
}
else if ( field.Attribute != null )
{
var attribute = field.Attribute;
// add dynamic filter to registrant grid
var control = attribute.FieldType.Field.FilterControl( attribute.QualifierValues, "filter_" + attribute.Id.ToString(), false, Rock.Reporting.FilterMode.SimpleFilter );
if ( control != null )
{
if ( control is IRockControl )
{
var rockControl = (IRockControl)control;
rockControl.Label = attribute.Name;
rockControl.Help = attribute.Description;
phRegistrantFormFieldFilters.Controls.Add( control );
}
else
{
var wrapper = new RockControlWrapper();
wrapper.ID = control.ID + "_wrapper";
wrapper.Label = attribute.Name;
wrapper.Controls.Add( control );
phRegistrantFormFieldFilters.Controls.Add( wrapper );
}
string savedValue = fRegistrants.GetUserPreference( attribute.Key );
if ( !string.IsNullOrWhiteSpace( savedValue ) )
{
try
{
var values = JsonConvert.DeserializeObject<List<string>>( savedValue );
attribute.FieldType.Field.SetFilterValues( control, attribute.QualifierValues, values );
}
catch { }
}
}
// add dynamic filter to wait list grid
var control2 = attribute.FieldType.Field.FilterControl( attribute.QualifierValues, "filter_" + attribute.Id.ToString(), false, Rock.Reporting.FilterMode.SimpleFilter );
if ( control2 != null )
{
if ( control2 is IRockControl )
{
var rockControl2 = (IRockControl)control2;
rockControl2.Label = attribute.Name;
rockControl2.Help = attribute.Description;
phWaitListFormFieldFilters.Controls.Add( control2 );
}
else
{
var wrapper2 = new RockControlWrapper();
wrapper2.ID = control.ID + "_wrapper";
wrapper2.Label = attribute.Name;
wrapper2.Controls.Add( control2 );
phWaitListFormFieldFilters.Controls.Add( wrapper2 );
}
string savedValue = fWaitList.GetUserPreference( "WL-" + attribute.Key );
if ( !string.IsNullOrWhiteSpace( savedValue ) )
{
try
{
var values = JsonConvert.DeserializeObject<List<string>>( savedValue );
attribute.FieldType.Field.SetFilterValues( control2, attribute.QualifierValues, values );
}
catch { }
}
}
string dataFieldExpression = attribute.Id.ToString() + attribute.Key;
bool columnExists = gRegistrants.Columns.OfType<AttributeField>().FirstOrDefault( a => a.DataField.Equals( dataFieldExpression ) ) != null;
if ( !columnExists )
{
AttributeField boundField = new AttributeField();
boundField.DataField = dataFieldExpression;
boundField.AttributeId = attribute.Id;
boundField.HeaderText = attribute.Name;
AttributeField boundField2 = new AttributeField();
boundField2.DataField = dataFieldExpression;
boundField2.AttributeId = attribute.Id;
boundField2.HeaderText = attribute.Name;
AttributeField boundField3 = new AttributeField();
boundField3.DataField = dataFieldExpression;
boundField3.AttributeId = attribute.Id;
boundField3.HeaderText = attribute.Name;
var attributeCache = Rock.Web.Cache.AttributeCache.Read( attribute.Id );
if ( attributeCache != null )
{
boundField.ItemStyle.HorizontalAlign = attributeCache.FieldType.Field.AlignValue;
boundField2.ItemStyle.HorizontalAlign = attributeCache.FieldType.Field.AlignValue;
boundField3.ItemStyle.HorizontalAlign = attributeCache.FieldType.Field.AlignValue;
}
gRegistrants.Columns.Add( boundField );
gGroupPlacements.Columns.Add( boundField2 );
gWaitList.Columns.Add( boundField3 );
}
}
}
}
// Add fee column
var feeField = new RockLiteralField();
feeField.ID = "lFees";
feeField.HeaderText = "Fees";
gRegistrants.Columns.Add( feeField );
var deleteField = new DeleteField();
gRegistrants.Columns.Add( deleteField );
deleteField.Click += gRegistrants_Delete;
var groupPickerField = new GroupPickerField();
groupPickerField.HeaderText = "Group";
groupPickerField.RootGroupId = gpGroupPlacementParentGroup.SelectedValueAsInt();
gGroupPlacements.Columns.Add( groupPickerField );
}