C# Class TrainNotifier.Service.TrainMovementRepository

Inheritance: DbRepository
Show file Open project: blueghostuk/trainnotifier-server

Public Methods

Method Description
CallingAtLocation ( string stanox, System.DateTime startDate = null, System.DateTime endDate = null, string atocCode = null, PowerType powerType = null ) : IEnumerable
CallingAtStation ( string crsCode, System.DateTime startDate = null, System.DateTime endDate = null, string atocCode = null, PowerType powerType = null ) : IEnumerable
CallingBetweenLocations ( string fromStanox, string toStanox, System.DateTime startDate = null, System.DateTime endDate = null, string atocCode = null, PowerType powerType = null ) : IEnumerable
CallingBetweenStations ( string fromCrs, string toCrs, System.DateTime startDate = null, System.DateTime endDate = null, string atocCode = null, PowerType powerType = null ) : IEnumerable
GetActivatedTrainMovementByHeadcodeAndStop ( string headcode, System.DateTime date, string stanox ) : CachedTrainDetails

Get an activated train id that calls at the given location

GetTrainMovementByHeadcode ( string headcode, DateTime date ) : IEnumerable
GetTrainMovementByHeadcodeAndLocation ( string headcode, string crsCode, string platform ) : TrainMovementLink
GetTrainMovementById ( string trainUid, DateTime date ) : TrainMovementResult
NearestTrains ( double lat, double lon, int limit ) : IEnumerable
StartingAtLocation ( string stanox, DateTime startDate = null, DateTime endDate = null, string atocCode = null, PowerType powerType = null ) : IEnumerable
StartingAtStation ( string crsCode, DateTime startDate = null, DateTime endDate = null, string atocCode = null, PowerType powerType = null ) : IEnumerable
TerminatingAtLocation ( string stanox, DateTime startDate, DateTime endDate, string atocCode = null, PowerType powerType = null ) : IEnumerable
TerminatingAtStation ( string crsCode, DateTime startDate, DateTime endDate, string atocCode = null, PowerType powerType = null ) : IEnumerable

Private Methods

Method Description
CallingAt ( IEnumerable tiplocs, System.DateTime startDate, System.DateTime endDate, string atocCode, PowerType powerType ) : IEnumerable
CallingBetween ( IEnumerable tiplocsFrom, IEnumerable tiplocsTo, System.DateTime startDate, System.DateTime endDate, string atocCode, PowerType powerType ) : IEnumerable
GetActualSchedule ( IEnumerable scheduleIds, System.DateTime startDate, System.DateTime endDate ) : IEnumerable
GetActualStops ( DbConnection connection, IEnumerable liveTrainIds ) : IEnumerable
GetCallingAtSchedules ( IEnumerable tiplocs, System.DateTime date, System.TimeSpan startTime, System.TimeSpan endTime, string atocCode, PowerType powerType ) : IEnumerable
GetCallingBetweenSchedules ( IEnumerable tiplocsFrom, IEnumerable tiplocsTo, System.DateTime date, System.TimeSpan startTime, System.TimeSpan endTime, string atocCode, PowerType powerType ) : IEnumerable
GetCancellations ( IEnumerable trainIds, DbConnection connection ) : IEnumerable
GetChangeOfOrigins ( IEnumerable trainIds, DbConnection connection ) : IEnumerable
GetDistinctSchedules ( IEnumerable schedules, System.DateTime date, string atocCode, PowerType powerType ) : IEnumerable
GetMatchingSchedules ( IEnumerable schedules, System.DateTime date, string atocCode, PowerType powerType ) : IEnumerable

this will pick up cancelled schedules which dont have any stops

GetReinstatements ( IEnumerable trainIds, DbConnection connection ) : IEnumerable
GetRunningAtSchedules ( IEnumerable tiplocs, System.DateTime date, System.TimeSpan startTime, System.TimeSpan endTime, string atocCode, PowerType powerType ) : IEnumerable
GetRunningCallingBetweenSchedules ( IEnumerable tiplocsFrom, IEnumerable tiplocsTo, System.DateTime date, System.TimeSpan startTime, System.TimeSpan endTime, string atocCode, PowerType powerType ) : IEnumerable
GetRunningStartingAtSchedules ( IEnumerable tiplocs, System.DateTime date, System.TimeSpan startTime, System.TimeSpan endTime, string atocCode, PowerType powerType ) : IEnumerable
GetRunningTerminatingAtSchedules ( IEnumerable tiplocs, System.DateTime date, System.TimeSpan startTime, System.TimeSpan endTime, string atocCode, PowerType powerType ) : IEnumerable
GetRunningTrainSchedules ( IEnumerable schedules, System.DateTime date ) : IEnumerable
GetSchedules ( IEnumerable scheduleIds, System.DateTime date ) : IEnumerable
GetStartingAtSchedules ( IEnumerable tiplocs, System.DateTime date, System.TimeSpan startTime, System.TimeSpan endTime, string atocCode, PowerType powerType ) : IEnumerable
GetStopsForSchedules ( DbConnection connection, IEnumerable scheduleIds ) : IEnumerable
GetTerminatingAtSchedules ( IEnumerable tiplocs, DateTime date, TimeSpan startTime, TimeSpan endTime, string atocCode, PowerType powerType ) : IEnumerable
GetTmSteps ( Guid trainId, DbConnection dbConnection ) : IEnumerable
GetTrainMovementById ( string trainId ) : TrainMovementLink
StartingAt ( IEnumerable tiplocs, DateTime startDate, DateTime endDate, string atocCode, PowerType powerType ) : IEnumerable
TerminatingAt ( IEnumerable tiplocs, DateTime startDate, DateTime endDate, string atocCode, PowerType powerType ) : IEnumerable

