Пример #1
0
        public async Task <Tuple <RidesStatisticsDto, RidesStatisticsDto> > ExecuteAsync()
        {
            var collection = await DocumentContext.GetCollectionAsync(DocumentDbContext.CollectionTrackedRides);

            var driverRidesSql          = "SELECT c.Miles, c.GpsAverageSpeed, c.Breakdowns FROM c where c.DriverId = " + DriverId;
            var driverStats             = GetRideStatistics(collection, driverRidesSql);
            RidesStatisticsDto allStats = null;

            if (GetGlobalStatisticsAlso)
            {
                var allRidesSql = "SELECT c.Miles, c.GpsAverageSpeed, c.Breakdowns FROM c";
                allStats = GetRideStatistics(collection, allRidesSql);
            }
            return(new Tuple <RidesStatisticsDto, RidesStatisticsDto>(item1: driverStats, item2: allStats));
        }
Пример #2
0
        private RidesStatisticsDto GetRideStatistics(DocumentCollection collection, string sql)
        {
            var rides = DocumentContext.CreateDocumentQueryFromSQL(collection,
                                                                   sql).
                        ToList();

            var statistics = new RidesStatisticsDto();
            var count      = 0;

            foreach (dynamic rideData in rides)
            {
                statistics.Breakdowns += rideData.Breakdowns;
                statistics.AvgSpeed    = ((statistics.Miles * statistics.AvgSpeed) + (rideData.Miles * rideData.GpsAverageSpeed)) / (statistics.Miles + rideData.Miles);
                statistics.Miles      += rideData.Miles;
                statistics.Items       = ++count;
            }


            return(statistics);
        }