public static string GetStatReasonNotAvail(string bedRowId)
{
string result = string.Empty;
string cmdString = QueryString.GetStatReasonNotAvailQueryString(bedRowId);
var value = InterSystemsDA.ExecuteScalarBindDataCommand(cmdString, Constants.Cache89ConnectionString);
if (!string.IsNullOrEmpty(value))
{
int intValue = 0;
if (Int32.TryParse(value, out intValue))
{
if (intValue == 3)
{
result = "W";
}
else if (intValue == 6)
{
result = "R";
}
else if (intValue == 7)
{
result = "O";
}
else if (intValue > 0)
{
result = "C";
}
}
}
return(result);
}
// 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);
}
public static double GetRevenueByEPI(string epino)
{
double revenue = 0.0;
var cmdString = QueryString.GetRevenueFromCache(epino);
var rev = InterSystemsDA.BindDataCommand(cmdString, Constants.Chache89);
var result = double.TryParse(rev, out revenue) ? revenue : 0.0;
return(result);
}
public static string GetAllergenCategory(string algName)
{
string result = string.Empty;
var cmdString = QueryString.GetAllergyCategory(algName);
result = InterSystemsDA.BindDataCommand(cmdString, Constants.Chache89);
return(result);
}
public static string GetHospitalSite(string siteCode)
{
string hos = string.Empty;
var cmdString = QueryString.GetHospitalSites(siteCode);
hos = InterSystemsDA.BindDataCommand(cmdString, Constants.Chache89);
return(hos);
}
public PatientOrder GetPatientOrder(string epiRowId, string dateFrom, string dateTo)
{
PatientOrder ptOrder = new PatientOrder();
var dtOneDay = InterSystemsDA.DTBindDataCommand(QueryString.GetOrders(epiRowId, dateFrom, dateTo, "OneDay"), conString);
var dtContinue = InterSystemsDA.DTBindDataCommand(QueryString.GetOrders(epiRowId, dateFrom, dateTo, "Continue"), conString);
ptOrder = Helper.DataTableToPatientOrder(epiRowId, dtOneDay, dtContinue);
return(ptOrder);
}
public List <Allergy> GetAllergys(string hn)
{
List <Allergy> results = new List <Allergy>();
var cmdString = QueryString.GetAllergy(hn);
var dtAlg = InterSystemsDA.DTBindDataCommand(cmdString, GlobalVariables.Cache89);
results = Helper.DataTableToAllergy(dtAlg);
return(results);
}
public static string GetBedType(string bedRowId)
{
string result = string.Empty;
string cmdString = QueryString.GetBedTypeQueryString(bedRowId);
result = InterSystemsDA.ExecuteScalarBindDataCommand(cmdString, Constants.Cache89ConnectionString);
result = result.Substring(2, 1);
return(result.Trim());
}
public static List <PatientPhone> GetPatientPhone(string hn)
{
List <PatientPhone> result = new List <PatientPhone>();
var cmdString = QueryString.GetPatientPhone(hn);
var dt = InterSystemsDA.DTBindDataCommand(cmdString, Constants.Chache89);
result = Helper.DataTableToPatientPhon(dt);
return(result);
}
public static List <Allergen> GetAllergens(string hn)
{
List <Allergen> results = new List <Allergen>();
var cmdString = QueryString.GetAllergy(hn);
var dtAlg = InterSystemsDA.DTBindDataCommand(cmdString, Constants.Chache89);
results = Helper.DataTableToAllergen(dtAlg);
return(results);
}
public static PatientInfo GetPatientInfo(string hn)
{
PatientInfo ptInfo = new PatientInfo();
var cmdString = QueryString.GetPatientInfo(hn);
var dt = InterSystemsDA.DTBindDataCommand(cmdString, Constants.Chache89);
ptInfo = Helper.DataTableToPatientInfo(dt);
return(ptInfo);
}
public static List <Location> GetAllLocations(string siteCode)
{
List <Location> locs = new List <Location>();
var cmdString = QueryString.GetAllLocations(siteCode);
var dt = InterSystemsDA.DTBindDataCommand(cmdString, Constants.Chache89);
locs = Helper.DataTableToLocationsList(dt);
return(locs);
}
public static PatientEpisode GetPatientEpisodes(string hn)
{
PatientEpisode ptEpi = new PatientEpisode();
var cmdString = QueryString.GetPatientEpisodes(hn);
//var dt = InterSystemsDA.DTBindDataCommand(cmdString, Constants.Chache89);
var dt = InterSystemsDA.GetDTGetPatientEpisode(hn);
ptEpi = Helper.DataTablePatientEpisode(dt, hn);
return(ptEpi);
}
// 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));
}
