using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI.WebControls;
using System.Data;
namespace TraumaFlow.Code
{
public class TraumaFlowHelper
{
public static string connectionName = "TraumaFlowConnectionString";
public static string getConnectionString()
{
DatabaseHelper dh = new DatabaseHelper(connectionName);
return dh.getConnectionString(connectionName);
}
public static void fillTextBox(TextBox tb, string XMLName, int TraumaFormID)
{
tb.Text = getValue(XMLName, TraumaFormID);
}
public static string getValue(string XMLName, int TraumaFormID)
{
if (XMLName == "PatientReportedName") return TraumaFlowHelper.getPatientName(TraumaFormID);
string sql = "SELECT Value FROM view_TextMedicalData ";
sql += "WHERE XMLName = '" + XMLName + "'";
sql += " AND id = " + Convert.ToString(TraumaFormID);
DatabaseHelper dh = new DatabaseHelper(connectionName);
return dh.executeSqlReturnString(sql);
}
public static string getPatientName(int TraumaFormID)
{
string sql = "SELECT name FROM TraumaForm WHERE id = '" + TraumaFormID.ToString() + "'";
DatabaseHelper dh = new DatabaseHelper(connectionName);
return dh.executeSqlReturnString(sql);
}
public static string getTraumaFormDate(int TraumaFormID)
{
string sql = "SELECT Arrival FROM TraumaForm WHERE id = '" + TraumaFormID.ToString() + "'";
DatabaseHelper dh = new DatabaseHelper(connectionName);
return dh.executeSqlReturnString(sql);
}
public static int getCodeID(string XMLName, int TraumaFormID)
{
string sql = "SELECT CodeID FROM view_CodedMedicalData ";
sql += "WHERE XMLName = '" + XMLName + "'";
sql += " AND id = " + Convert.ToString(TraumaFormID);
try
{
DatabaseHelper dh = new DatabaseHelper(connectionName);
return Convert.ToInt32(dh.executeSqlReturnString(sql));
}
catch
{
return 0;
}
}
public static DataTable matchStaffNames(string pattern)
{
string sql = "SELECT StaffName FROM StaffNames WHERE UPPER(StaffName) LIKE '%" + pattern.ToUpper() + "%'";
DatabaseHelper dh = new DatabaseHelper(connectionName);
return dh.executeSqlReturnDataTable(sql);
}
public static DataTable getAllXMLNames()
{
string sql = "SELECT DISTINCT(NameText) FROM NameResolution";
DatabaseHelper dh = new DatabaseHelper(connectionName);
return dh.executeSqlReturnDataTable(sql);
}
public static string[] traumaTeamMembers()
{
string[] s = {"TRAUMA_A_NURSE","RUNNER","LAB_TECH","ED_MD","TRAUMA_B_NURSE","OR_NURSE_TECH",
"RADIOLOGY_TECH", "ORTHO_TECH", "SCRIBE", "RESP_THERAPY", "CHAPLAIN", "OTHER"};
return s;
}
public static void insertMedicalData(string nameText, string value)
{
// stored procedure has logic for insert OR update
updateMedicalData(0, nameText, value);
}
public static void updateMedicalData(int traumaFormID, string nameText, string value)
{
if (doesMedicalDataExist(traumaFormID, nameText, value)) return;
string sql = "EXEC [sp_InsertMedicalData] " + Convert.ToString(traumaFormID) + ", '" + nameText + "', NULL , '" + value + "'";
DatabaseHelper dh = new DatabaseHelper(connectionName);
dh.executeSqlNonQuery(sql);
}
public static bool doesMedicalDataExist(int traumaFormID, string nameText, string value)
{
string categoryID = getCategoryIDFromNameText(nameText);
string sql = "SELECT COUNT(*) FROM MedicalData WHERE TraumaFormID = " + Convert.ToString(traumaFormID);
sql += " AND CategoryID = " + getCategoryIDFromNameText(nameText);
sql += " AND ValueText = '" + value + "'";
DatabaseHelper dh = new DatabaseHelper(connectionName);
int c = dh.executeSqlReturnInt(sql);
return (c >= 1);
}
public static string getCategoryIDFromNameText(string nameText)
{
string sql = "SELECT CategoryID FROM NameResolution WHERE NameText = '" + nameText +"'";
DatabaseHelper dh = new DatabaseHelper(connectionName);
return dh.executeSqlReturnString(sql);
}
}
}
|
Comments (0)
You don't have permission to comment on this page.