Example #1
0
        //
        // GET: /WhereToBuy/
        public ActionResult Index()
        {
            string dealersearch = Request.QueryString["search"];
            ViewBag.dealersearch = dealersearch;

            if (dealersearch != null && dealersearch.Trim() != "") {
                List<DealerLocation> localdealers = DealerModel.SearchLocationsByType(dealersearch);
                int loccount = localdealers.Count;
                if (loccount == 0) {
                    // Query Google Maps API for a geolocation
                    LatLong location = new LatLong();
                    try {
                        string apiurl = "http://maps.googleapis.com/maps/api/geocode/xml?sensor=false&address=" + dealersearch;
                        XDocument xdoc = XDocument.Load(apiurl);
                        location = (from latlng in xdoc.Descendants("result").Descendants("geometry").Descendants("location")
                                   select new LatLong {
                                       latitude = Convert.ToDouble(latlng.Element("lat").Value),
                                       longitude = Convert.ToDouble(latlng.Element("lng").Value)
                                   }).First<LatLong>();
                    } catch { };
                    if (location.latitude != null && location.longitude != null) {
                        localdealers = DealerModel.SearchLocationsByLatLong(location);
                    }
                }
                ViewBag.localdealers = localdealers;
            }

            List<Customer> onlinedealers = DealerModel.GetEtailers();
            ViewBag.onlinedealers = onlinedealers;

            List<MapGraphics> localtiers = DealerModel.GetLocalDealerTypes();
            ViewBag.localtiers = localtiers;

            return View();
        }
Example #2
0
 public static List<DealerLocation> SearchLocationsByLatLong(LatLong location)
 {
     // Use Haversine formula to find nearest dealers within 100 miles
     CurtDevDataContext db = new CurtDevDataContext();
     double earth = 3963.1676; // radius of Earth in miles
     double lat1 = location.latitude;
     double lon1 = location.longitude;
     List<DealerLocation> locations = (from cl in db.CustomerLocations
                                       join c in db.Customers on cl.cust_id equals c.cust_id
                                       join dt in db.DealerTypes on c.dealer_type equals dt.dealer_type
                                       join dtr in db.DealerTiers on c.tier equals dtr.ID
                                       where dt.online == false && dt.show == true && c.isDummy == false &&
                                       (earth * (
                                         2 * Math.Atan2(
                                                 Math.Sqrt((Math.Sin(((cl.latitude - lat1) * (Math.PI / 180)) / 2) * Math.Sin(((cl.latitude - lat1) * (Math.PI / 180)) / 2)) + ((Math.Sin(((cl.longitude - lon1) * (Math.PI / 180)) / 2)) * (Math.Sin(((cl.longitude - lon1) * (Math.PI / 180)) / 2))) * Math.Cos(location.latitudeRadians) * Math.Cos(cl.latitude * (Math.PI / 180))),
                                                 Math.Sqrt(1 - ((Math.Sin(((cl.latitude - lat1) * (Math.PI / 180)) / 2) * Math.Sin(((cl.latitude - lat1) * (Math.PI / 180)) / 2)) + ((Math.Sin(((cl.longitude - lon1) * (Math.PI / 180)) / 2)) * (Math.Sin(((cl.longitude - lon1) * (Math.PI / 180)) / 2))) * Math.Cos(location.latitudeRadians) * Math.Cos(cl.latitude * (Math.PI / 180))))
                                             )
                                       ) < 100.0)
                                       select new DealerLocation {
                                           distance = earth * (
                                                         2 * Math.Atan2(
                                                             Math.Sqrt((Math.Sin(((cl.latitude - lat1) * (Math.PI / 180)) / 2) * Math.Sin(((cl.latitude - lat1) * (Math.PI / 180)) / 2)) + ((Math.Sin(((cl.longitude - lon1) * (Math.PI / 180)) / 2)) * (Math.Sin(((cl.longitude - lon1) * (Math.PI / 180)) / 2))) * Math.Cos(location.latitudeRadians) * Math.Cos(cl.latitude * (Math.PI / 180))),
                                                             Math.Sqrt(1 - ((Math.Sin(((cl.latitude - lat1) * (Math.PI / 180)) / 2) * Math.Sin(((cl.latitude - lat1) * (Math.PI / 180)) / 2)) + ((Math.Sin(((cl.longitude - lon1) * (Math.PI / 180)) / 2)) * (Math.Sin(((cl.longitude - lon1) * (Math.PI / 180)) / 2))) * Math.Cos(location.latitudeRadians) * Math.Cos(cl.latitude * (Math.PI / 180))))
                                                         )
                                                      ),
                                           State = cl.State,
                                           dealerType = dt,
                                           dealerTier = dtr,
                                           locationID = cl.locationID,
                                           name = cl.name,
                                           address = cl.address,
                                           city = cl.city,
                                           stateID = cl.stateID,
                                           postalCode = cl.postalCode,
                                           email = cl.email,
                                           phone = cl.phone,
                                           fax = cl.fax,
                                           latitude = cl.latitude,
                                           longitude = cl.longitude,
                                           cust_id = cl.cust_id,
                                           isprimary = cl.isprimary,
                                           contact_person = cl.contact_person,
                                           websiteurl = (c.eLocalURL == null || c.eLocalURL.Trim() == "") ? ((c.website == null || c.website.Trim() == "") ? "" : c.website) : c.eLocalURL,
                                           showWebsite = c.showWebsite
                                       }).OrderBy(x => x.distance).ToList<DealerLocation>();
     return locations;
 }