public IHttpActionResult PutCoordonneeP(int id, CoordonneeP coordonneeP) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != coordonneeP.Id) { return(BadRequest()); } db.Entry(coordonneeP).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!CoordonneePExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult GetCoordonneeP(int id) { CoordonneeP coordonneeP = db.CoordonneePs.Find(id); if (coordonneeP == null) { return(NotFound()); } return(Ok(coordonneeP)); }
public IHttpActionResult PostCoordonneeP(CoordonneeP coordonneeP) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.CoordonneePs.Add(coordonneeP); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = coordonneeP.Id }, coordonneeP)); }
public IHttpActionResult DeleteCoordonneeP(int id) { CoordonneeP coordonneeP = db.CoordonneePs.Find(id); if (coordonneeP == null) { return(NotFound()); } db.CoordonneePs.Remove(coordonneeP); db.SaveChanges(); return(Ok(coordonneeP)); }
public string GetPrestatairesLibresEtProches(int idCli) //IQueryable<Prestataire> GetPrestatairesLibresEtProches(int idCli) { Prestation p = db.Prestations.Find(idCli); var address = p.RueDep + " " + p.VilleDep; // "123 something st, somewhere"; /*https://www.google.fr/maps/@50.5961833,3.0853137,12z*/ var requestUri = string.Format("http://maps.googleapis.com/maps/api/geocode/xml?address={0}&sensor=false", Uri.EscapeDataString(address)); var request = WebRequest.Create(requestUri); var response = request.GetResponse(); var xdoc = XDocument.Load(response.GetResponseStream()); var result = xdoc.Element("GeocodeResponse").Element("result"); var locationElement = result.Element("geometry").Element("location"); var lat1 = locationElement.Element("lat"); var lng1 = locationElement.Element("lng"); string lat11 = lat1.ToString().Substring(5, 15); lat11 = lat11.Substring(0, 10); lat11 = lat11.Replace(".", ","); string lng11 = lng1.ToString().Substring(5, 15); lng11 = lng11.Substring(0, 9); lng11 = lng11.Replace(".", ","); double lat111 = double.Parse(lat11); double lng111 = double.Parse(lng11); double distance = 42000.0; ////Prestataire p1 = db.Prestataires.Find(1); foreach (Prestataire p1 in db.Prestataires) { using (var context = new Db()) { CoordonneeP c1 = context.CoordonneePs.Find(p1.Id); var address2 = c1.Rue + " " + c1.Ville; // "123 something st, somewhere"; var requestUri2 = string.Format("http://maps.googleapis.com/maps/api/geocode/xml?address={0}&sensor=false", Uri.EscapeDataString(address2)); var request2 = WebRequest.Create(requestUri2); var response2 = request2.GetResponse(); var xdoc2 = XDocument.Load(response2.GetResponseStream()); var result2 = xdoc2.Element("GeocodeResponse").Element("result"); var locationElement2 = result2.Element("geometry").Element("location"); var lat2 = locationElement2.Element("lat"); var lng2 = locationElement2.Element("lng"); string lat22 = lat2.ToString().Substring(5, 15); lat22 = lat22.Substring(0, 10); lat22 = lat22.Replace(".", ","); string lng22 = lng2.ToString().Substring(5, 15); lng22 = lng22.Substring(0, 9); lng22 = lng22.Replace(".", ","); double lat222 = double.Parse(lat22); double lng222 = double.Parse(lng22); if (GetDistanceBetween(lat111, lng111, lat222, lng222) < distance) { distance = GetDistanceBetween(lat111, lng111, lat222, lng222); } return(result2.ToString()); } } //return ""; return(distance.ToString()); }