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