public List <AISData> GetAISData(int mmsi, DateTime startTime, DateTime endTime, double latitudeMinDeg, double latitudeMaxDeg, double longitudeMinDeg, double longitudeMaxDeg) { using var db = new AISDataContext(); var aisData = db.AISData.FilterByMMSI(mmsi).FilterByTime(startTime, endTime).FilterByLatitudeLongitude(latitudeMinDeg, latitudeMaxDeg, longitudeMinDeg, longitudeMaxDeg).OrderByTime().ToList();; return(aisData); }
public List <AISData> GetAISData(int mmsi, DateTime startTime, DateTime endTime) { using var db = new AISDataContext(); var aisData = db.AISData.FilterByMMSI(mmsi).FilterByTime(startTime, endTime).OrderByTime().ToList();; return(aisData); }
public List <int> GetMMSIs(DateTime startTime, DateTime endTime, double latitudeMinDeg, double latitudeMaxDeg, double longitudeMinDeg, double longitudeMaxDeg) { using var db = new AISDataContext(); var mmsis = db.AISData.FilterByTime(startTime, endTime).FilterByLatitudeLongitude(latitudeMinDeg, latitudeMaxDeg, longitudeMinDeg, longitudeMaxDeg).Select(s => s.MMSI).Distinct().OrderBy(s => s).ToList(); return(mmsis); }
public List <AISData> GetAISData(int mmsi) { using var db = new AISDataContext(); var aisData = db.AISData.FilterByMMSI(mmsi).ToList(); return(aisData); }
public List <int> GetMMSIs(DateTime startTime, DateTime endTime) { using var db = new AISDataContext(); var mmsis = db.AISData.FilterByTime(startTime, endTime).Select(s => s.MMSI).Distinct().OrderBy(s => s).ToList(); return(mmsis); }