private static string ClassName(CmsData.Organization o) { var lead = o.LeaderName; if (lead.HasValue()) { lead = ": " + lead; } var loc = o.Location; if (loc.HasValue()) { loc = " ({0})".Fmt(loc); } var dt1 = o.FirstMeetingDate; var dt2 = o.LastMeetingDate; var dt = ""; if (dt1.HasValue && dt2.HasValue) { dt = ", {0:MMM d}-{1:MMM d}".Fmt(dt1, dt2); } else if (dt1.HasValue) { dt = ", {0:MMM d}".Fmt(dt1); } return(o.OrganizationName + lead + dt + loc); }
public void populateFromOrg(Organization org) { values["SGF:OrgID"] = org.OrganizationId.ToString(); values["SGF:Name"] = org.OrganizationName; values["SGF:Description"] = org.Description; values["SGF:Room"] = org.Location; values["SGF:Leader"] = org.LeaderName; values["SGF:DateStamp"] = DateTime.Now.ToString("yyyy-MM-dd"); values["SGF:Schedule"] = ""; if (org.OrgSchedules.Count > 0) { int count = 0; foreach (var schedule in org.OrgSchedules) { if (count > 0) values["SGF:Schedule"] += "; "; values["SGF:Schedule"] += DAY_LAST[schedule.SchedDay ?? 0] + ", " + schedule.SchedTime.ToString2("t"); ; count++; } } foreach (var extra in org.OrganizationExtras) { if (extra.Field.StartsWith("SGF:")) values[extra.Field] = extra.Data; } }
public ManageSubsModel(int pid, int id) { this.pid = pid; var org = DbUtil.Db.LoadOrganizationById(id); if (org.RegistrationTypeId != RegistrationTypeCode.ManageSubscriptions2) throw new Exception("must be a ManageSubscriptions RegistrationType"); masterorgid = id; _masterorg = org; }
public SearchAddModel(string context, string contextid, bool displaySkipSearch = true) : this() { DisplaySkipSearch = displaySkipSearch; AddContext = context; PrimaryKeyForContextType = contextid; CampusId = null; switch (AddContext.ToLower()) { case "addpeople": case "menu": EntryPointId = 0; break; case "addtotag": EntryPointId = null; break; case "mergeto": EntryPointId = null; break; case "family": case "relatedfamily": EntryPointId = 0; break; case "org": case "pending": case "prospect": case "inactive": org = DbUtil.Db.LoadOrganizationById(contextid.ToInt()); CampusId = org.CampusId; EntryPointId = org.EntryPointId ?? 0; break; case "visitor": case "registered": org = (from meeting in DbUtil.Db.Meetings where meeting.MeetingId == contextid.ToInt() select meeting.Organization).Single(); EntryPointId = org.EntryPointId ?? 0; CampusId = org.CampusId; break; case "contactee": EntryPointId = 0; break; case "contactor": EntryPointId = 0; break; case "contributor": EntryPointId = 0; break; case "addtoemail": EntryPointId = 0; break; } }
public static IQueryable<Organization> UserSelectClasses(Organization masterorg) { if (!masterorg.OrgPickList.HasValue()) return DbUtil.Db.Organizations.Where(oo => false); var cklist = masterorg.OrgPickList.Split(',').Select(oo => oo.ToInt()).ToList(); var q = from o in DbUtil.Db.Organizations where cklist.Contains(o.OrganizationId) select o; return q; }
public MeetingModel(int id) { var i = (from m in DbUtil.Db.Meetings where m.MeetingId == id select new { org = m.Organization, m, }).Single(); meeting = i.m; org = i.org; }
public ManageSubsModel(int pid, int id) { this.pid = pid; var org = DbUtil.Db.LoadOrganizationById(id); if (org.RegistrationTypeId != RegistrationTypeCode.ManageSubscriptions2) { throw new Exception("must be a ManageSubscriptions RegistrationType"); } masterorgid = id; _masterorg = org; }
public void CheckMasterOrg() { if (org != null && masterorgid == null && (org.RegistrationTypeId == RegistrationTypeCode.UserSelects || org.RegistrationTypeId == RegistrationTypeCode.ComputeOrgByAge || org.RegistrationTypeId == RegistrationTypeCode.ManageSubscriptions)) { _masterOrg = org; masterorgid = Orgid; _orgid = null; _org = null; } }
public MeetingModel(int id) { var i = (from m in DbUtil.Db.Meetings where m.MeetingId == id select new { org = m.Organization, m }).Single(); meeting = i.m; org = i.org; }
public MeetingModel(int id) { var i = (from m in DbUtil.Db.Meetings where m.MeetingId == id select new { org = m.Organization, m, }).SingleOrDefault(); if (i == null) return; meeting = i.m; org = i.org; }
public static void CopySettings2(Organization frorg, Organization toorg) { toorg.AllowNonCampusCheckIn = frorg.AllowNonCampusCheckIn; toorg.AllowAttendOverlap = frorg.AllowAttendOverlap; toorg.CanSelfCheckin = frorg.CanSelfCheckin; toorg.NumWorkerCheckInLabels = frorg.NumWorkerCheckInLabels; toorg.NoSecurityLabel = frorg.NoSecurityLabel; toorg.NumCheckInLabels = frorg.NumCheckInLabels; toorg.PhoneNumber = frorg.PhoneNumber; toorg.EntryPointId = frorg.EntryPointId; toorg.RollSheetVisitorWks = frorg.RollSheetVisitorWks; toorg.GradeAgeStart = frorg.GradeAgeStart; toorg.DivisionId = frorg.DivisionId; }
public static List<ClassInfo> Classes(Organization masterorg, int id) { var q = from o in OrderedClasses(masterorg) let hasroom = (o.ClassFilled ?? false) == false && ((o.Limit ?? 0) == 0 || o.Limit > o.RegLimitCount(DbUtil.Db)) where o.RegistrationTypeId > 0 select new ClassInfo { Id = o.OrganizationId, Text = ClassName(o), selected = o.OrganizationId == id, filled = !hasroom }; var list = q.ToList(); return list; }
public ManageSubsModel(int pid, int id) { this.pid = pid; var org = DbUtil.Db.LoadOrganizationById(id); if (org != null && org.RegistrationTypeId == RegistrationTypeCode.ManageSubscriptions2) { this.masterorgid = id; _masterorg = org; } else { this.divid = id; } }
public void populateFromOrg(Organization org) { values["SGF:OrgID"] = org.OrganizationId.ToString(); values["SGF:Name"] = org.OrganizationName; values["SGF:Description"] = org.Description; values["SGF:Room"] = org.Location; values["SGF:Leader"] = org.LeaderName; values["SGF:DateStamp"] = DateTime.Now.ToString("yyyy-MM-dd"); foreach (var extra in org.OrganizationExtras) { if (extra.Field.StartsWith("SGF:")) values[extra.Field] = extra.Data; } }
public static Organization CreateOrganization(CMSDataContext Db, Division division, string organization) { var o = new Organization { OrganizationName = organization, SecurityTypeId = 0, CreatedDate = Util.Now, CreatedBy = Util.UserId1, OrganizationStatusId = 30, }; division.Organizations.Add(o); Db.DivOrgs.InsertOnSubmit(new DivOrg { Division = division, Organization = o }); Db.SubmitChanges(); return o; }
public Dictionary<string, string> GetValuesDictionary(Organization org, bool loadAllValues) { var values = new Dictionary<string, string>(); var leader = (from e in DbUtil.Db.People where e.PeopleId == org.LeaderId select e).SingleOrDefault(); values["SGF:OrgID"] = org.OrganizationId.ToString(); values["SGF:Name"] = org.OrganizationName; values["SGF:Description"] = org.Description; values["SGF:Room"] = org.Location; values["SGF:Leader"] = org.LeaderName; values["SGF:DateStamp"] = DateTime.Now.ToString("yyyy-MM-dd"); values["SGF:Schedule"] = ""; if (leader != null && leader.PictureId != null) values["SGF:LeaderPicSrc"] = "/Portrait/" + leader.Picture.SmallId.Value + "?v=" + DateTime.Now.ToString("yyyyMMddHHmmssffff"); else values["SGF:LeaderPicSrc"] = "/Portrait/-3"; if (org.OrgSchedules.Count > 0) { var count = 0; foreach (var schedule in org.OrgSchedules) { if (count > 0) values["SGF:Schedule"] += "; "; values["SGF:Schedule"] += GroupLookup.DAY_LAST[schedule.SchedDay ?? 0] + ", " + schedule.SchedTime.ToString2("t"); ; count++; } } foreach (var extra in org.OrganizationExtras) { var val = extra.Data ?? extra.StrValue ?? extra.DateValue?.ToString() ?? extra.IntValue?.ToString() ?? extra.BitValue?.ToString(); if (extra.Field.StartsWith("SGF:")) values[extra.Field] = val; else if (loadAllValues) values[$"SGF:{extra.Field}"] = val; } return values; }
private void FetchEntities(int aid, int? pid) { var q = from attend in Db.Attends where attend.AttendId == aid let p = Db.People.SingleOrDefault(pp => pp.PeopleId == pid) select new { attend, org = attend.Organization, person = p, }; var i = q.SingleOrDefault(); org = i.org; this.attend = i.attend; person = i.person; }
public MeetingModel(int id) { var i = (from m in DbUtil.Db.Meetings where m.MeetingId == id select new { org = m.Organization, m, }).SingleOrDefault(); if (i == null) { return; } meeting = i.m; org = i.org; }
public static List<Organization> OrderedClasses(Organization masterorg) { if (masterorg == null) throw new Exception("masterorg is null in OrderedClasses"); var cklist = masterorg.OrgPickList.Split(',').Select(oo => oo.ToInt()).ToList(); var list = UserSelectClasses(masterorg).ToList(); var d = new Dictionary<int, int>(); var n = 0; foreach (var i in cklist) d.Add(n++, i); list = (from o in list join i in d on o.OrganizationId equals i.Value into j from i in j orderby i.Key select o).ToList(); return list; }
public static List<ClassInfo> Classes(Organization masterorg, int id) { var q = from o in OrderedClasses(masterorg) let hasroom = (o.ClassFilled ?? false) == false && ((o.Limit ?? 0) == 0 || o.Limit > (o.MemberCount ?? 0)) where o.RegistrationTypeId > 0 select new ClassInfo { Id = o.OrganizationId, Text = ClassName(o), selected = o.OrganizationId == id, filled = !hasroom }; var list = q.ToList(); if (list.Count == 1) return list; list.Insert(0, new ClassInfo { Text = "Registration Options", Id = 0}); return list; }
private static string ClassName(Organization o) { var lead = o.LeaderName; if (lead.HasValue()) lead = ": " + lead; var loc = o.Location; if (loc.HasValue()) loc = $" ({loc})"; var dt1 = o.FirstMeetingDate; var dt2 = o.LastMeetingDate; var dt = ""; if (dt1.HasValue && dt2.HasValue) dt = $", {dt1:MMM d}-{dt2:MMM d}"; else if (dt1.HasValue) dt = $", {dt1:MMM d}"; return o.OrganizationName + lead + dt + loc; }
public static List<OrgPickInfo> OrganizationsFromIdString(Organization Org) { var a = Org.OrgPickList.SplitStr(",").Select(ss => ss.ToInt()).ToArray(); var n = 0; var d = a.ToDictionary(i => n++); var q = (from o in DbUtil.Db.Organizations where a.Contains(o.OrganizationId) select new OrgPickInfo { OrganizationId = o.OrganizationId, OrganizationName = o.OrganizationName }).ToList(); var list = (from op in q join i in d on op.OrganizationId equals i.Value into j from i in j orderby i.Key select op).ToList(); return list; }
public int AddOrganization(string name, int? templateid = null, bool copysettings = true) { using (var db2 = NewDataContext()) { var org = db2.LoadOrganizationById(templateid); if (org == null) { org = new Organization() {DivisionId = 1}; copysettings = false; } var neworg = new Organization { OrganizationName = name, CreatedDate = Util.Now, CreatedBy = Util.UserId1, EntryPointId = org.EntryPointId, OrganizationTypeId = org.OrganizationTypeId, CampusId = org.CampusId, OrganizationStatusId = 30, DivisionId = org.DivisionId, }; db2.Organizations.InsertOnSubmit(neworg); db2.SubmitChanges(); foreach (var div in org.DivOrgs) neworg.DivOrgs.Add(new DivOrg {Organization = neworg, DivId = div.DivId}); if (copysettings && templateid > 0) { foreach (var sc in org.OrgSchedules) neworg.OrgSchedules.Add(new OrgSchedule { OrganizationId = neworg.OrganizationId, AttendCreditId = sc.AttendCreditId, SchedDay = sc.SchedDay, SchedTime = sc.SchedTime, Id = sc.Id }); neworg.CopySettings(db2, templateid.Value); } db2.SubmitChanges(); db.LogActivity($"Python NewOrganization{neworg.OrganizationName} ({neworg.OrganizationId})"); return neworg.OrganizationId; } }
private void Populate() { var i = (from mm in DbUtil.Db.OrganizationMembers where mm.OrganizationId == OrgId && mm.PeopleId == PeopleId select new { mm, mm.Person.Name, mm.Organization.OrganizationName, mm.Organization.RegSetting, mm.Organization, mm.OrgMemMemTags, mm.Organization.IsMissionTrip, ts = DbUtil.Db.ViewTransactionSummaries.SingleOrDefault(tt => tt.RegId == mm.TranId && tt.PeopleId == PeopleId) }).SingleOrDefault(); if (i == null) { throw new Exception("missing OrgMember at oid={0}, pid={1}".Fmt(OrgId, PeopleId)); } om = i.mm; TransactionSummary = i.ts; this.CopyPropertiesFrom(om); Name = i.Name; IsMissionTrip = i.IsMissionTrip ?? false; if (TransactionSummary != null) { AmountPaidTransactions = IsMissionTrip ? om.TotalPaid(DbUtil.Db) : TransactionSummary.IndPaid; AmountDue = IsMissionTrip ? om.AmountDue(DbUtil.Db) : TransactionSummary.IndDue; } OrgName = i.OrganizationName; Organization = i.Organization; OrgMemMemTags = i.OrgMemMemTags.ToList(); Setting = new Settings(i.RegSetting, DbUtil.Db, OrgId ?? 0); }
private void Populate() { if (dopopulate) { dopopulate = false; if (!OrgId.HasValue || !PeopleId.HasValue) return; } var i = (from mm in DbUtil.Db.OrganizationMembers where mm.OrganizationId == OrgId && mm.PeopleId == PeopleId select new { mm, mm.Person.Name, mm.Organization.OrganizationName, mm.Organization, mm.OrgMemMemTags, mm.Organization.IsMissionTrip, ts = DbUtil.Db.ViewTransactionSummaries.SingleOrDefault(tt => tt.RegId == mm.TranId && tt.PeopleId == PeopleId && tt.OrganizationId == OrgId) }).SingleOrDefault(); if (i == null) throw new Exception($"missing OrgMember at oid={OrgId}, pid={PeopleId}"); OrgMember = i.mm; TransactionSummary = i.ts; this.CopyPropertiesFrom(OrgMember); Name = i.Name; IsMissionTrip = i.IsMissionTrip ?? false; AmtFee = i.ts?.IndPaid + i.ts?.IndDue; AmtDonation = i.ts?.IndAmt - AmtFee; AmtCoupon = i.ts?.TotCoupon; AmtPaid = OrgMember.AmountPaidTransactions(DbUtil.Db); AmtDue = OrgMember.AmountDueTransactions(DbUtil.Db); OrgName = i.OrganizationName; Organization = i.Organization; OrgMemMemTags = i.OrgMemMemTags.ToList(); Setting = DbUtil.Db.CreateRegistrationSettings(OrgId ?? 0); }
public int AddOrganization(string name, string program, string division) { using (var db2 = NewDataContext()) { var prog = Organization.FetchOrCreateProgram(db2, program); var div = Organization.FetchOrCreateDivision(db2, prog, division); var neworg = new Organization { OrganizationName = name, CreatedDate = Util.Now, CreatedBy = Util.UserId1, OrganizationStatusId = 30, DivisionId = div.Id, }; db2.Organizations.InsertOnSubmit(neworg); db2.SubmitChanges(); neworg.DivOrgs.Add(new DivOrg() {Organization = neworg, DivId = div.Id}); db2.SubmitChanges(); db.LogActivity($"Python AddOrganization({neworg.OrganizationName}, {program}, {division})"); return neworg.OrganizationId; } }
public void populateFromOrg(Organization org) { var leader = (from e in DbUtil.Db.People where e.PeopleId == org.LeaderId select e).SingleOrDefault(); values["SGF:OrgID"] = org.OrganizationId.ToString(); values["SGF:Name"] = org.OrganizationName; values["SGF:Description"] = org.Description; values["SGF:Room"] = org.Location; values["SGF:Leader"] = org.LeaderName; values["SGF:DateStamp"] = DateTime.Now.ToString("yyyy-MM-dd"); values["SGF:Schedule"] = ""; if (leader != null && leader.PictureId != null) values["SGF:LeaderPicSrc"] = "/Portrait/" + leader.Picture.SmallId.Value + "?v=" + DateTime.Now.ToString("yyyyMMddHHmmssffff"); else values["SGF:LeaderPicSrc"] = "/Portrait/-3"; if (org.OrgSchedules.Count > 0) { int count = 0; foreach (var schedule in org.OrgSchedules) { if (count > 0) values["SGF:Schedule"] += "; "; values["SGF:Schedule"] += DAY_LAST[schedule.SchedDay ?? 0] + ", " + schedule.SchedTime.ToString2("t"); ; count++; } } foreach (var extra in org.OrganizationExtras) { if (extra.Field.StartsWith("SGF:")) values[extra.Field] = extra.Data; } }
private void Populate() { if (dopopulate) { dopopulate = false; if (!OrgId.HasValue || !PeopleId.HasValue) return; } var i = (from et in DbUtil.Db.EnrollmentTransactions where et.OrganizationId == OrgId && et.PeopleId == PeopleId where et.TransactionTypeId == 5 orderby et.TransactionDate descending select new { et, et.Person.Name, et.Organization.OrganizationName, et.Organization, et.SmallGroups, ts = DbUtil.Db.ViewTransactionSummaries.SingleOrDefault( ts => ts.RegId == et.TranId && ts.PeopleId == PeopleId && ts.OrganizationId == OrgId) } ).FirstOrDefault(); if (i == null) throw new Exception($"missing PrevOrgMember at oid={OrgId}, pid={PeopleId}"); PrevMember = i.et; TransactionSummary = i.ts; this.CopyPropertiesFrom(PrevMember); Name = i.Name; AmtFee = i.ts?.IndPaid + i.ts?.IndDue; AmtDonation = i.ts?.IndAmt - AmtFee; AmtCoupon = i.ts?.TotCoupon; OrgName = i.OrganizationName; Organization = i.Organization; OrgMemMemTags = i.SmallGroups.SplitStr("\n").ToList(); Setting = DbUtil.Db.CreateRegistrationSettings(OrgId ?? 0); }
private void detach_Organizations(Organization entity) { this.SendPropertyChanging(); entity.Campu = null; }
public static List<SelectListItem> ShirtSizes(CMSDataContext Db, Organization org) { var setting = new Settings(org.RegSetting, Db, org.OrganizationId); return ShirtSizes(setting); }
private void attach_Organizations(Organization entity) { this.SendPropertyChanging(); entity.OrganizationType = this; }
public Organization CloneOrg(CMSDataContext Db, int? DivisionId) { var neworg = new Organization { SecurityTypeId = SecurityTypeId, CreatedDate = Util.Now, CreatedBy = Util.UserId1, LeaderMemberTypeId = LeaderMemberTypeId, OrganizationName = OrganizationName + " (copy)", OrganizationStatusId = OrganizationStatusId, CampusId = CampusId, IsBibleFellowshipOrg = IsBibleFellowshipOrg, }; Db.Organizations.InsertOnSubmit(neworg); foreach (var div in DivOrgs) neworg.DivOrgs.Add(new DivOrg { Organization = neworg, DivId = div.DivId }); foreach (var sc in OrgSchedules) neworg.OrgSchedules.Add(new OrgSchedule { OrganizationId = OrganizationId, AttendCreditId = sc.AttendCreditId, SchedDay = sc.SchedDay, SchedTime = sc.SchedTime, Id = sc.Id }); CopySettings2(this, neworg); Db.SubmitChanges(); return neworg; }
private void detach_Organizations(Organization entity) { this.SendPropertyChanging(); entity.EntryPoint = null; }
private void attach_Organizations(Organization entity) { this.SendPropertyChanging(); entity.EntryPoint = this; }
public static IEnumerable<SelectListItem> ShirtSizes(CMSDataContext Db, Organization org) { var setting = Db.CreateRegistrationSettings(org.OrganizationId); return ShirtSizes(setting); }
private void attach_Organizations(Organization entity) { this.SendPropertyChanging(); entity.Campu = this; }
private void detach_Organizations(Organization entity) { this.SendPropertyChanging(); entity.Division = null; }
private void detach_ChildOrgs(Organization entity) { this.SendPropertyChanging(); entity.ParentOrg = null; }
private bool IsEnded(Organization o) { if (o != null) return o.ClassFilled == true; return false; }