public static Hashtable GetCorspInfo(string pftEncID, string hcis) { int cntr = 1; Hashtable hash = new Hashtable(); DateTime todayDt = DateTime.Today; StringBuilder sb = new StringBuilder(); sb.Append("SELECT LONG_TEXT_ID,CREATED_DT_TM, CREATED_PRSNL_ID "); sb.Append("FROM vCORSP_LOG_RELTN_CORSP_LOG "); sb.Append("WHERE PFT_ENCNTR_ID = " + long.Parse(pftEncID) + " "); 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); } foreach (DataRow row in dt.Rows) { Hashtable tempHash = LineTextDAL.GetTextData(row["LONG_TEXT_ID"].ToString(), "ENCNTR_INFO", hcis, row["CREATED_DT_TM"].ToString()); hash.Add(cntr, tempHash); cntr = cntr + 1; } dt.Dispose(); return(hash); }
public static Hashtable GetEncounterInfoV2(string encounter_id, string hcis) { Hashtable tempHash = LineTextDAL.GetTextDataAll(encounter_id, hcis); return(tempHash); }