public HashSet <TableInfo> getTable(string db, string sqlPlace, string sqlReview, List <string> APIList)
{
TripDB tripdb = new TripDB();
SentimentAnalysis sent = new SentimentAnalysis();
HashSet <TableInfo> result = new HashSet <TableInfo>();
HashSet <Places> placeSet = tripdb.getPlaces(db, sqlPlace);
Parallel.ForEach(placeSet, place =>
{
string id = place.Id.ToString();
HashSet <Review> reviewSet = tripdb.getReviews(db, sqlReview, place.Id);
double note = 0;
int counter = 0;
foreach (Review review in reviewSet)
{
if (APIList.Count > 0)
{
note += sent.getSentiment(review.Reviewstr, APIList);
counter++;
}
else
{
break;
}
}
double moyenne = note / counter;
TableInfo temp = new TableInfo();
temp.Note = moyenne;
temp.Latitude = place.Latitude;
temp.Longitude = place.Longitude;
result.Add(temp);
});
return(result);
}
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);
}
