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();
}
}
public List <Patients> getIncompletes()
{
clsUtility.Connection = getConnectionString();
List <Patients> tmpList = new List <Patients>();
SqlDataReader sqlDR = clsUtility.ExecuteSP_DataReader("getAllPatients", null);
while (sqlDR.Read())
{
Patients tmpPatient = new Patients();
Type type = tmpPatient.GetType();
foreach (PropertyInfo pi in type.GetProperties())
{
if (sqlDR["PatientName"].ToString() != "")
{
if (pi.Name == "FirstName")
{
char[] splitter = { ',' };
string[] pName = sqlDR["PatientName"].ToString().Split(splitter);
if (pName[1] != "")
{
pi.SetValue(tmpPatient, pName[1].ToString().Trim(), null);
}
}
else if (pi.Name == "LastName")
{
char[] splitter = { ',' };
string[] pName = sqlDR["PatientName"].ToString().Split(splitter);
if (pName[0] != "")
{
pi.SetValue(tmpPatient, pName[0].ToString().Trim(), null);
}
}
}
}
tmpList.Add(tmpPatient);
}
sqlDR.Close();
return(tmpList);
}
public List <Tips> pullAllTips()
{
clsUtility.Connection = getConnectionString();
List <Tips> lTips = new List <Tips>();
SqlDataReader sqlDR = clsUtility.ExecuteSP_DataReader("pullAllTips", null);
try
{
while (sqlDR.Read())
{
Tips tmpTips = new Tips();
tmpTips.TipID = Int32.Parse(sqlDR["ExplanationID"].ToString());
tmpTips.Description = sqlDR["Description"].ToString();
tmpTips.TipText = sqlDR["Text"].ToString();
lTips.Add(tmpTips);
}
}
finally
{
sqlDR.Close();
}
return(lTips);
}