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