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 Employer LoadEmpData(DataTable dt)
{
Employer emp = new Employer();
foreach (DataRow row in dt.Rows)
{
string orgId = row["Organization_ID"].ToString() + ".0000";
emp.EmploymentStatus = row["EMPL_STATUS_CD"].ToString().Replace(".0000", "");
emp.Occupation = row["EMPL_TITLE"].ToString();
emp.EmployerName = OrganizationDAL.GetOrganizationName(orgId);
emp.WorkAddress = AddressDAL.GetAddress_Org(orgId);
emp.EmployerPhone = PhoneDAL.GetWorkPhoneOrganization(orgId);
emp.EmployeeID = "";
}
return(emp);
}
private static Employer LoadEmpData(DataTable dt)
{
Employer emp = new Employer();
foreach (DataRow row in dt.Rows)
{
string orgId = row["Organization_ID"].ToString();
string workpos = row["EMPL_OCCUPATION_TEXT"].ToString();
if (workpos == "null")
{
workpos = "";
}
emp.EmploymentStatus = row["EMPL_STATUS_CD"].ToString();
emp.Occupation = workpos;
emp.EmployerName = OrganizationDAL.GetOrganizationName(orgId);
emp.WorkAddress = AddressDAL.GetAddress_Org(orgId);
emp.EmployerPhone = PhoneDAL.GetWorkPhoneOrganization(orgId);
emp.EmployeeID = "";
}
return(emp);
}