// Return [ward, room] with datatable from cache
public static DataTable GetBedRoom(string wardCode)
{
dt = new DataTable();
dt = InterSystemsDA.DataTableBindDataCommand(QueryString.GetBedRoomQueryString(wardCode), Constants.Cache89ConnectionString);
return(dt);
}
// Return [hn, episode] with tuple from cache
public static Tuple <string, string> PatientHnAdm(string bedRowId)
{
dt = new DataTable();
string papmi_No = "";
string paadm_Admno = "";
dt = InterSystemsDA.DataTableBindDataCommand(QueryString.GetPatientIPDQueryString(bedRowId), Constants.Cache89ConnectionString);
if (dt.Rows.Count > 0)
{
papmi_No = dt.Rows[0]["RN_No"].ToString();
paadm_Admno = dt.Rows[0]["EpisodeNo"].ToString();
}
return(Tuple.Create(papmi_No, paadm_Admno));
}