/// <summary>
        /// Enregistre ou met a jour un evenement
        /// </summary>
        public void Save()
        {
            if (this.Id == Guid.Empty)
            {
                this.Metier.Id = Guid.NewGuid();
                this.Metier.ImageEvenement.Id   = Guid.NewGuid();
                this.Metier.AdresseEvenement.Id = Guid.NewGuid();

                using (ParkingContext context = new ParkingContext())
                {
                    ServiceAdresse.Insert(this.Metier.AdresseEvenement, context);
                    ServiceImage.Insert(this.Metier.ImageEvenement, context);

                    string query = "https://maps.googleapis.com/maps/api/geocode/json?address=" + this.Metier.AdresseEvenement.ToString() + "&key=AIzaSyCyoqbqJVd_MtZRT_0DmYmznxxJWRfMjQI";

                    using (WebClient wc = new WebClient())
                    {
                        var json = wc.DownloadString(query);
                        RootObjectGoogle item = JsonConvert.DeserializeObject <RootObjectGoogle>(json);
                        if (item != null)
                        {
                            this.Metier.AdresseEvenement.lat = item.results.FirstOrDefault().geometry.location.lat;
                            this.Metier.AdresseEvenement.lng = item.results.FirstOrDefault().geometry.location.lng;
                        }
                    }

                    ServiceEvenement.Insert(this.Metier, context);
                    context.SaveChanges();
                }
            }
            else
            {
                ServiceEvenement.Update(this.Metier);
            }
        }
        public static void AddtoBase()
        {
            List <Parking> parkingToAdd = new List <Parking>();

            //recupere les parkings
            using (ParkingContext context = new ParkingContext())
            {
                using (WebClient wc = new WebClient())
                {
                    HttpWebRequest request = (HttpWebRequest)WebRequest.Create("http://data.citedia.com/r1/parks/timetable-and-prices");

                    StreamReader reader;

                    using (HttpWebResponse response = (HttpWebResponse)request.GetResponse())
                    {
                        reader = new StreamReader(response.GetResponseStream());
                        List <string[]> csvfile = new List <string[]>();// = reader.ReadToEnd();
                        string          line;
                        while ((line = reader.ReadLine()) != null)
                        {
                            csvfile.Add(Regex.Matches(line, @"[\""].+?[\""]|[^;]+").Cast <Match>().Select(m => m.Value).ToArray());
                        }
                        reader.Close();


                        int count = 0;
                        foreach (string[] stringtab in csvfile)
                        {
                            if (count != 0)
                            {
                                var     json = wc.DownloadString("http://data.citedia.com/r1/parks/" + stringtab[0]);
                                dynamic data = JsonConvert.DeserializeObject <ParkInformation>(json);

                                Adresse adresse = new Adresse(Guid.NewGuid(), stringtab[3], 0, 35000, "rennes", "france", true);
                                Parking parking = new Parking(Guid.NewGuid(), RemoveDiacritics(stringtab[0]), adresse, data.max, data.free, RemoveDiacritics(stringtab[2]), RemoveDiacritics(stringtab[1]), data.status);

                                ServiceAdresse.Insert(adresse, context);
                                ServiceParking.Insert(parking, context);

                                //Suppression des anciennes données
                                ServiceParking.DeleteAll();
                                ServiceAdresse.DeleteParking();

                                parkingToAdd.Add(parking);
                            }
                            count++;
                        }
                    }
                    context.Parkings.AddRange(parkingToAdd);
                    context.SaveChanges();
                }
            }
        }
 /// <summary>
 /// Enregistre ou met a jour un Adresse
 /// </summary>
 public void Save()
 {
     if (this.Id == Guid.Empty)
     {
         this.Metier.Id = Guid.NewGuid();
         ServiceAdresse.Insert(this.Metier);
     }
     else
     {
         ServiceAdresse.Update(this.Metier);
     }
 }