internal void SaveSongToLib(Song song)
{
using (RemoteLibraryEntities ctx = new RemoteLibraryEntities())
{
ctx.Songs.Add(song);
ctx.SaveChanges();
Console.WriteLine("Song: {0}, {1}, {2}", song.Id, song.Title, song.ArtistName);
}
}
internal void DeleteSongInPlaylist(PlayList pl)
{
using (RemoteLibraryEntities ctx = new RemoteLibraryEntities())
{
ctx.PlayLists.Remove(pl);
ctx.SaveChanges();
Console.WriteLine("Playlist: {0}, {1}, {2}, {3}", pl.Id, pl.SongId, pl.PlayListName, pl.Description);
}
}
internal void SavePlaylistsToLib(List <PlayList> lstPlaylist)
{
using (RemoteLibraryEntities ctx = new RemoteLibraryEntities())
{
foreach (var pl in lstPlaylist)
{
ctx.PlayLists.Add(pl);
ctx.SaveChanges();
Console.WriteLine("Playlist: {0}, {1}, {2}, {3}", pl.Id, pl.SongId, pl.PlayListName, pl.Description);
}
}
}
//add by chenchen 0428
internal void DeletePlaylistFromLibBySongIdAndplName(int id, String plName)
{
using (RemoteLibraryEntities ctx = new RemoteLibraryEntities())
{
var lstPlaylist = (from pl in ctx.PlayLists
where pl.SongId == id && pl.PlayListName == plName
select pl
).ToList <PlayList>();
foreach (var pl in lstPlaylist)
{
ctx.PlayLists.Remove(pl);
ctx.SaveChanges();
Console.WriteLine("Playlist: {0}, {1}, {2}, {3}", pl.Id, pl.SongId, pl.PlayListName, pl.Description);
}
}
}
internal void UpdatePlaylistbyName(String oldName, string newName, string desc)
{
using (RemoteLibraryEntities ctx = new RemoteLibraryEntities())
{
var lstPlaylist = (from pl in ctx.PlayLists
where pl.PlayListName == oldName
select pl
).ToList <PlayList>();
foreach (var pl in lstPlaylist)
{
pl.PlayListName = newName;
pl.Description = desc;
Console.WriteLine("Playlist Name: {0}, {1}, {2}", pl.Id, pl.PlayListName, pl.Description);
}
ctx.SaveChanges();
}
}
//internal void SavePlaylist(String plName,String plDescription)
internal void DeleteSongFromLib(Song song)
{
using (RemoteLibraryEntities ctx = new RemoteLibraryEntities())
{
var songToRemove = ctx.Songs.SingleOrDefault(s => s.Id == song.Id);
if (songToRemove != null)
{
ctx.Songs.Remove(songToRemove);
ctx.SaveChanges();
Console.WriteLine("Song: {0}, {1}, {2}", song.Id, song.Title, song.ArtistName);
}
else
{
Console.WriteLine("Database internal error");
}
}
}
internal void SaveOnePlaylistsToLib(List <PlayList> lstPlaylist)
{
using (RemoteLibraryEntities ctx = new RemoteLibraryEntities())
{
foreach (var pl in lstPlaylist)
{
ctx.PlayLists.Add(pl);
Console.WriteLine("Playlist: {0}, {1}, {2}, {3}", pl.Id, pl.SongId, pl.PlayListName, pl.Description);
try
{
ctx.SaveChanges();
}
catch (System.Data.Entity.Infrastructure.DbUpdateException ex)
{
Console.WriteLine("Entity.Infrastructure update Exception" + ex.StackTrace);
}
}
}
}
//adding by chen 0426
internal void UpdateSongByPath(Song song)
{
using (RemoteLibraryEntities ctx = new RemoteLibraryEntities())
{
var lstSong = (from s in ctx.Songs
where s.PathToFile == song.PathToFile
select s
).ToList <Song>();
foreach (var s in lstSong)
{
s.Title = song.Title;
s.ArtistName = song.ArtistName;
s.Album = song.Album;
s.Description = song.Description;
s.Rating = song.Rating;
s.Year = song.Year;
s.Genre = song.Genre;
Console.WriteLine("Song : {0}, {1}, {2}", s.Id, s.ArtistName, s.Description);
}
ctx.SaveChanges();
}
}