public IShow Create(CreateShowRequest request)
{
const string sql = @"
INSERT INTO show (show_id, name, maze_id, path)
VALUES (default, @name, @mazeid, @path)
RETURNING show_id" ;
using (var dbConnection = Database.CreateConnection())
{
return(new Show
{
ShowId = dbConnection.Query <Id <Show> >(sql, request).Single(),
Name = request.Name,
MazeId = request.MazeId,
Path = request.Path,
});
}
}
public async Task <ActionResult <Result> > Create([FromBody] CreateShowRequest createShowRequest)
{
var show = _showStore.Create(createShowRequest);
return(await _refreshShowTask.Refresh(show));
}
