public List <ViolationsGroupedByLocationsDTO> GetViolationsListGroupedByLocation(DateTime?StartDateTime, int?ViolationTypeId)
{
try
{
var lstViolations = operationalDataContext.fn_GroupViolationsByLocations(StartDateTime, ViolationTypeId)
.Where(Violation => Violation.Latitude != null && Violation.Longitude != null)
.Select(Violation => new ViolationsGroupedByLocationsDTO
{
Altitude = Violation.Altitude,
Latitude = Violation.Latitude.Value,
Longitude = Violation.Longitude.Value,
ViolationsCount = Violation.ViolationsCount,
LocationCode = Violation.LocationCode
}).ToList();
return(lstViolations);
}
catch (Exception ex)
{
}
return(null);
}