Exemplo n.º 1
0
        public static bool UpdatePlaylistSong(PlaylistSong editedPlaylistSong)
        {
            bool success = false;

            using (CDCatalogEntities db = new CDCatalogEntities())
            {
                try
                {
                    PlaylistSong playlistSong = db.PlaylistSongs.Where(p => p.PlaylistID.Equals(editedPlaylistSong.PlaylistID) &&
                                                                       p.SongID.Equals(editedPlaylistSong.SongID)).First();
                    playlistSong.SongOrder = editedPlaylistSong.SongOrder;
                    db.SaveChanges();
                    success = true;
                }
                catch (Exception SQLe)
                {
                    LogError("CDCatalogManager.UpdatePlaylistSong", SQLe.ToString());
                    //using (StreamWriter sw = File.AppendText("errorlog.txt"))
                    //{
                    //    sw.WriteLine("--------------");
                    //    sw.WriteLine(DateTime.Now);
                    //    sw.WriteLine("Source: CDCatalogManager.UpdatePlaylistSong");
                    //    sw.WriteLine(SQLe.ToString());
                    //}
                }
                return(success);
            }
        }
Exemplo n.º 2
0
        public static bool DeleteAlbum(Album albumToDelete)
        {
            bool success = false;

            using (CDCatalogEntities db = new CDCatalogEntities())
            {
                try
                {
                    Album alb = db.Albums.Where(a => a.AlbumID.Equals(albumToDelete.AlbumID)).First();

                    db.Albums.Remove(alb);
                    db.SaveChanges();
                    success = true;
                }
                catch (Exception SQLe)
                {
                    LogError("CDCatalogManager.DeleteAlbum", SQLe.ToString());
                    //using (StreamWriter sw = File.AppendText("errorlog.txt"))
                    //{
                    //    sw.WriteLine("--------------");
                    //    sw.WriteLine(DateTime.Now);
                    //    sw.WriteLine("Source: CDCatalogManager.DeleteAlbums");
                    //    sw.WriteLine(SQLe.ToString());
                    //}
                }
                return(success);
            }
        }
Exemplo n.º 3
0
        public static List <Song> GetSongsFromPlaylist(Playlist playlist)
        {
            //Take a Playlist, find all the PlaylistSongs with the matchingPlaylistID,
            //and populate a List with all the Songs that match the PlaylistSongs' SongIDs.
            List <Song>         workingList = GetSongs();
            List <Song>         songList    = new List <Song>();
            List <PlaylistSong> pLSList     = new List <PlaylistSong>();

            using (CDCatalogEntities db = new CDCatalogEntities())
            {
                try
                {
                    pLSList = db.PlaylistSongs.Where(pls => pls.PlaylistID.Equals(playlist.PlaylistID)).ToList();
                    foreach (PlaylistSong pls in pLSList)
                    {
                        songList.Add(workingList.Where(s => s.SongID.Equals(pls.SongID)).First());
                    }
                }
                catch (Exception SQLe)
                {
                    LogError("CDCatalogManager.GetSongsFromPlaylist", SQLe.ToString());
                    //using (StreamWriter sw = File.AppendText("errorlog.txt"))
                    //{
                    //    sw.WriteLine("--------------");
                    //    sw.WriteLine(DateTime.Now);
                    //    sw.WriteLine("Source: CDCatalogManager.GetSongsFromPlaylist");
                    //    sw.WriteLine(SQLe.ToString());
                    //}
                }
            }
            return(songList);
        }
Exemplo n.º 4
0
        public static bool DeletePlaylistSong(PlaylistSong playlistSongToDelete)
        {
            bool success = false;

            using (CDCatalogEntities db = new CDCatalogEntities())
            {
                try
                {
                    db.PlaylistSongs.Remove(playlistSongToDelete);
                    db.SaveChanges();
                    success = true;
                }
                catch (Exception SQLe)
                {
                    LogError("CDCatalogManager.DeletePlaylistSong", SQLe.ToString());
                    //using (StreamWriter sw = File.AppendText("errorlog.txt"))
                    //{
                    //    sw.WriteLine("--------------");
                    //    sw.WriteLine(DateTime.Now);
                    //    sw.WriteLine("Source: CDCatalogManager.DeletePlaylistSong");
                    //    sw.WriteLine(SQLe.ToString());
                    //}
                }
                return(success);
            }
        }
