private static string RecentAbsentsEmail(OrgSearchController c, IEnumerable<RecentAbsent> list)
{
var q = from p in list
orderby p.Consecutive, p.Name2
select p;
return ViewExtensions2.RenderPartialViewToString(c, "RecentAbsentsEmail", q);
}
private static string RecentVisitsEmail(OrgSearchController c, IEnumerable<OrgVisitorsAsOfDate> list)
{
var q = from p in list
orderby p.LastAttended, p.LastName, p.PreferredName
select p;
return ViewExtensions2.RenderPartialViewToString(c, "RecentVisitsEmail", q);
}
public void SendNotices(OrgSearchController c)
{
const int days = 36;
var olist = FetchOrgs().Select(oo => oo.OrganizationId).ToList();
var alist = (from p in DbUtil.Db.RecentAbsents(null, null, days)
where olist.Contains(p.OrganizationId)
select p).ToList();
var mlist = (from r in DbUtil.Db.LastMeetings(null, null, days)
where olist.Contains(r.OrganizationId)
select r).ToList();
var plist = (from om in DbUtil.Db.ViewOrganizationLeaders
where olist.Contains(om.OrganizationId)
group om.OrganizationId by om.PeopleId into leaderlist
select leaderlist).ToList();
var sb2 = new StringBuilder("Notices sent to:</br>\n<table>\n");
foreach (var p in plist)
{
var sb = new StringBuilder("The following meetings are ready to be viewed:<br/>\n");
var orgids = p.Select(vv => vv).ToList();
var meetings = mlist.Where(m => orgids.Contains(m.OrganizationId)).ToList();
var leader = DbUtil.Db.LoadPersonById(p.Key);
foreach (var m in meetings)
{
string orgname = Organization.FormatOrgName(m.OrganizationName, m.LeaderName, m.Location);
sb.AppendFormat("<a href='{0}Meeting/Index/{1}'>{2} - {3}</a><br/>\n",
DbUtil.Db.CmsHost, m.MeetingId, orgname, m.Lastmeeting.FormatDateTm());
sb2.AppendFormat("<tr><td>{0}</td><td>{1}</td><td>{2:g}</td></tr>\n",
leader.Name, orgname, m.Lastmeeting.FormatDateTm());
}
foreach (var m in meetings)
{
var absents = alist.Where(a => a.OrganizationId == m.OrganizationId);
var vlist = DbUtil.Db.OrgVisitorsAsOfDate(m.OrganizationId, m.Lastmeeting, NoCurrentMembers: true).ToList();
sb.Append(RecentAbsentsEmail(c, absents));
sb.Append(RecentVisitsEmail(c, vlist));
}
DbUtil.Db.Email(DbUtil.Db.CurrentUser.Person.FromEmail, leader, null,
"Attendance reports are ready for viewing", sb.ToString(), false);
}
sb2.Append("</table>\n");
DbUtil.Db.Email(DbUtil.Db.CurrentUser.Person.FromEmail, DbUtil.Db.CurrentUser.Person, null,
"Attendance emails sent", sb2.ToString(), false);
}
