public IHttpActionResult Get(int memberId, int familyId) { using (bkContext context = new bkContext()) { Member member = context.Members.Where(x => x.MemberID == memberId).FirstOrDefault(); if (member == null) { return(BadRequest("Your record cannot be loaded. Please try again or contact Administrator for help")); } List <FamilyMemberAssociation> fmAssociation = context.FamilyMemberAssociations.Where(x => x.FamilyId == familyId).ToList(); MemberViewModel vm = new MemberViewModel(); vm.MemberID = member.MemberID; vm.FirstName = member.FirstName; vm.LastName = member.LastName; vm.NickName = member.NickName; vm.Email = member.EmailAddress; vm.PhoneNumber = member.Phone; vm.Gender = member.Gender; vm.DOB = member.DOB; vm.BirthPlace = member.BirthPlace; vm.Alive = member.Alive; vm.DOD = member.DOD; vm.DeathPlace = member.DeathPlace; vm.EducationLevel = member.EducationLevel; vm.EducationField = member.EducationField; vm.OccupationId = member.OccupationID; vm.CompanyName = member.CompanyName; vm.JobTitle = member.JobTitle; vm.InstagramHandle = member.InstagramHandle; vm.FacebookHandle = member.FacebookHandle; vm.TwitterHandle = member.TwitterHandle; vm.MaritalStatusId = member.MaritalStatusID; vm.Anniversary = member.Anniversary; vm.PhotoUrl = MemberWrapper.ProfilePhoto(member.MemberID, member.Gender, member.ModifiedOn); vm.ModifiedOn = member.ModifiedOn.HasValue ? member.ModifiedOn : member.CreatedOn; vm.ProfileText = member.ProfileText; GetMaternalFamily_Result mResult = context.GetMaternalFamily(member.MemberID).FirstOrDefault(); if (mResult != null) { vm.MaternalFamilyId = mResult.MaternalFamilyID; vm.MaternalFamilyName = string.Format("{0}, {1}", mResult.MaternalFamilyName, mResult.MaternalFamilyAddress); } GetPaternalFamily_Result pResult = context.GetPaternalFamily(member.MemberID, member.Gender, member.MaritalStatusID).FirstOrDefault(); if (pResult != null) { vm.PaternalFamilyId = pResult.PaternalFamilyID; vm.PaternalFamilyName = string.Format("{0}, {1}", pResult.PaternalFamilyName, pResult.PaternalFamilyAddress); } FamilyMemberAssociation fma = fmAssociation.FirstOrDefault(x => x.MemberId == memberId); if (fma != null) { vm.RelatedMemberId = fma.RelatedId; vm.RelationTypeId = fma.RelationTypeId; vm.DefaultFamily = fma.DefaultFamily; } vm.canEdit = CanEditMember(fmAssociation, memberId); return(Ok(vm)); } }