public static BasicPersonInfo GetBasicPersonInfo(int?id) { var cv = new CodeValueModel(); var p = DbUtil.Db.LoadPersonById(id.Value); var pi = new BasicPersonInfo { Age = p.Age.ToString(), Birthday = p.DOB, CampusId = p.CampusId ?? 0, Mobile = p.CellPhone.FmtFone(), DeceasedDate = p.DeceasedDate, DoNotCallFlag = p.DoNotCallFlag, DoNotMailFlag = p.DoNotMailFlag, DoNotVisitFlag = p.DoNotVisitFlag, DoNotPublishPhones = p.DoNotPublishPhones ?? false, PrimaryEmail = new EmailInfo(p.EmailAddress, p.SendEmailAddress1 ?? true), AltEmail = new EmailInfo(p.EmailAddress2, p.SendEmailAddress2 ?? false), Employer = p.EmployerOther, FirstName = p.FirstName, Created = p.CreatedDate, Grade = p.Grade.ToString(), HomePhone = p.Family.HomePhone.FmtFone(), JoinDate = p.JoinDate, LastName = p.LastName, AltName = p.AltName, FormerName = p.MaidenName, Gender = new CodeInfo(p.GenderId, cv.GenderCodesWithUnspecified()), Marital = new CodeInfo(p.MaritalStatusId, cv.MaritalStatusCodes99()), MemberStatus = new CodeInfo(p.MemberStatusId, cv.MemberStatusCodes0()), FamilyPosition = new CodeInfo(p.PositionInFamilyId, cv.FamilyPositionCodes()), MiddleName = p.MiddleName, GoesBy = p.NickName, Occupation = p.OccupationOther, PeopleId = p.PeopleId, School = p.SchoolOther, Spouse = p.SpouseName(DbUtil.Db), Suffix = p.SuffixCode, Title = new CodeInfo(p.TitleCode, cv.TitleCodes(), "Value"), WeddingDate = p.WeddingDate.FormatDate(), Work = p.WorkPhone.FmtFone(), ReceiveSMS = p.ReceiveSMS, }; pi.person = p; return(pi); }
private static void UpdatePeople(DbConnection cn, CMSDataContext Db, int userPeopleId) { var cv = new CodeValueModel(); var pcmd = cn.CreateCommand(); pcmd.CommandText = "select * from [Sheet1$]"; var rd = pcmd.ExecuteReader(); while (rd.Read()) { var i = Util.GetAs(rd, typeof(UpdatePeopleItem)) as UpdatePeopleItem; var p = Db.LoadPersonById(i.PeopleId); //var psb = new StringBuilder(); var psb = new List <ChangeDetail>(); p.UpdateValue(psb, "TitleCode", i.Title); p.UpdateValue(psb, "FirstName", i.First); p.UpdateValue(psb, "NickName", i.GoesBy); p.UpdateValue(psb, "LastName", i.Last); p.UpdateValue(psb, "SuffixCode", i.Suffix); p.UpdateValue(psb, "EmailAddress", i.Email1); p.UpdateValue(psb, "EmailAddress2", i.Email2); p.UpdateValue(psb, "DOB", i.BirthDate.FormatDate()); p.UpdateValue(psb, "WeddingDate", i.Anniversary); p.UpdateValue(psb, "JoinDate", i.Joined); p.UpdateValue(psb, "CellPhone", i.Cell.GetDigits()); p.UpdateValue(psb, "WorkPhone", i.Work.GetDigits()); p.UpdateValue(psb, "AltName", i.AltName); p.UpdateValue(psb, "SchoolOther", i.School); p.UpdateValue(psb, "OccupationOther", i.Occupation); p.UpdateValue(psb, "EmployerOther", i.Employer); p.UpdateValue(psb, "Grade", i.Grade); p.UpdateValue(psb, "DeceasedDate", i.Deceased); p.UpdateValue(psb, "MemberStatusId", CviOrNull(cv.MemberStatusCodes().SingleOrDefault(c => c.Value == i.Member)) ?? 20); p.UpdateValue(psb, "GenderId", CviOrNull(cv.GenderCodes().SingleOrDefault(c => c.Value == i.Gender)) ?? 0); p.UpdateValue(psb, "MaritalStatusId", CviOrNull(cv.MaritalStatusCodes().SingleOrDefault(c => c.Value == i.Marital)) ?? 0); p.UpdateValue(psb, "PositionInFamilyId", CviOrNull(cv.FamilyPositionCodes().SingleOrDefault(c => c.Value == i.FamilyPos)) ?? 0); p.UpdateValue(psb, "CampusId", CviOrNull(cv.AllCampuses().SingleOrDefault(c => c.Value == i.Campus))); p.LogChanges(Db, psb); Db.SubmitChanges(); } }
public IEnumerable<TitleItems> TitleItems() { var Model = new CodeValueModel(); return new List<TitleItems> { new TitleItems { title = "Member Status Codes", items = Model.MemberStatusCodes() }, new TitleItems { title = "Drop Type Codes", items = Model.DropTypes() }, new TitleItems { title = "Baptism Status Codes", items = Model.BaptismStatuses() }, new TitleItems { title = "Baptism Type Codes", items = Model.BaptismTypes() }, new TitleItems { title = "Campus Codes", items = Model.AllCampuses() }, new TitleItems { title = "Marital Status Codes", items = Model.MaritalStatusCodes() }, new TitleItems { title = "Gender Codes", items = Model.GenderCodes() }, new TitleItems { title = "Family Position Codes", items = Model.FamilyPositionCodes() }, new TitleItems { title = "Contribution Statement Options", items = Model.EnvelopeOptions() }, new TitleItems { title = "Envelope Options", items = Model.EnvelopeOptions() }, new TitleItems { title = "Entry Point Codes", items = Model.EntryPoints() }, new TitleItems { title = "New Member Class", items = Model.NewMemberClassStatusCodes() }, new TitleItems { title = "Approval Codes (negative to remove, 0 to remove all)", items = Model.VolunteerCodes() }, }; }
public static PersonInfo GetPersonInfo(int?id) { var cv = new CodeValueModel(); var flags = DbUtil.Db.Setting("StatusFlags", "F04,F01,F02,F03"); var i = (from pp in DbUtil.Db.People let spouse = (from sp in pp.Family.People where sp.PeopleId == pp.SpouseId select sp.Name).SingleOrDefault() let statusflags = DbUtil.Db.StatusFlags(flags).Single(sf => sf.PeopleId == id).StatusFlags where pp.PeopleId == id select new { pp, f = pp.Family, spouse = spouse, pp.Picture, statusflags, }).FirstOrDefault(); if (i == null) { return(null); } var p = i.pp; var fam = i.f; var pi = new PersonInfo { PeopleId = p.PeopleId, AddressTypeId = p.AddressTypeId, Deceased = p.IsDeceased ?? false, FamilyId = p.FamilyId, Name = p.Name, Picture = i.Picture, SpouseId = p.SpouseId, StatusFlags = (i.statusflags ?? "").Split(','), member = new MemberInfo { PeopleId = p.PeopleId, BaptismSchedDate = p.BaptismSchedDate, BaptismTypeId = p.BaptismTypeId ?? 0, BaptismStatusId = p.BaptismStatusId ?? 0, BaptismDate = p.BaptismDate, DecisionDate = p.DecisionDate, DecisionTypeId = p.DecisionTypeId ?? 0, DropDate = p.DropDate, DropTypeId = p.DropCodeId, EnvelopeOptionId = p.EnvelopeOptionsId ?? 0, StatementOptionId = p.ContributionOptionsId ?? 0, JoinTypeId = p.JoinCodeId, NewChurch = p.OtherNewChurch, PrevChurch = p.OtherPreviousChurch, NewMemberClassDate = p.NewMemberClassDate, NewMemberClassStatusId = p.NewMemberClassStatusId ?? 0, MemberStatusId = p.MemberStatusId, JoinDate = p.JoinDate, }, basic = new BasicPersonInfo { PeopleId = p.PeopleId, person = p, Age = p.Age.ToString(), Birthday = p.DOB, CampusId = p.CampusId ?? 0, Mobile = p.CellPhone.FmtFone(), DeceasedDate = p.DeceasedDate, DoNotCallFlag = p.DoNotCallFlag, DoNotMailFlag = p.DoNotMailFlag, DoNotVisitFlag = p.DoNotVisitFlag, PrimaryEmail = new EmailInfo(p.EmailAddress, p.SendEmailAddress1 ?? true), AltEmail = new EmailInfo(p.EmailAddress2, p.SendEmailAddress2 ?? false), Gender = new CodeInfo(p.GenderId, cv.GenderCodesWithUnspecified()), Marital = new CodeInfo(p.MaritalStatusId, cv.MaritalStatusCodes99()), MemberStatus = new CodeInfo(p.MemberStatusId, cv.MemberStatusCodes0()), FamilyPosition = new CodeInfo(p.PositionInFamilyId, cv.FamilyPositionCodes()), Employer = p.EmployerOther, FirstName = p.FirstName, Created = p.CreatedDate, Grade = p.Grade.ToString(), HomePhone = p.Family.HomePhone, JoinDate = p.JoinDate, LastName = p.LastName, AltName = p.AltName, FormerName = p.MaidenName, MemberStatusId = p.MemberStatusId, MiddleName = p.MiddleName, GoesBy = p.NickName, Occupation = p.OccupationOther, School = p.SchoolOther, Spouse = i.spouse, Suffix = p.SuffixCode, Title = new CodeInfo(p.TitleCode, cv.TitleCodes(), "Value"), WeddingDate = p.WeddingDate.FormatDate(), Work = p.WorkPhone.FmtFone(), ReceiveSMS = p.ReceiveSMS, }, growth = new GrowthInfo { PeopleId = p.PeopleId, InterestPointId = p.InterestPointId ?? 0, OriginId = p.OriginId ?? 0, EntryPointId = p.EntryPointId ?? 0, ChristAsSavior = p.ChristAsSavior, Comments = p.Comments, InterestedInJoining = p.InterestedInJoining, MemberAnyChurch = p.MemberAnyChurch, PleaseVisit = p.PleaseVisit, SendInfo = p.InfoBecomeAChristian, }, membernotes = new MemberNotesInfo { PeopleId = p.PeopleId, LetterStatusId = p.LetterStatusId ?? 0, LetterReceived = p.LetterDateReceived, LetterRequested = p.LetterDateRequested, LetterNotes = p.LetterStatusNotes, }, FamilyAddr = new AddressInfo { Name = "FamilyAddr", PeopleId = p.PeopleId, person = p, Address1 = fam.AddressLineOne, Address2 = fam.AddressLineTwo, City = fam.CityName, Zip = fam.ZipCode, BadAddress = fam.BadAddressFlag, State = new CodeInfo(fam.StateCode, AddressInfo.StateCodes()), Country = new CodeInfo(fam.CountryName, AddressInfo.Countries()), ResCode = new CodeInfo(fam.ResCodeId, AddressInfo.ResCodes()), FromDt = fam.AddressFromDate, ToDt = fam.AddressToDate, Preferred = p.AddressTypeId == 10, }, PersonalAddr = new AddressInfo { Name = "PersonalAddr", PeopleId = p.PeopleId, person = p, Address1 = p.AddressLineOne, Address2 = p.AddressLineTwo, City = p.CityName, State = new CodeInfo(p.StateCode, AddressInfo.StateCodes()), Country = new CodeInfo(p.CountryName, AddressInfo.Countries()), ResCode = new CodeInfo(p.ResCodeId, AddressInfo.ResCodes()), Zip = p.ZipCode, BadAddress = p.BadAddressFlag, FromDt = p.AddressFromDate, ToDt = p.AddressToDate, Preferred = p.AddressTypeId == 30, }, //familymembers = i.familymembers }; return(pi); }
public IEnumerable <TitleItems> FetchTitleItems() { var Model = new CodeValueModel(); return(new List <TitleItems> { new TitleItems { title = "Approval Codes", Instructions = "(negative to remove, 0 to remove all)", items = Model.VolunteerCodes() }, new TitleItems { title = "Baptism Status Codes", items = Model.BaptismStatusList() }, new TitleItems { title = "Baptism Type Codes", items = Model.BaptismTypeList() }, new TitleItems { title = "Bad Address Flag", items = BadAddressFlag(), UseCode = true }, new TitleItems { title = "Campus Codes", items = Model.AllCampuses() }, new TitleItems { title = "Contribution Statement Options", items = Model.EnvelopeOptionList() }, new TitleItems { title = "Decision Type Codes", items = Model.DecisionTypeList() }, new TitleItems { title = "Do Not Mail", items = DoNotMail(), UseCode = true }, new TitleItems { title = "Drop Type Codes", items = Model.DropTypeList() }, new TitleItems { title = "Envelope Options", items = Model.EnvelopeOptionList() }, new TitleItems { title = "Entry Point Codes", items = Model.EntryPoints() }, new TitleItems { title = "Family Position Codes", items = Model.FamilyPositionCodes() }, new TitleItems { title = "Gender Codes", items = Model.GenderCodes() }, new TitleItems { title = "Grades", items = Grades(), UseCode = true }, new TitleItems { title = "Join Type Codes", items = Model.JoinTypeList() }, new TitleItems { title = "Marital Status Codes", items = Model.MaritalStatusCodes() }, new TitleItems { title = "Member Status Codes", items = Model.MemberStatusCodes() }, new TitleItems { title = "New Member Class", items = Model.NewMemberClassStatusList() }, new TitleItems { title = "Receive SMS", items = ReceiveSMS(), UseCode = true }, }); }
public static IEnumerable <CodeValueItem> Fetch(string field, ref bool useCode) { IEnumerable <CodeValueItem> m = null; var lookups = new CodeValueModel(); switch (field) { case "Approval Codes": m = lookups.VolunteerCodes(); break; case "Baptism Status": m = lookups.BaptismStatusList(); break; case "Baptism Type": m = lookups.BaptismTypeList(); break; case "Bad Address Flag": m = UpdateFieldsModel.BadAddressFlag(); useCode = true; break; case "Campus": m = lookups.AllCampuses(); break; case "Statement Options": m = lookups.EnvelopeOptionList(); break; case "Electronic Statement": m = UpdateFieldsModel.ElectronicStatement(); useCode = true; break; case "Decision Type": m = lookups.DecisionTypeList(); break; case "Do Not Call": m = UpdateFieldsModel.DoNotCall(); useCode = true; break; case "Do Not Mail": m = UpdateFieldsModel.DoNotMail(); useCode = true; break; case "Drop Type": m = lookups.DropTypeList(); break; case "Envelope Options": m = lookups.EnvelopeOptionList(); break; case "Entry Point": m = lookups.EntryPoints(); useCode = false; break; case "Family Position": m = lookups.FamilyPositionCodes(); break; case "Gender": m = lookups.GenderCodes(); break; case "Grade": m = UpdateFieldsModel.Grades(); useCode = true; break; case "Join Type": m = lookups.JoinTypeList(); break; case "Marital Status": m = lookups.MaritalStatusCodes(); break; case "Member Status": m = lookups.MemberStatusCodes(); break; case "New Member Class": m = lookups.NewMemberClassStatusList(); break; case "ReceiveSMS": m = UpdateFieldsModel.ReceiveSMS(); useCode = true; break; } return(m); }