/// <summary> /// See interface docs. /// </summary> /// <param name="criteria"></param> /// <param name="fromRow"></param> /// <param name="toRow"></param> /// <param name="sortField1"></param> /// <param name="sortField1Ascending"></param> /// <param name="sortField2"></param> /// <param name="sortField2Ascending"></param> /// <returns></returns> public List <BaseStationFlight> GetFlights(SearchBaseStationCriteria criteria, int fromRow, int toRow, string sortField1, bool sortField1Ascending, string sortField2, bool sortField2Ascending) { if (criteria == null) { throw new ArgumentNullException("criteria"); } FlightsTable.NormaliseCriteria(criteria); List <BaseStationFlight> result = new List <BaseStationFlight>(); lock (_ConnectionLock) { OpenConnection(); if (_Connection != null) { result = _FlightTable.GetFlights(_Connection, null, _DatabaseLog, criteria, fromRow, toRow, sortField1, sortField1Ascending, sortField2, sortField2Ascending); } } return(result); }
/// <summary> /// See interface docs. /// </summary> /// <param name="criteria"></param> /// <returns></returns> public int GetCountOfFlights(SearchBaseStationCriteria criteria) { if (criteria == null) { throw new ArgumentNullException("criteria"); } FlightsTable.NormaliseCriteria(criteria); int result = 0; lock (_ConnectionLock) { OpenConnection(); if (_Connection != null) { result = _FlightTable.GetCount(_Connection, null, _DatabaseLog, criteria); } } return(result); }
/// <summary> /// Disposes of or finalises the object. Note that the object is sealed. /// </summary> /// <param name="disposing"></param> private void Dispose(bool disposing) { if (disposing) { _TransactionHelper.Abandon(); CloseConnection(); if (_AircraftTable != null) { _AircraftTable.Dispose(); _AircraftTable = null; } if (_FlightTable != null) { _FlightTable.Dispose(); _FlightTable = null; } if (_DbHistoryTable != null) { _DbHistoryTable.Dispose(); _DbHistoryTable = null; } if (_DbInfoTable != null) { _DbInfoTable.Dispose(); _DbInfoTable = null; } if (_LocationsTable != null) { _LocationsTable.Dispose(); _LocationsTable = null; } if (_SessionsTable != null) { _SessionsTable.Dispose(); _SessionsTable = null; } if (_SystemEventsTable != null) { _SystemEventsTable.Dispose(); _SystemEventsTable = null; } if (_ConfigurationStorage != null) { _ConfigurationStorage.ConfigurationChanged -= ConfigurationStorage_ConfigurationChanged; _ConfigurationStorage = null; } if (_DatabaseLog != null) { _DatabaseLog.Flush(); _DatabaseLog.Dispose(); _DatabaseLog = null; } } }
/// <summary> /// Disposes of or finalises the object. Note that the object is sealed. /// </summary> /// <param name="disposing"></param> private void Dispose(bool disposing) { if(disposing) { _TransactionHelper.Abandon(); CloseConnection(); if(_AircraftTable != null) { _AircraftTable.Dispose(); _AircraftTable = null; } if(_FlightTable != null) { _FlightTable.Dispose(); _FlightTable = null; } if(_DbHistoryTable != null) { _DbHistoryTable.Dispose(); _DbHistoryTable = null; } if(_DbInfoTable != null) { _DbInfoTable.Dispose(); _DbInfoTable = null; } if(_LocationsTable != null) { _LocationsTable.Dispose(); _LocationsTable = null; } if(_SessionsTable != null) { _SessionsTable.Dispose(); _SessionsTable = null; } if(_SystemEventsTable != null) { _SystemEventsTable.Dispose(); _SystemEventsTable = null; } if(_ConfigurationStorage != null) { _ConfigurationStorage.ConfigurationChanged -= ConfigurationStorage_ConfigurationChanged; _ConfigurationStorage = null; } if(_DatabaseLog != null) { _DatabaseLog.Flush(); _DatabaseLog.Dispose(); _DatabaseLog = null; } } }