public List <FM_PositioningReport> GetDetailedAlarmReport(FleetRptCriteria frcmodel)
{
try
{
DataTable dataTableModel = model.Get_DetailedAlarmReport(frcmodel);
List <FM_PositioningReport> ListModel = dataTableModel.ToList <FM_PositioningReport>();
var assetStatus = ListModel.Where(u => u.AssetStatus != null).Select(a => a.AssetStatus).ToList();
if (assetStatus.Count > 0)
{
foreach (var item in ListModel)
{
if (item.AssetStatus == "True")
{
item.AssetStatus = "On";
}
else
{
item.AssetStatus = "Off";
}
}
return(ListModel.ToList());
}
else
{
return(ListModel.ToList());
}
}
catch (Exception ex)
{
throw ex;
}
}
public List <FM_PositioningReport> GetGeoFenceReport(FleetRptCriteria frcmodel)
{
try
{
DataTable dataTableModel = model.Get_GeoFenceReport(frcmodel);
List <FM_PositioningReport> ListModel = dataTableModel.ToList <FM_PositioningReport>();
return(ListModel.ToList());
}
catch (Exception ex)
{
throw ex;
}
}
public HttpResponseMessage MileageReport(FleetRptCriteria frcmodel)
{
//List<FM_PositioningReport> LstPositionReport = new List<FM_PositioningReport>();
List <FM_PositioningReport> modelResult = new List <FM_PositioningReport>();
modelResult = model.GetMileageReport(frcmodel);
//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));
}
public DataTable Get_MileageReport(FleetRptCriteria frcmodel)
{
SqlCommand loCommand = DataContext.OpenConnection();
try
{
loCommand = DataContext.SetStoredProcedure(loCommand, "FM_GetMileageReport");
//loCommand = DataContext.StartTransaction(loCommand);
return(DataContext.Select(DataContext.AddParameters(loCommand, "@Filter", frcmodel.ReportFilter, "@startDate", frcmodel.startDate, "@endDate", frcmodel.endDate, "@Device", frcmodel.Device, "@FuelConsumption", frcmodel.FuelConsumption, "@FuelPrice", frcmodel.FuelPrice)));
}
catch (Exception ex)
{
throw ex;
}
finally
{
DataContext.CloseConnection(loCommand);
}
}
public DataTable Get_SpeedReports(FleetRptCriteria frcmodel)
{
SqlCommand loCommand = DataContext.OpenConnection();
try
{
loCommand = DataContext.SetStoredProcedure(loCommand, "FM_GetSpeedReporting");
//loCommand = DataContext.StartTransaction(loCommand);
return(DataContext.Select(DataContext.AddParameters(loCommand, "@Filter", frcmodel.ReportFilter, "@startDate", frcmodel.startDate, "@endDate", frcmodel.endDate, "@Device",
frcmodel.Device, "@Speed", frcmodel.Speed, "@DriveOverHour", frcmodel.Driveoverhour, "@NoParkRest", frcmodel.Noparkrest, "@IdleSpeedMoreThan", frcmodel.Idlespeedmorethan)));
}
catch (Exception ex)
{
throw ex;
}
finally
{
DataContext.CloseConnection(loCommand);
}
}
public DataTable Get_PositioningReports(FleetRptCriteria frcmodel)
{
SqlCommand loCommand = DataContext.OpenConnection();
try
{
loCommand = DataContext.SetStoredProcedure(loCommand, "FM_GetFleetReporting");
//loCommand = DataContext.StartTransaction(loCommand);
return(DataContext.Select(DataContext.AddParameters(loCommand, "@Filter", frcmodel.ReportFilter, "@startDate", frcmodel.startDate,
"@endDate", frcmodel.endDate, "@Device", frcmodel.Device, "@Latitude", frcmodel.Latitude, "@Longitude", frcmodel.Longitude,
"@Radius", frcmodel.Radius, "@startWork", frcmodel.startWork, "@endWork", frcmodel.endWork, "@ParkingTime", frcmodel.parkingTime, "@DrivingTime", frcmodel.drivingTime)));
}
catch (Exception ex)
{
throw ex;
}
finally
{
DataContext.CloseConnection(loCommand);
}
}
public List <FM_PositioningReport> GetPositioningReports(FleetRptCriteria frcmodel)
{
try
{
DataTable dataTableModel = model.Get_PositioningReports(frcmodel);
List <FM_PositioningReport> ListModel = dataTableModel.ToList <FM_PositioningReport>();
var date = ListModel.Where(o => o.Date != null).Select(i => i.Date).ToList();
var assetStatus = ListModel.Where(u => u.AssetStatus != null).Select(a => a.AssetStatus).ToList();
if (date.Count > 0)
{
var x = ListModel.Select(y => { y.Date = DateTime.Parse(y.Date).ToString("MM-dd-yyyy"); return(y); });
return(x.ToList());
}
else if (assetStatus.Count > 0)
{
foreach (var item in ListModel)
{
if (item.AssetStatus == "True")
{
item.AssetStatus = "On";
}
else
{
item.AssetStatus = "Off";
}
}
return(ListModel.ToList());
}
else
{
return(ListModel.ToList());
}
}
catch (Exception ex)
{
throw ex;
}
}
public List <FM_PositioningReport> GetAssetStatus(FleetRptCriteria frcmodel)
{
try
{
DataTable dataTableModel = model.Get_AssetStatus(frcmodel);
List <FM_PositioningReport> ListModel = dataTableModel.ToList <FM_PositioningReport>();
var assetStatus = ListModel.Where(u => u.EngineStatus != null).Select(a => a.AssetStatus).ToList();
var doorStatus = ListModel.Where(u => u.DoorStatus != null).Select(a => a.DoorStatus).ToList();
var vibrationSensorState = ListModel.Where(u => u.VibrationSensorState != null).Select(a => a.VibrationSensorState).ToList();
if (assetStatus.Count > 0)
{
foreach (var item in ListModel)
{
if (item.EngineStatus == "True")
{
item.EngineStatus = "On";
}
else
{
item.EngineStatus = "Off";
}
}
return(ListModel.ToList());
}
else if (doorStatus.Count > 0)
{
foreach (var item in ListModel)
{
if (item.DoorStatus == "True")
{
item.DoorStatus = "On";
}
else
{
item.DoorStatus = "Off";
}
}
return(ListModel.ToList());
}
else if (vibrationSensorState.Count > 0)
{
foreach (var item in ListModel)
{
if (item.VibrationSensorState == "True")
{
item.VibrationSensorState = "SensorOn";
}
else
{
item.VibrationSensorState = "SensorOff";
}
}
return(ListModel.ToList());
}
else
{
}
return(ListModel.ToList());
}
catch (Exception ex)
{
throw ex;
}
}
