public static void MajCoordonnees()
{
using (var db = new masterEntities())
{
var query = from even in db.Evenement
orderby even.EVENT_NAME
select even;
int max = 2000;
foreach (Evenement even in query)
{
var request = new GeocodingRequest();
request.Address = even.ADRESSE;
var response = new GeocodingService().GetResponse(request);
//The GeocodingService class submits the request to the API web service, and returns the
//response strongly typed as a GeocodeResponse object which may contain zero, one or more results.
//Assuming we received at least one result, let's get some of its properties:
if (response.Status == ServiceResponseStatus.Ok && response.Results.Count() > 0)
{
var result = response.Results.First();
even.LATITUDE = result.Geometry.Location.Latitude;
even.LONGITUDE = result.Geometry.Location.Longitude;
}
else
{
Console.WriteLine("Unable to geocode. Status={0} and ErrorMessage={1}", response.Status, response.ErrorMessage);
}
max -= 1;
if (max == 0)
{
break;
}
}
db.SaveChanges();
}
}
protected void Page_Load(object sender, EventArgs e)
{
nbLoad++;
listeElements.Controls.Clear();
if ("".Equals(Date.Text))
{
Date.Text = DateTime.Now.ToString("yyyy-MM-dd");
}
if ("".Equals(Adresse.Text))
{
//Masque impression
printButton.Attributes.Add("style", "display: none");
}
else
{
if (nbLoad == 6)
{
pointDepart = Utils.GetCoordonnees(Adresse.Text);
}
//Adresse.Attributes.Add("style", "display: none");
//Pour test :
//System.Web.UI.HtmlControls.HtmlGenericControl lattitude = new System.Web.UI.HtmlControls.HtmlGenericControl("P");
//lattitude.InnerHtml = "Lattitude : "+pointDepart.LATITUDE.ToString();
//listeElements.Controls.Add(lattitude);
//System.Web.UI.HtmlControls.HtmlGenericControl longitude = new System.Web.UI.HtmlControls.HtmlGenericControl("P");
//longitude.InnerHtml = "Longitude : " + pointDepart.LONGITUDE.ToString();
//listeElements.Controls.Add(longitude);
//if (pointDepart.LONGITUDE != null)
//{
printButton.Attributes.Add("style", "display: block; font-size: large;");
using (var db = new masterEntities())
{
var query = from even in db.Evenement
where (even.LATITUDE != null) && (even.LATITUDE > 42) && (even.LATITUDE < 45) && (even.LONGITUDE > 2) && (even.LONGITUDE < 6) && "EVENEMENT".Equals(even.TYPE_EVENEMENT) && (even.URL_PHOTO != null)
orderby Guid.NewGuid()
select even;
var evenements = query.Take(3).ToList();
query = from even in db.Evenement
where (even.LATITUDE != null) && (even.LATITUDE > 42) && (even.LATITUDE < 45) && (even.LONGITUDE > 2) && (even.LONGITUDE < 6) && "RESTAURANT".Equals(even.TYPE_EVENEMENT)
orderby Guid.NewGuid()
select even;
var restaurants = query.Take(2).ToList();
Evenement matin;
if (Cbmatin.Checked)
{
matin = (Evenement)Session["matin"];
}
else
{
matin = evenements[0];
}
Evenement midi;
if (Cbmidi.Checked)
{
midi = (Evenement)Session["midi"];
}
else
{
midi = restaurants[0];
}
Evenement aprem;
if (Cbaprem.Checked)
{
aprem = (Evenement)Session["aprem"];
}
else
{
aprem = evenements[1];
}
Evenement diner;
if (Cbdiner.Checked)
{
diner = (Evenement)Session["diner"];
}
else
{
diner = restaurants[1];
}
Evenement soir;
if (Cbsoir.Checked)
{
soir = (Evenement)Session["soir"];
}
else
{
soir = evenements[2];
}
//Ceci est un gros hack d&geulasse
if (nbLoad > 1)
{
Session["matin"] = matin;
Session["midi"] = midi;
Session["aprem"] = aprem;
Session["diner"] = diner;
Session["soir"] = soir;
if (Session["nameIndex"] != null)
{
nameIndex = (int)Session["nameIndex"];
}
if (nameIndex >= buttonNames.Length)
{
nameIndex = 0;
}
search.Text = buttonNames[nameIndex];
nameIndex += 1;
Session["nameIndex"] = nameIndex;
}
Control activiteMatin = AfficherEvenement(matin, "Matinée", Cbmatin);
listeElements.Controls.Add(activiteMatin);
Control repasMidi = AfficherEvenement(midi, "Repas du midi", Cbmidi, "background-color : lightgrey; margin-top: 10px; margin-bottom: 10px", "Content/restau.png");
listeElements.Controls.Add(repasMidi);
Control activiteApresMidin = AfficherEvenement(aprem, "Après-midi", Cbaprem);
listeElements.Controls.Add(activiteApresMidin);
Control repasSoir = AfficherEvenement(diner, "Repas du soir", Cbdiner, "background-color : lightgrey; margin-top: 10px; margin-bottom: 10px", "Content/restau.png");
listeElements.Controls.Add(repasSoir);
Control activiteSoiree = AfficherEvenement(soir, "Soirée", Cbsoir);
listeElements.Controls.Add(activiteSoiree);
}
//}
//else
//{
// System.Web.UI.HtmlControls.HtmlGenericControl affichageErreur = new System.Web.UI.HtmlControls.HtmlGenericControl("P");
// affichageErreur.InnerHtml = pointDepart.ADRESSE;
// listeElements.Controls.Add(affichageErreur);
//}
}
//Random rnd = new Random();
//int IDrand = rnd.Next(1, 10000);
//var evenement = new Evenement { ID = IDrand, EVENT_NAME = "test import from code", LATITUDE = (decimal)4.245451, LONGITUDE = (decimal)44.5245451 };
//db.Evenement.Add(evenement);
//db.SaveChanges();
// Display all Blogs from the database
//GridViewResult.DataBind();
}
