private void avgTest()
{
string cs = @"server=localhost;userid=root;password=;database=traitement";
string sqlAvg = "SELECT AVG(note) FROM tripreviewsamst WHERE idplace =";
int idplace = 239469;
TripDB trip = new TripDB();
double avgTest = trip.getAVG(cs, sqlAvg, idplace);
textBlock.Text = avgTest.ToString();
}
public HashSet <TableInfo> getTable(string db, string sqlPlace, string sqlAvg)
{
TripDB tripdb = new TripDB();
HashSet <TableInfo> result = new HashSet <TableInfo>();
HashSet <Places> placeSet = tripdb.getPlaces(db, sqlPlace);
Parallel.ForEach(placeSet, place =>
{
double avg = tripdb.getAVG(db, sqlAvg, place.Id);
TableInfo temp = new TableInfo();
temp.Note = avg;
temp.Latitude = place.Latitude;
temp.Longitude = place.Longitude;
result.Add(temp);
});
return(result);
}