public GasScore GetGasScores(UserModel user) { using (var dataModel = new Mibarim_plusEntities()) { var score = new GasScore(); var begining = DateTime.Parse("2017-08-30"); var trips = dataModel.vwDriverTrips.Where(x => x.UserId == user.UserId && x.TCreateTime > begining && x.TState != 5).ToList(); if (trips.Count > 0) { foreach (var vwDriverTrip in trips) { long minDistance; var stationRoute = dataModel.StationRoutes.FirstOrDefault(x => x.StationRouteId == vwDriverTrip.StationRouteId); if (stationRoute.DistanceMin != null) { minDistance = (long)stationRoute.DistanceMin; score.DistanceRouted += (long)(minDistance * 0.001); score.Payment += (long)(minDistance * 0.1); } } } return(score); } }
public GasScore GetGasScores(Guid userUId) { using (var dataModel = new MibarimEntities()) { var user = dataModel.vwUserInfoes.FirstOrDefault(x => x.UserUId == userUId); var score = new GasScore(); var begining = DateTime.Parse("2017-08-30"); //var trips = dataModel.vwDriverTrips.Where(x => x.UserId == user.UserId && x.TCreateTime > begining && x.TState != 5).ToList(); var trips = dataModel.GetDriverRate(begining, user.UserId).ToList(); if (trips.Count > 0) { score.RouteCount = trips.Count; foreach (var trip in trips) { long minDistance = trip.Value; score.DistanceRouted += (long)(minDistance * 0.001); score.Payment += (long)(minDistance * 0.1); } } return(score); } }