/// <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 AddNewAlbumToDatabase(NewAlbumDTO newAlbum) { var albumId = _repo.AddNewAlbumToDatabase(newAlbum); if (albumId == null) { return(BadRequest()); } else { return(Created($"album/{newAlbum.Title}", newAlbum)); } }