public ActionResult MeetingsForDateRange(DateTime dt1, DateTime dt2, OrgSearchModel m) { var orgs = string.Join(",", m.FetchOrgs().Select(oo => oo.OrganizationId)); var cn = new SqlConnection(Util.ConnectionString); cn.Open(); var q = cn.Query("MeetingsForDateRange", new { orgs, startdate = dt1, enddate = dt2, }, commandType: CommandType.StoredProcedure, commandTimeout: 600); var entity = (IDictionary<string, object>) q.First(); var cols = entity.Keys.Cast<string>().ToList(); var ep = new ExcelPackage(); var ws = ep.Workbook.Worksheets.Add("Sheet1"); int row = 1; for (var i = 0; i < cols.Count; i++) ws.Cells[row, i+1].Value = cols[i]; row++; foreach (var r in q) { var rr = (IDictionary<string, object>) r; for (var i = 0; i < cols.Count; i++) ws.Cells[row, i+1].Value = rr[cols[i]]; row++; } ws.Cells[ws.Dimension.Address].AutoFitColumns(); return new EpplusResult(ep, "MeetingsForDateRange.xlsx"); }
public static EpplusResult Result(OrgSearchModel m) { var q = List(m); var cols = typeof(MissionTripTotal).GetProperties(); var count = q.Count; var ep = new ExcelPackage(); var ws = ep.Workbook.Worksheets.Add("Sheet1"); if (count == 0) { ws.Cells["A1"].Value = "nothing to report"; return new EpplusResult(ep, "MissionTripFunding.xlsx"); } ws.Cells["A2"].LoadFromCollection(q); var range = ws.Cells[1, 1, count + 1, cols.Length]; var table = ws.Tables.Add(range, "Trips"); table.TableStyle = TableStyles.Light9; table.ShowFilter = false; for (var i = 0; i < cols.Length; i++) { var col = i + 1; var name = cols[i].Name; table.Columns[i].Name = name; var colrange = ws.Cells[1, col, count + 2, col]; } ws.Cells[ws.Dimension.Address].AutoFitColumns(); return new EpplusResult(ep, "MissionTripFunding.xlsx"); }
public static List<MissionTripTotal> List(OrgSearchModel m) { var orgids = string.Join(",", m.FetchOrgs().Select(mm => mm.OrganizationId)); var q = from t in DbUtil.Db.ViewMissionTripTotals join i in DbUtil.Db.SplitInts(orgids) on t.OrganizationId equals i.ValueX orderby t.OrganizationId, t.SortOrder select t; return q.ToList(); }
public ActionResult MeetingsAttendance(DateTime? dt1, DateTime? dt2, OrgSearchModel m) { var dt = ChurchAttendanceModel.MostRecentAttendedSunday(); if (!dt1.HasValue) dt1 = new DateTime(dt.Year, 1, 1); if (!dt2.HasValue) dt2 = dt; var m2 = new AttendanceDetailModel(dt1.Value, dt2, m); return m2.FetchMeetings().ToDataTable().ToExcel("MeetingsExport.xlsx"); }
public ActionResult AttendanceDetail(string Dt1, string Dt2, OrgSearchModel m) { var dt1 = Dt1.ToDate(); if (!dt1.HasValue) dt1 = ChurchAttendanceModel.MostRecentAttendedSunday(); var dt2 = Dt2.ToDate(); if (!dt2.HasValue) dt2 = dt1.Value.AddDays(1); var m2 = new AttendanceDetailModel(dt1.Value, dt2, m); return View(m2); }
public ActionResult EnrollmentControl2a(OrgSearchModel m) { return(View(m)); }
public ActionResult EmailAttendanceNotices(OrgSearchModel m) { m.SendNotices(); return(Content("ok")); }
public OrgSearchInfo(OrgSearchModel m) { this.CopyPropertiesFrom(m); }
public ActionResult SGMap(OrgSearchModel m) { return Redirect("/Sgmap/Index/" + m.DivisionId); }
public ActionResult Count(OrgSearchModel m) { return(Content(m.FetchOrgs().Count().ToString())); }
public static EpplusResult List(OrgSearchModel m) { var orgids = string.Join(",", m.FetchOrgs().Select(mm => mm.OrganizationId)); return Result(SenderGifts(orgids)); }
public ActionResult RecentAbsents(OrgSearchModel m) { var cn = new SqlConnection(Util.ConnectionString); cn.Open(); var q = cn.Query("RecentAbsentsSP2", new { name = m.Name, prog = m.ProgramId, div = m.DivisionId, campus = m.CampusId, sched = m.ScheduleId, status = m.StatusId, onlinereg = m.OnlineReg, orgtypeid = m.TypeId }, commandType: CommandType.StoredProcedure, commandTimeout: 600); return View(q); }
public ActionResult Index(OrgSearchModel osm) { var model = new RepairTransactionsOrgs(osm); return(View(model)); }
public ClassListResult(OrgSearchModel m) { model = m; }
public RosterListResult(OrgSearchModel m) { model = m; }
public ActionResult RecentAbsents(OrgSearchModel m) { var orgs = string.Join(",", m.FetchOrgs().Select(oo => oo.OrganizationId)); var cn = new SqlConnection(Util.ConnectionString); cn.Open(); var q = cn.Query("RecentAbsentsSP2", new { orgs }, commandType: CommandType.StoredProcedure, commandTimeout: 600); return View(q); }
public OrgLeadersResult(OrgSearchModel m) { model = m; }
public ActionResult Results(OrgSearchModel m) { UpdateModel(m.Pager); SaveToSession(m); return(View(m)); }
public ActionResult Index(OrgSearchModel m) { var model = new OrgSearchDrop(m); return(View(model)); }
public ActionResult MissionTripFunding(OrgSearchModel m) { return(View(MissionTripFundingModel.List(m))); }
public ActionResult ClassList(OrgSearchModel m) { return(new ClassListResult(m)); }
public ActionResult Roster1(OrgSearchModel m) { return(new RosterResult(m)); }
public ActionResult OrgLeaders(OrgSearchModel m) { return(new OrgLeadersResult(m)); }
public ActionResult MissionTripSenders(OrgSearchModel m) { return MissionTripSendersModel.List(m); }
public ActionResult SGMap(OrgSearchModel m) { return(Redirect("/Sgmap/Index/" + m.DivisionId)); }
public ActionResult Rollsheets(NewMeetingInfo mi, OrgSearchModel m) { return new RollsheetResult { OrgSearchModel = m, NewMeetingInfo = mi }; }
public ActionResult IncompleteRegistrations(OrgSearchModel orgsearch, int?days) { var m = new IncompleteRegistrations(orgsearch, days); return(View("IncompleteRegistrations", m)); }
public ActionResult OrgContactee(int id) { ViewBag.ContactId = id; var m = new OrgSearchModel(); return View("SearchOrganization", m); }
public ActionResult SelectOrg(OrgSearchModel m, int cid, int oid) { // TODO Reimplement with new paradigm return(null); }
public ActionResult OrgIds(OrgSearchModel m) { var orgs = m.FetchOrgs(); return(Content(string.Join(",", orgs.Select(oo => oo.OrganizationId)))); }
public ActionResult ResOrgContacteeResultsults(OrgSearchModel m, int id) { ViewBag.ContactId = id; DbUtil.Db.SetNoLock(); ModelState.Clear(); return View("ResultsOrganization", m); }
public ActionResult DisplayAttendanceNotices(OrgSearchModel m) { var leaders = m.NoticesToSend(); return(View(leaders)); }
public ActionResult MissionTripFunding(OrgSearchModel m) { return MissionTripFundingModel.Result(m); }
public ActionResult Results(OrgSearchModel m) { Session[STR_OrgSearch] = new OrgSearchInfo(m); return(View(m)); }
public ActionResult ClassList(string org, OrgSearchModel m) { return new ClassListResult(m) { orgid = org == "curr" ? DbUtil.Db.CurrentOrg.Id : null }; }
public ActionResult EnrollmentControl2b(string na, string j) { var m = OrgSearchModel.DecodedJson(j); return(View(EnrollmentControlModel.List(m, na))); }
public ActionResult EnrollmentControl2(OrgSearchModel m) { return View(m); }
public ActionResult MissionTripSenders(OrgSearchModel m) { return(MissionTripSendersModel.List(m)); }
public ActionResult MeetingsForMonth(DateTime dt1, OrgSearchModel m) { var orgs = string.Join(",", m.FetchOrgs().Select(oo => oo.OrganizationId)); ViewBag.Month = dt1.ToString("MMMM yyyy"); dt1 = new DateTime(dt1.Year, dt1.Month, 1); var dt2 = dt1.AddMonths(1).AddDays(-1); var hasmeetings = DbUtil.Db.MeetingsDataForDateRange(orgs, dt1, dt2).AsEnumerable().Any(); if (!hasmeetings) return RedirectShowError("No meetings to show"); var cn = new SqlConnection(Util.ConnectionString); cn.Open(); var q = cn.Query("MeetingsForDateRange", new { orgs, startdate = dt1, enddate = dt2, }, commandType: CommandType.StoredProcedure, commandTimeout: 600); return View(q); }
public ActionResult OrgDayStats(DateTime? dt, OrgSearchModel m) { if(!dt.HasValue) dt = ChurchAttendanceModel.MostRecentAttendedSunday(); var orgs = string.Join(",", m.FetchOrgs().Select(oo => oo.OrganizationId)); var q = DbUtil.Db.OrgDayStats(orgs, dt); return q.ToDataTable().ToExcel("OrgDatStats.xlsx"); }
public ActionResult SelectOrg(OrgSearchModel m, int cid, int oid) { // TODO Reimplement with new paradigm return null; }
public ActionResult DefaultMeetingDate(int id) { var dt = OrgSearchModel.DefaultMeetingDate(id); return(Json(new { date = dt.Date.ToShortDateString(), time = dt.ToShortTimeString() })); }
public ActionResult ExportExcel(OrgSearchModel m) { return(m.OrganizationExcelList()); }
public ActionResult EnrollmentControl(bool? excel, bool? usecurrenttag, OrgSearchModel m) { if (excel != true) return new EnrollmentControlResult { OrgSearch = m, UseCurrentTag = usecurrenttag ?? false }; var d = (from p in EnrollmentControlModel.List(m, usecurrenttag: usecurrenttag ?? false) orderby p.Name select p).ToDataTable(); return d.ToExcel("EnrollmentControl.xlsx"); }
public ActionResult ExportMembersExcel(OrgSearchModel m) { return(m.OrgsMemberList()); }
public ActionResult EnrollmentControl2a(OrgSearchModel m) { var json = m.EncodedJson(); var mm = OrgSearchModel.DecodedJson(json); return RedirectToAction("EnrollmentControl2a", new { json }); }
public ActionResult RegOptions(OrgSearchModel m) { return(m.RegOptionsList()); }
public ActionResult MissionTripFunding(OrgSearchModel m) { return View(MissionTripFundingModel.List(m)); }
public ActionResult RegQuestionsUsage(OrgSearchModel m) { return(m.RegQuestionsUsage()); }
public ActionResult OrgLeaders(string org, OrgSearchModel m) { return new OrgLeadersResult(m) { orgid = org == "curr" ? DbUtil.Db.CurrentOrg.Id : null }; }
public ActionResult RegSettingUsages(OrgSearchModel m) { return(m.RegSettingUsages()); }
public ActionResult Rollsheet(string dt, int? bygroup, string sgprefix, bool? altnames, string highlight, OrgSearchModel m) { DateTime? dt2 = dt.ToDate(); if (!dt2.HasValue) return Message("no date"); var mi = new NewMeetingInfo() { ByGroup = bygroup > 0, GroupFilterPrefix = sgprefix, UseAltNames = altnames == true, HighlightGroup = highlight, MeetingDate = dt2.Value }; return new RollsheetResult { OrgSearchModel = m, NewMeetingInfo = mi }; }
public ActionResult RegSettingsXml(OrgSearchModel m) { Response.ContentType = "text/xml"; m.RegSettingsXml(Response.OutputStream); return(new EmptyResult()); }
public ActionResult Roster1(OrgSearchModel m) { return new RosterResult(m); }
public ActionResult RegMessages(OrgSearchModel m, Settings.Messages messages) { Response.ContentType = "text/xml"; m.RegMessagesXml(Response.OutputStream, messages); return(new EmptyResult()); }
public ActionResult ShirtSizes(string org, OrgSearchModel m) { var orgid = org == "curr" ? DbUtil.Db.CurrentOrg.Id : null; var orgs = orgid.HasValue ? OrgSearchModel.FetchOrgs(orgid.Value) : m.FetchOrgs(); var q = from om in DbUtil.Db.OrganizationMembers join o in orgs on om.OrganizationId equals o.OrganizationId where o.OrganizationId == orgid || (orgid ?? 0) == 0 group 1 by om.ShirtSize into g select new ShirtSizeInfo { Size = g.Key, Count = g.Count(), }; return View(q); }
public ActionResult Test(string id) { return Content("ok"); var m = new OrgSearchModel() { }; var leaders = m.NoticesToSend(); return Content(leaders.First().Value); }