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);
}
