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); }
public SelectList MemberStatusCodes() { return(new SelectList(cv.MemberStatusCodes0(), "Id", "Value", m.memberstatus)); }
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); }