public IEnumerable <MeetingRow> FetchMeetings() { var q = from m in DbUtil.Db.Meetings let sc = m.Organization.OrgSchedules.FirstOrDefault() // SCHED where m.Organization.DivOrgs.Any(dd => dd.DivId == divid || divid == 0) where m.MeetingDate >= dt1 where m.MeetingDate < dt2 where campusid == null || campusid == 0 || m.Organization.CampusId == campusid where schedid == null || schedid == 0 || sc.ScheduleId == schedid where name == null || name == "" || m.Organization.OrganizationName.Contains(name) orderby m.Organization.OrganizationName, m.OrganizationId, m.MeetingDate descending select new { MeetingId = m.MeetingId, OrgName = m.Organization.OrganizationName, Leader = m.Organization.LeaderName, location = m.Organization.Location, date = m.MeetingDate.Value, OrgId = m.OrganizationId, Present = m.NumPresent, Visitors = m.NumNewVisit + m.NumRepeatVst, OutTowners = m.NumOutTown ?? 0 }; var q2 = from m in q.ToList() select new MeetingRow { MeetingId = m.MeetingId, OrgName = m.OrgName, Leader = m.Leader, date = m.date.ToString("g"), OrgId = m.OrgId.ToString(), Present = m.Present, Visitors = m.Visitors, OutTowners = m.OutTowners }; var list = q2.ToList(); var t = new MeetingRow { OrgName = "Total", Leader = string.Empty, date = "", OrgId = "", Present = list.Sum(i => i.Present), Visitors = list.Sum(i => i.Visitors), OutTowners = list.Sum(i => i.OutTowners) }; list.Add(t); return(list); }
public IEnumerable<MeetingRow> FetchMeetings() { var orgs = Model.FetchOrgs(); var q = from m in DbUtil.Db.Meetings join o in orgs on m.OrganizationId equals o.OrganizationId where m.MeetingDate >= dt1 where m.MeetingDate <= dt2 where Model.ScheduleId == 0 || m.ScheduleId == Model.ScheduleId orderby o.OrganizationName, o.OrganizationId, m.MeetingDate descending select new { MeetingId = m.MeetingId, OrgName = m.Organization.OrganizationName, Leader = m.Organization.LeaderName, location = m.Organization.Location, date = m.MeetingDate.Value, OrgId = m.OrganizationId, Present = m.MaxCount ?? 0, Visitors = m.NumNewVisit + m.NumRepeatVst, OutTowners = m.NumOutTown ?? 0 }; var q2 = from m in q.ToList() select new MeetingRow { MeetingId = m.MeetingId, OrgName = m.OrgName, Leader = m.Leader, date = m.date.ToString("g"), OrgId = m.OrgId.ToString(), Present = m.Present, Visitors = m.Visitors, OutTowners = m.OutTowners }; var list = q2.ToList(); var t = new MeetingRow { OrgName = "Total", Leader = string.Empty, date = "", OrgId = "", Present = list.Sum(i => i.Present), Visitors = list.Sum(i => i.Visitors), OutTowners = list.Sum(i => i.OutTowners) }; list.Add(t); return list; }
public List <MeetingRow> FetchMeetings() { var orgs = Model.FetchOrgs(); var q = from m in DbUtil.Db.Meetings join o in orgs on m.OrganizationId equals o.OrganizationId where m.MeetingDate >= dt1 where m.MeetingDate <= dt2 where Model.ScheduleId == 0 || m.ScheduleId == Model.ScheduleId orderby o.OrganizationName, o.OrganizationId, m.MeetingDate descending select new { MeetingId = m.MeetingId, OrgName = m.Organization.OrganizationName, Leader = m.Organization.LeaderName, location = m.Organization.Location, date = m.MeetingDate.Value, OrgId = m.OrganizationId, Present = m.MaxCount ?? 0, Visitors = m.NumNewVisit + m.NumRepeatVst, OutTowners = m.NumOutTown ?? 0 }; var q2 = from m in q select new MeetingRow { OrgName = m.OrgName, Leader = m.Leader, DateTime = m.date, Present = m.Present, Visitors = m.Visitors, OutTowners = m.OutTowners }; var list = q2.ToList(); var t = new MeetingRow { OrgName = "Total", Leader = string.Empty, Present = list.Sum(i => i.Present), Visitors = list.Sum(i => i.Visitors), OutTowners = list.Sum(i => i.OutTowners) }; list.Add(t); return(list); }