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 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 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 ActionResult RepairTransactions(OrgSearchModel m) { foreach (var o in m.FetchOrgs()) DbUtil.Db.PopulateComputedEnrollmentTransactions(o.OrganizationId); return new EmptyResult(); }
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 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 static EpplusResult List(OrgSearchModel m) { var orgids = string.Join(",", m.FetchOrgs().Select(mm => mm.OrganizationId)); return(Result(SenderGifts(orgids))); }
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 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 ActionResult MeetingsForMonth(DateTime dt1, OrgSearchModel m) { var orgs = string.Join(",", m.FetchOrgs().Select(oo => oo.OrganizationId)); var cn = new SqlConnection(Util.ConnectionString); cn.Open(); ViewBag.Month = dt1.ToString("MMMM yyyy"); dt1 = new DateTime(dt1.Year, dt1.Month, 1); var dt2 = dt1.AddMonths(1).AddDays(-1); var q = cn.Query("MeetingsForDateRange", new { orgs, startdate = dt1, enddate = dt2, }, commandType: CommandType.StoredProcedure, commandTimeout: 600); return View(q); }
public ActionResult CreateMeetings(DateTime dt, OrgSearchModel model) { foreach (var o in model.FetchOrgs()) { var mt = DbUtil.Db.Meetings.SingleOrDefault(m => m.MeetingDate == dt && m.OrganizationId == o.OrganizationId); if (mt != null) continue; mt = new CmsData.Meeting { CreatedDate = Util.Now, CreatedBy = Util.UserId1, OrganizationId = o.OrganizationId, Location = o.Location, MeetingDate = dt, }; DbUtil.Db.Meetings.InsertOnSubmit(mt); DbUtil.Db.SubmitChanges(); } DbUtil.LogActivity("Creating new meetings from OrgSearch"); return Content("done"); }
public static EpplusResult List(OrgSearchModel m) { var orgids = string.Join(",", m.FetchOrgs().Select(mm => mm.OrganizationId)); return Result(SenderGifts(orgids)); }