public bool ChangeName(String name, int id)
{
try
{
DBMusicDataContext db = new DBMusicDataContext();
playlistinfo playlist = db.playlistinfos.FirstOrDefault(x => x.id == id);
if (playlist == null)
{
return(false); //không tồn tại false
}
playlist.name = name;
db.SubmitChanges();//xác nhận chỉnh sửa
return(true);
}
catch
{
return(false);
}
}
public int InsertNewPlaylist(string name, string user)
{
try
{
DBMusicDataContext db = new DBMusicDataContext();
playlistinfo playlist = new playlistinfo();
playlistinfo playlistx = db.playlistinfos.FirstOrDefault(x => x.name == name && x.username == user);
if (playlistx != null)
{
return(0); //không tồn tại false
}
playlist.username = user;
playlist.name = name;
db.playlistinfos.InsertOnSubmit(playlist);
db.SubmitChanges();
return(playlist.id);
}
catch
{
return(0);
}
}
public bool DeletePlaylist(int id)
{
DBMusicDataContext db = new DBMusicDataContext();
playlistinfo playlist = db.playlistinfos.FirstOrDefault(x => x.id == id);
if (playlist == null)
{
return(false); //không tồn tại false
}
List <playlistsong> listsong = GetPlayListsSong(id);
foreach (playlistsong s in listsong)
{
DeletePlaylistSong(id, s.songid);
}
db.playlistinfos.DeleteOnSubmit(playlist);
db.SubmitChanges();
return(true);
}
