internal EmployeeActivityCountsView Build(int establishmentId)
{
var publishedText = ActivityMode.Public.AsSentenceFragment();
var activities = _entities.Query <Activity>()
.Where(x =>
x.Original == null && x.ModeText == publishedText && // published, non-work-copy
x.Person.Affiliations.Any(y => y.IsDefault) // make sure person's default affiliation is not null
&&
( // person must be affiliated with this establishment or one of its offspring under the default affiliation
x.Person.Affiliations.Any(y => (y.EstablishmentId == establishmentId || y.Establishment.Ancestors.Any(z => z.AncestorId == establishmentId))
// ReSharper disable PossibleNullReferenceException
&& (y.IsDefault || y.Establishment.Ancestors.Any(z => z.AncestorId == x.Person.Affiliations.FirstOrDefault(a => a.IsDefault).EstablishmentId)))
// ReSharper restore PossibleNullReferenceException
)
)
.Select(x => x.Values.FirstOrDefault(y => y.ModeText == publishedText))
;
var view = new EmployeeActivityCountsView
{
EstablishmentId = establishmentId,
ActivityCount = activities.Count(),
PersonCount = activities.Select(x => x.Activity.PersonId).Distinct().Count(),
LocationCount = activities.SelectMany(x => x.Locations).Select(x => x.PlaceId).Distinct().Count(),
};
return(view);
}
internal void Set(EmployeeActivityCountsView view, int establishmentId)
{
Lock.EnterWriteLock();
try
{
_views.Set <EmployeeActivityCountsView>(view, establishmentId);
}
finally
{
Lock.ExitWriteLock();
}
}
internal void Set(EmployeeActivityCountsView view, int establishmentId)
{
Lock.EnterWriteLock();
try
{
_views.Set<EmployeeActivityCountsView>(view, establishmentId);
}
finally
{
Lock.ExitWriteLock();
}
}
