public Appointment GetAppointment(int id)
{
var appointment = new Appointment();
connection.Open();
var sql = $"SELECT * FROM appointment WHERE appointmentId = @Id";
try
{
MySqlCommand cmd = new MySqlCommand(sql, connection);
cmd.Parameters.Add("@Id", MySqlDbType.Int32);
cmd.Parameters["@Id"].Value = id;
var reader = cmd.ExecuteReader();
appointment = ConstructAppointment(reader);
LocationService.AdjustAppointmentTimeForZone(appointment);
reader.Close();
}
catch (Exception e)
{
throw e;
}
finally
{
if (connection.State == ConnectionState.Open)
{
connection.Close();
}
}
return(appointment);
}