Example #1
0
        public MusicRepository(ApplicationDbContext context)
        {
            this.context = context;

            // If MusicTracks is empty, load all data from DB
            if (MusicTracks.Count == 0)
            {
                // load genre/instrument/mood/musicTrack list from db
                genreList.AddRange(context.GenreTags.OrderBy(g => g.Tag).ToList());

                // THE FAST WAY
                moodList.AddRange(context.MoodTags.OrderBy(m => m.Tag).ToList());

                // THE SLOW WAY
                //List<MoodTag> allMoodTags = context.MoodTags.ToList();

                //foreach (MoodTag mt in allMoodTags)
                //{
                //    moodList.Add(mt.Tag);
                //}

                //moodList.Sort();

                instrumentList.AddRange(context.InstrumentTags.OrderBy(i => i.Tag).ToList());

                musicTrackInstrumentTags.AddRange(context.MusicTrackInstrumentTags.ToList());

                musicTrackMoodTags.AddRange(context.MusicTrackMoodTags.ToList());


                musicTracks = context.MusicTracks.Include(m => m.Genre).Include(x => x.MusicTrackMoodTags).Include(x => x.MusicTrackInstrumentTags).ToList();

                foreach (MusicTrack musicTrack in musicTracks)
                {
                    foreach (MusicTrackMoodTag mt in musicTrack.MusicTrackMoodTags)
                    {
                        musicTrack.Moods.Add(MoodList.First(m => m.ID == mt.MoodTagID));
                    }

                    foreach (MusicTrackInstrumentTag it in musicTrack.MusicTrackInstrumentTags)
                    {
                        musicTrack.Instruments.Add(InstrumentList.First(m => m.ID == it.InstrumentTagID));
                    }
                }
            }
        }
Example #2
0
        public void RefreshMusicTracks()
        {
            musicTracks = new List <MusicTrack>();

            musicTracks = context.MusicTracks.Include(m => m.Genre).Include(x => x.MusicTrackMoodTags).Include(x => x.MusicTrackInstrumentTags).ToList();

            foreach (MusicTrack musicTrack in musicTracks)
            {
                foreach (MusicTrackMoodTag mt in musicTrack.MusicTrackMoodTags)
                {
                    musicTrack.Moods.Add(MoodList.First(m => m.ID == mt.MoodTagID));
                }

                foreach (MusicTrackInstrumentTag it in musicTrack.MusicTrackInstrumentTags)
                {
                    musicTrack.Instruments.Add(InstrumentList.First(m => m.ID == it.InstrumentTagID));
                }
            }
        }