/// <summary>
/// Adds a new album into the database
/// </summary>
/// <param name="newAlbumDTO">Album info needed to create new album into database</param>
/// <returns>Unique Id of album created</returns>
public Guid AddNewAlbumToDatabase(NewAlbumDTO newAlbumDTO)
{
using (var db = new SqlConnection(_connectionString))
{
var sql = @"INSERT INTO [Album]
(
[Title],
[ImgUrl],
[Label],
[Artist],
[ReleaseYear],
[DiscogId]
)
OUTPUT INSERTED.Id
VALUES
(
@title,
@imgUrl,
@label,
@artist,
@releaseYear,
@discogId
)";
var id = db.QueryFirst <Guid>(sql, newAlbumDTO);
foreach (string genreName in newAlbumDTO.Genre)
{
_genreRepo.AddGenreToAlbum(id, genreName);
}
return(id);
}
}