public async Task <IActionResult> RemoveSinger(int id, int idSong)
{
var singerOfSong = await _context.SingerOfSong.FindAsync(id);
if (singerOfSong != null)
{
_context.Remove(singerOfSong);
await _context.SaveChangesAsync();
}
var song = _context.Song.Find(idSong);
var ListSinger = _context.SingerOfSong.Include(m => m.Singer).Where(m => m.IdSong == idSong).ToList();
if (song != null)
{
song.NameSinger = String.Empty;
foreach (var item in ListSinger)
{
if (item != ListSinger.LastOrDefault())
{
song.NameSinger += item.Singer.Name + ", ";
}
else
{
song.NameSinger += item.Singer.Name;
}
}
song.NameUnsignedSinger = RemoveUnicode(song.NameSinger.Trim());
_context.Update(song);
await _context.SaveChangesAsync();
}
ViewBag.IdSong = idSong;
ViewData["Singers"] = new SelectList(_context.Singer, "Id", "Name");
return(PartialView("_SingerOfSong", _context.SingerOfSong.Include(m => m.Singer).Where(m => m.IdSong == idSong)));
}
