public void AddBandAlbumSong(Guid idBand, Guid?idAlbum, Guid idSong)
{
if (!db.Bands.Any(b => b.IdBand == idBand))
{
throw new Exception("Band id not found");
}
if (idAlbum != null)
{
if (!db.Albums.Any(a => a.IdAlbum == idAlbum))
{
throw new Exception("Album id not found");
}
}
if (!db.Songs.Any(s => s.IdSong == idSong))
{
throw new Exception("Song id not found");
}
if (db.BandAlbumSongs.Any(bas => bas.IdBand == idBand && bas.IdSong == idSong))
{
throw new Exception("BandAlbumSong link already exists");
}
BandAlbumSong newBandAlbumSong = new BandAlbumSong()
{
IdBand = idBand, IdAlbum = idAlbum, IdSong = idSong
};
db.BandAlbumSongs.InsertOnSubmit(newBandAlbumSong);
db.SubmitChanges();
}
private void detach_BandAlbumSongs(BandAlbumSong entity)
{
this.SendPropertyChanging();
entity.Band = null;
}
private void attach_BandAlbumSongs(BandAlbumSong entity)
{
this.SendPropertyChanging();
entity.Band = this;
}
partial void DeleteBandAlbumSong(BandAlbumSong instance);
partial void UpdateBandAlbumSong(BandAlbumSong instance);
partial void InsertBandAlbumSong(BandAlbumSong instance);
