public static string GetPrimaryCarePhysician(string personId) { if (personId.Contains(".0000") == false) { personId = personId + ".0000"; } string today = DateTime.Today.ToString("yyyy-MM-dd"); StringBuilder sb = new StringBuilder(); sb.Append("SELECT Prsnl_Person_Id, Person_Prsnl_R_Cd "); sb.Append("FROM PERSON_PRSNL_RELTN "); sb.Append("WHERE Person_Id = '" + personId + "' "); sb.Append("AND Person_Prsnl_R_Cd = '1115.0000' "); sb.Append("AND active_ind = '1.0000' "); //sb.Append("AND end_effective_dt_tm > '" + today + "' "); DataTable dt = new DataTable(); using (var conn = new SqlConnection(GlobalSettings.SqlConnectionString())) using (var cmd = new SqlCommand(sb.ToString(), conn)) using (var da = new SqlDataAdapter(cmd)) { cmd.CommandType = CommandType.Text; da.Fill(dt); } string result = string.Empty; if (dt.Rows.Count > 0) { string physCode = EncntrPrsnlReltnDAL.GetAttendPhysician(dt.Rows[0]["Prsnl_Person_Id"].ToString()); result = CernerMapDAL.GetMap("CERNER_PROVIDER", physCode, "Z.CONVPROV"); } return(result); }
public static string GetPrimaryCarePhysician(string personId) { DateTime todayDt = DateTime.Today; StringBuilder sb = new StringBuilder(); sb.Append("SELECT Prsnl_Person_Id, Person_Prsnl_R_Cd "); sb.Append("FROM BAR_PERSON_PRSNL_RELTN "); sb.Append("WHERE Person_Id = " + long.Parse(personId) + " "); sb.Append("AND Person_Prsnl_R_Cd = '1115' "); sb.Append("AND active_ind = '1' "); sb.Append("AND END_EFFECTIVE_DT_TM > '" + todayDt + "'"); DataTable dt = new DataTable(); using (var conn = new SqlConnection(GlobalSettings.SqlConnectionString())) using (var cmd = new SqlCommand(sb.ToString(), conn)) using (var da = new SqlDataAdapter(cmd)) { cmd.CommandType = CommandType.Text; da.Fill(dt); } string result = string.Empty; if (dt.Rows.Count > 0) { string physCode = EncntrPrsnlReltnDAL.GetAttendPhysician(dt.Rows[0]["Prsnl_Person_Id"].ToString()); result = CernerMapDAL.GetMap("CERNER_PROVIDER", physCode, "Z.CONVPROV"); } dt.Dispose(); return(result); }
private static Encounter LoadEncounter(DataRow row) { string npi = ""; Encounter encounter = new Encounter(); encounter.Active_Ind = row["Active_Ind"].ToString().Replace(".0000", ""); string dischDisp = CernerCommon.StripDecimalsForMap(row["Disch_Disposition_Cd"].ToString()); encounter.Disch_Disposition_Cd = CernerMapDAL.GetMap("CERNER_DISCHARGE_DISPOSITION", dischDisp, dischDisp); encounter.Cerner_Disch_Disposition_Cd_Display = CodeValueDAL.GetCodeValueDisplay(dischDisp); encounter.Disch_Dt_Tm = row["Disch_Dt_Tm"].ToString(); encounter.Encntr_type_class_cd = row["Encntr_type_class_cd"].ToString().Replace(".0000", ""); encounter.Original_Encounter_Id = row["Encntr_Id"].ToString().Replace(".0000", ""); string encntrId = Encounter_AliasDAL.GetEncounterVisitNumber(row["Encntr_Id"].ToString().Replace(".0000", "")); encounter.Encounter_Id = encntrId; string encounterTypeCd = CernerCommon.StripDecimalsForMap(row["Encntr_Type_Cd"].ToString()); encounter.Cerner_Encoutner_Type_Cd = encounterTypeCd; //used for special logic in mpi conversion record 02 encounter.Cerner_Encounter_Type_Cd_Display = CodeValueDAL.GetCodeValueDisplay(encounterTypeCd); //for data sheet encounter.Encounter_Type_Cd = CernerMapDAL.GetMap("CERNER_REGTYPE", encounterTypeCd, encounterTypeCd); encounter.Inpatient_Admit_Dt_Tm = row["Inpatient_Admit_Dt_Tm"].ToString(); //From Encounter Table use field E_LOC_NURSE_UNIT_CD to retrieve the DISPLAY_KEY (col E) in CodeSet 220. //Use the DISPLAY_KEY to retrieve the Meditech location from the spreadsheet - "Approved locations" string loc = CodeValueDAL.GetCodeValueDisplay_Key(row["Loc_Nurse_Unit_Cd"].ToString().Replace(".0000", "")); encounter.Cerner_Loc_Nurse_Unit_Cd_Display = loc; //for data sheet encounter.Loc_Nurse_Unit_Cd = CernerMapDAL.GetMap("CERNER_LOCATION", loc, loc); //string attendPhys = EncntrPrsnlReltnDAL.GetAttendPhysician(row["Encntr_Id"].ToString()); encounter.AttendPhysicianId = ""; //attendPhys; //MPIOrganization org = MPIOrganizationDAL.GetOrganization(CernerCommon.StripDecimalsForMap(encounter.Organization_Id)); //npi = PrsnlAliasDAL.GetPrsnlAlias(attendPhys); encounter.AttendPhysician = "";//CernerMapDAL.GetMapDR(npi, facility, "Z.CONVPROV"); encounter.Person_Id = row["Person_Id"].ToString().Replace(".0000", ""); encounter.Reason_For_Visit = row["Reason_For_Visit"].ToString(); encounter.Reg_Dt_Tm = row["Reg_Dt_Tm"].ToString(); encounter.ConfidentialVisit = row["confid_level_cd"].ToString(); encounter.VIP_Cd = row["vip_cd"].ToString().Replace(".0000", ""); encounter.Organization_Id = row["organization_id"].ToString().Replace(".0000", ""); encounter.Med_Serv_Cd = row["med_service_cd"].ToString().Replace(".0000", ""); //DateTime? d = GMTtoTZ(encounter.Disch_Dt_Tm, "Mountain Standard Time"); //for BAR encounter.BAR_Encounter_Type_Cd = CernerMapDAL.GetMap("CERNER_REGTYPE", encounterTypeCd, encounterTypeCd); encounter.Admit_Src_Cd = row["admit_src_cd"].ToString().Replace(".0000", ""); encounter.Admit_Type_Cd = row["admit_type_cd"].ToString().Replace(".0000", ""); return(encounter); }
private static Person LoadPerson(DataRow row) { Person person = new Person(); person.PersonId = row["Person_Id"].ToString(); person.Birth_Dt_Tm = row["Birth_Dt_Tm"].ToString(); person.Deceased_Dt_Tm = row["Deceased_Dt_Tm"].ToString(); person.Deceased_Tz = row["Deceased_Tz"].ToString(); string languageCd = CernerCommon.StripDecimalsForMap(row["Language_Cd"].ToString()); person.Language_Cd = CernerMapDAL.GetMap("CERNER_LANGUAGE", languageCd, languageCd); string maritalStatus = CernerCommon.StripDecimalsForMap(row["Marital_Type_Cd"].ToString()); person.Marital_Type_Cd = CernerMapDAL.GetMap("CERNER_MARITALSTATUS", maritalStatus, maritalStatus); person.Mother_Maiden_Name = row["Mother_Maiden_Name"].ToString(); person.Name_Full_Formatted = row["Name_Full_Formatted"].ToString(); string raceCd = CernerCommon.StripDecimalsForMap(row["Race_Cd"].ToString()); person.Race_Cd = CernerMapDAL.GetMap("CERNER_RACE", raceCd, raceCd); string religionCd = CernerCommon.StripDecimalsForMap(row["Religion_Cd"].ToString()); person.Religion_Cd = CernerMapDAL.GetMap("CERNER_RELIGION", religionCd, religionCd); string sexCd = CernerCommon.StripDecimalsForMap(row["Sex_Cd"].ToString()); person.Sex_Cd = CernerMapDAL.GetMap("CERNER_GENDER", sexCd, sexCd); person.Vip_Cd = CernerCommon.StripDecimalsForMap(row["Vip_Cd"].ToString()); person.SocialSecurityNumber = PersonAliasDAL.GetPersonAlias_SSN(person.PersonId); person.HomeAddress = AddressDAL.GetHomeAddress(person.PersonId); person.EmailAddress = AddressDAL.GetEmailAddress(person.PersonId); person.HomePhone = PhoneDAL.GetHomePhone(person.PersonId); //person.OtherPhone = PhoneDAL.GetOtherPhone(person.PersonId); person.MobilePhone = PhoneDAL.GetMobilePhone(person.PersonId); person.WorkPhone = PhoneDAL.GetWorkPhone(person.PersonId); person.Name_First = row["Name_First"].ToString().ToUpper(); person.Name_Last = row["Name_Last"].ToString().ToUpper(); person.Name_Middle = CheckCode(row["Name_Middle"].ToString().ToUpper()); string ethnicGroupCd = CernerCommon.StripDecimalsForMap(row["ethnic_grp_cd"].ToString()); person.Ethnic_Group_Cd = CernerMapDAL.GetMap("CERNER_ETHNIC_GROUP_CD", ethnicGroupCd, ethnicGroupCd); person.PrimaryCarePhysician = ""; // Person_Prsnl_ReltnDAL.GetPrimaryCarePhysician(person.PersonId); person.PrimaryCarePhysicianName = ""; // Person_Prsnl_ReltnDAL.GetPrimaryCarePhysicianName(person.PersonId); return(person); }
private static Encntr_Person_Reltn LoadPersonReltn(DataRow row) { string relCd = ""; Encntr_Person_Reltn reltn = new Encntr_Person_Reltn(); relCd = row["related_person_reltn_cd"].ToString(); reltn.guarPersonID = row["related_person_id"].ToString(); reltn.relationship = CernerMapDAL.GetMap("CERNER_RELATIONSHIP", relCd, relCd); return(reltn); }
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 Address LoadAddress(DataRow row) { Address address = new Address(); address.Street_Addr = row["street_addr"].ToString(); address.Street_Addr2 = row["street_addr2"].ToString(); address.Street_Addr2 = row["street_addr2"].ToString(); address.City = row["city"].ToString(); address.Country = row["country_cd"].ToString(); string stateCd = CernerCommon.StripDecimalsForMap(row["state_cd"].ToString()); address.State_Cd = CernerMapDAL.GetMap("CERNER_STATE", stateCd, stateCd); address.ZipCode = row["zipcode"].ToString(); return(address); }
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); }