コード例 #1
0
ファイル: PersonModel.cs プロジェクト: rossspoon/bvcms
        public PersonModel(int id)
        {
            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,
                         pp.Picture,
                         statusflags,
                     }).FirstOrDefault();
            if (i == null)
                return;

            Person = i.pp;
            var p = Person;
            var fam = i.f;

            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,
                Mobile = new CellPhoneInfo(p.CellPhone.FmtFone(), p.ReceiveSMS),
                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),
                Campus = new CodeInfo(p.CampusId, "Campus"),
                Gender = new CodeInfo(p.GenderId, "Gender"),
                Marital = new CodeInfo(p.MaritalStatusId, "Marital"),
                MemberStatus = new CodeInfo(p.MemberStatusId, "MemberStatus"),
                FamilyPosition = new CodeInfo(p.PositionInFamilyId, "FamilyPosition"),
                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, "Title"),
                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, "State"),
                Country = new CodeInfo(fam.CountryName, "Country"),
                ResCode = new CodeInfo(fam.ResCodeId, "ResCode"),
                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, "State"),
                Country = new CodeInfo(p.CountryName, "Country"),
                ResCode = new CodeInfo(p.ResCodeId, "ResCode"),
                Zip = p.ZipCode,
                BadAddress = p.BadAddressFlag,
                FromDt = p.AddressFromDate,
                ToDt = p.AddressToDate,
                Preferred = p.AddressTypeId == 30,
            };
        }
コード例 #2
0
ファイル: BasicPersonInfo.cs プロジェクト: rossspoon/bvcms
 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,
         Campus = new CodeInfo(p.CampusId, "Campus"),
         Mobile = new CellPhoneInfo(p.CellPhone.FmtFone(), p.ReceiveSMS),
         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, "Gender"),
         Marital = new CodeInfo(p.MaritalStatusId, "Marital"),
         MemberStatus = new CodeInfo(p.MemberStatusId, "MemberStatus"),
         FamilyPosition = new CodeInfo(p.PositionInFamilyId, "FamilyPosition"),
         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, "Title"),
         WeddingDate = p.WeddingDate.FormatDate(),
         Work = p.WorkPhone.FmtFone(),
         ReceiveSMS = p.ReceiveSMS,
     };
     pi.person = p;
     return pi;
 }