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;
        }
Пример #3
0
        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;
        }
Пример #4
0
        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;
        }
Пример #6
0
        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);
                }
            }
        }
Пример #7
0
 public static void AddOrUpdateSongGenre(StoreContext context, Song song, List<int> genreIDs)
 {
     List<Genre> genres = GetGenresFromIntList(context, genreIDs);
     AddOrUpdateSongGenre(context, song, genres);
 }
Пример #8
0
 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);
 }