/// <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);
}
