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));
}
