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