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