public static List <Occurrence_Code> GetOccurrence_Codes(string encounterId)
{
StringBuilder sb = new StringBuilder();
sb.Append("select occurrence_cd, occurrence_dt_tm ");
sb.Append("FROM ENCNTR_OCCURRENCE_CODE ");
sb.Append("where encntr_Id = '" + encounterId.Replace(".0000", "") + "' and active_ind = '1' ");
//sb.Append("order by CONVERT(int, diag_priority) ");
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))
{
da.Fill(dt);
}
List <Occurrence_Code> codes = new List <Occurrence_Code>();
foreach (DataRow row in dt.Rows)
{
Occurrence_Code code = LoadOccurrenceCodes(row);
if (code != null)
{
codes.Add(code);
}
}
return(codes);
}
public static List <Occurrence_Code> GetOccurrence_Codes(string encounterId)
{
DateTime todayDt = DateTime.Today;
StringBuilder sb = new StringBuilder();
sb.Append("select occurrence_cd, occurrence_dt_tm ");
sb.Append("FROM BAR_ENCNTR_OCCURRENCE_CODE ");
sb.Append("where encntr_Id = " + long.Parse(encounterId) + " and active_ind = '1' ");
sb.Append("AND END_EFFECTIVE_DT_TM > '" + todayDt + "'");
//sb.Append("order by CONVERT(int, diag_priority) ");
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))
{
da.Fill(dt);
}
List <Occurrence_Code> codes = new List <Occurrence_Code>();
foreach (DataRow row in dt.Rows)
{
Occurrence_Code code = LoadOccurrenceCodes(row);
if (code != null)
{
codes.Add(code);
}
}
return(codes);
}
private static Occurrence_Code LoadOccurrenceCodes(DataRow row)
{
Occurrence_Code code = new Occurrence_Code();
code.OccurrenceCode = row["occurrence_cd"].ToString();
code.OccurrenceDate = CernerCommon.ConvertDateString(row["occurrence_dt_tm"].ToString());
return(code);
}
private static Occurrence_Code LoadOccurrenceCodes(DataRow row)
{
string ocode = "";
string[] items;
Occurrence_Code code = new Occurrence_Code();
ocode = CodeValueDAL.GetCodeValueDisplay(row["occurrence_cd"].ToString().Trim());
items = ocode.Split(' ');
code.OccurrenceCode = items[0].Trim();
code.OccurrenceDate = CernerCommon.ConvertDateString(row["occurrence_dt_tm"].ToString());
return(code);
}