Ejemplo n.º 1
0
        public List<TrackDto> ListTracks()
        {
            using (var db = new MyTunesDatabaseContext())
            {
                // TODO: Remove hard-wired "paging"
                var tracks = db.Tracks.Take(20).Project().To<TrackDto>().ToList();

                return tracks;
            }
        }
Ejemplo n.º 2
0
        public void DeleteTrack(int trackId)
        {
            using (var db = new MyTunesDatabaseContext())
            {
                var entity = new Track { TrackId = trackId };

                db.Entry(entity).State = EntityState.Deleted;
                db.SaveChanges();
            }
        }
Ejemplo n.º 3
0
        public TrackDetailsDto GetTrackDetails(int id)
        {
            using (var db = new MyTunesDatabaseContext())
            {
                var track = db.Tracks
                    .FirstOrDefault(t => t.TrackId == id).ToDetailsDto();

                return track;
            }
        }
Ejemplo n.º 4
0
        public TrackDetailsDto AddTrack(TrackDetailsDto trackDetailsDto)
        {
            using (var db = new MyTunesDatabaseContext())
            {
                var entity = trackDetailsDto.ToTrack();
                entity.MediaTypeId = 1;

                db.Entry(entity).State = EntityState.Added;
                db.SaveChanges();

                return entity.ToDetailsDto();
            }
        }