DatabaseServiceBusTableInterchanges.h

Go to the documentation of this file.

#ifndef DATABASESERVICEBUSTABLEINTERCHANGES_H
#define DATABASESERVICEBUSTABLEINTERCHANGES_H

// QT INCLUDES
#include <QList>
#include <QPair>

// BASE INCLUDES
#include "database/service/DatabaseService.h"

namespace EM
{
    namespace Devices
    {
        class EInterchangeInfo;
    }
}

class DatabaseServiceBusTableInterchanges : public DatabaseService
{
public:
    DatabaseServiceBusTableInterchanges();
    virtual ~DatabaseServiceBusTableInterchanges();

    static ApplicationDefines::ResultValue CreateDBTablesIfNotExist();
    static ApplicationDefines::ResultValue AddColumnPlatformNameIfNeeded();

    static ApplicationDefines::ResultValue ChangeInterchangeDepartureLineNumberToLineTextIfNeeded();

    static ApplicationDefines::ResultValue GetInterchangeDepartures( const int lineNumber, const int tripNumber, const int busStopID, QList<EM::Devices::EInterchangeInfo> &interchanges );
    static ApplicationDefines::ResultValue DeleteInterchangeDeparturesByInterchangeBusStopID( const QVariant &interchangeBusStopID );
    static ApplicationDefines::ResultValue GetInterchangeTrips( const int lineNumber, const int tripNumber, const int busStopID, QList<QPair<QString, int> > &interchangeTrips );

private:
    static QString GetQueryContentForInterchangeDepartureTableCreation();
};

#endif // DATABASESERVICEBUSTABLEINTERCHANGES_H