public static List<INFATITrip> CalculateTripsByCarId(Int16 carId)
{
DBController dbc = new DBController();
//Fetch all temporalinformation for a cardId
List<TemporalInformation> datapoints = dbc.GetTimestampsByCarId(carId);
dbc.Close();
//Instantiate the containers for trips and timestamps fetched by a single date at a time
List<INFATITrip> allTrips = new List<INFATITrip>();
INFATITrip trip = new INFATITrip(carId);
allTrips.Add(trip);
//First case
allTrips.Last().Timestamps.Add(new TemporalInformation(datapoints.ElementAt(0).EntryId, datapoints.ElementAt(0).Timestamp));
//Starting to iterate over all timestamps
for (int i = 1; i < datapoints.Count(); i++) {
//Compare the last seen timestamp to the current, if more than 300 seconds has past, create a new trip and store the current timestamp in it
if (Math.Abs(ToUnixTime(allTrips.Last().Timestamps.Last().Timestamp) - ToUnixTime(datapoints.ElementAt(i).Timestamp)) <= 180) {
allTrips.Last().Timestamps.Add(new TemporalInformation(datapoints.ElementAt(i).EntryId, datapoints.ElementAt(i).Timestamp));
} else {
allTrips.Add(new INFATITrip(carId));
allTrips.Last().Timestamps.Add(new TemporalInformation(datapoints.ElementAt(i).EntryId, datapoints.ElementAt(i).Timestamp));
}
}
return allTrips;
}
public static void LoadCarData(Int16 teamId, Int16 carId)
{
INFATI.AdjustLog(teamId, carId);
INFATILoader.DBLoader(carId, INFATI.ReadLog(teamId, carId));
DBController dbc = new DBController();
List<TemporalInformation> datapoints = dbc.GetTimestampsByCarId(carId);
dbc.Close();
Console.WriteLine("Found " + datapoints.Count + " gps-entries for car " + carId);
List<INFATITrip> trips = TripCalculator.CalculateTripsByCarId(carId);
Console.WriteLine("Found " + trips.Count + " trips for car " + carId);
dbc = new DBController();
foreach (INFATITrip trip in trips) {
dbc.InsertTripAndUpdateFactTable(trip);
}
dbc.Close();
}
