public async void Delete(int id) { using (var db = Db) { var pokemonToPokemonSkillRepository = new PokemonToPokemonSkillRepository(db); var skillMaps = await pokemonToPokemonSkillRepository.GetByPokemonId(id); foreach (var skillMap in skillMaps) { pokemonToPokemonSkillRepository.Delete(skillMap); } var pokemonToPokemonTypeRepository = new PokemonToPokemonTypeRepository(db); var typeMaps = await pokemonToPokemonTypeRepository.GetByPokemonId(id); foreach (var typeMap in typeMaps) { pokemonToPokemonTypeRepository.Delete(typeMap); } var pokemonRepository = new PokemonRepository(db); var pokemon = await pokemonRepository.FindOneById(id); pokemonRepository.Delete(pokemon); } }
private async Task <List <PokemonType> > GetPokemonTypes(int id, PokedexContext db) { var pokemonToPokemonTypeRepository = new PokemonToPokemonTypeRepository(db); var task = await pokemonToPokemonTypeRepository.GetByPokemonId(id); var results = task.Select(x => x.PokemonTypeId); var pokemonTypeRepository = new PokemonTypeRepository(db); var task2 = await pokemonTypeRepository.GetAll(); return(task2.Where(x => results.Contains(x.Id)).ToList()); }
public void Insert(List <PokemonResponse> values) { using (var db = Db) { var pokemonRepository = new PokemonRepository(db); foreach (var value in values) { var pokemon = new Pokemon() { Id = value.Id, Name = value.Name, BaseAttack = value.BaseAttack, BaseDefense = value.BaseDefense, BaseHP = value.BaseHP, BaseSpAtk = value.BaseSpAtk, BaseSpDef = value.BaseSpDef, BaseSpeed = value.BaseSpeed, }; pokemonRepository.Insert(pokemon); var pokemonToPokemonSkillRepository = new PokemonToPokemonSkillRepository(db); foreach (var skill in value.Skills) { var newMap = new PokemonToPokemonSkill() { PokemonId = value.Id, PokemonSkillId = skill.Id }; pokemonToPokemonSkillRepository.Insert(newMap); } var pokemonToPokemonTypeRepository = new PokemonToPokemonTypeRepository(db); foreach (var type in value.Types) { var newMap = new PokemonToPokemonType() { PokemonId = value.Id, PokemonTypeId = type.Id }; pokemonToPokemonTypeRepository.Insert(newMap); } } } }
public async void Update(List <PokemonResponse> values) { using (var db = Db) { var pokemonRepository = new PokemonRepository(db); foreach (var value in values) { var pokemon = await pokemonRepository.FindOneById(value.Id); pokemon.Name = value.Name; pokemon.BaseAttack = value.BaseAttack; pokemon.BaseDefense = value.BaseDefense; pokemon.BaseHP = value.BaseHP; pokemon.BaseSpAtk = value.BaseSpAtk; pokemon.BaseSpDef = value.BaseSpDef; pokemon.BaseSpeed = value.BaseSpeed; pokemonRepository.Update(pokemon); var pokemonToPokemonSkillRepository = new PokemonToPokemonSkillRepository(db); var task = await pokemonToPokemonSkillRepository.GetByPokemonId(value.Id); var oldSkills = task.ToList(); var newSkills = value.Skills.Where(p => !oldSkills.Any(p2 => p2.PokemonSkillId.Equals(p.Id))); foreach (var skill in newSkills) { var skillMap = new PokemonToPokemonSkill() { PokemonId = value.Id, PokemonSkillId = skill.Id }; pokemonToPokemonSkillRepository.Insert(skillMap); } var removedSkills = oldSkills.Where(p => !value.Skills.Any(p2 => p2.Id.Equals(p.PokemonSkillId))); foreach (var skill in removedSkills) { pokemonToPokemonSkillRepository.Delete(skill); } var pokemonToPokemonTypeRepository = new PokemonToPokemonTypeRepository(db); var oldTypes = await pokemonToPokemonTypeRepository.GetByPokemonId(value.Id); var newTypes = value.Types.Where(p => !oldTypes.Any(p2 => p2.PokemonTypeId.Equals(p.Id))); foreach (var type in newTypes) { var typeMap = new PokemonToPokemonType() { PokemonId = value.Id, PokemonTypeId = type.Id }; pokemonToPokemonTypeRepository.Insert(typeMap); } var removedTypes = oldTypes.Where(p => !value.Types.Any(p2 => p2.Id.Equals(p.PokemonTypeId))); foreach (var type in removedTypes) { pokemonToPokemonTypeRepository.Delete(type); } } } }