/// <summary>
/// Add one or more albums into selected subcollection
/// </summary>
/// <param name="addToSubcollection">Object</param>
/// <returns>True if no errors</returns>
public bool AddAlbumsToSubcollection(AddToSubcollectionDTO addToSubcollection)
{
using (var db = new SqlConnection(_connectionString))
{
var albumId = addToSubcollection.AlbumsToAdd;
var collectionId = addToSubcollection.CollectionId;
List <Object> parameters = new List <Object>();
// creates a new list of objects to add
foreach (Guid id in albumId)
{
var obj = new
{
AlbumId = id,
CollectionId = collectionId
};
parameters.Add(obj);
}
var sql = @"INSERT INTO [CollectionAlbum]
(
[CollectionId],
[AlbumId]
)
VALUES
(
@collectionId,
@albumId
)";
return(db.Execute(sql, parameters) >= 1);
}
}
public IActionResult AddAlbumsToSubcollection(AddToSubcollectionDTO addToSubcollection)
{
if (_repo.AddAlbumsToSubcollection(addToSubcollection))
{
return(Ok());
}
else
{
return(BadRequest());
}
}