Exemplo n.º 5
0
        public static bool AddAlbum(Album newAlbum)
        {
            bool success = false;

            using (CDCatalogEntities db = new CDCatalogEntities())
            {
                try
                {
                    db.Albums.Add(newAlbum);
                    db.SaveChanges();
                    success = true;
                }
                catch (Exception SQLe)
                {
                    LogError("CDCatalogManager.AddAlbum", SQLe.ToString());
                    //using (StreamWriter sw = File.AppendText("errorlog.txt"))
                    //{
                    //    sw.WriteLine("--------------");
                    //    sw.WriteLine(DateTime.Now);
                    //    sw.WriteLine("Source: CDCatalogManager.AddAlbum");
                    //    sw.WriteLine(SQLe.ToString());
                    //}
                }
                return(success);
            }
        }
Exemplo n.º 6
0
 public static List <Song> GetSongs()
 {
     using (CDCatalogEntities db = new CDCatalogEntities())
     {
         List <Song> songList = new List <Song>();
         try
         {
             songList = db.Songs.OrderByDescending(s => s.Rating).ToList();
             //A Song is a complex object. It has associated Artist, Album, and Genre objects,
             //and the associated Album object has its own associated Artist object, which may be
             //different than the Artist associated with the Song.
             //This loop populates the Song object with its necessary associated data.
             foreach (Song song in songList)
             {
                 song.Artist       = db.Artists.Where(art => art.ArtistID.Equals(song.ArtistID)).First();
                 song.Genre        = db.Genres.Where(g => g.GenreID.Equals(song.GenreID)).First();
                 song.Album        = db.Albums.Where(alb => (alb.AlbumID == song.AlbumID)).First();
                 song.Album.Artist = db.Artists.Where(art => (art.ArtistID == song.Album.ArtistID)).First();
             }
         }
         catch (Exception SQLe)
         {
             LogError("CDCatalogManager.GetSongs", SQLe.ToString());
             //using (StreamWriter sw = File.AppendText("errorlog.txt"))
             //{
             //    sw.WriteLine("--------------");
             //    sw.WriteLine(DateTime.Now);
             //    sw.WriteLine("Source: CDCatalogManager.GetSongs");
             //    sw.WriteLine(SQLe.ToString());
             //}
         }
         return(songList);
     }
 }
Exemplo n.º 7
0
        public static bool UpdateSong(Song editedSong)
        {
            bool success = false;

            using (CDCatalogEntities db = new CDCatalogEntities())
            {
                try
                {
                    Song son = db.Songs.Where(s => s.SongID.Equals(editedSong.SongID)).First();
                    son.SongTitle     = editedSong.SongTitle;
                    son.AlbumID       = editedSong.AlbumID;
                    son.ArtistID      = editedSong.ArtistID;
                    son.GenreID       = editedSong.GenreID;
                    son.PlaylistSongs = editedSong.PlaylistSongs;
                    son.Rating        = editedSong.Rating;
                    son.TrackLength   = editedSong.TrackLength;
                    son.TrackNumber   = editedSong.TrackNumber;
                    db.SaveChanges();
                    success = true;
                }
                catch (Exception SQLe)
                {
                    LogError("CDCatalogManager.UpdateSong", SQLe.ToString());
                    //using (StreamWriter sw = File.AppendText("errorlog.txt"))
                    //{
                    //    sw.WriteLine("--------------");
                    //    sw.WriteLine(DateTime.Now);
                    //    sw.WriteLine("Source: CDCatalogManager.UpdateSong");
                    //    sw.WriteLine(SQLe.ToString());
                    //}
                }
                return(success);
            }
        }
