public IEnumerable <PogoRelScanChat> Execute(GetAllChatsForAreaRequest request) { using (var db = databaseFactory.CreateNew()) { return(db.PogoRelScanChats.ToList()); } }
public IEnumerable <PogoRaidPreference> Execute(GetRaidBossPreferencesAllRequest request) { using (var db = databaseFactory.CreateNew()) { return(db.PogoRaidPreferences.ToList()); } }
public IEnumerable <PogoChatPoke> Execute(GetPokesForChatRequest request) { using (var db = databaseFactory.CreateNew()) { return(db.PogoChatPokes.Where(x => x.ChatId == request.ChatId).ToList()); } }
public IEnumerable <PogoGym> Execute(GetGymsRequest request) { using (var db = databaseFactory.CreateNew()) { return(db.PogoGyms.ToList()); } }
public DataAccess.Models.Location Execute(EventLocationByIdRequest request) { using (var db = databaseFactory.CreateNew()) { return(db.Locations.SingleOrDefault(x => x.Id == request.EventId)); } }
public PogoPoke?Execute(GetPokeByIdRequest request) { using (var db = databaseFactory.CreateNew()) { return(db.PogoPokes.SingleOrDefault(x => x.Id == request.PokeId)); } }
public bool Execute(HasDailyFarmRequest request) { using (var db = databaseFactory.CreateNew()) { return(db.IngrEvents.SingleOrDefault(x => x.ChatId == request.ChatId && x.Start == request.Day) != null); } }
public PogoConfiguration Execute(GetPogoConfigurationRequest request) { using (var db = databaseFactory.CreateNew()) { return(db.PogoConfigurations.Single()); } }
public State?Execute(QueryCurrentStateRequest request) { using (var db = databaseFactory.CreateNew()) { return(db.States.Where(x => x.UserId == request.ChatId).OrderByDescending(x => x.Level).FirstOrDefault()); } }
public IEnumerable <PogoRaidUser> Execute(GetChatAreasRequest request) { using (var db = databaseFactory.CreateNew()) { return(db.PogoRaidUsers.Where(x => request.ChatIds.Contains(x.ChatId)).ToList()); } }
public void Execute(GameCreateRequest request) { using (var db = databaseFactory.CreateNew()) { var game = new PogoGamePoke { ChatId = request.ChatId, MessageId = request.MessageId, Difficulty = request.Difficulty, Finish = request.Finish, TargetPokeId = request.Poke1Id, TargetPokeMoveTyp = request.Poke1Move, Choice1PokeId = request.Poke2Id, Choice1PokeMoveTyp = request.Poke2Move, Choice2PokeId = request.Poke3Id, Choice2PokeMoveTyp = request.Poke3Move, Choice3PokeId = request.Poke4Id, Choice3PokeMoveTyp = request.Poke4Move, Choice4PokeId = request.Poke5Id, Choice4PokeMoveTyp = request.Poke5Move }; db.PogoGamePokes.Add(game); db.SaveChanges(); } }
public void Execute(SetChatForManualRaidAndInitializeRequest request) { using (var db = databaseFactory.CreateNew()) { var result = db.PogoUserRaids.SingleOrDefault(x => x.UserId == request.UserId); if (result == null) { db.PogoUserRaids.Add(new PogoUserRaid { UserId = request.UserId, ChatId = request.ChatId }); } else { result.ChatId = request.ChatId; result.GymId = null; result.Level = null; result.PokeId = null; result.RaidId = null; result.Start = null; result.TimeMode = null; result.Title = string.Empty; result.UpdRaidId = 0; } db.SaveChanges(); } }
public DataAccess.Models.ActivePoll?Execute(ActivePollRequest request) { using (var db = databaseFactory.CreateNew()) { return(db.ActivePolls.SingleOrDefault(x => x.ChatId == request.ChatId && x.MessageId == request.MessageId)); } }
public IEnumerable <PogoSpecialGym> Execute(GetSpecialGymsForChatsRequest request) { using (var db = databaseFactory.CreateNew()) { return(db.PogoSpecialGyms.Where(x => request.ChatIds.Contains(x.ChatId)).ToList()); } }
public IEnumerable <Models.Location> Execute(EventLocationsRequest request) { using (var db = databaseFactory.CreateNew()) { return(db.Locations.FromSqlInterpolated( $@" ( SELECT * FROM LOCATIONS WHERE NAME < @p0 ORDER BY NAME DESC LIMIT 1 ) UNION ( SELECT * FROM LOCATIONS WHERE NAME >= { request.Name } ORDER BY NAME ASC LIMIT 2 )").ToList()); //return db.Locations.ToList().OrderBy(x => x.Id); } }
public PogoUserRaid?Execute(GetCurrentManualRaidRequest request) { using (var db = databaseFactory.CreateNew()) { return(db.PogoUserRaids.SingleOrDefault(x => x.UserId == request.UserId)); } }
public IngrEvent Execute(GetEventByIdRequest request) { using (var db = databaseFactory.CreateNew()) { return(db.IngrEvents.SingleOrDefault(x => x.Id == request.EventId)); } }
public DataAccess.Models.EventSetup?Execute(EventSetupRequest request) { using (var db = databaseFactory.CreateNew()) { return(db.EventSetups.SingleOrDefault(x => x.ChatId == request.ChatId && x.MessageId == request.MessageId)); } }
public int[] Execute(GetActiveUserRaidsRequest request) { using (var db = databaseFactory.CreateNew()) { return(db.PogoRaids.Where(x => x.OwnerId == request.UserId && x.Finished <= DateTime.UtcNow.AddMinutes(5)).Select(x => x.Id).ToArray()); } }
public IEnumerable <PogoRaidPreference> Execute(GetRaidBossPreferencesRequest request) { using (var db = databaseFactory.CreateNew()) { return(db.PogoRaidPreferences.Where(x => x.ChatId == request.ChatId).ToList()); } }
public IEnumerable <PogoGamePokesAnswer> Execute(GetGameAnswersRequest request) { using (var db = databaseFactory.CreateNew()) { return(db.PogoGamePokesAnswers.Where(x => request.ChatId == x.ChatId && request.MessageId == x.MessageId).ToList()); } }
public bool Execute(IsActivePollRequest request) { using (var db = databaseFactory.CreateNew()) { return(db.ActivePolls.Any(x => x.ChatId == request.ChatId && x.MessageId == request.MessageId)); } }
public IEnumerable <PogoRaidUser> Execute(GetActiveGroupsRequest request) { using (var db = databaseFactory.CreateNew()) { return(db.PogoRaidUsers.Where(x => x.Active == true && x.Ingress == true).ToList()); } }
public PogoUser?Execute(GetCurrentUserSettingsRequest request) { using (var db = databaseFactory.CreateNew()) { return(db.PogoUsers.SingleOrDefault(x => x.UserId == request.UserId)); } }
public IEnumerable <Models.Location> Execute(EventLocations2Request request) { using (var db = databaseFactory.CreateNew()) { return(db.Locations.OrderBy(x => x.Name).ToList()); } }
public ActivePoll?Execute(GetActivePollByRaidRequest request) { using (var db = databaseFactory.CreateNew()) { return(db.ActivePolls.SingleOrDefault(x => x.RaidId == request.RaidId && x.ChatId == request.ChatId)); } }
public void Execute(AnRequest request) { using (var db = databaseFactory.CreateNew()) { var result = db.PogoUsers.SingleOrDefault(x => x.UserId == request.UserId); if (result == null) { result = _Helper.CreateNewUser(db, request.UserId); } if (result != null) { result.Active = true; db.SaveChanges(); } var active = db.RelChatBots.SingleOrDefault(x => x.ChatId == request.UserId && x.BotId == request.BotId); if (active != null) { active.AllowNotification = true; db.SaveChanges(); } } }
public int Execute(NumberOfBotsInChatRequest request) { using (var db = databaseFactory.CreateNew()) { return(db.RelChatBots.Count(x => x.ChatId == request.ChatId)); } }
public IEnumerable <PogoGamePoke> Execute(GetCurrentGamesRequest request) { using (var db = databaseFactory.CreateNew()) { return(db.PogoGamePokes.Where(x => x.Finish >= request.Until).ToList()); } }
public PogoUser?Execute(GetUserByIdRequest request) { using (var db = databaseFactory.CreateNew()) { return(db.PogoUsers.Where(x => x.UserId == request.UserId).SingleOrDefault()); } }