public AppointmentDataAccess.appointment SetUpAppointment(AppointmentDataAccess.appointment appointment)
 {
     AppointmentDataAccess.appointment result = null;
     using (var sqlConnection = new SqlConnection(ConnectionString)) {
         DynamicParameters parameters = new DynamicParameters();
         sqlConnection.Open();
         parameters.Add("@appointmentId", appointment.appointmentId, DbType.String, ParameterDirection.Input);
         parameters.Add("@appointmentStartDate", appointment.appointmentStartDate, DbType.String, ParameterDirection.Input);
         parameters.Add("@appointmentEndDate", appointment.appointmentEndDate, DbType.String, ParameterDirection.Input);
         parameters.Add("@memo", appointment.memo, DbType.String, ParameterDirection.Input);
         parameters.Add("@cancelled", appointment.cancelled ? 1 : 0, DbType.String, ParameterDirection.Input);
         parameters.Add("@confirmed", appointment.confirmed ? 1 : 0, DbType.String, ParameterDirection.Input);
         parameters.Add("@completed", appointment.completed ? 1 : 0, DbType.String, ParameterDirection.Input);
         result = sqlConnection.QueryFirstOrDefault <AppointmentDataAccess.appointment>("Appointment_add", parameters, commandType: CommandType.StoredProcedure);
         sqlConnection.Close();
     }
     return(result);
 }
 public AppointmentDataAccess.appointment SetUpAppointment(AppointmentDataAccess.appointment appointment)
 {
     return(DataProvider.Instance.SetUpAppointment(appointment));
 }