Exemplo n.º 8
0
        public static bool UpdateGenre(Genre editedGenre)
        {
            bool success = false;

            using (CDCatalogEntities db = new CDCatalogEntities())
            {
                try
                {
                    Genre gen = db.Genres.Where(g => g.GenreID.Equals(editedGenre.GenreID)).First();
                    gen.GenreName = editedGenre.GenreName;
                    //gen.Songs = editedGenre.Songs; //This seems unnecessary?
                    db.SaveChanges();
                    success = true;
                }
                catch (Exception SQLe)
                {
                    LogError("CDCatalogManager.UpdateGenre", SQLe.ToString());
                    //using (StreamWriter sw = File.AppendText("errorlog.txt"))
                    //{
                    //    sw.WriteLine("--------------");
                    //    sw.WriteLine(DateTime.Now);
                    //    sw.WriteLine("Source: CDCatalogManager.UpdateGenre");
                    //    sw.WriteLine(SQLe.ToString());
                    //}
                }
                return(success);
            }
        }
Exemplo n.º 9
0
        public static bool UpdatePlaylist(Playlist editedPlaylist)
        {
            bool success = false;

            using (CDCatalogEntities db = new CDCatalogEntities())
            {
                try
                {
                    Playlist play = db.Playlists.Where(p => p.PlaylistID.Equals(editedPlaylist.PlaylistID)).First();
                    play.PlaylistName = editedPlaylist.PlaylistName;
                    //TODO: Need to think about this process some more.
                    //play.PlaylistSongs = editedPlaylist.PlaylistSongs;
                    db.SaveChanges();
                    success = true;
                }
                catch (Exception SQLe)
                {
                    LogError("CDCatalogManager.UpdatePlaylist", SQLe.ToString());
                    //using (StreamWriter sw = File.AppendText("errorlog.txt"))
                    //{
                    //    sw.WriteLine("--------------");
                    //    sw.WriteLine(DateTime.Now);
                    //    sw.WriteLine("Source: CDCatalogManager.UpdatePlaylist");
                    //    sw.WriteLine(SQLe.ToString());
                    //}
                }
                return(success);
            }
        }
Exemplo n.º 10
0
        public static List <Album> GetAlbums()
        {
            List <Album> albumList = new List <Album>();

            using (CDCatalogEntities db = new CDCatalogEntities())
            {
                try
                {
                    albumList = db.Albums.OrderByDescending(a => a.Rating).ToList();
                    //An Album object has an associated Artist object; this loop attaches Artists to Albums.
                    foreach (Album alb in albumList)
                    {
                        alb.Artist = db.Artists.Where(art => art.ArtistID.Equals(alb.ArtistID)).First();
                    }
                }
                catch (Exception SQLe)
                {
                    LogError("CDCatalogManager.GetAlbums", SQLe.ToString());
                    //using (StreamWriter sw = File.AppendText("errorlog.txt"))
                    //{
                    //    sw.WriteLine("--------------");
                    //    sw.WriteLine(DateTime.Now);
                    //    sw.WriteLine("Source: CDCatalogManager.GetAlbums");
                    //    sw.WriteLine(SQLe.ToString());
                    //}
                }
                return(albumList);
            }
        }
Exemplo n.º 11
0
        public static bool UpdateArtist(Artist editedArtist)
        {
            bool success = false;

            using (CDCatalogEntities db = new CDCatalogEntities())
            {
                try
                {
                    Artist art = db.Artists.Where(a => a.ArtistID.Equals(editedArtist.ArtistID)).First();

                    art.ArtistName = editedArtist.ArtistName;
                    //art.Albums = editedArtist.Albums; //This seems unnecessary
                    //art.Songs = editedArtist.Songs; //This, too.
                    db.SaveChanges();
                    success = true;
                }
                catch (Exception SQLe)
                {
                    LogError("CDCatalogManager.UpdateArtist", SQLe.ToString());
                    //using (StreamWriter sw = File.AppendText("errorlog.txt"))
                    //{
                    //    sw.WriteLine("--------------");
                    //    sw.WriteLine(DateTime.Now);
                    //    sw.WriteLine("Source: CDCatalogManager.UpdateArtist");
                    //    sw.WriteLine(SQLe.ToString());
                    //}
                }
                return(success);
            }
        }
