public static Pokemon SelectPokemonFromParty(PokemonGroup partyPokemon) { using (DB_r0739290Entities entities = new DB_r0739290Entities()) { IQueryable <Pokemon> query = entities.Pokemon .Include("Statpool") .Include("Statpool.BaseStats") .Include("Statpool.EVStats") .Include("Statpool.IVStats") .Include("LearnedMoves") .Include("Pokedex") .Include("Trainer") .Include("Pokedex.Types") .Include("Pokedex.Types1") .Include("LearnedMoves.PokemonMoves") .Include("StatusEffects") .Include("Items") .Include("Ability") .Where(x => x.Id == partyPokemon.PokemonId); return(query.SingleOrDefault()); } }
public static List <Trainer> GetTrainerList() { using (DB_r0739290Entities entities = new DB_r0739290Entities()) { DbSet <Trainer> query = entities.Trainer; return(query.ToList()); } }
public static int CurrentPokemonGroups() { using (DB_r0739290Entities entities = new DB_r0739290Entities()) { DbSet <PokemonGroup> query = entities.PokemonGroup; return(query.ToList().Max(x => x.Id)); } }
public static List <Items> ItemList() { using (DB_r0739290Entities entities = new DB_r0739290Entities()) { DbSet <Items> query = entities.Items; return(query.ToList()); } }
public static int CurrentPlayerItems() { using (DB_r0739290Entities entities = new DB_r0739290Entities()) { DbSet <PlayerInventory> query = entities.PlayerInventory; return(query.ToList().Max(x => x.id)); } }
public static int CurrentStatCollections() { using (DB_r0739290Entities entities = new DB_r0739290Entities()) { DbSet <StatCollection> query = entities.StatCollection; return(query.ToList().Max(x => x.Id));; } }
public static int CurrentLearnedMoves() { using (DB_r0739290Entities entities = new DB_r0739290Entities()) { DbSet <LearnedMoves> query = entities.LearnedMoves; return(query.ToList().Max(x => x.Id)); } }
public static List <PokemonMoves> AllMoves() { using (DB_r0739290Entities entities = new DB_r0739290Entities()) { IOrderedQueryable <PokemonMoves> query = entities.PokemonMoves .OrderBy(x => x.Id); return(query.ToList()); } }
public static int CurrentStatpools() { using (DB_r0739290Entities entities = new DB_r0739290Entities()) { DbSet <StatPool> query = entities.StatPool; return(query.ToList().Max(x => x.Id));; } }
public static List <Ability> AbilityList() { using (DB_r0739290Entities entities = new DB_r0739290Entities()) { IOrderedQueryable <Ability> query = entities.Ability .OrderBy(x => x.Id); return(query.ToList()); } }
public static List <Types> Typinglist() { using (DB_r0739290Entities entities = new DB_r0739290Entities()) { IOrderedQueryable <Types> query = entities.Types .OrderBy(x => x.Id); return(query.ToList()); } }
public static List <Pokedex> PokedexEntryAZ() { using (DB_r0739290Entities entities = new DB_r0739290Entities()) { IOrderedQueryable <Pokedex> query = entities.Pokedex .OrderBy(x => x.PokemonName); return(query.ToList()); } }
public static int CurrentItems() { using (DB_r0739290Entities entities = new DB_r0739290Entities()) { DbSet <Items> query = entities.Items; return(query.ToList().Max(x => x.Id)); } }
public static List <Pokemon> PokemonList() { using (DB_r0739290Entities entities = new DB_r0739290Entities()) { DbSet <Pokemon> query = entities.Pokemon; return(query.ToList()); } }
public static List <Trainer> SelectMoneyOwnedFromTrainer(Trainer trainer) { using (DB_r0739290Entities entities = new DB_r0739290Entities()) { IQueryable <Trainer> query = entities.Trainer .Where(x => x.TrainerName == trainer.TrainerName); return(query.ToList()); } }
public static List <Trainer> TrainerList() { using (DB_r0739290Entities entities = new DB_r0739290Entities()) { IOrderedQueryable <Trainer> query = entities.Trainer .Include("PokemonGroup") .OrderBy(x => x.Id); return(query.ToList()); } }
public static Pokedex SelectPokemonFromPokedex(Pokedex pokedexpokemon) { using (DB_r0739290Entities entities = new DB_r0739290Entities()) { IQueryable <Pokedex> query = entities.Pokedex .Where(x => x.Id == pokedexpokemon.Id); return(query.SingleOrDefault()); } }
public static List <PlayerInventory> SelectQuantityFromItems(Items item) { using (DB_r0739290Entities entities = new DB_r0739290Entities()) { IQueryable <PlayerInventory> query = entities.PlayerInventory .Where(x => x.ItemID == item.Id); return(query.ToList()); } }
public static List <Items> GetDistinctCategory() { using (DB_r0739290Entities entities = new DB_r0739290Entities()) { IOrderedQueryable <Items> query = entities.Items .OrderBy(x => x.Catagory); return(query.ToList()); } }
public static Trainer SelectTrainer(int trainerId) { using (DB_r0739290Entities entities = new DB_r0739290Entities()) { IQueryable <Trainer> query = entities.Trainer .Include("PlayerInventory") .Include("Pokemon") .Include("PokemonGroup") .Where(x => x.Id == trainerId); return(query.SingleOrDefault()); } }
public static List <LearnedMoves> SelectMovesFromPokemon(Pokemon pokemon) { using (DB_r0739290Entities entities = new DB_r0739290Entities()) { IOrderedQueryable <LearnedMoves> query = entities.LearnedMoves .Include("PokemonMoves") .Include("PokemonMoves.Types") .Where(x => x.PokemonId == pokemon.Id) .OrderBy(x => x.Position); return(query.ToList()); } }
public static List <PlayerInventory> GetItems(int trainerId) { using (DB_r0739290Entities entities = new DB_r0739290Entities()) { List <int> query = entities.Items .Select(i => i.Id).ToList(); IQueryable <PlayerInventory> iquery = entities.PlayerInventory .Include("Items") .Include("Trainer") .Where(x => query.Contains(x.ItemID.Value)); return(iquery.ToList()); } }
public static List <Pokedex> PokedexEntry() { using (DB_r0739290Entities entities = new DB_r0739290Entities()) { IOrderedQueryable <Pokedex> query = entities.Pokedex .Include("Types") .Include("Types1") .Include("Types.Pokedex") .Include("Types.Pokedex1") .OrderBy(x => x.Id); return(query.ToList()); } }
public static List <PokemonMoves> AllMovesExceptCurrent(Pokemon pokemon) { using (DB_r0739290Entities entities = new DB_r0739290Entities()) { List <int?> iQuery = entities.LearnedMoves .Where(x => x.PokemonId == pokemon.Id) .Select(i => i.MoveId).ToList();; IOrderedQueryable <PokemonMoves> query = entities.PokemonMoves .Where(x => !iQuery.Contains(x.Id)) .OrderBy(x => x.Id); return(query.ToList()); } }
public static List <PlayerInventory> SelectAllInventory(string category) { using (DB_r0739290Entities entities = new DB_r0739290Entities()) { List <int> iQuery = entities.Items .Where(i => i.Catagory.ToString() == category) .Select(i => i.Id).ToList(); IQueryable <PlayerInventory> query = entities.PlayerInventory .Include("Items") .Include("Trainer") .Where(x => iQuery.Contains(x.ItemID.Value)); return(query.ToList()); } }
public static int DeletePokedexEntry(Pokedex oldPokedex) { try { using (DB_r0739290Entities entities = new DB_r0739290Entities()) { entities.Entry(oldPokedex).State = EntityState.Deleted; return(entities.SaveChanges()); } } catch (Exception ex) { ErrorLogging(ex); return(0); } }
public static PokemonGroup SelectPokemonFromParty(int trainerID, int position) { using (DB_r0739290Entities entities = new DB_r0739290Entities()) { IQueryable <PokemonGroup> query = entities.PokemonGroup .Include("Pokemon") .Include("Pokemon.Statpool") .Include("Pokemon.Statpool.BaseStats") .Include("Pokemon.Statpool.EVStats") .Include("Pokemon.Statpool.IVStats") .Where(x => x.PlayerId == trainerID && x.Position == position); return(query.SingleOrDefault()); } }
public static int AddPlayerinvtoryItem(PlayerInventory item) { try { using (DB_r0739290Entities entities = new DB_r0739290Entities()) { entities.PlayerInventory.Add(item); return(entities.SaveChanges()); } } catch (Exception ex) { ErrorLogging(ex); return(0); } }
public static int AddItem(Items item) { try { using (DB_r0739290Entities entities = new DB_r0739290Entities()) { entities.Items.Add(item); return(entities.SaveChanges()); } } catch (Exception ex) { ErrorLogging(ex); return(0); } }
public static int UpdatePlayerInventory(PlayerInventory currentPlayerInventory) { try { using (DB_r0739290Entities entities = new DB_r0739290Entities()) { entities.Entry(currentPlayerInventory).State = EntityState.Modified; return(entities.SaveChanges()); } } catch (Exception ex) { ErrorLogging(ex); return(0); } }