private void alterPatient(bool update, Patient patient)
{
string queryString = "addPatient";
if (update)
{
queryString = "updatePatient";
}
SqlCommand command = new SqlCommand(queryString, conn);
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("@gender", patient.getGender()));
command.Parameters.Add(new SqlParameter("@ssn", patient.getSSN()));
command.Parameters.Add(new SqlParameter("@birthDate", patient.getBirthDate()));
command.Parameters.Add(new SqlParameter("@firstName", patient.getFirstName()));
command.Parameters.Add(new SqlParameter("@middleInitial", patient.getMiddleInitial()));
command.Parameters.Add(new SqlParameter("@lastName", patient.getLastName()));
command.Parameters.Add(new SqlParameter("@addressLine1", patient.getAddressLine1()));
command.Parameters.Add(new SqlParameter("@addressLine2", patient.getAddressLine2()));
command.Parameters.Add(new SqlParameter("@state", patient.getState()));
command.Parameters.Add(new SqlParameter("@city", patient.getCity()));
command.Parameters.Add(new SqlParameter("@zipcode", patient.getZipcode()));
command.Parameters.Add(new SqlParameter("@insurerId", patient.getInsurer()));
command.Parameters.Add(new SqlParameter("@doNotResuscitate", patient.getDoNotResuscitateStatus()));
command.Parameters.Add(new SqlParameter("@organDonor", patient.getOrganDonorStatus()));
command.Connection = conn;
SqlDataReader reader = command.ExecuteReader();
reader.Close();
}
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);
}
}
}
private void displayPatient()
{
patientFirstNameTextBox.Text = selectedPatient.getFirstName();
PatientMiddleInitialTextBox.Text = selectedPatient.getMiddleInitial().ToString();
patientLastNameTextBox.Text = selectedPatient.getLastName();
patientAddressLine1TextBox.Text = selectedPatient.getAddressLine1();
patientAddressLine2TextBox.Text = selectedPatient.getAddressLine2();
patientCityTextBox.Text = selectedPatient.getCity();
patientStateTextBox.Text = selectedPatient.getState();
patientZipTextBox.Text = selectedPatient.getZipcode();
patientGenderTextBox.Text = selectedPatient.getGender().ToString();
patientSSN.Text = selectedPatient.getSSN();
patientInsurerID.Text = selectedPatient.getInsurer();
if (selectedPatient.getDoNotResuscitateStatus())
{
patientDNR.Text = "True";
}
else
{
patientDNR.Text = "False";
}
if (selectedPatient.getOrganDonorStatus())
{
patientOrganDonor.Text = "True";
}
else
{
patientOrganDonor.Text = "False";
}
//patientBirthdateTextBox.Text = selectedPatient.getBirthDate().ToString("MM/dd/yyyy");
dateBirthdate.Value = selectedPatient.getBirthDate();
if (selectedVisit == null)
{
EntryDatePicker.Visible = false;
changeRoomButton.Enabled = false;
diagnosisWizardButton.Enabled = false;
useInventoryButton.Enabled = false;
}
else
{
EntryDatePicker.Visible = true;
EntryDatePicker.Value = selectedVisit.getEntryDate();
if (selectedVisit.getRoomList().Count > 0)
{
visitRoomNumber.Text = selectedVisit.getRoomList()[selectedVisit.getRoomList().Count - 1].getRoomNumber();
}
textSymptoms.Text = "";
foreach (string s in selectedVisit.getSymptomList())
{
textSymptoms.Text += s + "\r\n";
}
VisitDiagnosisTextBox.Text = selectedVisit.getDiagnosis();
textAttendingPhy.Text = selectedVisit.getAttendingPhysician();
visitNotes.Text = selectedVisit.getNote();
changeRoomButton.Enabled = true;
diagnosisWizardButton.Enabled = true;
useInventoryButton.Enabled = true;
//roomNumber.Items = selectedVisit.getRoomList()
}
listPreviousVisits.Items.Clear();
for (int i = selectedPatient.getVisitList().Count - 1; i >= 0; i--) // selectedPatient.getVisitList.Count Visit v in selectedPatient.getVisitList())
{
Visit v = selectedPatient.getVisitList()[i];
if (selectedVisit != null && selectedVisit.getEntryDate() == v.getEntryDate())
{
continue; // we don't want to display current visit in previous visit list
}
Console.WriteLine("Adding previous visit at date: " + v.getEntryDate().ToShortDateString());
ListViewItem previousVisit = new ListViewItem(v.getEntryDate().ToString());
previousVisit.SubItems.Add(v.getAttendingPhysician());
previousVisit.SubItems.Add(v.getDiagnosis());
// previousVisitList.Items.Add(previousVisit);
listPreviousVisits.Items.Add(previousVisit);
}
if (selectedVisit == null)
{
textSymptoms.Enabled = true;
VisitDiagnosisTextBox.Enabled = true;
textAttendingPhy.Enabled = true;
visitNotes.Enabled = true;
}
else
{
textSymptoms.Enabled = false;
VisitDiagnosisTextBox.Enabled = false;
textAttendingPhy.Enabled = false;
visitNotes.Enabled = false;
}
}