private List <Appointment> ConstructAppointments(MySqlDataReader reader) { if (reader.HasRows) { var appointments = new List <Appointment>(); while (reader.Read()) { var appointment = new Appointment { Id = reader.GetInt32("appointmentId"), CustomerId = reader.GetInt32("customerId"), UserId = reader.GetInt32("userId"), Title = reader.GetString("title"), Description = reader.GetString("description"), Location = reader.GetString("location"), Contact = reader.GetString("contact"), Url = reader.GetString("url"), Start = reader.GetDateTime("start"), End = reader.GetDateTime("end"), Type = reader.GetString("type") }; appointments.Add(appointment); } LocationService.AdjustAppointmentTimesForZone(appointments); return(appointments); } return(null); }