public IEnumerable <MovieDataModel> UpsertMovie(MovieRequest video)
{
using var sqlConnection = new SqlConnection(_configuration.CreateConnectionString());
var command = video.CreateMovieCommand(sqlConnection);
return(ReadFromDatabase <MovieDataModel>(command));
}
public static void AddRequestItem(MovieRequest request, IConfiguration configuration)
{
var connection = configuration.CreateConnectionString();
using var sqlConnection = new SqlConnection(connection);
var command = request.CreateMovieCommand(sqlConnection);
command.Connection.Open();
command.ExecuteNonQuery();
command.Connection.Close();
}
