public void getVisits(ref Patient patient)
{
/* This attaches a list of visits to patient.
* Symptoms are pulled from the symptoms table and attached to visits
* Rooms are attached to visits
* TODO: Items and Services still need to be attached to the visit!
*
*/
patient.getVisitList().Clear(); // should probably clear the list so as not to duplicate?
string queryString = "getVisits";
SqlCommand command = new SqlCommand(queryString, conn);
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("@ssn", patient.getSSN()));
command.Connection = conn;
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Visit visit = new Visit();
if (!reader.IsDBNull((int)VisCol.EntryDate))
{
visit.setEntryDate(reader.GetDateTime((int)VisCol.EntryDate));
}
if (!reader.IsDBNull((int)VisCol.ExitDate))
{
visit.setExitDate(reader.GetDateTime((int)VisCol.ExitDate));
}
else
{
patient.setCurrentVisit(ref visit);
}
if (!reader.IsDBNull((int)VisCol.AttendingPhysician))
{
visit.setAttendingPhysician(reader.GetString((int)VisCol.AttendingPhysician));
}
if (!reader.IsDBNull((int)VisCol.Diagnosis))
{
visit.changeDiagnosis(reader.GetString((int)VisCol.Diagnosis));
}
if (!reader.IsDBNull((int)VisCol.Notes))
{
visit.setNote(reader.GetString((int)VisCol.Notes));
}
patient.addVisit(visit);
}
reader.Close();
// while we are getting patient visits, we might as well populate patient symptoms
List <Visit> visits = patient.getVisitList();
Console.WriteLine("Visits: " + visits.Count);
for (int i = 0; i < visits.Count; i++)
{
List <string> symptoms = querySymptoms(patient, visits[i]);
Console.WriteLine("Symptoms: " + symptoms.Count);
foreach (string s in symptoms) // add symptoms
{
Console.WriteLine(s);
visits[i].addSymptom(s);
Console.WriteLine("Symptoms LIst: " + patient.getVisitList()[i].getSymptomList().Count);
}
Visit v = visits[i];
getRoomList(ref patient, ref v);
foreach (Room r in visits[i].getRoomList()) // add rooms
{
Console.WriteLine("Patient " + patient.getFirstName() + " " + patient.getLastName() + " stayed in room " + r.getRoomNumber() + " which has an hourly rate of " + r.getHourlyRate());
getRoomEntryExitDates(patient, visits[i], r, out DateTime entryDate, out DateTime exitDate, out bool stillInroom);
Console.WriteLine("Patient stayed in room from " + entryDate + " to " + exitDate);
}
}
}