public static IEnumerable<MemberInfo> List(OrgSearchModel model, string na = "", bool usecurrenttag = false) { var orgs = model.FetchOrgs(); var q = from m in DbUtil.Db.OrganizationMembers join o in orgs on m.OrganizationId equals o.OrganizationId select m; if (usecurrenttag) { var tagid = DbUtil.Db.TagCurrent().Id; q = from m in q where m.Person.Tags.Any(tt => tt.Id == tagid) select m; } var q2 = from m in q where m.Person.LastName.StartsWith(na) orderby m.Person.Name2 select new MemberInfo { Name = m.Person.Name2, Id = m.PeopleId, Organization = m.Organization.OrganizationName, Location = m.Organization.Location, MemberType = m.MemberType.Description, }; return q2; }
public ActionResult Index(int id, OrgSearchModel osm) { var model = new RepairTransactionsOrgs(id); var orgIds = osm.FetchOrgs().Select(oo => oo.OrganizationId).ToArray(); model.Orgs = string.Join(",", orgIds); model.Count = orgIds.Length; model.RemoveExistingLop(DbUtil.Db, id, RepairTransactionsOrgs.Op); return View(model); }
public IncompleteRegistrations(OrgSearchModel orgsearch, int?days) : base("Date", "desc", true) { if (orgsearch != null) { var q = orgsearch.FetchOrgs(); oids = string.Join(",", q.OrderBy(mm => mm.OrganizationName).Select(mm => mm.OrganizationId)); } this.days = days; setPageSize(); }
public IncompleteRegistrations(CMSDataContext db, OrgSearchModel orgsearch, int?days) : base(db) { Init(); if (orgsearch != null) { var q = orgsearch.FetchOrgs(); oids = string.Join(",", q.OrderBy(mm => mm.OrganizationName).Select(mm => mm.OrganizationId)); } this.days = days; setPageSize(); }
public RepairTransactionsOrgs(OrgSearchModel m) { Id = Util.UserPeopleId ?? 0; var q = (from o in m.FetchOrgs() select new OrgInfo { Id = o.OrganizationId, Name = o.OrganizationName, Count = o.MemberCount ?? 0 }).ToList(); Count = q.Count(); Orgs = JsonConvert.SerializeObject(q); }
public ActionResult ApplyType(int id, OrgSearchModel m) { var 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) { var q = from o in DbUtil.Db.Organizations join os in m.FetchOrgs() on o.OrganizationId equals os.OrganizationId select o; foreach (var o in q) o.OrganizationTypeId = t; } else return Content("error: missing type"); DbUtil.Db.SubmitChanges(); return Content("ok"); }
public ActionResult Count(OrgSearchModel m) { return Content(m.FetchOrgs().Count().ToString()); }
public ActionResult RepairTransactions(OrgSearchModel m) { foreach (var oid in m.FetchOrgs().Select(oo => oo.OrganizationId)) DbUtil.Db.PopulateComputedEnrollmentTransactions(oid); return new EmptyResult(); }
public ActionResult PasteSettings(OrgSearchModel m) { var frorg = (int) Session["OrgCopySettings"]; var orgs = from os in m.FetchOrgs() join o in DbUtil.Db.Organizations on os.OrganizationId equals o.OrganizationId select o; foreach (var o in orgs) 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 ActionResult MovePendingToMember(OrgSearchModel m) { var orgids = string.Join(",", m.FetchOrgs().Select(mm => mm.OrganizationId)); var i = DbUtil.Db.Connection.ExecuteScalar($@" UPDATE dbo.OrganizationMembers SET Pending = NULL FROM dbo.OrganizationMembers om JOIN dbo.SplitInts('{orgids}') i ON i.Value = om.OrganizationId WHERE om.Pending = 1 SELECT @@ROWCOUNT "); return Content($"changed {i} people"); }
public ActionResult MakeChildrenOf(int id, OrgSearchModel m) { var t = (id == -1 ? (int?) null : id); if (t == 0) return Content(""); var org = DbUtil.Db.LoadOrganizationById(id); if (t.HasValue || org != null) { var q = from o in DbUtil.Db.Organizations join os in m.FetchOrgs() on o.OrganizationId equals os.OrganizationId where o.OrganizationId != id select o; foreach (var o in q) o.ParentOrgId = t; } else return Content("error: missing type"); DbUtil.Db.SubmitChanges(); return Content("ok"); }
public ActionResult CreateMeetings(DateTime dt, bool noautoabsents, OrgSearchModel model) { var orgIds = model.FetchOrgs().Select(oo => oo.OrganizationId).ToList(); foreach (var oid in orgIds) { var db = DbUtil.Create(Util.Host); Meeting.FetchOrCreateMeeting(db, oid, dt, noautoabsents); db.Dispose(); } DbUtil.LogActivity("Creating new meetings from OrgSearch"); return Content("done"); }
public ActionResult OrgIds(OrgSearchModel m) { var orgs = m.FetchOrgs(); return Content(string.Join(",", orgs.Select(oo => oo.OrganizationId))); }
public ActionResult SqlReport(OrgSearchModel m, string report) { try { var orgs = m.FetchOrgs(); var oids = string.Join(",", orgs.Select(oo => oo.OrganizationId)); ViewBag.ExcelUrl = $"/OrgSearch/SqlReportExcel/{report}"; ViewBag.DisplayName = report.SpaceCamelCase(); ViewBag.Results = m.SqlTable(report, oids); ViewBag.OrgIds = oids; return View(); } catch (Exception ex) { return Message(ex); } }