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) { var leaders = NoticesToSend(c); foreach (var leader in leaders) { DbUtil.Db.Email(DbUtil.Db.CurrentUser.Person.FromEmail, leader.Key, null, DbUtil.Db.Setting("SubjectAttendanceNotices", "Attendance reports are ready for viewing"), leader.Value, false); } DbUtil.Db.Email(DbUtil.Db.CurrentUser.Person.FromEmail, DbUtil.Db.CurrentUser.Person, null, "Attendance emails sent", noticelist, false); }
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); }
public Dictionary<Person, string> NoticesToSend(OrgSearchController c) { var leaderNotices = new Dictionary<Person, string>(); 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.ToList(); var meetings = mlist.Where(m => orgids.Contains(m.OrganizationId)).ToList(); var leader = DbUtil.Db.LoadPersonById(p.Key); foreach (var m in meetings) { var orgname = Organization.FormatOrgName(m.OrganizationName, m.LeaderName, m.Location); sb.AppendFormat("<a href='{0}'>{1} - {2}</a><br/>\n", DbUtil.Db.ServerLink("/Meeting/" + 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, true).ToList(); sb.Append(RecentAbsentsEmail(c, absents)); sb.Append(RecentVisitsEmail(c, vlist)); } leaderNotices.Add(leader, sb.ToString()); } sb2.Append("</table>\n"); noticelist = sb2.ToString(); return leaderNotices; }