public static void AddOrUpdateArtist(StoreContext db, Song song, Artist artistToAdd) { if (song.Artist == artistToAdd) //new artist is the same as the original artist { //do nothing } else { song.Artist = artistToAdd; } }
public static SelectList GetAllArtists(StoreContext db) { var query = from a in db.Artist orderby a.Name select a; List<Artist> allArtists = query.ToList(); SelectList list = new SelectList(allArtists, "ArtistID", "Name"); return list; }
public static List<Genre> GetGenresFromIntList(StoreContext db, List<int> selectedGenres) { List<Genre> genresToAdd = new List<Genre>(); foreach (int genreID in selectedGenres) { genresToAdd.Add(db.Genre.Find(genreID)); } return genresToAdd; }
public static MultiSelectList GetAllGenres(StoreContext context) { var genres = from g in context.Genre orderby g.Name select g; List<Genre> allGenres = genres.ToList(); MultiSelectList genreList = new MultiSelectList(allGenres, "GenreID", "Name"); return genreList; }
public static SelectList GetAllArtistsWithAll(StoreContext db) { var query = from a in db.Artist orderby a.Name select a; List<Artist> allArtists = query.ToList(); allArtists.Insert(0, new Artist { ArtistID = -1, Name = "All Artists" }); SelectList list = new SelectList(allArtists, "ArtistID", "Name"); return list; }
public static void AddOrUpdateSongGenre(StoreContext context, Song song, IEnumerable<Genre> songGenres) { if (songGenres != null) { //drop existing song genres song.Genres.Clear(); foreach (var songGenre in songGenres) { song.Genres.Add(songGenre); } } }
public static void AddOrUpdateSongGenre(StoreContext context, Song song, List<int> genreIDs) { List<Genre> genres = GetGenresFromIntList(context, genreIDs); AddOrUpdateSongGenre(context, song, genres); }
public static void AddOrUpdateSongGenre(StoreContext context, string songName, string genreName) { var genre = context.Genre.SingleOrDefault(g => g.Name == genreName); var song = context.Song.SingleOrDefault(s => s.Name == songName); song.Genres.Add(genre); }