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); } }
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); } }
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); }
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); } }
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); } }
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); } }
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); } }
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); } }
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); } }
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); } }
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); } }
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); } }
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); } }
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); } }
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); } }