public async Task RemoveVideoFromPlaylist(VideoPlaylistViewModel videoPlaylist)
{
using (NpgsqlConnection conexao = new NpgsqlConnection(connectionString))
{
var playlist = await conexao.ExecuteAsync(@"DELETE FROM videoplaylist
WHERE videoid = @VideoId AND playlistid = @PlaylistId", videoPlaylist);
}
}
public async Task AddVideoToPlaylist(VideoPlaylistViewModel videoPlaylist)
{
using (NpgsqlConnection conexao = new NpgsqlConnection(connectionString))
{
var result = await conexao.QueryFirstOrDefaultAsync <VideoPlaylist>(@"SELECT * FROM videoplaylist
WHERE videoId = @VideoId AND playlistid = @PlaylistId", videoPlaylist);
if (result != null)
{
throw new Exception("Relacionamento já existe");
}
await conexao.ExecuteAsync("INSERT INTO VideoPlaylist(videoid, playlistid) VALUES(@VideoId, @PlaylistId)", videoPlaylist);
}
}
public async Task AddVideoToPlaylist(VideoPlaylistViewModel videoPlaylistViewModel)
{
await repository.AddVideoToPlaylist(videoPlaylistViewModel);
}
public async Task RemoveVideoFromPlaylist(VideoPlaylistViewModel videoPlaylist)
{
await repository.RemoveVideoFromPlaylist(videoPlaylist);
}
