/// <summary>
/// Adds a new album into the users main collection.
/// </summary>
/// <param name="albumToCollectionDTO">Object</param>
/// <returns>True if no errors</returns>
public bool AddNewAlbumToMainCollection(AlbumToCollectionDTO albumToCollectionDTO)
{
using (var db = new SqlConnection(_connectionString))
{
var album = albumToCollectionDTO.NewAlbum;
Guid albumId;
// First checks to see if album has already been added into Discdig DB from Discog DB
var albumCheck = _albumRepo.GetAlbumIdByDiscogId(album.DiscogId);
if (albumCheck == default)
{
// adds the album id into Discdig DB
albumId = _albumRepo.AddNewAlbumToDatabase(album);
}
else
{
// sets the album id to what is returned from the check
albumId = albumCheck;
}
var mainId = GetUsersMainCollectionId(albumToCollectionDTO.UserId);
var sql = @"INSERT INTO [CollectionAlbum]
(
[CollectionId],
[AlbumId]
)
VALUES
(
@mainId,
@albumId
)";
var parameters = new { albumId, mainId };
return(db.Execute(sql, parameters) == 1);
}
}
public IActionResult AddNewAlbumToCollection(AlbumToCollectionDTO albumToCollectionDTO)
{
if (_repo.AddNewAlbumToMainCollection(albumToCollectionDTO))
{
return(Created($"collection/{albumToCollectionDTO.NewAlbum.Title}", albumToCollectionDTO));
}
else
{
return(BadRequest());
}
}
