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