// Method used to populate ListBox public static string patientToString(PatientsTable patient, HospitalDBEntities dbcon) { List <TestsTable> tests = dbcon.TestsTables.ToList(); List <MedicationListTable> meds = dbcon.MedicationListTables.ToList(); List <AppointmentsTable> appointments = dbcon.AppointmentsTables.ToList(); String final = "Name: " + patient.FirstName + " " + patient.LastName + "\nEmail: " + patient.Email + "\nTests:"; foreach (TestsTable test in tests) { if (patient.TestID == test.TestID) { final += " " + test.TestResults + " " + test.TestDate; } } final += "\nMedications:"; foreach (MedicationListTable med in meds) { if (patient.MedicationID == med.MedicationID) { final += " " + med.Description; } } final += "\nAppointments:"; foreach (AppointmentsTable app in appointments) { if (patient.PatientID == app.PatientID) { final += " " + app.VisitSummary + " " + app.Date + "\n"; } } return(final); }
// Creates Patient from login username public static PatientsTable getPatient(string username) { PatientsTable myPatient = null; username = username.Trim(); foreach (PatientsTable patient in dbcon.PatientsTables) { if (patient.UserLoginName.ToString().Trim() == username) // if input is equal to a username in database, create copy { myPatient = new PatientsTable(); myPatient.PatientID = patient.PatientID; myPatient.DoctorID = patient.DoctorID; myPatient.FirstName = patient.FirstName; myPatient.LastName = patient.LastName; myPatient.Address = patient.Address; myPatient.Phone = patient.Phone; myPatient.Email = patient.Email; myPatient.UserLoginName = patient.UserLoginName; myPatient.MedicationID = patient.MedicationID; myPatient.TestID = patient.TestID; break; } } return(myPatient); }
protected void Page_Load(object sender, EventArgs e) { myPatient = UtilitiesClass.getPatient(Session["LoginName"].ToString()); if (!IsPostBack) { ShowSelectedDateLabel.Visible = false; } }
protected void Page_Load(object sender, EventArgs e) { if (Convert.ToInt32(Session["IsDoctor"]) == 0) { PatientsTable myPatient = UtilitiesClass.getPatient(Session["LoginName"].ToString()); DoctorsTable myDoctor = UtilitiesClass.getPatientsDoctor(myPatient); HyperLink4.Text = "Medications/Tests"; HyperLink4.NavigateUrl = "~/MedAndTestsList.aspx"; Label1.Text = "Current Session: " + myPatient.FirstName.Trim() + " " + myPatient.LastName.Trim() + " - Your Doctor: " + myDoctor.FirstName + " " + myDoctor.LastName; } else if (Convert.ToInt32(Session["IsDoctor"]) == 1) { DoctorsTable myDoctor = UtilitiesClass.getDoctor(Session["LoginName"].ToString()); HyperLink4.Text = "Search for Patient"; HyperLink4.NavigateUrl = "~/PatientSearch.aspx"; Label1.Text = "Current Session: " + myDoctor.FirstName + " " + myDoctor.LastName; } }
// Creates Doctor from loged in patient public static DoctorsTable getPatientsDoctor(PatientsTable patient) { DoctorsTable doctor = null; foreach (DoctorsTable doc in dbcon.DoctorsTables) { if (doc.DoctorID == patient.DoctorID) // if patient's DoctorID equals DoctorID in doctor table, create copy of doctor { doctor = new DoctorsTable(); doctor.FirstName = doc.FirstName; doctor.LastName = doc.LastName; doctor.UserLoginName = doc.UserLoginName; doctor.Email = doc.Email; doctor.DoctorID = doc.DoctorID; doctor.Location = doc.Location; doctor.Department = doc.Department; break; } } return(doctor); }
protected void Page_Load(object sender, EventArgs e) { // Checks if user is patient or doctor, and creates object if (Convert.ToInt32(Session["IsDoctor"]) == 0) { myPatient = UtilitiesClass.getPatient(Session["LoginName"].ToString()); Session["PatientID"] = myPatient.PatientID; Label1.Text = myPatient.FirstName + " " + myPatient.LastName; myDoctor = UtilitiesClass.getPatientsDoctor(myPatient); GridView2.Visible = false; } else { myDoctor = UtilitiesClass.getDoctor(Session["LoginName"].ToString()); Session["DoctorID"] = myDoctor.DoctorID; Label1.Text = myDoctor.FirstName + " " + myDoctor.LastName; GridView1.Visible = false; } }