public List <Documents> getDocumentsByPatient(int PatientID)
{
clsUtility.Connection = getConnectionString();
List <Documents> lDocuments = new List <Documents>();
InfiniEdge.SqlParameterCollection parameters = new InfiniEdge.SqlParameterCollection();
parameters.Add(new SqlParameter("@PatientID", PatientID));
SqlDataReader sqlDr = clsUtility.ExecuteSP_DataReader("getDocumentsByPatientID", parameters);
try
{
while (sqlDr.Read())
{
Documents tmpDoc = new Documents();
tmpDoc.DocumentID = Int32.Parse(sqlDr["DocumentID"].ToString());
tmpDoc.DocumentLink = sqlDr["DocumentLink"].ToString();
tmpDoc.DocumentType = sqlDr["DocumentType"].ToString();
lDocuments.Add(tmpDoc);
}
}
finally
{
sqlDr.Close();
}
return(lDocuments);
}
public List <Medications> getAllMedications(int patientID)
{
clsUtility.Connection = dbTool.getConnectionString();
InfiniEdge.SqlParameterCollection parameters = new InfiniEdge.SqlParameterCollection();
parameters.Add(new SqlParameter("@PatientID", patientID));
List <Medications> tmpMeds = new List <Medications>();
SqlDataReader sqlDR = clsUtility.ExecuteSP_DataReader("getMedication", parameters);
try
{
while (sqlDR.Read())
{
Medications tmpM = new Medications();
tmpM.Dosage = Single.Parse(sqlDR["Dosage"].ToString());
tmpM.Measurement = sqlDR["Measurement"].ToString();
tmpM.MedicationDesc = sqlDR["Medication Name"].ToString();
tmpM.MedicationId = Int32.Parse(sqlDR["MedicationId"].ToString());
tmpM.PatientID = Int32.Parse(sqlDR["PatientID"].ToString());
tmpMeds.Add(tmpM);
}
return(tmpMeds);
}
finally
{
sqlDR.Close();
}
}
//Updates a patients entry
public int updatePatient(Patients pInfo, int PatientID)
{
clsUtility.Connection = getConnectionString();
Type type = pInfo.GetType();
InfiniEdge.SqlParameterCollection parameters = new InfiniEdge.SqlParameterCollection();
foreach (PropertyInfo pi in type.GetProperties())
{
if (pi.GetValue(pInfo, null) == null)
{
parameters.Add(new SqlParameter("@" + pi.Name, ""));
}
else
{
parameters.Add(new SqlParameter("@" + pi.Name, pi.GetValue(pInfo, null).ToString()));
}
}
parameters.Add(new SqlParameter("@EncounterStatus", "I"));
parameters.Add(new SqlParameter("@Medic", Int32.Parse(HttpContext.Current.Session["MedicPK"].ToString())));
parameters.Add(new SqlParameter("@PatientID", PatientID));
int pKey = clsUtility.ExecuteSP_RETURN_VALUE("UpdatePatient", parameters);
return(pKey);
}
public void LogUse(int MedicID, int ProgramID)
{
string sIPAddress;
sIPAddress = System.Web.HttpContext.Current.Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
if (sIPAddress == null)
{
sIPAddress = System.Web.HttpContext.Current.Request.ServerVariables["REMOTE_ADDR"];
}
string sp;
sp = "wsAddIntranetLog";
SqlParameter Param1 = new SqlParameter("@MedicID", MedicID);
SqlParameter Param2 = new SqlParameter("@ProgramID", ProgramID);
SqlParameter Param3 = new SqlParameter("@IPAddress", sIPAddress);
InfiniEdge.SqlParameterCollection parameters = new InfiniEdge.SqlParameterCollection();
parameters.Add(Param1);
parameters.Add(Param2);
parameters.Add(Param3);
clsUtility.ExecuteSP(sp, parameters);
}
} // Done... Tested...
private void LoadData(int intPatientID, bool Complete)
{
DataTable tblResults;
if (AppMode)
{
clsUtility.Connection = enc.SimpleCrypt(ConfigurationManager.AppSettings["remoteConn"]);
}
else
{
clsUtility.Connection = enc.SimpleCrypt(ConfigurationManager.AppSettings["infiniConn"]);
}
string strProc;
strProc = "wsGetPatientByID";
InfiniEdge.SqlParameterCollection parameters = new InfiniEdge.SqlParameterCollection();
parameters.Add(new SqlParameter("@PatientID", intPatientID));
tblResults = clsUtility.ExecuteSP_DataTable(strProc, parameters);
if (Complete == true)
{
LoadControls(tblResults);
}
else
{
LoadControlsIncomplete(tblResults);
}
} // Obsolete...
//Gets medics rig,username,and ID
public DataTable getMedicInfo(string Username)
{
clsUtility.Connection = getConnectionString();
InfiniEdge.SqlParameterCollection parameters = new InfiniEdge.SqlParameterCollection();
parameters.Add(new SqlParameter("@Username", Username));
DataTable dT = clsUtility.ExecuteSP_DataTable("getMedicbyUsername", parameters);
return(dT);
}
//Gets the patients medic
public int getMedicByPatient(int PatientID)
{
clsUtility.Connection = getConnectionString();
InfiniEdge.SqlParameterCollection parameters = new InfiniEdge.SqlParameterCollection();
parameters.Add(new SqlParameter("@PatientID", PatientID));
int iReturn = clsUtility.ExecuteSP_RETURN_VALUE("getMedicbyPatient", parameters);
return(iReturn);
}
//Pulls all States and their Abbreviations
public DataTable getStateAbbrev(int CityID)
{
clsUtility.Connection = getConnectionString();
InfiniEdge.SqlParameterCollection parameters = new InfiniEdge.SqlParameterCollection();
parameters.Add(new SqlParameter("@CityID", CityID));
DataTable dT = clsUtility.ExecuteSP_DataTable("getStateAbbrev", parameters);
return(dT);
}
//Pulls Patients name and ID for the Medics Rig with an incomplete status
public DataTable getRigIncomplete(string MedicID)
{
clsUtility.Connection = getConnectionString();
InfiniEdge.SqlParameterCollection parameters = new InfiniEdge.SqlParameterCollection();
parameters.Add(new SqlParameter("@MedicID", MedicID));
DataTable dT = clsUtility.ExecuteSP_DataTable("getRigPatients", parameters);
return(dT);
}
//Pulls Employers Phone Num, address, email, city,state, and zip
public DataTable getEmployerInfo(int EmployerID)
{
clsUtility.Connection = getConnectionString();
InfiniEdge.SqlParameterCollection parameters = new InfiniEdge.SqlParameterCollection();
parameters.Add(new SqlParameter("@EmployerID", EmployerID));
DataTable dT = clsUtility.ExecuteSP_DataTable("getEmployerInfo", parameters);
return(dT);
}
public void newAllergy(int AllergyID)
{
clsUtility.Connection = getConnectionString();
InfiniEdge.SqlParameterCollection parameters = new InfiniEdge.SqlParameterCollection();
parameters.Add(new SqlParameter("@AllergyID", AllergyID));
parameters.Add(new SqlParameter("@PatientID", Int32.Parse(HttpContext.Current.Session["PatientID"].ToString())));
clsUtility.ExecuteSP("InsertAllergy", parameters);
}
public DataTable getVitals(int PatientID)
{
clsUtility.Connection = getConnectionString();
InfiniEdge.SqlParameterCollection parameters = new InfiniEdge.SqlParameterCollection();
parameters.Add(new SqlParameter("@PatientID", PatientID));
DataTable dT = clsUtility.ExecuteSP_DataTable("getVitals", parameters);
return(dT);
}
public void deleteVitals(int PatientID, int VitalID)
{
clsUtility.Connection = getConnectionString();
InfiniEdge.SqlParameterCollection parameters = new InfiniEdge.SqlParameterCollection();
parameters.Add(new SqlParameter("@VitalSignID", VitalID));
parameters.Add(new SqlParameter("@PatientID", PatientID));
clsUtility.ExecuteSP("deleteVitals", parameters);
}
public void deleteMedication(int PatientID, int MedicationID)
{
clsUtility.Connection = getConnectionString();
InfiniEdge.SqlParameterCollection parameters = new InfiniEdge.SqlParameterCollection();
parameters.Add(new SqlParameter("@PatientID", PatientID));
parameters.Add(new SqlParameter("@MedicationID", MedicationID));
clsUtility.ExecuteSP("deleteMedication", parameters);
}
public void NewMedication(int PatientID, string MedicationDesc, float Dosage, string Measurement)
{
clsUtility.Connection = getConnectionString();
InfiniEdge.SqlParameterCollection parameters = new InfiniEdge.SqlParameterCollection();
parameters.Add(new SqlParameter("@PatientID", PatientID));
parameters.Add(new SqlParameter("@MedicationDesc", MedicationDesc));
parameters.Add(new SqlParameter("@Dosage", Dosage));
parameters.Add(new SqlParameter("@Measurement", Measurement));
clsUtility.ExecuteSP("newPatientMedication", parameters);
}
public string JobSheetAdmin(string username)
{
clsUtility.Connection = getConnectionString();
InfiniEdge.SqlParameterCollection parameters = new InfiniEdge.SqlParameterCollection();
parameters.Add(new SqlParameter("@Username", username));
DataSet tmpDS = clsUtility.ExecuteSP_DataSet("isJSAdmin", parameters);
string tempStr = tmpDS.Tables[0].Rows[0][0].ToString();
return(tempStr);
}
public int getNoteStatus(int PatientID)
{
clsUtility.Connection = getConnectionString();
InfiniEdge.SqlParameterCollection parameters = new InfiniEdge.SqlParameterCollection();
parameters.Add(new SqlParameter("@PatientID", PatientID));
int NoteStatus = clsUtility.ExecuteSP_RETURN_VALUE("getPatientNotesCount", parameters);
return(NoteStatus);
//getPatientNotesCount
}
// Returns patients' name,address,ssn,phone#,rig,and encounterdate
public DataTable performSearch(int MedicID, string FirstName, string LastName, string SSN)
{
clsUtility.Connection = getConnectionString();
InfiniEdge.SqlParameterCollection parameters = new InfiniEdge.SqlParameterCollection();
parameters.Add(new SqlParameter("@FirstName", FirstName));
parameters.Add(new SqlParameter("@LastName", LastName));
parameters.Add(new SqlParameter("@SSN", SSN));
parameters.Add(new SqlParameter("@MedicID", MedicID));
DataTable dT = clsUtility.ExecuteSP_DataTable("getPatientSearch", parameters);
return(dT);
}
//Pulls properties for Patients object
public DataTable getPatientInfo(int PatientID)
{
clsUtility.Connection = getConnectionString();
string strProc;
strProc = "wsGetPatientByID";
InfiniEdge.SqlParameterCollection parameters = new InfiniEdge.SqlParameterCollection();
parameters.Add(new SqlParameter("@PatientID", PatientID));
DataTable tblResults = clsUtility.ExecuteSP_DataTable(strProc, parameters);
return(tblResults);
//Patients pinfo = new Patients();
}
public void newVitals(int PatientID, string Time, string BP, string Pulse, string Resp, string Temp, string TraumaScore)
{
clsUtility.Connection = getConnectionString();
InfiniEdge.SqlParameterCollection parameters = new InfiniEdge.SqlParameterCollection();
parameters.Add(new SqlParameter("@PatientID", PatientID));
parameters.Add(new SqlParameter("@Time", Time));
parameters.Add(new SqlParameter("@BP", BP));
parameters.Add(new SqlParameter("@Pulse", Pulse));
parameters.Add(new SqlParameter("@Resp", Resp));
parameters.Add(new SqlParameter("@Temp", Temp));
parameters.Add(new SqlParameter("@TraumaScore", TraumaScore));
clsUtility.ExecuteSP("newPatientVital", parameters);
}
public int updateMedicalRecord(MedicalInfo mInfo)
{
clsUtility.Connection = getConnectionString();
Type type = mInfo.GetType();
InfiniEdge.SqlParameterCollection parameters = new InfiniEdge.SqlParameterCollection();
foreach (PropertyInfo pi in type.GetProperties())
{
// Database was not saving these 2 date fields correctly if they were null.
// Added this statement to insert DBNulls instead.
if (pi.Name == "DepartDate" || pi.Name == "ArrivalDate")
{
if (pi.GetValue(mInfo, null) == null)
{
parameters.Add(new SqlParameter("@" + pi.Name, DBNull.Value));
}
else
{
parameters.Add(new SqlParameter("@" + pi.Name, pi.GetValue(mInfo, null).ToString()));
}
}
else
{
if (pi.GetValue(mInfo, null) == null)
{
parameters.Add(new SqlParameter("@" + pi.Name, ""));
}
else
{
parameters.Add(new SqlParameter("@" + pi.Name, pi.GetValue(mInfo, null).ToString()));
}
}
}
parameters.Add(new SqlParameter("@PatientID", Int32.Parse(HttpContext.Current.Session["PatientID"].ToString())));
// 'Gets the password for the user
//Dim passwdOutput As New SqlParameter("@password", SqlDbType.VarChar, 35)
//passwdOutput.Direction = ParameterDirection.Output
//pParams.Add(passwdOutput)
//oSQL.ExecuteSP("GetPasswordByUserName", pParams)
//password = passwdOutput.Value.ToString()
int pKey = clsUtility.ExecuteSP_RETURN_VALUE("InsertPatientMedical", parameters);
return(pKey);
}
public void updateNote(string EncounterStatus, MedicNotes mNotes)
{
clsUtility.Connection = getConnectionString(); Type type = mNotes.GetType();
InfiniEdge.SqlParameterCollection parameters = new InfiniEdge.SqlParameterCollection();
foreach (PropertyInfo pi in type.GetProperties())
{
if (pi.GetValue(mNotes, null) == null)
{
parameters.Add(new SqlParameter("@" + pi.Name, ""));
}
else
{
parameters.Add(new SqlParameter("@" + pi.Name, pi.GetValue(mNotes, null).ToString()));
}
}
parameters.Add(new SqlParameter("@EncounterStatus", EncounterStatus));
parameters.Add(new SqlParameter("@patientID", Int32.Parse(HttpContext.Current.Session["PatientID"].ToString())));
clsUtility.ExecuteSP("updateNotes", parameters);
}
