static void Main(string[] args)
{
DBController dbc = new DBController();
List<Trip> trips = dbc.GetAllTrips();
for(int i = 0; i > trips.Count; i++) {
GPSFactUpdater.UpdateRawGPS((Int16)trips[i].CarId, trips[i].TripId);
List<Fact> facts = new List<Fact>();
facts = dbc.GetFactsByTripId(trips[i].TripId);
trips[i] = TripFactUpdater.UpdateTripWithCountsAndIntervals(trips[i], facts, dbc);
dbc.UpdateTripFactWithCounts(trips[i]);
dbc.UpdateTripFactWithIntervals(trips[i]);
}
/*
List<Trip> trips = dbc.GetTripsByCarId(34);
Console.WriteLine("AverageTripPercentage:");
Console.WriteLine(UserProfile.AverageTripPercentage(trips).ToString());
Console.WriteLine("AverageMetricPercentage:");
UserProfile.print(UserProfile.AverageMetricPercentage(trips));
Console.WriteLine("AverageMetricNormalized:");
UserProfile.print(UserProfile.AverageMetricNormalized(trips));
Console.WriteLine("AverageMetricDegree:");
UserProfile.print(UserProfile.AverageMetricDegree(trips));
Console.WriteLine("CorrelationMatrix:");
Double[,] matrix = MetricCorrelation.getCorrelationMatrix(trips);
MetricCorrelation.printMatrix(matrix);
*/
Console.WriteLine("Aaaaand its done");
Console.ReadLine();
}
public FleetStatistics()
{
DBController dbc = new DBController();
this.AllTrips = dbc.GetAllTrips();
dbc.Close();
int totalTrips = AllTrips.Count;
RemoveBadTrips();
Console.WriteLine("Number of bad trips: " + (totalTrips - AllTrips.Count));
Console.WriteLine("Number of trips: " + AllTrips.Count);
Console.WriteLine("Average Distance Driven: " + AverageDistanceDriven());
Console.WriteLine("Average OptimalScore: " + AverageOptimalScore());
Console.WriteLine("Average TripScore: " + AverageTripScore());
Console.WriteLine("Average Percentage Above Optimal: " + (AveragePercentage() - 100));
Trip worst = WorstPercentageTrip();
Console.WriteLine("Worst Percentage: " + ((worst.TripScore / worst.OptimalScore * 100)-100) + " On Trip " + worst.TripId);
}