public List<MapPoint> GetDonationsByCountry(MapPoint northwest, MapPoint southeast) { return GetDonationLocations("dbo.GetDonationsByCountry", northwest, southeast); }
private List<MapPoint> GetDonationLocations(string sproc, MapPoint northwest, MapPoint southeast) { using (var db = new DataAccess()) { db.CreateStoredProcCommand(sproc); db.AddInputParameter("@NwLat", DbType.Double, northwest.Latitude); db.AddInputParameter("@NwLng", DbType.Double, northwest.Longitude); db.AddInputParameter("@SeLat", DbType.Double, southeast.Latitude); db.AddInputParameter("@SeLng", DbType.Double, southeast.Longitude); try { var points = new List<MapPoint>(); db.ReadInto(points); return points; } catch (Exception ex) { Log.Error("Error while searching donations.", ex); throw; } } }
public JsonResult Locations(ZoomLevel? zoom) { var p1 = new MapPoint(null, null); List<MapPoint> model; switch (zoom) { case ZoomLevel.City: model = _donationRepository.GetDonationsByCity(p1, p1); break; case ZoomLevel.State: model = _donationRepository.GetDonationsByState(p1, p1); break; case ZoomLevel.Country: default: model = _donationRepository.GetDonationsByCity(p1, p1); break; } return Json(model, JsonRequestBehavior.AllowGet); }