public void Update(Parking parking)
{
Parking p = DalGenerique <Parking> .GetInstance().GetById(parking.Id);
p.Identifiant = parking.Identifiant;
p.Nom = parking.Nom;
p.Statut = parking.Statut;
p.PlacesMax = parking.PlacesMax;
p.PlacesLibres = parking.PlacesLibres;
p.Coordonnees = parking.Coordonnees;
p.Adresse = parking.Adresse;
p.TexteHoraires = parking.TexteHoraires;
p.TexteTarifs = parking.TexteTarifs;
p.LastUpdate = parking.LastUpdate;
p.ListeHoraires = parking.ListeHoraires;
db.SaveChanges();
}
public static Parking GetById(string idParking)
{
var client = new WebClient();
client.Encoding = Encoding.UTF8;
var adresse = @"http://data.citedia.com/r1/parks/" + idParking;
var json = client.DownloadString(adresse);
ParkInformation parkInformation = JsonConvert.DeserializeObject <ParkInformation>(json);
var parking = new Parking
{
Identifiant = idParking,
Nom = parkInformation.name,
Statut = parkInformation.status,
PlacesMax = parkInformation.max,
PlacesLibres = parkInformation.free
};
return(parking);
}
internal static Parking GetParkingById(int id)
{
using (SqlConnection connection = new SqlConnection(ActualConnectionString.Get()))
{
SqlCommand command = new SqlCommand("GetParkingByID");
command.CommandType = CommandType.StoredProcedure;
command.Connection = connection;
command.Parameters.AddWithValue("@id", id);
connection.Open();
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
Parking parking = new Parking(id, (string)reader["Адрес"]);
return(parking);
}
}
}
return(null);
}
public static List <Parking> GetAll()
{
List <Parking> listeParkings = new List <Parking>();
var client = new WebClient();
client.Encoding = Encoding.UTF8;
var adresse = @"http://data.citedia.com/r1/parks/?crs=EPSG:4326";
var json = client.DownloadString(adresse);
RootObject rootObject = JsonConvert.DeserializeObject <RootObject>(json);
//Donnees des parking
foreach (var park in rootObject.parks)
{
if (park != null && park.parkInformation != null && park.parkInformation.free >= 10)
{
listeParkings.Add(new Parking
{
Identifiant = park.id,
Nom = park.parkInformation.name,
Statut = park.parkInformation.status,
PlacesMax = park.parkInformation.max,
PlacesLibres = park.parkInformation.free
});
}
}
//Coordonnees des parkings
foreach (var feature in rootObject.features.features)
{
var parkingSelected = listeParkings.FirstOrDefault(f => f.Identifiant == feature.id);
if (parkingSelected != null)
{
parkingSelected.Coordonnees = FormatCoordonnees(feature.geometry.coordinates);
}
}
//TexteTarifs et adresses des parkings
List <ParkingPrice> listeTarifs = SplitCSV(@"http://data.citedia.com/r1/parks/timetable-and-prices");
foreach (var tarif in listeTarifs)
{
Parking p = listeParkings.FirstOrDefault(f => f.Identifiant == tarif.Id);
if (p != null)
{
p.TexteHoraires = tarif.Horaires;
p.Adresse = tarif.Adresse;
p.TexteTarifs = tarif.Tarifs;
}
}
foreach (var parking in listeParkings)
{
parking.Adresse = DalGoogleMaps.GetAddressFromLatLng(parking.Coordonnees);
parking.LastUpdate = DateTime.Now;
}
//TODO Creer objets horaires et tarifs
//Horaires
Horaire h = new Horaire();
//Tarifs
Tarif t = new Tarif();
SaveParkings(listeParkings);
return(listeParkings);
}
