public function saveCinemaSession(cw_cinema_sessions $status)
{
$query = $status->getId() ? 'UPDATE cw_cinema_sessions
SET idMovie = :idMovie,
idTheater = :idTheater,
date = :date,
language = :language,
subModels :subModels,
archive :archive
WHERE id = :id' : 'INSERT INTO cw_cinema_sessions
(id, idMovie, idTheater, date, language, subModels, archive)
VALUES
(:id, :idMovie, :idTheater, :date, :language, :subModels, :archive)';
$query = $this->db->prepare($query);
$query->execute(['id' => $status->getId(), 'idTheater' => $status->getIdTheater(), 'idMovie' => $status->getIdMovie(), 'date' => $status->getDate(), 'language' => $status->getLanguage(), 'subModels' => $status->getsubModels(), 'archive' => $status->getArchive()]);
return $this->db->lastInsertId();
}
<?php
use Cinewax\Api\Models\Cinewax\cw_cinema_sessions;
use silex\Application;
use Symfony\Component\HttpFoundation\Request;
use Symfony\Component\HttpFoundation\Response;
$app->post('/addCinemaSessions', function (Application $app, Request $request) {
$status = new cw_cinema_sessions();
$status->setIdMovie($request->request->get('idMovie'));
$status->setIdTheater($request->request->get('idTheater'));
$status->setDate($request->request->get('date'));
$status->setLanguage($request->request->get('language'));
$status->setSubModels($request->request->get('setSubModels'));
$status->setArchive($request->request->get('archive'));
$id = $app['repo.cinemaSessions']->saveCinemaSession($status);
$response = new Response(null, 201);
$response->headers->set('Location', $app['url_generator']->generate('status', ['status' => $id]));
return $response;
});