/// <summary> /// Returns all visits in DB /// </summary> /// <returns>List of all visits</returns> public List <Visit> GetAllVisits() { AppointmentDAL appointmentDAL = new AppointmentDAL(); List <Visit> visits = new List <Visit>(); string selectStatement = "SELECT * FROM visit;"; using (SqlConnection connection = ClinicDBConnection.GetConnection()) { connection.Open(); using (SqlCommand command = new SqlCommand(selectStatement, connection)) { using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { Visit visit = new Visit { VisitId = (int)reader["id"], DateTime = (DateTime)reader["visit_datetime"], Weight = (decimal)reader["weight"], BpSystolic = (int)reader["bp_systolic"], BpDiastolic = (int)reader["bp_diastolic"], BodyTemperature = (decimal)reader["body_temp"], Pulse = (int)reader["pulse"], Symptoms = reader["symptoms"].ToString(), Info = reader["checkup_info"].ToString(), Nurse = NurseDAL.GetNurseByID((int)reader["nurse_id"]), Appointment = appointmentDAL.GetAppointmentByID((int)reader["appointment_id"]), InitialDiagnosis = reader["initial_diagnosis"].ToString(), FinalDiagnosis = reader["final_diagnosis"].ToString() }; visits.Add(visit); } } } connection.Close(); } return(visits); }
/// <summary> /// Returns a visit based on the appointment ID /// </summary> /// <param name="id">Appointment id</param> /// <returns>Visit Object</returns> public Visit GetVisitByAppointmentID(int id) { AppointmentDAL appointmentDAL = new AppointmentDAL(); Visit visit = new Visit(); string selectStatement = "SELECT * FROM visit WHERE appointment_id = @appointmentID;"; using (SqlConnection connection = ClinicDBConnection.GetConnection()) { connection.Open(); using (SqlCommand command = new SqlCommand(selectStatement, connection)) { command.Parameters.AddWithValue("@appointmentID", id); using (SqlDataReader reader = command.ExecuteReader()) { visit.Appointment = appointmentDAL.GetAppointmentByID(id); if (reader.Read()) { visit.VisitId = (int)reader["id"]; visit.DateTime = (DateTime)reader["visit_datetime"]; visit.Weight = (decimal)reader["weight"]; visit.BpSystolic = (int)reader["bp_systolic"]; visit.BpDiastolic = (int)reader["bp_diastolic"]; visit.BodyTemperature = (decimal)reader["body_temp"]; visit.Pulse = (int)reader["pulse"]; visit.Symptoms = reader["symptoms"].ToString(); visit.Info = reader["checkup_info"].ToString(); visit.Nurse = NurseDAL.GetNurseByID((int)reader["nurse_id"]); visit.InitialDiagnosis = reader["initial_diagnosis"].ToString(); visit.FinalDiagnosis = reader["final_diagnosis"].ToString(); } } } connection.Close(); } return(visit); }