/// <summary>
/// Raises the <see cref="E:System.Web.UI.Control.Load" /> event.
/// </summary>
/// <param name="e">The <see cref="T:System.EventArgs" /> object that contains the event data.</param>
protected override void OnLoad(EventArgs e)
{
base.OnLoad(e);
_occurrence = GetOccurrence();
if (!Page.IsPostBack)
{
pnlDetails.Visible = _canEdit;
if (_canEdit)
{
if (_allowCampusFilter)
{
var campus = CampusCache.Read(GetBlockUserPreference("Campus").AsInteger());
if (campus != null)
{
bddlCampus.Title = campus.Name;
ExtensionMethods.SetValue((ListControl)bddlCampus, campus.Id);
}
}
BindLocations();
ShowDetails();
}
else
{
nbNotice.Heading = "Sorry";
nbNotice.Text = "<p>You're not authorized to update the attendance for the selected group.</p>";
nbNotice.NotificationBoxType = NotificationBoxType.Danger;
nbNotice.Visible = true;
}
}
else
{
if (_attendees != null)
{
foreach (var item in lvMembers.Items)
{
var hfMember = item.FindControl("hfMember") as HiddenField;
var cbMember = item.FindControl("cbMember") as CheckBox;
if (hfMember != null && cbMember != null)
{
int personId = hfMember.ValueAsInt();
var attendance = _attendees.Where(a => a.PersonId == personId).FirstOrDefault();
if (attendance != null)
{
attendance.Attended = cbMember.Checked;
}
}
}
}
}
}
/// <summary>
/// Raises the <see cref="E:System.Web.UI.Control.Load" /> event.
/// </summary>
/// <param name="e">The <see cref="T:System.EventArgs" /> object that contains the event data.</param>
protected override void OnLoad(EventArgs e)
{
base.OnLoad(e);
_occurrence = GetOccurrence();
if (!Page.IsPostBack)
{
pnlDetails.Visible = _canEdit;
if (_canEdit)
{
BindLocations();
ShowDetails();
}
else
{
nbNotice.Heading = "Sorry";
nbNotice.Text = "<p>You're not authorized to update the attendance for the selected group.</p>";
nbNotice.NotificationBoxType = NotificationBoxType.Danger;
nbNotice.Visible = true;
}
}
else
{
if (_attendees != null)
{
foreach (var item in lvMembers.Items)
{
var hfMember = item.FindControl("hfMember") as HiddenField;
var cbMember = item.FindControl("cbMember") as CheckBox;
if (hfMember != null && cbMember != null)
{
int personId = hfMember.ValueAsInt();
var attendance = _attendees.Where(a => a.PersonId == personId).FirstOrDefault();
if (attendance != null)
{
attendance.Attended = cbMember.Checked;
}
}
}
}
}
}
/// <summary>
/// Gets the attendance.
/// </summary>
/// <param name="group">The group.</param>
/// <param name="occurrence">The occurrence.</param>
/// <returns></returns>
public IQueryable<Attendance> GetAttendance( Group group, ScheduleOccurrence occurrence )
{
if ( group != null && occurrence != null )
{
DateTime startDate = occurrence.Date;
DateTime endDate = occurrence.Date.AddDays( 1 );
return new AttendanceService( (RockContext)this.Context )
.Queryable( "PersonAlias" ).AsNoTracking()
.Where( a =>
a.GroupId == group.Id &&
a.LocationId == occurrence.LocationId &&
a.ScheduleId == occurrence.ScheduleId &&
a.StartDateTime >= startDate &&
a.StartDateTime < endDate );
}
return null;
}
/// <summary>
/// Raises the <see cref="E:System.Web.UI.Control.Load" /> event.
/// </summary>
/// <param name="e">The <see cref="T:System.EventArgs" /> object that contains the event data.</param>
protected override void OnLoad(EventArgs e)
{
base.OnLoad(e);
_occurrence = GetOccurrence();
if (!Page.IsPostBack)
{
pnlDetails.Visible = _canEdit;
if (_canEdit)
{
ShowDetails();
}
else
{
nbNotice.Heading = "Sorry";
nbNotice.Text = "<p>You're not authorized to update the attendance for the selected group.</p>";
nbNotice.NotificationBoxType = NotificationBoxType.Danger;
nbNotice.Visible = true;
}
}
}
/// <summary>
/// Raises the <see cref="E:System.Web.UI.Control.Load" /> event.
/// </summary>
/// <param name="e">The <see cref="T:System.EventArgs" /> object that contains the event data.</param>
protected override void OnLoad( EventArgs e )
{
base.OnLoad( e );
_occurrence = GetOccurrence();
if ( !Page.IsPostBack )
{
pnlDetails.Visible = _canEdit;
if ( _canEdit )
{
if ( _allowCampusFilter )
{
var campus = CampusCache.Read( GetBlockUserPreference( "Campus" ).AsInteger() );
if ( campus != null )
{
bddlCampus.Title = campus.Name;
bddlCampus.SetValue( campus.Id );
}
}
BindLocations();
ShowDetails();
}
else
{
nbNotice.Heading = "Sorry";
nbNotice.Text = "<p>You're not authorized to update the attendance for the selected group.</p>";
nbNotice.NotificationBoxType = NotificationBoxType.Danger;
nbNotice.Visible = true;
}
}
else
{
if ( _attendees != null )
{
foreach ( var item in lvMembers.Items )
{
var hfMember = item.FindControl( "hfMember" ) as HiddenField;
var cbMember = item.FindControl( "cbMember" ) as CheckBox;
if ( hfMember != null && cbMember != null )
{
int personId = hfMember.ValueAsInt();
var attendance = _attendees.Where( a => a.PersonId == personId ).FirstOrDefault();
if ( attendance != null )
{
attendance.Attended = cbMember.Checked;
}
}
}
}
}
}
/// <summary>
/// Gets occurrence data for the selected group
/// </summary>
/// <param name="group">The group.</param>
/// <param name="fromDateTime">From date time.</param>
/// <param name="toDateTime">To date time.</param>
/// <param name="locationIds">The location ids.</param>
/// <param name="scheduleIds">The schedule ids.</param>
/// <param name="loadSummaryData">if set to <c>true</c> [load summary data].</param>
/// <returns></returns>
public List<ScheduleOccurrence> GetGroupOccurrences( Group group, DateTime? fromDateTime, DateTime? toDateTime,
List<int> locationIds, List<int> scheduleIds, bool loadSummaryData )
{
var occurrences = new List<ScheduleOccurrence>();
if ( group != null )
{
var rockContext = (RockContext)this.Context;
var attendanceService = new AttendanceService( rockContext );
var scheduleService = new ScheduleService( rockContext );
var locationService = new LocationService( rockContext );
// Set up an 'occurrences' query for the group
var qry = attendanceService
.Queryable().AsNoTracking()
.Where( a => a.GroupId == group.Id );
// Filter by date range
if ( fromDateTime.HasValue )
{
var fromDate = fromDateTime.Value.Date;
qry = qry.Where( a => DbFunctions.TruncateTime( a.StartDateTime ) >= ( fromDate ) );
}
if ( toDateTime.HasValue )
{
var toDate = toDateTime.Value.Date;
qry = qry.Where( a => DbFunctions.TruncateTime( a.StartDateTime ) < ( toDate ) );
}
// Location Filter
if ( locationIds.Any() )
{
qry = qry.Where( a =>
a.LocationId.HasValue &&
locationIds.Contains( a.LocationId.Value ) );
}
// Schedule Filter
if ( scheduleIds.Any() )
{
qry = qry.Where( a =>
a.ScheduleId.HasValue &&
scheduleIds.Contains( a.ScheduleId.Value ) );
}
// Get the unique combination of location/schedule/date for the selected group
var occurrenceDates = qry
.Select( a => new
{
a.LocationId,
a.ScheduleId,
Date = DbFunctions.TruncateTime( a.StartDateTime )
} )
.Distinct()
.ToList();
// Get the locations for each unique location id
var selectedlocationIds = occurrenceDates.Select( o => o.LocationId ).Distinct().ToList();
var locations = locationService
.Queryable().AsNoTracking()
.Where( l => selectedlocationIds.Contains( l.Id ) )
.Select( l => new { l.Id, l.ParentLocationId, l.Name } )
.ToList();
var locationNames = new Dictionary<int, string>();
locations.ForEach( l => locationNames.Add( l.Id, l.Name ) );
// Get the parent location path for each unique location
var parentlocationPaths = new Dictionary<int, string>();
locations
.Where( l => l.ParentLocationId.HasValue )
.Select( l => l.ParentLocationId.Value )
.Distinct()
.ToList()
.ForEach( l => parentlocationPaths.Add( l, locationService.GetPath( l ) ) );
var locationPaths = new Dictionary<int, string>();
locations
.Where( l => l.ParentLocationId.HasValue )
.ToList()
.ForEach( l => locationPaths.Add( l.Id, parentlocationPaths[l.ParentLocationId.Value] ) );
// Get the schedules for each unique schedule id
var selectedScheduleIds = occurrenceDates.Select( o => o.ScheduleId ).Distinct().ToList();
var schedules = scheduleService
.Queryable().AsNoTracking()
.Where( s => selectedScheduleIds.Contains( s.Id ) )
.ToList();
var scheduleNames = new Dictionary<int, string>();
var scheduleStartTimes = new Dictionary<int, TimeSpan>();
schedules
.ForEach( s => {
scheduleNames.Add( s.Id, s.Name );
scheduleStartTimes.Add( s.Id, s.StartTimeOfDay );
});
foreach ( var occurrence in occurrenceDates.Where( o => o.Date.HasValue ) )
{
occurrences.Add(
new ScheduleOccurrence(
occurrence.Date.Value,
occurrence.ScheduleId.HasValue && scheduleStartTimes.ContainsKey( occurrence.ScheduleId.Value ) ?
scheduleStartTimes[occurrence.ScheduleId.Value] : new TimeSpan(),
occurrence.ScheduleId,
occurrence.ScheduleId.HasValue && scheduleNames.ContainsKey( occurrence.ScheduleId.Value ) ?
scheduleNames[occurrence.ScheduleId.Value] : string.Empty,
occurrence.LocationId,
occurrence.LocationId.HasValue && locationNames.ContainsKey( occurrence.LocationId.Value ) ?
locationNames[occurrence.LocationId.Value] : string.Empty,
occurrence.LocationId.HasValue && locationPaths.ContainsKey( occurrence.LocationId.Value ) ?
locationPaths[occurrence.LocationId.Value] : string.Empty
) );
}
// Load the attendance data for each occurrence
if ( loadSummaryData && occurrences.Any())
{
var minDate = occurrences.Min( o => o.Date );
var maxDate = occurrences.Max( o => o.Date ).AddDays( 1 );
foreach( var summary in attendanceService
.Queryable().AsNoTracking()
.Where( a =>
a.PersonAliasId.HasValue &&
a.GroupId.HasValue &&
a.GroupId == group.Id &&
a.StartDateTime >= minDate &&
a.StartDateTime < maxDate )
.GroupBy( a => new
{
a.LocationId,
a.ScheduleId,
Date = DbFunctions.TruncateTime( a.StartDateTime )
} )
.Select( a => new
{
a.Key.LocationId,
a.Key.ScheduleId,
a.Key.Date,
DidAttendCount = a
.Where( t => t.DidAttend.HasValue && t.DidAttend.Value )
.Select( t => t.PersonAliasId.Value )
.Distinct()
.Count(),
DidNotOccurCount = a
.Where( t => t.DidNotOccur.HasValue && t.DidNotOccur.Value )
.Select( t => t.PersonAliasId.Value )
.Distinct()
.Count(),
TotalCount = a
.Select( t => t.PersonAliasId )
.Distinct()
.Count()
} ) )
{
var occurrence = occurrences
.Where( o =>
o.ScheduleId.Equals( summary.ScheduleId ) &&
o.LocationId.Equals( summary.LocationId ) &&
o.Date.Equals( summary.Date ) )
.FirstOrDefault();
if ( occurrence != null )
{
occurrence.DidAttendCount = summary.DidAttendCount;
occurrence.DidNotOccurCount = summary.DidNotOccurCount;
occurrence.TotalCount = summary.TotalCount;
}
}
}
// Create any missing occurrences from the group's schedule (not location schedules)
Schedule groupSchedule = null;
if ( group.ScheduleId.HasValue )
{
groupSchedule = group.Schedule;
if ( groupSchedule == null )
{
groupSchedule = new ScheduleService( rockContext ).Get( group.ScheduleId.Value );
}
}
if ( groupSchedule != null )
{
var newOccurrences = new List<ScheduleOccurrence>();
var existingDates = occurrences
.Where( o => o.ScheduleId.Equals( groupSchedule.Id ) )
.Select( o => o.Date )
.Distinct()
.ToList();
var startDate = fromDateTime.HasValue ? fromDateTime.Value : RockDateTime.Today.AddMonths( -2 );
var endDate = toDateTime.HasValue ? toDateTime.Value : RockDateTime.Today.AddDays( 1 );
DDay.iCal.Event calEvent = groupSchedule.GetCalenderEvent();
if ( calEvent != null )
{
// If schedule has an iCal schedule, get all the past occurrences
foreach ( var occurrence in calEvent.GetOccurrences( startDate, endDate ) )
{
var scheduleOccurrence = new ScheduleOccurrence(
occurrence.Period.StartTime.Date, occurrence.Period.StartTime.TimeOfDay, groupSchedule.Id, groupSchedule.Name );
if ( !existingDates.Contains( scheduleOccurrence.Date ) )
{
newOccurrences.Add( scheduleOccurrence );
}
}
}
else
{
// if schedule does not have an iCal, then check for weekly schedule and calculate occurrences starting with first attendance or current week
if ( groupSchedule.WeeklyDayOfWeek.HasValue )
{
// default to start with date 2 months earlier
startDate = fromDateTime.HasValue ? fromDateTime.Value : RockDateTime.Today.AddMonths( -2 );
if ( existingDates.Any( d => d < startDate ) )
{
startDate = existingDates.Min();
}
// Back up start time to the correct day of week
while ( startDate.DayOfWeek != groupSchedule.WeeklyDayOfWeek.Value )
{
startDate = startDate.AddDays( -1 );
}
// Add the start time
if ( groupSchedule.WeeklyTimeOfDay.HasValue )
{
startDate = startDate.Add( groupSchedule.WeeklyTimeOfDay.Value );
}
// Create occurrences up to current time
while ( startDate < endDate )
{
if ( !existingDates.Contains( startDate.Date ) )
{
var scheduleOccurrence = new ScheduleOccurrence( startDate.Date, startDate.TimeOfDay, groupSchedule.Id, groupSchedule.Name );
newOccurrences.Add( scheduleOccurrence );
}
startDate = startDate.AddDays( 7 );
}
}
}
if ( newOccurrences.Any() )
{
// Filter Exclusions
var groupType = GroupTypeCache.Read( group.GroupTypeId );
foreach ( var exclusion in groupType.GroupScheduleExclusions )
{
if ( exclusion.Start.HasValue && exclusion.End.HasValue )
{
foreach ( var occurrence in newOccurrences.ToList() )
{
if ( occurrence.Date >= exclusion.Start.Value &&
occurrence.Date < exclusion.End.Value.AddDays( 1 ) )
{
newOccurrences.Remove( occurrence );
}
}
}
}
}
foreach( var occurrence in newOccurrences )
{
occurrences.Add( occurrence );
}
}
}
return occurrences;
}
/// <summary>
/// Loads the attendance data.
/// </summary>
/// <param name="group">The group.</param>
/// <param name="occurrence">The occurrence.</param>
public void LoadSummaryData( Group group, ScheduleOccurrence occurrence )
{
if ( group != null && occurrence != null )
{
var attendances = new AttendanceService( (RockContext)this.Context )
.Queryable().AsNoTracking()
.Where( a =>
a.PersonAliasId.HasValue &&
a.GroupId.HasValue &&
a.GroupId == group.Id &&
a.LocationId.Equals( occurrence.LocationId ) &&
a.ScheduleId.Equals( occurrence.ScheduleId ) &&
DbFunctions.TruncateTime( a.StartDateTime ).Equals( occurrence.Date ) )
.ToList();
if ( attendances.Any() )
{
occurrence.DidAttendCount = attendances
.Where( t => t.DidAttend.HasValue && t.DidAttend.Value )
.Select( t => t.PersonAliasId.Value )
.Distinct()
.Count();
occurrence.DidNotOccurCount = attendances
.Where( t => t.DidNotOccur.HasValue && t.DidNotOccur.Value )
.Select( t => t.PersonAliasId.Value )
.Distinct()
.Count();
occurrence.TotalCount = attendances
.Select( t => t.PersonAliasId )
.Distinct()
.Count();
}
}
}
/// <summary>
/// Loads the attendance data.
/// </summary>
/// <param name="group">The group.</param>
/// <param name="occurrence">The occurrence.</param>
public void LoadAttendanceData( Group group, ScheduleOccurrence occurrence )
{
if ( group != null && occurrence != null )
{
var attendanceData = new AttendanceService( (RockContext)this.Context )
.Queryable( "PersonAlias" ).AsNoTracking()
.Where( a =>
a.GroupId == group.Id &&
a.StartDateTime >= occurrence.StartDateTime &&
a.StartDateTime < occurrence.EndDateTime )
.ToList();
occurrence.Attendance = attendanceData;
}
}
/// <summary>
/// Raises the <see cref="E:System.Web.UI.Control.Load" /> event.
/// </summary>
/// <param name="e">The <see cref="T:System.EventArgs" /> object that contains the event data.</param>
protected override void OnLoad( EventArgs e )
{
base.OnLoad( e );
_occurrence = GetOccurrence();
if ( !Page.IsPostBack )
{
pnlDetails.Visible = _canEdit;
if ( _canEdit )
{
ShowDetails();
}
else
{
nbNotice.Heading = "Sorry";
nbNotice.Text = "<p>You're not authorized to update the attendance for the selected group.</p>";
nbNotice.NotificationBoxType = NotificationBoxType.Danger;
nbNotice.Visible = true;
}
}
}