public static double AverageDistancePerTrip(Int16 carId) { double totalDistance = 0; DBController dbc = new DBController(); Int64 tripCount = dbc.GetTripCountByCarId(carId); dbc.Close(); List<double> distancePerTrip = DistancePerTrip(carId); foreach (double distance in distancePerTrip) { totalDistance += distance; } return totalDistance / tripCount; }
public static Int64 TripCount(Int16 carId) { DBController dbc = new DBController(); Int64 tripCount = dbc.GetTripCountByCarId(carId); dbc.Close(); return tripCount; }