public async Task <PokemonSkill> Get(int id) { using (var db = Db) { var pokemonSkillRepository = new PokemonSkillRepository(db); return(await pokemonSkillRepository.FindOneById(id)); } }
public async Task <IList <PokemonSkill> > GetAll() { using (var db = Db) { var pokemonSkillRepository = new PokemonSkillRepository(db); return(await pokemonSkillRepository.GetAll()); } }
public async void Delete(int id) { using (var db = Db) { var pokemonSkillRepository = new PokemonSkillRepository(db); var pokemonSkill = await pokemonSkillRepository.FindOneById(id); pokemonSkillRepository.Delete(pokemonSkill); } }
private async Task <List <PokemonSkill> > GetPokemonSkills(int id, PokedexContext db) { var pokemonToPokemonSkillRepository = new PokemonToPokemonSkillRepository(db); var task = await pokemonToPokemonSkillRepository.GetByPokemonId(id); var results = task.Select(x => x.PokemonSkillId); var pokemonSkillRepository = new PokemonSkillRepository(db); var task2 = await pokemonSkillRepository.GetAll(); return(task2.Where(x => results.Contains(x.Id)).ToList()); }
public async void Update(List <PokemonSkill> values) { using (var db = Db) { var pokemonSkillRepository = new PokemonSkillRepository(db); foreach (var value in values) { var pokemonType = await pokemonSkillRepository.FindOneById(value.Id); pokemonType.Name = value.Name; pokemonSkillRepository.Update(value); } } }
public async void Insert(List <PokemonSkill> values) { using (var db = Db) { var pokemonSkillRepository = new PokemonSkillRepository(db); foreach (var value in values) { var pokemonSkill = await pokemonSkillRepository.FindOneByAttribute(value); if (pokemonSkill.Count.Equals(0)) { pokemonSkillRepository.Insert(value); } else { // Log error for DuplicateException Id or Name already exists in table } } } }