public async Task <HeroAbilityStat> LookupHeroAbilityStat(int heroId, int abilityId) { using (var db = new Dota2HeroStatsDB()) { return(await db.HeroAbilityStats.FindAsync(heroId, abilityId)); } }
public async Task <Ability> LookupAbility(int abilityId) { using (var db = new Dota2HeroStatsDB()) { return(await db.Abilities.FindAsync(abilityId)); } }
public async Task <Hero> LookupHero(int heroId) { Hero hero = null; using (var db = new Dota2HeroStatsDB()) { hero = await db.Heroes.AsNoTracking().FirstOrDefaultAsync(h => h.HeroId == heroId); } return(hero); }
public async Task <Role> LookupRoleByName(string stringRole) { Role role = null; using (var db = new Dota2HeroStatsDB()) { role = await db.Roles.AsNoTracking().FirstOrDefaultAsync(r => r.Name == stringRole); } return(role); }
private bool ClaimIdIsValid(string value) { string steamId = value.Replace("https://steamcommunity.com/openid/id/", ""); using (var db = new Dota2HeroStatsDB()) { var admin = db.Admins.Find(steamId); if (admin == null) { return(false); } return(true); } }
public async Task UpdateEntity <T>(T entity) where T : class, IEntity { using (var db = new Dota2HeroStatsDB()) { //db.Set<T>().Add(entity); db.Set <T>().Attach(entity); foreach (DbEntityEntry <IEntity> entry in db.ChangeTracker.Entries <IEntity>()) { IEntity currEntity = entry.Entity; entry.State = GetEntityState(currEntity.EntityState); } try { await db.SaveChangesAsync(); } catch (DbUpdateException e) { throw new DataSourceException("Error Updating item in database.", e); } } }