public static Song GetOrCreateSong(Song song, MusicStoreDb musicStoreDbContext) { Song existingSong = null; song.Artist = GetOrCreateArtist(song.Artist, musicStoreDbContext); if (song.Id != 0) { existingSong = musicStoreDbContext.Songs.FirstOrDefault(s => s.Id == song.Id); } else if (song.Title != null) { existingSong = musicStoreDbContext.Songs.FirstOrDefault(s => s.Title == song.Title); } if (existingSong != null) { return existingSong; } musicStoreDbContext.Songs.Add(song); musicStoreDbContext.SaveChanges(); return song; }
public static Artist GetOrCreateArtist(Artist artist, MusicStoreDb musicStoreDbContext) { Artist existingArtist = null; if (artist.Id != 0) { existingArtist = musicStoreDbContext.Artists.FirstOrDefault(a => a.Id == artist.Id); } else if (artist.Name != null) { existingArtist = musicStoreDbContext.Artists.FirstOrDefault(a => a.Name == artist.Name); } if (existingArtist != null) { return existingArtist; } musicStoreDbContext.Artists.Add(artist); musicStoreDbContext.SaveChanges(); return artist; }
public static Album GetOrCreateAlbum(Album album, MusicStoreDb musicStoreDbContext) { Album existingAlbum = null; if (album.Id != 0) { existingAlbum = musicStoreDbContext.Albums.FirstOrDefault(a => a.Id == album.Id); } else if (album.Title != null) { existingAlbum = musicStoreDbContext.Albums.FirstOrDefault(a => a.Title == album.Title); } if (existingAlbum != null) { return existingAlbum; } musicStoreDbContext.Albums.Add(album); musicStoreDbContext.SaveChanges(); return album; }