Exemplo n.º 12
0
        public static bool UpdateAlbum(Album editedAlbum)
        {
            bool success = false;

            using (CDCatalogEntities db = new CDCatalogEntities())
            {
                try
                {
                    Album alb = db.Albums.Where(a => a.AlbumID.Equals(editedAlbum.AlbumID)).First();
                    alb.AlbumTitle = editedAlbum.AlbumTitle;
                    alb.Rating     = editedAlbum.Rating;
                    alb.Year       = editedAlbum.Year;
                    alb.ArtistID   = editedAlbum.ArtistID;
                    db.SaveChanges();
                    success = true;
                }
                catch (Exception SQLe)
                {
                    LogError("CDCatalogManager.UpdateAlbum", SQLe.ToString());
                    //using (StreamWriter sw = File.AppendText("errorlog.txt"))
                    //{
                    //    sw.WriteLine("--------------");
                    //    sw.WriteLine(DateTime.Now);
                    //    sw.WriteLine("Source: CDCatalogManager.UpdateAlbum");
                    //    sw.WriteLine(SQLe.ToString());
                    //}
                }
                return(success);
            }
        }
Exemplo n.º 13
0
 public static List <PlaylistSong> GetPlaylistSongs()
 {
     using (CDCatalogEntities db = new CDCatalogEntities())
     {
         List <PlaylistSong> playlistSongList = new List <PlaylistSong>();
         try
         {
             playlistSongList = db.PlaylistSongs.OrderBy(p => p.SongOrder).ToList();
         }
         catch (Exception SQLe)
         {
             LogError("CDCatalogManager.GetPlaylistSongs", SQLe.ToString());
             //using (StreamWriter sw = File.AppendText("errorlog.txt"))
             //{
             //    sw.WriteLine("--------------");
             //    sw.WriteLine(DateTime.Now);
             //    sw.WriteLine("Source: CDCatalogManager.GetPlaylistSongs");
             //    sw.WriteLine(SQLe.ToString());
             //}
         }
         return(playlistSongList);
     }
 }
Exemplo n.º 14
0
 public static List <Genre> GetGenres()
 {
     using (CDCatalogEntities db = new CDCatalogEntities())
     {
         List <Genre> genreList = new List <Genre>();
         try
         {
             genreList = db.Genres.OrderBy(g => g.GenreName).ToList();
         }
         catch (Exception SQLe)
         {
             LogError("CDCatalogManager.GetGenres", SQLe.ToString());
             //using (StreamWriter sw = File.AppendText("errorlog.txt"))
             //{
             //    sw.WriteLine("--------------");
             //    sw.WriteLine(DateTime.Now);
             //    sw.WriteLine("Source: CDCatalogManager.GetGenres");
             //    sw.WriteLine(SQLe.ToString());
             //}
         }
         return(genreList);
     }
 }
Exemplo n.º 15
0
 public static List <Artist> GetArtists()
 {
     using (CDCatalogEntities db = new CDCatalogEntities())
     {
         List <Artist> artistList = new List <Artist>();
         try
         {
             artistList = db.Artists.OrderBy(a => a.ArtistName).ToList();
         }
         catch (Exception SQLe)
         {
             LogError("CDCatalogManager.GetArtists", SQLe.ToString());
             //using (StreamWriter sw = File.AppendText("errorlog.txt"))
             //{
             //    sw.WriteLine("--------------");
             //    sw.WriteLine(DateTime.Now);
             //    sw.WriteLine("Source: CDCatalogManager.GetArtists");
             //    sw.WriteLine(SQLe.ToString());
             //}
         }
         return(artistList);
     }
 }