//Delete lien quan
public bool DelFileAndTableRelated(int id)
{
var item = db.QualityMusics.Find(id);
var lsSinger = new SingerMusicDao().GetSMByID(item.MusicID);
foreach (var singer in lsSinger)
{
db.SingerMusics.Remove(db.SingerMusics.Find(singer.ID));
db.SaveChanges();
}
Delete(id);
return(new MusicDao().DeleteLQ(item.MusicID) == true ? true : false);
}
//delete file lien quan nhac
#region deletefiletuiupload
public bool DeleteLQ(int id)
{
var data = db.Musics.Find(id);
var lsQualityMusic = new QualityMusicDao().GetFileByIdMusic(data.ID);
var lsSinger = new SingerMusicDao().GetSMByID(data.ID);
foreach (var qualityMusic in lsQualityMusic)
{
db.QualityMusics.Remove(db.QualityMusics.Find(qualityMusic.ID));
db.SaveChanges();
}
foreach (var singer in lsSinger)
{
db.SingerMusics.Remove(db.SingerMusics.Find(singer.ID));
db.SaveChanges();
}
return(DeleteMusicLQ(id) == true ? true : false);
}
