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());
}
}