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); }
public static List <Encntr_Person_Reltn> GetGuarantor(string encounterId) { DateTime todayDt = DateTime.Today; StringBuilder sb = new StringBuilder(); sb.Append("SELECT related_person_id,related_person_reltn_cd "); sb.Append("FROM BAR_ENCNTR_PERSON_RELTN "); sb.Append("WHERE encntr_id = " + long.Parse(encounterId) + " "); sb.Append("AND person_reltn_type_cd = '1150' "); 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); } List <Encntr_Person_Reltn> prs = new List <Encntr_Person_Reltn>(); foreach (DataRow row in dt.Rows) { Encntr_Person_Reltn pr = LoadPersonReltn(row); prs.Add(pr); } //string result = personId; //foreach (DataRow row in dt.Rows) //{ // result = row["related_person_id"].ToString().Trim(); //} //if (dt.Rows.Count > 0) // result = dt.Rows[0][0].ToString(); dt.Dispose(); return(prs); }