public void DeletarAlbum(int id)
{
MusicaRepository musicaRepository = new MusicaRepository(database);
musicaRepository.DeletarMusicaPorIdAlbum(id);
database.Connection.Execute(@"
DELETE FROM [dbo].[Album]
WHERE
[idAlbum] = @id", new { id }, database.Transaction);
}
public Album Obter(int id)
{
var album = database.Connection.Query <Album>(@"
SELECT
[AlbumId] As Id,
[Nome]
FROM [dbo].[Album]
WHERE [AlbumId]=@Id
", new { id }, database.Transaction).FirstOrDefault();
if (album == null)
{
return(null);
}
var musicaRepository = new MusicaRepository(database);
var listaDeMusicas = musicaRepository.ListarMusicas(album.Id);
album.Musicas = listaDeMusicas;
return(album);
}
