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 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 AttendanceDetailModel(DateTime dt1, DateTime? dt2, OrgSearchModel model)
{
if (dt2.HasValue)
{
if (dt2.Value.TimeOfDay == TimeSpan.Zero)
dt2 = dt2.Value.AddDays(1);
}
else
dt2 = dt1.AddDays(1);
this.dt1 = dt1;
this.dt2 = dt2;
Model = model;
}
public ActionResult ApplyType(int id, OrgSearchModel m)
{
int? t = (id == -1 ? (int?) null : id);
if (t == 0)
return Content("");
var ot = DbUtil.Db.OrganizationTypes.SingleOrDefault(tt => tt.Id == id);
if (t.HasValue || ot != null)
foreach (var o in m.FetchOrgs())
o.OrganizationTypeId = t;
else
return Content("error: missing type");
DbUtil.Db.SubmitChanges();
return Content("ok");
}
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");
ws.Cells["A2"].LoadFromCollection(q);
var range = ws.Cells[1, 1, count + 1, cols.Length];
var table = ws.Tables.Add(range, "Trips");
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 ActionResult ToggleTag(int id, int tagdiv)
{
var Db = DbUtil.Db;
var organization = Db.LoadOrganizationById(id);
if (tagdiv == 0)
return Json(new { error = "bad tagdiv" });
bool t = organization.ToggleTag(DbUtil.Db, tagdiv);
Db.SubmitChanges();
var m = new OrgSearchModel { StatusId = 0, TagDiv = tagdiv, Name = id.ToString() };
var o = m.OrganizationList().SingleOrDefault();
if (o == null)
return Content("error");
return View("Row", o);
}
public ActionResult Results(OrgSearchModel m)
{
SaveToSession(m);
return View(m);
}
public ActionResult RenameDiv(int id, int divid, string name)
{
var d = DbUtil.Db.Divisions.Single(dd => dd.Id == divid);
d.Name = name;
DbUtil.Db.SubmitChanges();
var m = new OrgSearchModel { ProgramId = id };
return View("DivisionIds", m);
}
public ActionResult OrganizationStructure(bool? active, OrgSearchModel m)
{
var orgs = m.FetchOrgs();
var q = from os in DbUtil.Db.ViewOrganizationStructures
join o in orgs on os.OrgId equals o.OrganizationId
select os;
return View(q.OrderBy(oo => oo.Program).ThenBy(oo => oo.Division).ThenBy(oo => oo.Organization));
}
public ActionResult MainDiv(int id, int tagdiv)
{
var Db = DbUtil.Db;
Db.SetMainDivision(id, tagdiv);
var m = new OrgSearchModel { TagDiv = tagdiv, Name = id.ToString() };
var o = m.OrganizationList().SingleOrDefault();
if (o == null)
return Content("error");
return View("Row", o);
}
public ActionResult ExportMembersExcel(OrgSearchModel m)
{
return new OrgsMembersExcelResult(m);
}
public ActionResult ClassList(string org, OrgSearchModel m)
{
return new ClassListResult(m) { orgid = org == "curr" ? (int?)Util2.CurrentOrgId : null };
}
public ClassListResult(OrgSearchModel m)
{
model = m;
}
public RosterListResult(OrgSearchModel m)
{
model = m;
}
public ActionResult MissionTripFunding(OrgSearchModel m)
{
return MissionTripFundingModel.Result(m);
}
public static EpplusResult List(OrgSearchModel m)
{
var orgids = string.Join(",", m.FetchOrgs().Select(mm => mm.OrganizationId));
return(Result(SenderGifts(orgids)));
}
public ActionResult EmailAttendanceNotices(OrgSearchModel m)
{
m.SendNotices(this);
return Content("ok");
}
public ActionResult OrgLeaders(string org, OrgSearchModel m)
{
return new OrgLeadersResult(m) {orgid = org == "curr" ? (int?) Util2.CurrentOrgId : null};
}
public ActionResult Index(int? div, int? progid)
{
Response.NoCache();
var m = new OrgSearchModel();
if (div.HasValue)
{
m.DivisionId = div;
if (progid.HasValue)
m.ProgramId = progid;
else
m.ProgramId = m.Division().ProgId;
m.TagProgramId = m.ProgramId;
m.TagDiv = div;
}
else if (progid.HasValue)
{
m.ProgramId = progid;
m.TagProgramId = m.ProgramId;
}
else if (Session[STR_OrgSearch].IsNotNull())
{
var os = Session[STR_OrgSearch] as OrgSearchInfo;
m.Name = os.Name;
m.ProgramId = os.Program;
m.DivisionId = os.Division;
m.ScheduleId = os.Sched;
m.StatusId = os.Status;
m.OnlineReg = os.OnlineReg;
m.TypeId = os.Type;
m.CampusId = os.Campus;
}
return View(m);
}
public ActionResult RecentAbsents(int? id, 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,
type = m.TypeId,
campus = m.CampusId,
sched = m.ScheduleId,
status = m.StatusId,
onlinereg = m.OnlineReg,
mainfellowship = m.MainFellowship,
parentorg = m.ParentOrg
}, commandType: CommandType.StoredProcedure, commandTimeout: 600);
return View(q);
}
public ActionResult MakeNewDiv(int id, string name)
{
var d = new Division { Name = name, ProgId = id };
d.ProgDivs.Add(new ProgDiv { ProgId = id });
DbUtil.Db.Divisions.InsertOnSubmit(d);
DbUtil.Db.SubmitChanges();
var m = new OrgSearchModel { ProgramId = id, TagDiv = d.Id };
return View("DivisionIds", m);
}
public ActionResult Rollsheet(int? id, string org, string dt, int? meetingid, int? bygroup, string sgprefix, bool? altnames, string highlight, OrgSearchModel m)
{
var dt2 = dt.ToDate();
return new RollsheetResult
{
qid = id,
orgid = org == "curr" ? (int?)Util2.CurrentOrgId : null,
groups = org == "curr" ? Util2.CurrentGroups : new int[] { 0 },
meetingid = meetingid,
bygroup = bygroup.HasValue,
sgprefix = sgprefix,
dt = dt2,
altnames = altnames,
highlightsg = highlight,
Model = m
};
}
public ActionResult PasteSettings(OrgSearchModel m)
{
var frorg = (int)Session["OrgCopySettings"];
foreach (var o in m.FetchOrgs())
o.CopySettings(DbUtil.Db, frorg);
return new EmptyResult();
}
public ActionResult Roster(OrgSearchModel m)
{
return new RosterListResult(m);
}
public ActionResult RepairTransactions(OrgSearchModel m)
{
foreach (var o in m.FetchOrgs())
DbUtil.Db.PopulateComputedEnrollmentTransactions(o.OrganizationId);
return new EmptyResult();
}
public ActionResult ShirtSizes(string org, OrgSearchModel m)
{
var orgid = org == "curr" ? (int?)Util2.CurrentOrgId : null;
var orgs = 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 TagDivIds(int id)
{
var m = new OrgSearchModel { ProgramId = id };
return View("DivisionIds", m);
}
public OrgLeadersResult(OrgSearchModel m)
{
model = m;
}
private void SaveToSession(OrgSearchModel m)
{
Session[STR_OrgSearch] = new OrgSearchInfo
{
Name = m.Name,
Program = m.ProgramId,
Division = m.DivisionId,
Sched = m.ScheduleId,
Status = m.StatusId,
OnlineReg = m.OnlineReg,
Type = m.TypeId,
Campus = m.CampusId,
};
}
public OrgExcelResult(OrgSearchModel m)
{
this.m = m;
}
public ActionResult DivisionIds(int id)
{
var m = new OrgSearchModel { ProgramId = id };
return View(m);
//return Json(OrgSearchModel.DivisionIds(id));
}
public OrgExcelResult(OrgSearchModel m)
{
this.m = m;
}
