/// <summary>
/// Binds the grid.
/// </summary>
private void BindGrid()
{
var dateRange = SlidingDateRangePicker.CalculateDateRangeFromDelimitedValues( drpSlidingDateRange.DelimitedValues );
string groupTypeIds = null;
string campusIds = cpCampuses.SelectedCampusIds.AsDelimited( "," );
SortProperty sortProperty = gAttendance.SortProperty;
var chartData = new AttendanceService( new RockContext() ).GetChartData(
hfGroupBy.Value.ConvertToEnumOrNull<AttendanceGroupBy>() ?? AttendanceGroupBy.Week,
hfGraphBy.Value.ConvertToEnumOrNull<AttendanceGraphBy>() ?? AttendanceGraphBy.Total,
dateRange.Start,
dateRange.End,
groupTypeIds,
campusIds );
if ( sortProperty != null )
{
gAttendance.DataSource = chartData.AsQueryable().Sort( sortProperty ).ToList();
}
else
{
gAttendance.DataSource = chartData.OrderBy( a => a.DateTimeStamp ).ToList();
}
gAttendance.DataBind();
}
private void BuildNavigationControls()
{
if ( NavData != null )
{
if ( string.IsNullOrWhiteSpace( CurrentNavPath ) || !CurrentNavPath.StartsWith( _configuredMode ) )
{
CurrentNavPath = _configuredMode;
}
var pathParts = CurrentNavPath.Split( new char[] { '|' }, StringSplitOptions.RemoveEmptyEntries );
int numParts = pathParts.Length;
NavigationItem item = NavData.GetItem( pathParts[numParts-1] );
while (item == null && numParts > 1)
{
numParts--;
item = NavData.GetItem( pathParts[numParts-1] );
}
CurrentNavPath = pathParts.Take( numParts ).ToList().AsDelimited( "|" );
string itemKey = pathParts[numParts - 1];
string itemType = itemKey.Left( 1 );
int? itemId = itemKey.Length > 1 ? itemKey.Substring( 1 ).AsIntegerOrNull() : null;
SetUserPreference( "CurrentNavPath", CurrentNavPath );
var navItems = new List<NavigationItem>();
switch ( itemType )
{
case "L": // Location
{
// Add child locations
NavData.Locations
.Where( l => l.ParentId == itemId )
.ToList()
.ForEach( l => navItems.Add( l ) );
break;
}
case "T": // Group Type
{
// Add child group types
NavData.GroupTypes
.Where( t => t.ParentId.Equals(itemId) )
.ToList().ForEach( t => navItems.Add( t ) );
// Add child groups
var groupIds = NavData.GroupTypes
.Where( t => t.Id == itemId )
.SelectMany( t => t.ChildGroupIds )
.Distinct()
.ToList();
NavData.Groups
.Where( g => groupIds.Contains( g.Id ) )
.ToList()
.ForEach( g => navItems.Add( g ) );
break;
}
case "G": // Group
{
// Add child groups
var groupIds = NavData.Groups
.Where( g => g.Id == itemId )
.SelectMany( g => g.ChildGroupIds )
.Distinct()
.ToList();
NavData.Groups
.Where( g => groupIds.Contains( g.Id ) )
.ToList()
.ForEach( g => navItems.Add( g ) );
// Add child locations
var locations = NavData.Groups
.Where( g => g.Id == itemId )
.SelectMany( g => g.ChildLocationIds )
.Distinct()
.ToList();
NavData.Locations
.Where( l => locations.Contains( l.Id ) )
.ToList()
.ForEach( l => navItems.Add( l ) );
break;
}
}
// Get chart data
Dictionary<DateTime, List<int>> chartCounts = null;
if (item != null)
{
chartCounts = item.RecentPersonIds;
}
else
{
chartCounts = new Dictionary<DateTime, List<int>>();
foreach(var navItem in navItems)
{
foreach ( var kv in navItem.RecentPersonIds )
{
if ( !chartCounts.ContainsKey( kv.Key ) )
{
chartCounts.Add( kv.Key, new List<int>() );
}
chartCounts[kv.Key] = chartCounts[kv.Key].Union( kv.Value ).ToList();
}
}
}
var chartData = new List<string>();
TimeSpan baseSpan = new TimeSpan( new DateTime(1970, 1, 1).Ticks );
foreach ( var kv in chartCounts.OrderBy( c => c.Key ) )
{
DateTime offsetTime = kv.Key.Subtract( baseSpan );
long ticks = (long)( offsetTime.Ticks / 10000 );
chartData.Add( string.Format( "[{0}, {1}]", ticks, kv.Value.Count() ) );
}
hfChartData.Value = string.Format( "[ [ {0} ] ]", chartData.AsDelimited( ", " ) );
pnlChart.Attributes["onClick"] = upnlContent.GetPostBackEventReference("R");
pnlNavHeading.Visible = item != null;
if ( item != null )
{
if ( numParts > 0 )
{
pnlNavHeading.Attributes["onClick"] = upnlContent.GetPostBackEventReference(
pathParts.ToList().Take( numParts - 1 ).ToList().AsDelimited( "|" ) );
}
lNavHeading.Text = item.Name;
var locationItem = item as NavigationLocation;
if (locationItem != null && locationItem.HasGroups)
{
tglHeadingRoom.Visible = true;
tglHeadingRoom.Checked = locationItem.IsActive;
tglHeadingRoom.Attributes["data-key"] = locationItem.Id.ToString();
var rockContext = new RockContext();
var activeSchedules = new List<int>();
foreach ( var schedule in new ScheduleService( rockContext )
.Queryable().AsNoTracking()
.Where( s => s.CheckInStartOffsetMinutes.HasValue ) )
{
if ( schedule.IsScheduleOrCheckInActive )
{
activeSchedules.Add( schedule.Id );
}
}
var dayStart = RockDateTime.Today;
var now = RockDateTime.Now;
var attendees = new AttendanceService( rockContext )
.Queryable( "Group,PersonAlias.Person,Schedule" )
.AsNoTracking()
.Where( a =>
a.StartDateTime > dayStart &&
a.StartDateTime < now &&
a.LocationId.HasValue &&
a.LocationId == locationItem.Id &&
a.DidAttend.HasValue &&
a.DidAttend.Value &&
a.ScheduleId.HasValue &&
activeSchedules.Contains( a.ScheduleId.Value ) )
.ToList();
var people = new List<PersonResult>();
foreach ( var personId in attendees
.OrderBy( a => a.PersonAlias.Person.NickName )
.ThenBy( a => a.PersonAlias.Person.LastName )
.Select( a => a.PersonAlias.PersonId )
.Distinct() )
{
var matchingAttendees = attendees
.Where( a => a.PersonAlias.PersonId == personId )
.ToList();
people.Add( new PersonResult( matchingAttendees ) );
}
rptPeople.Visible = true;
rptPeople.DataSource = people;
rptPeople.DataBind();
}
else
{
tglHeadingRoom.Visible = false;
rptPeople.Visible = false;
}
}
else
{
rptPeople.Visible = false;
}
rptNavItems.Visible = navItems.Any();
rptNavItems.DataSource = navItems
.OrderBy( i => i.TypeKey )
.ThenBy( i => i.Order )
.ThenBy( i => i.Name );
rptNavItems.DataBind();
RegisterStartupScript();
}
}
