public JsonResult OverSpeedData(string id) { List <OverSpeed> data = new List <OverSpeed>(); var x = 0; var a = 0; var vehicleObj = db.AspNetDriver_Vehicle.FirstOrDefault(s => s.DriverID == id); var overspeedPositions = (from sub in db.AspNetVehicleLocationTables where sub.VehicleID == vehicleObj.VehicleID select new { sub.Id, sub.LastLatitude, sub.Speed, sub.LastLongitude, sub.VehicleID, sub.EngineRPM }).ToList(); foreach (var item in overspeedPositions) { OverSpeed overspeedobj = new OverSpeed(); int counter = item.Id - 1; x = Convert.ToInt32(item.Speed); a = Convert.ToInt32(item.EngineRPM); if (x >= 50 && a >= 100) { AspNetVehicleLocationTable LastLocation = null; do { LastLocation = db.AspNetVehicleLocationTables.FirstOrDefault(s => s.Id == counter && s.VehicleID == item.VehicleID); if (LastLocation != null) { var y = Convert.ToInt32(LastLocation.Speed); if (y <= 49) { overspeedobj.latitude = item.LastLatitude; overspeedobj.longitude = item.LastLongitude; overspeedobj.vehicleid = item.VehicleID; data.Add(overspeedobj); } } counter--; }while (LastLocation == null); } } return(Json(data, JsonRequestBehavior.AllowGet)); }
/***************************************************************************************************************************************************/ public JsonResult OverSpeedDataByTrip(int startid) { var vehiclelocationobj = db.AspNetVehicleLocationTables.FirstOrDefault(s => s.Id == startid); int RouteObjCounter = 0; var driverobj = db.AspNetDriver_Vehicle.FirstOrDefault(s => s.VehicleID == vehiclelocationobj.VehicleID); List <OverSpeed> data = new List <OverSpeed>(); var x = 0; var a = 0; var vehicleObj = db.AspNetDriver_Vehicle.FirstOrDefault(s => s.DriverID == driverobj.DriverID); //var overspeedPositions = (from sub in db.AspNetVehicleLocationTables // where sub.VehicleID == vehicleObj.VehicleID // select new { sub.Id, sub.LastLatitude, sub.Speed, sub.LastLongitude, sub.VehicleID, sub.EngineRPM }).ToList(); List <AspNetVehicleLocationTable> overspeedPositions = new List <AspNetVehicleLocationTable>(); RouteObjCounter = startid; var routeobj = new AspNetVehicleLocationTable(); do { routeobj = null; routeobj = db.AspNetVehicleLocationTables.FirstOrDefault(s => s.Id == RouteObjCounter && s.VehicleID == vehiclelocationobj.VehicleID); if (routeobj != null) { overspeedPositions.Add(routeobj); } RouteObjCounter++; }while (routeobj == null || routeobj.TripStatus != "EndTrip"); foreach (var item in overspeedPositions) { OverSpeed overspeedobj = new OverSpeed(); int counter = item.Id - 1; x = Convert.ToInt32(item.Speed); a = Convert.ToInt32(item.EngineRPM); if (x >= 50 && a >= 100) { AspNetVehicleLocationTable LastLocation = null; do { LastLocation = db.AspNetVehicleLocationTables.FirstOrDefault(s => s.Id == counter && s.VehicleID == item.VehicleID); if (LastLocation != null) { var y = Convert.ToInt32(LastLocation.Speed); if (y <= 49) { overspeedobj.latitude = item.LastLatitude; overspeedobj.longitude = item.LastLongitude; overspeedobj.vehicleid = item.VehicleID; data.Add(overspeedobj); } } counter--; }while (LastLocation == null); } } return(Json(data, JsonRequestBehavior.AllowGet)); }