private static Encntr_Plan_Reltn LoadEncPlans(DataRow row) { Encntr_Plan_Reltn plan = new Encntr_Plan_Reltn(); plan.InsuranceCode = row["health_plan_id"].ToString().Trim(); plan.InsuranceName = Health_PlanDAL.HealthPlanName(row["health_plan_id"].ToString().Trim()).Trim(); plan.Address = AddressDAL.GetAddress_Org(row["organization_id"].ToString().Trim()); plan.InsurancePhone = PhoneDAL.GetWorkPhoneOrganization(row["organization_id"].ToString().Trim()); plan.GroupName = row["group_name"].ToString().Trim(); plan.GroupNbr = row["group_nbr"].ToString().Trim(); plan.SequenceNbr = row["priority_seq"].ToString().Trim(); plan.PolicyNbr = row["policy_nbr"].ToString().Trim(); plan.SubscriberPhone = PhoneDAL.GetHomePhone(row["person_id"].ToString().Trim()); plan.SubscriberAddress = AddressDAL.GetHomeAddress(row["person_id"].ToString().Trim()); plan.EffectiveDate = row["Beg_Effective_Dt_Tm"].ToString().Trim(); plan.SubscriberPerson = PersonDAL.GetPerson(row["person_id"].ToString().Trim()); plan.SubPolicyNbr = "";// row["subs_member_nbr"].ToString().Trim(); plan.SubscriberEmailAddress = AddressDAL.GetEmailAddress(row["person_id"].ToString().Trim()); plan.StatusDate = row["verify_dt_tm"].ToString().Trim(); plan.InsEligibilitySts = row["verify_status_cd"].ToString().Trim(); plan.Relationship = PersonPersonReltDAL.GetRelationship(row["person_id"].ToString().Trim()); plan.CoverageNbr = row["member_nbr"].ToString().Trim(); plan.Authorizations = AuthorizationDAL.GetAuthorizations(row["encntr_id"].ToString().Trim(), row["health_plan_id"].ToString().Trim(), 1); return(plan); }
private static Person LoadPersons(DataRow row) { string personId = row["related_person_id"].ToString(); string relationship = CernerCommon.StripDecimalsForMap(row["related_person_reltn_cd"].ToString()); Person person = PersonDAL.GetPerson(personId); if (person != null) { person.Cerner_Relationship = CodeValueDAL.GetCodeValueDisplay(relationship); person.RelationShip = CernerMapDAL.GetMap("CERNER_RELATIONSHIP", relationship, relationship); } return(person); }
private static List <Person> LoadPersons(DataTable dt) { List <Person> persons = new List <Person>(); foreach (DataRow row in dt.Rows) { string personId = row["related_person_id"].ToString(); string relationship = CernerCommon.StripDecimalsForMap(row["related_person_reltn_cd"].ToString()); Person person = PersonDAL.GetPerson(personId); if (person != null) { person.Cerner_Relationship = CodeValueDAL.GetCodeValueDisplay(relationship); person.RelationShip = CernerMapDAL.GetMap("CERNER_RELATIONSHIP", relationship, relationship); persons.Add(person); } } return(persons); }