/// <summary>
/// Adds the schedule columns.
/// </summary>
private void AddScheduleColumns()
{
ScheduleService scheduleService = new ScheduleService( new RockContext() );
// limit Schedules to ones that have a CheckInStartOffsetMinutes
var scheduleQry = scheduleService.Queryable().Where( a => a.CheckInStartOffsetMinutes != null );
// limit Schedules to the Category from the Filter
int scheduleCategoryId = CategoryCache.Read( Rock.SystemGuid.Category.SCHEDULE_SERVICE_TIMES.AsGuid() ).Id;
scheduleQry = scheduleQry.Where( a => a.CategoryId == scheduleCategoryId );
// clear out any existing schedule columns just in case schedules been added/removed
var scheduleList = scheduleQry.ToList().OrderBy( a => a.ToString() ).ToList();
var checkBoxEditableFields = gGroupLocationSchedule.Columns.OfType<CheckBoxEditableField>().ToList();
foreach ( var field in checkBoxEditableFields )
{
gGroupLocationSchedule.Columns.Remove( field );
}
foreach ( var item in scheduleList )
{
string dataFieldName = string.Format( "scheduleField_{0}", item.Id );
CheckBoxEditableField field = new CheckBoxEditableField { HeaderText = item.FriendlyScheduleText.Replace( " at ", "<br/>" ), DataField = dataFieldName };
gGroupLocationSchedule.Columns.Add( field );
}
}
/// <summary>
/// Adds the schedule columns.
/// </summary>
private void AddScheduleColumns()
{
ScheduleService scheduleService = new ScheduleService( new RockContext() );
// limit Schedules to ones that have a CheckInStartOffsetMinutes
var scheduleQry = scheduleService.Queryable().Where( a => a.CheckInStartOffsetMinutes != null );
// limit Schedules to the Category from the Filter
int scheduleCategoryId = rFilter.GetUserPreference( "Category" ).AsIntegerOrNull() ?? Rock.Constants.All.Id;
if ( scheduleCategoryId != Rock.Constants.All.Id )
{
scheduleQry = scheduleQry.Where( a => a.CategoryId == scheduleCategoryId );
}
else
{
// NULL (or 0) means Shared, so specifically filter so to show only Schedules with CategoryId NULL
scheduleQry = scheduleQry.Where( a => a.CategoryId == null );
}
// clear out any existing schedule columns and add the ones that match the current filter setting
var scheduleList = scheduleQry.ToList().OrderBy( a => a.ToString() ).ToList();
var checkBoxEditableFields = gGroupLocationSchedule.Columns.OfType<CheckBoxEditableField>().ToList();
foreach ( var field in checkBoxEditableFields )
{
gGroupLocationSchedule.Columns.Remove( field );
}
foreach ( var item in scheduleList )
{
string dataFieldName = string.Format( "scheduleField_{0}", item.Id );
CheckBoxEditableField field = new CheckBoxEditableField { HeaderText = item.Name, DataField = dataFieldName };
gGroupLocationSchedule.Columns.Add( field );
}
if ( !scheduleList.Any() )
{
nbNotification.Text = nbNotification.Text = String.Format( "<p><strong>Warning</strong></p>No schedules found. Consider <a class='alert-link' href='{0}'>adding a schedule</a> or a different schedule category.", ResolveUrl( "~/Schedules" ) );
nbNotification.Visible = true;
}
else
{
nbNotification.Visible = false;
}
}