public List <AlbumTrackerView> Get()
        {
            List <AlbumTrackerView> albumTrackerList = new List <AlbumTrackerView>();

            using (AlbumTrackerDBContext db = new AlbumTrackerDBContext())
            {
                var result = db.AlbumTrackerTable;
                if (result != null)
                {
                    foreach (var item in result)
                    {
                        AlbumTrackerView albumTrackerView = new AlbumTrackerView();
                        albumTrackerView.AlbumID          = item.AlbumID;
                        albumTrackerView.AlbumName        = item.AlbumName;
                        albumTrackerView.ArtistName       = item.ArtistName;
                        albumTrackerView.AlbumDescription = item.AlbumDescription;
                        albumTrackerView.AlbumRating      = item.AlbumRating;
                        albumTrackerView.AlbumYear        = item.AlbumYear;

                        albumTrackerList.Add(albumTrackerView);
                    }
                }
            }

            return(albumTrackerList);
        }
        public void Put(int id, [FromBody] AlbumTrackerView albumTracker)
        {
            using (AlbumTrackerDBContext db = new AlbumTrackerDBContext())
            {
                var result = db.AlbumTrackerTable.FirstOrDefault(p => p.AlbumID == id);
                if (result != null)
                {
                    result.AlbumName        = albumTracker.AlbumName;
                    result.ArtistName       = albumTracker.ArtistName;
                    result.AlbumDescription = albumTracker.AlbumDescription;
                    result.AlbumRating      = albumTracker.AlbumRating;
                    result.AlbumYear        = albumTracker.AlbumYear;

                    db.SaveChanges();
                }
            }
        }
        public void Post([FromBody] AlbumTrackerView albumTracker)
        {
            if (albumTracker != null)
            {
                using (AlbumTrackerDBContext db = new AlbumTrackerDBContext())
                {
                    AlbumTrackerRepresentation albumTrackerRepresentation = new AlbumTrackerRepresentation();
                    albumTrackerRepresentation.AlbumName        = albumTracker.AlbumName;
                    albumTrackerRepresentation.ArtistName       = albumTracker.ArtistName;
                    albumTrackerRepresentation.AlbumDescription = albumTracker.AlbumDescription;
                    albumTrackerRepresentation.AlbumRating      = albumTracker.AlbumRating;
                    albumTrackerRepresentation.AlbumYear        = albumTracker.AlbumYear;

                    db.AlbumTrackerTable.Add(albumTrackerRepresentation);
                    db.SaveChanges();
                }
            }
        }
        public AlbumTrackerView Get(int id)
        {
            if (id > 0)
            {
                using (AlbumTrackerDBContext db = new AlbumTrackerDBContext())
                {
                    var result = db.AlbumTrackerTable.FirstOrDefault(p => p.AlbumID == id);
                    if (result != null)
                    {
                        AlbumTrackerView albumTrackerView = new AlbumTrackerView();
                        albumTrackerView.AlbumID          = result.AlbumID;
                        albumTrackerView.AlbumName        = result.AlbumName;
                        albumTrackerView.ArtistName       = result.ArtistName;
                        albumTrackerView.AlbumDescription = result.AlbumDescription;
                        albumTrackerView.AlbumRating      = result.AlbumRating;
                        albumTrackerView.AlbumYear        = result.AlbumYear;

                        return(albumTrackerView);
                    }
                }
            }

            return(null);
        }