public static string GetPokeStopName(string id)
{
using (var db = new BotContext())
{
var targetPs = db.PokeStops.FirstOrDefault(x => x.Id == id);
return(targetPs == null ? "PokeStop" : targetPs.Name);
}
}
public static IEnumerable <PokemonSeen> GetPokemonSeenForCoords(double lat, double lng, double distance)
{
distance = distance / 1000;
using (var db = new BotContext())
{
return
(db.PokemonSeen.Where(
x =>
12742 *
SqlCeFunctions.Asin(
SqlCeFunctions.SquareRoot(SqlCeFunctions.Sin(SqlCeFunctions.Pi() / 180 * (x.Latitude - lat) / 2) *
SqlCeFunctions.Sin(SqlCeFunctions.Pi() / 180 *
(x.Latitude - lat) / 2) +
SqlCeFunctions.Cos(SqlCeFunctions.Pi() / 180 * lat) *
SqlCeFunctions.Cos(SqlCeFunctions.Pi() / 180 * x.Latitude) *
SqlCeFunctions.Sin(SqlCeFunctions.Pi() / 180 * (x.Longitude - lng) / 2) *
SqlCeFunctions.Sin(SqlCeFunctions.Pi() / 180 * (x.Longitude - lng) / 2))) <
distance).ToList());
}
}
