public async Task <Character> Associate_Episode_With_Character(int episodeId, int characterID) { var episode = _appDbContext.Episodes.FirstOrDefault(f => f.Id == episodeId); var character = _appDbContext.Characters.FirstOrDefault(c => c.Id == characterID); var episodeCharacter = new EpisodeCharacter { EpisodeId = episodeId, CharacterId = characterID, Episode = episode, Character = character }; character.AppersIn_Episodes.Add(episodeCharacter); _appDbContext.SaveChanges(); return(await Task.FromResult(character)); }
public async Task <Episode> Associate_Character_With_Episode(int episodeId, int characterID) { var episode = _appDbContext.Episodes.Include(e => e.Cast).FirstOrDefault(f => f.Id == episodeId); var character = _appDbContext.Characters.FirstOrDefault(c => c.Id == characterID); var episodeCharacter = new EpisodeCharacter { EpisodeId = episodeId, CharacterId = characterID, Episode = episode, Character = character }; var charactesExists = episode.Cast.FirstOrDefault(c => c.CharacterId == characterID && c.EpisodeId == episodeId); if (charactesExists == null) { episode.Cast.Add(episodeCharacter); _appDbContext.SaveChanges(); } return(await Task.FromResult(episode)); }