public HttpResponseMessage FleeDetailTrackReplay(FleetReplayCriteria fleetreplaymodel)
{
//List<FM_PositioningReport> LstPositionReport = new List<FM_PositioningReport>();
List <FM_FleetReplay_VM> modelResult = new List <FM_FleetReplay_VM>();
modelResult = model.GetFleetReplayRecord(fleetreplaymodel);
//LstPositionReport.Add(modelResult);
// in your case this will be result of some service method and then
if (modelResult == null)
{
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
return(Request.CreateResponse(HttpStatusCode.OK, modelResult));
}
//Fleet Replay Records Start
public DataTable Get_FleetReplayRecords(FleetReplayCriteria fleetreplaycriteria)
{
SqlCommand loCommand = DataContext.OpenConnection();
try
{
loCommand = DataContext.SetStoredProcedure(loCommand, "FM_GetFleetReplayRecords");
//loCommand = DataContext.StartTransaction(loCommand);
return(DataContext.Select(DataContext.AddParameters(loCommand, "@Filter", fleetreplaycriteria.Filter, "@resultDate", fleetreplaycriteria.resultDate, "@Device", fleetreplaycriteria.Device)));
}
catch (Exception ex)
{
throw ex;
}
finally
{
DataContext.CloseConnection(loCommand);
}
}
public List <FM_TrackerTrip> GetFleetReplayTripRecord(FleetReplayCriteria fleetreplaycriteria)
{
try
{
DataTable dataTableModel = model.Get_FleetReplayRecords(fleetreplaycriteria);
List <FM_TrackerTrip> ListModel = dataTableModel.ToList <FM_TrackerTrip>();
var tripDate = ListModel.Where(u => u.TripDate != null).Select(a => a.TripDate).ToList();
if (tripDate.Count > 0)
{
foreach (var item in ListModel)
{
DateTime replaytripDate = Convert.ToDateTime(item.TripDate);
item.TripDate = replaytripDate.ToShortDateString();
}
}
return(ListModel);
}
catch (Exception ex)
{
throw ex;
}
}
//Start Fleet Replay Record
public List <FM_FleetReplay_VM> GetFleetReplayRecord(FleetReplayCriteria fleetreplaycriteria)
{
try
{
DataTable dataTableModel = model.Get_FleetReplayRecords(fleetreplaycriteria);
List <FM_FleetReplay_VM> ListModel = dataTableModel.ToList <FM_FleetReplay_VM>();
int counter = 0;
foreach (DataRow row in dataTableModel.Rows)
{
var objVeh = new FM_Vehicle();
objVeh.RegistrationNumber = row["RegistrationNumber"].ToString();
objVeh.IMEI = row["IMEI"].ToString();
if (fleetreplaycriteria.Filter == "IdleEngineReport")
{
objVeh.Longitude = Convert.ToDouble(row["Longitude"]);
objVeh.Latitude = Convert.ToDouble(row["Latitude"]);
}
if (fleetreplaycriteria.Filter == "Alarms" || fleetreplaycriteria.Filter == "DetailTrack")
{
objVeh.Longitude = Convert.ToDouble(row["Longitude"]);
objVeh.Latitude = Convert.ToDouble(row["Latitude"]);
objVeh.Speed = Convert.ToDouble(row["Speed"]);
objVeh.Direction = Convert.ToDouble(row["Direction"]);
objVeh.Odometer = Convert.ToDouble(row["Odometer"]);
objVeh.Rotation = row["Rotation"].ToString();
objVeh.CurrentTripMileage = Convert.ToDouble(row["CurrentTripMileage"]);
objVeh.GPSSignalStatus = row["GPSSignalStatus"].ToString();
objVeh.GSMSignal = row["GSMSignal"].ToString();
}
ListModel[counter].LstVehicle = objVeh;
counter = counter + 1;
}
var FatigueStatus = ListModel.Where(u => u.Status != null).Select(a => a.Status).ToList();
var engineStatus = ListModel.Where(u => u.InEngineOnOff != null).Select(a => a.InEngineOnOff).ToList();
var alarmState = ListModel.Where(u => u.AlarmState != null).Select(a => a.AlarmState).ToList();
if (FatigueStatus.Count > 0 || engineStatus.Count > 0)
{
foreach (var item in ListModel)
{
if (item.Status == "True")
{
item.Status = "Yes";
}
if (item.AlarmState == "True")
{
item.AlarmState = "On";
}
else
{
item.AlarmState = "Off";
}
if (item.InEngineOnOff == "True")
{
item.InEngineOnOff = "On";
}
else
{
item.InEngineOnOff = "Off";
}
}
return(ListModel.ToList());
}
else
{
return(ListModel.ToList());
}
}
catch (Exception ex)
{
throw ex;
}
}
