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