public void alterVisit(bool update, Visit visit, Patient patient)
{
string queryString = "addVisit";
if (update)
{
queryString = "updateVisit";
}
SqlCommand command = new SqlCommand(queryString, conn);
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("@patientID", patient.getSSN()));
command.Parameters.Add(new SqlParameter("@entryDate", visit.getEntryDate()));
command.Parameters.Add(new SqlParameter("@attendingPhysician", visit.getAttendingPhysician()));
// '@attendingPhysician
command.Parameters.Add(new SqlParameter("@diagnosis", visit.getDiagnosis()));
command.Parameters.Add(new SqlParameter("@note", visit.getNote()));
command.Connection = conn;
SqlDataReader reader = command.ExecuteReader();
reader.Close();
}
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;
}
}