/*

* Copyright (c) 2002 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: create/save/get Internet connection methods from database.

*

*/

#include <d32dbms.h>

#include <e32base.h>

//database name

//_LIT(KtxDatabaseName, "DBS_INTERNET_ConnectionMethods.db");

_LIT(KtxDatabaseName, "c:InternetConnectionMethods.db");

_LIT( KNonSecureDbFullName, "C:\\system\\data\\InternetConnectionMethods.db" );

//Originator max length

#define KOriginatorMaxLength 50 

// database column names

_LIT(NCol1, "Index");

_LIT(NCol2, "APID");

_LIT(NCol3, "BearerType");

_LIT(NCol4, "Originator");

// database table name

_LIT(KtxtItemlist, "itemlist");

class TAccessPointItem

    {

public:

    TAccessPointItem() :

        iIndex(-1)

        {

        }

    ;

public:

    TInt iIndex;

    TUint iAPID;

    TUint iBearerType;

    TBuf<KOriginatorMaxLength> iOriginator;

    };

class CWPInternetAPDB : public CBase

    {

public:

    /**

     * Two-phased constructor.

     */

    static CWPInternetAPDB* NewL();

    /**

     * Two-phased constructor.

     */

    static CWPInternetAPDB* NewLC();

public:

    void ConstructL();

    ~CWPInternetAPDB();

public:

    /** 

     * CreateandOpenL

     * Creates and Opens the database.

     * @param name Path of the database

     * @return void

     **/

    inline void CreateandOpenL(TParse& name);

    /** 

     * ReadItemsL

     * Reads the Access Point data from a 

     * database and store the data in a Item array.

     * @param aItemArray Item Array

     * @param QueryBuffer SQL Query

     * @return void

     **/

    void

            ReadItemsL(RArray<TAccessPointItem>& aItemArray,

                    TFileName QueryBuffer);

    /** 

     * SaveToDatabaseL

     * Saves the Access Point data in a database

     * database and stores the data in a Item array.

     * @param aIndex Index

     * @param aAPId Access Point ID

     * @param aBearerType Bearer Type

     * @param aOriginator Operator

     * @return void

     **/

    void SaveToDatabaseL(TInt& aIndex, TUint aAPId, TUint32 aBearerType,

            const TDesC& aOriginator);

    /** 

     * ReadDbItemsL

     * Reads the Access Point data from a 

     * database and stores the data in a Item array.

     * @param aItemArray Item Array

     * @return void

     **/

    void ReadDbItemsL(RArray<TAccessPointItem>& aItemArray);

    /** 

     * ReadDbItemsForOrigL

     * Reads the Access Point data  for an operartor  

     * from a database and stores the data in a Item array.

     * @param aItemArray Item Array

     * @param aValue Operator

     * @return void

     **/

    void ReadDbItemsForOrigL(RArray<TAccessPointItem>& aItemArray,

            TDesC& aValue);

    /** 

     * DeleteFromDatabaseL

     * Deletes the existings rows which have same Access Point ID  

     * @param aAPId Access Point ID

     * @return TBool deleted rows

     **/

    TBool DeleteFromDatabaseL(TUint aAPId);

private:

    /** 

     * CreateTableL

     * Creates table for a database  

     * @param aDatabase Database Name

     * @return void

     **/

    void CreateTableL(RDbDatabase& aDatabase);

private:

    // Database Name

    RDbNamedDatabase iItemsDatabase;

    // File session

    RFs iFsSession;

    //Datbase session

    RDbs iRdbSession;

    };