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);
}