Method Details

CallingAtLocation() public method

public CallingAtLocation ( string stanox, System.DateTime startDate = null, System.DateTime endDate = null, string atocCode = null, PowerType powerType = null ) : IEnumerable
stanox string
startDate System.DateTime
endDate System.DateTime
atocCode string
powerType PowerType
return IEnumerable

CallingAtStation() public method

public CallingAtStation ( string crsCode, System.DateTime startDate = null, System.DateTime endDate = null, string atocCode = null, PowerType powerType = null ) : IEnumerable
crsCode string
startDate System.DateTime
endDate System.DateTime
atocCode string
powerType PowerType
return IEnumerable

CallingBetweenLocations() public method

public CallingBetweenLocations ( string fromStanox, string toStanox, System.DateTime startDate = null, System.DateTime endDate = null, string atocCode = null, PowerType powerType = null ) : IEnumerable
fromStanox string
toStanox string
startDate System.DateTime
endDate System.DateTime
atocCode string
powerType PowerType
return IEnumerable

CallingBetweenStations() public method

public CallingBetweenStations ( string fromCrs, string toCrs, System.DateTime startDate = null, System.DateTime endDate = null, string atocCode = null, PowerType powerType = null ) : IEnumerable
fromCrs string
toCrs string
startDate System.DateTime
endDate System.DateTime
atocCode string
powerType PowerType
return IEnumerable

GetActivatedTrainMovementByHeadcodeAndStop() public method

Get an activated train id that calls at the given location
public GetActivatedTrainMovementByHeadcodeAndStop ( string headcode, System.DateTime date, string stanox ) : CachedTrainDetails
headcode string headcode of train
date System.DateTime date train started on
stanox string location called at
return TrainNotifier.Common.Model.TDCache.CachedTrainDetails

GetTrainMovementByHeadcode() public method

public GetTrainMovementByHeadcode ( string headcode, DateTime date ) : IEnumerable
headcode string
date DateTime
return IEnumerable

GetTrainMovementByHeadcodeAndLocation() public method

public GetTrainMovementByHeadcodeAndLocation ( string headcode, string crsCode, string platform ) : TrainMovementLink
headcode string
crsCode string
platform string
return TrainMovementLink

GetTrainMovementById() public method

public GetTrainMovementById ( string trainUid, DateTime date ) : TrainMovementResult
trainUid string
date DateTime
return TrainMovementResult

NearestTrains() public method

public NearestTrains ( double lat, double lon, int limit ) : IEnumerable
lat double
lon double
limit int
return IEnumerable

StartingAtLocation() public method

public StartingAtLocation ( string stanox, DateTime startDate = null, DateTime endDate = null, string atocCode = null, PowerType powerType = null ) : IEnumerable
stanox string
startDate DateTime
endDate DateTime
atocCode string
powerType PowerType
return IEnumerable

StartingAtStation() public method

public StartingAtStation ( string crsCode, DateTime startDate = null, DateTime endDate = null, string atocCode = null, PowerType powerType = null ) : IEnumerable
crsCode string
startDate DateTime
endDate DateTime
atocCode string
powerType PowerType
return IEnumerable

TerminatingAtLocation() public method

public TerminatingAtLocation ( string stanox, DateTime startDate, DateTime endDate, string atocCode = null, PowerType powerType = null ) : IEnumerable
stanox string
startDate DateTime
endDate DateTime
atocCode string
powerType PowerType
return IEnumerable

TerminatingAtStation() public method

public TerminatingAtStation ( string crsCode, DateTime startDate, DateTime endDate, string atocCode = null, PowerType powerType = null ) : IEnumerable
crsCode string
startDate DateTime
endDate DateTime
atocCode string
powerType PowerType
return IEnumerable