public Move GetMoveByName(string name)
{
using (var context = new PokeContext())
{
var move = context.Moves.FirstOrDefault(p => p.Name == name);
return move;
}
}
public IEnumerable<Move> GetMoves()
{
using (var context = new PokeContext())
{
var moves = context.Moves.ToList();
return moves;
}
}
public Move GetMoveById(int id)
{
using (var context = new PokeContext())
{
var move = context.Moves.Find(id);
return move;
}
}
public void DeleteAllPokemon()
{
using (var context = new PokeContext())
{
var allPokemon = context.Pokemon;
context.Pokemon.RemoveRange(allPokemon);
context.SaveChanges();
}
}
public void DeleteAllMoves()
{
using (var context = new PokeContext())
{
var allMoves = context.Moves;
context.Moves.RemoveRange(allMoves);
context.SaveChanges();
}
}
public bool addPokemonMoveRelationship(int level, string moveName, string pokemonName)
{
if (moveName == null || pokemonName == null || level <= 0)
return false;
using (var context = new PokeContext())
{
var pokemon = context.Pokemon.FirstOrDefault(p => p.Name == pokemonName);
var move = context.Moves.FirstOrDefault(m => m.Name == moveName);
if (move == null || pokemon == null) return false;
var pokemon_move = new Pokemon_Moves
{
MoveId = move.MoveId,
PokemonId = pokemon.PokeId,
Level = level
};
context.Pokemon_Moves.Add(pokemon_move);
return SaveContextChanges(context);
}
}
public IEnumerable<Move> GetMovesByPokemon(string name)
{
using (var context = new PokeContext())
{
var pokemon = context.Pokemon.FirstOrDefault(p => p.Name == name);
IEnumerable<Move> data = null;
try
{
data = context.Pokemon_Moves
.Join(context.Moves, pm => pm.MoveId, m => m.MoveId, (pm, m) => new { PM = pm, M = m })
.Where(selection => selection.PM.PokemonId == pokemon.PokeId).Select(final => final.M)
.ToList();
}
catch (Exception ex)
{
Console.WriteLine("No Data available");
}
return data;
}
}
public IEnumerable<Move> GetMovesByType(string type)
{
using (var context = new PokeContext())
{
var moves = context.Moves.Where(m => m.Type == type).OrderByDescending(m => m.Power).ToList();
return moves;
}
}