/// <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()); } }