/// <summary>
/// Adds the grid columns.
/// </summary>
/// <param name="dataTable">The data table.</param>
private void AddGridColumns( Grid grid, DataTable dataTable )
{
bool showColumns = GetAttributeValue( "ShowColumns" ).AsBoolean();
var columnList = GetAttributeValue( "Columns" ).SplitDelimitedValues().ToList();
int rowsToEval = 10;
if ( dataTable.Rows.Count < 10 )
{
rowsToEval = dataTable.Rows.Count;
}
grid.Columns.Clear();
if ( !string.IsNullOrWhiteSpace( grid.PersonIdField ) )
{
grid.Columns.Add( new SelectField() );
}
GridFilterColumnLookup = new Dictionary<Control, string>();
foreach ( DataColumn dataTableColumn in dataTable.Columns )
{
if ( columnList.Count > 0 &&
( ( showColumns && !columnList.Contains( dataTableColumn.ColumnName, StringComparer.OrdinalIgnoreCase ) ) ||
( !showColumns && columnList.Contains( dataTableColumn.ColumnName, StringComparer.OrdinalIgnoreCase ) ) ) )
{
continue;
}
BoundField bf = new BoundField();
var splitCaseName = dataTableColumn.ColumnName.SplitCase();
if ( dataTableColumn.DataType == typeof( bool ) )
{
bf = new BoolField();
if ( GridFilter != null )
{
var id = "ddl" + dataTableColumn.ColumnName.RemoveSpecialCharacters();
var filterControl = new RockDropDownList()
{
Label = splitCaseName,
ID = id
};
GridFilterColumnLookup.Add( filterControl, dataTableColumn.ColumnName );
filterControl.Items.Add( BoolToString( null ) );
filterControl.Items.Add( BoolToString( true ) );
filterControl.Items.Add( BoolToString( false ) );
GridFilter.Controls.Add( filterControl );
var value = GridFilter.GetUserPreference( id );
if ( value != null )
{
filterControl.SetValue( value );
}
}
}
else if ( dataTableColumn.DataType == typeof( DateTime ) )
{
bf = new DateField();
for ( int i = 0; i < rowsToEval; i++ )
{
object dateObj = dataTable.Rows[i][dataTableColumn];
if ( dateObj is DateTime )
{
DateTime dateTime = ( DateTime ) dateObj;
if ( dateTime.TimeOfDay.Seconds != 0 )
{
bf = new DateTimeField();
break;
}
}
}
if ( GridFilter != null )
{
var id = "drp" + dataTableColumn.ColumnName.RemoveSpecialCharacters();
var filterControl = new DateRangePicker()
{
Label = splitCaseName,
ID = id,
};
GridFilterColumnLookup.Add( filterControl, dataTableColumn.ColumnName );
GridFilter.Controls.Add( filterControl );
var value = GridFilter.GetUserPreference( id );
if ( value != null )
{
DateTime upper;
DateTime lower;
if ( DateRangePicker.TryParse( value, out lower, out upper ) )
{
filterControl.LowerValue = lower;
filterControl.UpperValue = upper;
}
}
}
}
else
{
bf.HtmlEncode = false;
if ( GridFilter != null )
{
var id = "tb" + dataTableColumn.ColumnName.RemoveSpecialCharacters();
var filterControl = new RockTextBox()
{
Label = splitCaseName,
ID = id
};
GridFilterColumnLookup.Add( filterControl, dataTableColumn.ColumnName );
GridFilter.Controls.Add( filterControl );
var key = filterControl.ID;
var value = GridFilter.GetUserPreference( key );
if ( value != null )
{
filterControl.Text = value;
}
}
}
bf.DataField = dataTableColumn.ColumnName;
bf.SortExpression = dataTableColumn.ColumnName;
bf.HeaderText = splitCaseName;
grid.Columns.Add( bf );
}
}
private void AddGridColumns(DataTable dataTable)
{
int rowsToEval = 10;
if ( dataTable.Rows.Count < 10 )
{
rowsToEval = dataTable.Rows.Count;
}
gReport.Columns.Clear();
foreach(DataColumn dtColumn in dataTable.Columns)
{
BoundField bf = new BoundField();
if ( dtColumn.DataType == typeof( Boolean ) )
{
bf = new BoolField();
}
if ( dtColumn.DataType == typeof( DateTime ) )
{
bf = new DateField();
for ( int i = 0; i < rowsToEval; i++ )
{
object dateObj = dataTable.Rows[i][dtColumn];
if ( dateObj is DateTime )
{
DateTime dateTime = (DateTime)dateObj;
if ( dateTime.TimeOfDay.Seconds != 0 )
{
bf = new DateTimeField();
break;
}
}
}
}
bf.DataField = dtColumn.ColumnName;
bf.SortExpression = dtColumn.ColumnName;
bf.HeaderText = dtColumn.ColumnName.SplitCase();
gReport.Columns.Add( bf );
}
}
/// <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;
}
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>
/// Gets the grid field.
/// </summary>
/// <param name="propertyType">Type of the property.</param>
/// <returns></returns>
public static BoundField GetGridField( Type propertyType )
{
BoundField bf = new BoundField();
Type baseType = propertyType;
if ( baseType == typeof( Boolean ) || baseType == typeof( Boolean? ) )
{
bf = new BoolField();
}
else if ( baseType == typeof( DateTime ) || baseType == typeof( DateTime? ) )
{
bf = new DateField();
}
else if ( baseType.IsEnum )
{
bf = new EnumField();
}
else if ( baseType == typeof( decimal ) || baseType == typeof( decimal? ) ||
baseType == typeof( int ) || baseType == typeof( int? ) )
{
bf = new BoundField();
bf.HeaderStyle.HorizontalAlign = HorizontalAlign.Right;
bf.ItemStyle.HorizontalAlign = HorizontalAlign.Right;
}
else if ( baseType == typeof( IEnumerable<object> ) )
{
bf = new ListDelimitedField();
}
return bf;
}
/// <summary>
/// Adds the grid columns.
/// </summary>
/// <param name="dataTable">The data table.</param>
private void AddGridColumns( DataTable dataTable )
{
bool showColumns = bool.Parse( GetAttributeValue( "ShowColumns" ) );
var columnList = GetAttributeValue( "Columns" ).SplitDelimitedValues().ToList();
int rowsToEval = 10;
if ( dataTable.Rows.Count < 10 )
{
rowsToEval = dataTable.Rows.Count;
}
gReport.Columns.Clear();
if ( !string.IsNullOrWhiteSpace( gReport.PersonIdField ) )
{
gReport.Columns.Add( new SelectField() );
}
foreach ( DataColumn dataTableColumn in dataTable.Columns )
{
if ( columnList.Count > 0 &&
( ( showColumns && !columnList.Contains( dataTableColumn.ColumnName, StringComparer.OrdinalIgnoreCase ) ) ||
( !showColumns && columnList.Contains( dataTableColumn.ColumnName, StringComparer.OrdinalIgnoreCase ) ) ) )
{
continue;
}
BoundField bf = new BoundField();
if ( dataTableColumn.DataType == typeof( bool ) )
{
bf = new BoolField();
}
if ( dataTableColumn.DataType == typeof( DateTime ) )
{
bf = new DateField();
for ( int i = 0; i < rowsToEval; i++ )
{
object dateObj = dataTable.Rows[i][dataTableColumn];
if ( dateObj is DateTime )
{
DateTime dateTime = (DateTime)dateObj;
if ( dateTime.TimeOfDay.Seconds != 0 )
{
bf = new DateTimeField();
break;
}
}
}
}
bf.DataField = dataTableColumn.ColumnName;
bf.SortExpression = dataTableColumn.ColumnName;
bf.HeaderText = dataTableColumn.ColumnName.SplitCase();
gReport.Columns.Add( bf );
}
}
/// <summary>
/// Raises the <see cref="E:System.Web.UI.Control.Init" /> event.
/// </summary>
/// <param name="e">An <see cref="T:System.EventArgs" /> object that contains the event data.</param>
protected override void OnInit( EventArgs e )
{
base.OnInit( e );
gReport.DataKeyNames = new string[] { "Id" };
gReport.GridRebind += gReport_GridRebind;
int tagId = int.MinValue;
if ( int.TryParse( PageParameter( "tagId" ), out tagId ) && tagId > 0 )
{
Tag _tag = new TagService( new RockContext() ).Get( tagId );
if ( _tag != null )
{
TagId = tagId;
TagEntityType = EntityTypeCache.Read( _tag.EntityTypeId );
if ( TagEntityType != null )
{
Type modelType = TagEntityType.GetEntityType();
gReport.RowItemText = modelType.Name + " Tag";
lTaggedTitle.Text = "Tagged " + modelType.Name.Pluralize();
if ( modelType != null )
{
// If displaying people, set the person id fiels so that merge and communication icons are displayed
if ( TagEntityType.Name == "Rock.Model.Person" )
{
gReport.PersonIdField = "Id";
}
foreach ( var column in gReport.GetPreviewColumns( modelType ) )
{
gReport.Columns.Add( column );
}
// Add a CreatedDateTime if one does not exist
var gridBoundColumns = gReport.Columns.OfType<BoundField>();
if ( gridBoundColumns.Any( c => c.DataField.Equals( "CreatedDateTime" ) ) == false )
{
BoundField addedDateTime = new DateField();
addedDateTime.DataField = "CreatedDateTime";
addedDateTime.SortExpression = "CreatedDateTime";
addedDateTime.HeaderText = "Date Tagged";
gReport.Columns.Add( addedDateTime );
}
// Add delete column
var deleteField = new DeleteField();
gReport.Columns.Add( deleteField );
deleteField.Click += gReport_Delete;
if ( !Page.IsPostBack )
{
BindGrid();
}
}
}
}
}
}
/// <summary>
/// Gets the grid field.
/// </summary>
/// <param name="propertyType">Type of the property.</param>
/// <returns></returns>
public static BoundField GetGridField( Type propertyType )
{
BoundField bf = new BoundField();
Type baseType = propertyType;
if (propertyType.IsGenericType)
{
baseType = propertyType.GetGenericArguments()[0];
}
if ( baseType == typeof( Boolean ) || baseType == typeof( Boolean? ) )
{
bf = new BoolField();
}
else if ( baseType == typeof( DateTime ) || baseType == typeof( DateTime? ) )
{
bf = new DateField();
}
else if ( baseType.IsEnum )
{
bf = new EnumField();
}
else if ( baseType == typeof( decimal ) || baseType == typeof( decimal? ) ||
baseType == typeof( int ) || baseType == typeof( int? ) )
{
bf = new BoundField();
bf.HeaderStyle.HorizontalAlign = HorizontalAlign.Right;
bf.ItemStyle.HorizontalAlign = HorizontalAlign.Right;
}
return bf;
}
/// <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 );
}
