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