public List <DateInfo> Meetings()
{
return((from a in DbUtil.Db.Attends
where a.OrganizationId == OrgId
where a.MeetingDate >= Sunday
where a.MeetingDate <= EndDt.AddHours(24)
where a.Commitment == AttendCommitmentCode.Attending || a.Commitment == AttendCommitmentCode.Substitute
group a by a.MeetingDate into g
let attend = (from aa in g
where aa.PeopleId == PeopleId
select aa).SingleOrDefault()
select new DateInfo()
{
attend = attend,
MeetingDate = g.Key,
count = g.Count(),
iscommitted = attend != null
}).ToList());
}
