public string GetAllCoordonneeDepart() { CarShareDBContext db = new CarShareDBContext(); string s = ""; foreach (Coordonnee t in db.Coordonnees) { s += t.latD + "," + t.longD + "/"; } return s; }
public bool emailAlreadyExist(string _email) { CarShareDBContext db = new CarShareDBContext(); foreach (Membre m in db.Membres) { if (m.email.Equals(_email, StringComparison.CurrentCultureIgnoreCase)) return true; } return false; }
public int creerCoordonnee(int _idTrajet, string _urlGoogleMapjson, string _addresseD, string _addresseA, string _villeD, string _villeA) { CarShareDBContext db = new CarShareDBContext(); Coordonnee coordonnee = new Coordonnee(); string jsonDepart = this.getCoordonneeFromAdresseToJson(_urlGoogleMapjson, _addresseD + " " + _villeD); string jsonArrivee = this.getCoordonneeFromAdresseToJson(_urlGoogleMapjson, _addresseA + " " + _villeA); coordonnee.idTrajet = _idTrajet;//liaison du trajet et des coordonnées coordonnee.latD = this.getCoordonneesFromJson(jsonDepart)[0]; coordonnee.longD = this.getCoordonneesFromJson(jsonDepart)[1]; coordonnee.latA = this.getCoordonneesFromJson(jsonArrivee)[0]; coordonnee.longA = this.getCoordonneesFromJson(jsonArrivee)[1]; db.Coordonnees.Add(coordonnee); db.SaveChanges(); return coordonnee.id; }
public string GetAllDepart() { CarShareDBContext db = new CarShareDBContext(); string s = ""; foreach (Trajet t in db.Trajets) { s += t.villeD + "!"; } return s; }
public List<Trajet> getListeTrajetByInfo(string villeD, string villeA, DateTime date) { CarShareDBContext db = new CarShareDBContext(); List<Trajet> liste = new List<Trajet>(); string villeDToTest; string villeAToTest; if (!String.IsNullOrEmpty(villeD) && !String.IsNullOrEmpty(villeA) && date != null) { // adresse,VILLE,somethingOrNothing,france DONC 1 if (villeD.Split(',').Length > 2) { villeDToTest = villeD.Split(',')[1]; } // VILLE,somethingOrNothing,france DONC 0 else { villeDToTest = villeD.Split(',')[0]; } if (villeA.Split(',').Length > 2) { villeAToTest = villeA.Split(',')[1]; } else { villeAToTest = villeA.Split(',')[0]; } var trajet = from table in db.Trajets where (table.date.CompareTo(date) >= 0 & (table.villeD.Contains(villeDToTest) && table.villeA.Contains(villeAToTest))) select table; foreach (Trajet t in trajet.ToList()) { t.villeD = villeDToTest; t.villeA = villeAToTest; t.villeD = t.villeD.Replace(", France", ""); t.villeA = t.villeA.Replace(", France", ""); liste.Add(t); } } return liste; }
public string GetAllDepartArrivee() { CarShareDBContext db = new CarShareDBContext(); string s = ""; foreach (Trajet t in db.Trajets) { s += t.villeD + " <br /><strong>Arrivée :</strong> " + t.villeA + "<br /> !"; } return s; }
public string getCoordDansPerimetre(string lat, string lng, string perimetre) { List<string[]> coordonnesDansPerimetre = new List<string[]>(); CarShareDBContext db = new CarShareDBContext(); string json; string distanceMetre; string jsonRetour = ""; if (perimetre != null && perimetre != "") { foreach (Coordonnee c in db.Coordonnees) { //calcul distance json = new WebClient().DownloadString(Const.GOOGLEMAP_URL_DISTANCE + "origin=" + lat + "," + lng + "&destination=" + c.latD + "," + c.longD + "&sensor=true").ToString(); JObject o = JObject.Parse(json); distanceMetre = (string)o.SelectToken("routes[0].legs[0].distance.value"); if (int.Parse(distanceMetre) <= int.Parse(perimetre))//si dans périmetre on ajoute les coordonnées { jsonRetour += "_" + c.latD + "/" + c.longD + "/" + distanceMetre; } } } else jsonRetour = "Erreur dans le perimetre"; return jsonRetour; }
public Membre getMembreByEmail(string _email) { CarShareDBContext db = new CarShareDBContext(); foreach (Membre m in db.Membres) { if (m.email.Equals(_email)) return m; } return null; }