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