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 static void Update(Int16 CarId) { DBController dbc = new DBController(); List<Int64> tripIds = dbc.GetTripIdsByCarId(CarId); foreach (Int64 tripId in tripIds) { List<Fact> facts = dbc.GetFactsByTripId(tripId); dbc.UpdateGPSFactWithMeasures(UpdatedFacts(facts)); } dbc.Close(); }
public static void Update(Int16 carId) { DBController dbc = new DBController(); List<Int64> tripIds = dbc.GetTripIdsByCarId(carId); List<Fact> facts; Trip trip; Int64 previousTripId = 0; DateTime previousEndTimestamp = new DateTime(); for (int i = 0; i < tripIds.Count; i++) { trip = dbc.GetTripByTripId(tripIds[i]); facts = dbc.GetFactsByTripId(tripIds[i]); //If a previous trip exists, save ID and the time passed between them if (i > 0) { trip.PreviousTripId = previousTripId; trip.SecondsToLag = MeasureCalculator.SecondsToLag(facts[0].Temporal.Timestamp, previousEndTimestamp); } //Remember variables for next iteration previousTripId = trip.TripId; previousEndTimestamp = trip.EndTemporal.Timestamp; Console.WriteLine("Updating car {0}, trip {1} ({2} facts)", carId, trip.TripId, facts.Count); trip = UpdateTrip(trip, facts, dbc); trip.OptimalScore = FinalScore.CalculateOptimalScore(trip); List<double> fullscores = FinalScore.CalculateTripScores(trip); trip.RoadTypeScore = fullscores[0]; trip.CriticalTimeScore = fullscores[1]; trip.SpeedingScore = fullscores[2]; trip.AccelerationScore = fullscores[3]; trip.BrakeScore = fullscores[4]; trip.JerkScore = fullscores[5]; trip.TripScore = fullscores[6]; dbc.UpdateTripFactWithMeasures(trip); } dbc.Close(); }