Example #1
0
        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);
            }
        }
Example #2
0
        public async Task <PokemonResponse> Get(int id)
        {
            using (var db = Db)
            {
                var pokemonRepository = new PokemonRepository(db);

                var pokemon = await pokemonRepository.FindOneById(id);

                var pokemonResponse = new PokemonResponse()
                {
                    Id          = pokemon.Id,
                    Name        = pokemon.Name,
                    BaseAttack  = pokemon.BaseAttack,
                    BaseDefense = pokemon.BaseDefense,
                    BaseHP      = pokemon.BaseHP,
                    BaseSpAtk   = pokemon.BaseSpAtk,
                    BaseSpDef   = pokemon.BaseSpDef,
                    BaseSpeed   = pokemon.BaseSpeed,
                    Skills      = await GetPokemonSkills(pokemon.Id, db),
                    Types       = await GetPokemonTypes(pokemon.Id, db)
                };
                return(pokemonResponse);
            }
        }
Example #3
0
        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);
                    }
                }
            }
        }