/*

 * Copyright (c) 2009 Nokia Corporation and/or its subsidiary(-ies).

 * All rights reserved.

 * This component and the accompanying materials are made available

 * under the terms of "Eclipse Public License v1.0"

 * which accompanies this distribution, and is available

 * at the URL "http://www.eclipse.org/legal/epl-v10.html".

 *

 * Initial Contributors:

 * Nokia Corporation - initial contribution.

 *

 * Contributors:

 *

 * Description: 

 *

 */

#include <QSqlQuery>

#include <QSqlError>

#include <qsysteminfo.h>

using namespace QtMobility;

#include <QVariant>

#include <QStringList.h>

#include "isproviderdbmanager.h"

#include "isproviderdbconstants.h"

/*!

 * \brief Constructor

 */

IsProviderDBManager::IsProviderDBManager( QObject *parent ) :  QObject(parent)

    {    

    }

/*!

 * \brief Destructor

 */

IsProviderDBManager::~IsProviderDBManager()

    {

    }

/*!

 * \brief Opens the database

 */

bool IsProviderDBManager::OpenDatabase()

    {

    m_db = QSqlDatabase::addDatabase(databaseType, connectionName);

    m_db.setDatabaseName(databaseName);

    if ( !m_db.isValid())

        {

        CloseDatabase();

        return false;

        }

    if (!m_db.isOpen())

        {

        if (!m_db.open())

            {

            CloseDatabase();

            return false;

            }

        }

    return true;

    }

/*!

 * \brief Closes the database

 */

void IsProviderDBManager::CloseDatabase()

    {    

  //  if (m_db.isValid() && m_db.isOpen())

  //      {

        m_db.close();

   //     }

    }

/*!

 * \brief Reads providers allowed in the current country

 */

bool IsProviderDBManager::GetProviders(QList<ServiceProvider>& providers)

    {

    bool ok = OpenDatabase();

    if (ok)

        {

        // Create query that gets providers allowed this country

        QString queryString(providerQuery);        

        // get country code and append to query

        queryString.append(GetCountryCode());

        queryString.append("\'");

        QSqlQuery query(QSqlDatabase::database(connectionName));    

        query.prepare(queryString);

        query.exec();

        // read all found providers

        while (query.next())

            {

            ServiceProvider* provider = new ServiceProvider();

            int providerId = query.value(0).toInt();

            provider->SetId(providerId);

            QString providerName = query.value(1).toString();

            provider->SetName(providerName);

            QString providerDescription = query.value(2).toString();

            provider->SetDescription(providerDescription);

            HbIcon icon(query.value(3).toString());            

            provider->SetIcon(icon);

            QString pluginName = query.value(10).toString();

            provider->SetPluginName(pluginName);

            providers.append(*provider);

            }    

        }

    CloseDatabase();

    return ok;

    }

/*!

 * \brief Gets selected provider

 */

ServiceProvider* IsProviderDBManager::SelectedProvider()

    {

    ServiceProvider* provider = NULL;

    bool ok = OpenDatabase();

    if (ok)

        {

        // Create query that gets providers allowed this country       

        QSqlQuery query(QSqlDatabase::database(connectionName));    

        query.prepare(selectedProviderQuery);

        query.exec();  

        // read all found providers

        while (query.next())

            {

            provider = new ServiceProvider();

            int providerId = query.value(0).toInt();

            provider->SetId(providerId);

            QString providerName = query.value(1).toString();

            provider->SetName(providerName);

            QString providerDescription = query.value(2).toString();

            provider->SetDescription(providerDescription);

            HbIcon icon(query.value(3).toString());            

            provider->SetIcon(icon);           

            QString providerUrl = query.value(4).toString();

            provider->SetProviderUrl(providerUrl);

            }    

        }

    CloseDatabase();

    return provider;

    }

/*!

 * \brief Sets selected provider

 */

bool IsProviderDBManager::SetSelectedProvider(int providerId)

    {    

    bool ok = OpenDatabase();

    if (ok)

        {

        // Clear selection status from all providers

        QSqlQuery query(QSqlDatabase::database(connectionName));    

        query.prepare(resetProviderSelection);

        ok = query.exec();

        if (ok)

            {

            // Set selection status to selected provider    

            QString queryString(setSelectedProvider);

            queryString.append( QString::number(providerId));        

            query.clear();

            query.prepare(queryString);

            ok = query.exec();        

            }

        }

    CloseDatabase();

    return ok;

    }

/*!

 * \brief Reads country list from database

 */

bool IsProviderDBManager::GetCountryList(QStringList& countryList)

    {

    bool ok = OpenDatabase();

    if (ok)

        {

        // Create query that gets country list   

        QSqlQuery query(QSqlDatabase::database(connectionName));    

        query.prepare(countryQuery);

        ok = query.exec();

        // read all found providers

        while (query.next())

            {

                countryList << query.value(0).toString();

            }     

        }

    CloseDatabase();   

    return ok;

    }

/*!

 * \brief Return current country code retrieved from system

 */

QString IsProviderDBManager::GetCountryCode()

    {

    QSystemInfo *sysInfo = new QSystemInfo(this);

    return "FI";//sysInfo->currentCountryCode();

    }