/*

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

* All rights reserved.

* This component and the accompanying materials are made available

* under the terms of the License "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:    header file for CIptvSettingsDatabase class*

*/

#ifndef __CIPTVSETTINGSDATABASE_H__

#define __CIPTVSETTINGSDATABASE_H__

//  INCLUDES

#include <e32base.h>

#include <d32dbms.h>

#include <f32file.h>

// CONSTANTS

// Settings table

_LIT( KIptvSettingsTable, 					"Settings" );   

_LIT( KIptvSettingsDbKeyCol, 				"Key" );

_LIT( KIptvParentalControlCol,				"ParentalControl" );

_LIT( KIptvRecordingTimeCol,				"RecordingTime" );

_LIT( KIptvReminderTimeCol,					"ReminderTime" );

_LIT( KIptvLastUsedServiceCol,				"LastService" );

_LIT( KIptvLastUsedChannelCol,				"LastChannel" );

_LIT( KIptvIsLastUsedCol,			        "IsLast" );

_LIT( KIptvQuerySettingsSql, "SELECT ParentalControl, RecordingTime, ReminderTime, LastService, LastChannel, IsLast FROM Settings" );

// Default setting values

const TInt KIptvDefaultParentalControl = 0;

const TInt KIptvDefaultRecordingTimeReserve = 0;

const TInt KIptvDefaultReminderTime = 0;

const TUint32 KIptvDefaultLastUsedServiceId = 0;

const TInt64 KIptvDefaultLastUsedChannelId = 0;

const TInt KIptvDefaultIsLastUsed = 0;

// FORWARD DECLARATIONS

// CLASS DECLARATIONS

/**

* Live TV specific settings class.

*/

class TIptvLiveUISettings

	{

	public: 

		TInt    iParentalControl; 			// 0 = Off, or "%N Years"

		TInt    iRecordingTimeReserve;   	// 0 = Off, or "%N min"

		TInt    iReminderTime;				// 0 = Off, or "%N min"

  		TUint32 iLastUsedServiceId;         // 0 = Not used

  		TInt64  iLastUsedChannelId;         // 0 = Not used

  		TInt    iIsLastUsed;                // 0 = No (default), 1 = Yes

	};

/**

 * Class:       CIptvSettingsDatabase

 *

 * Description: An instance of class CIptvSettingsDatabase provides settings

 *              database access: creating & manipulating settings database

 *              files and database entries.

 * 

 */

class CIptvSettingsDatabase : public CBase

    {

    public:  // Constructors and destructor

         /**

         * Two-phased constructor.

         * @param aDbFile Database file name.

         */

        IMPORT_C static CIptvSettingsDatabase* NewL( const TFileName& aDbFile );

        /**

         * Destructor.

         */

        IMPORT_C virtual ~CIptvSettingsDatabase();

	public: // Public API for database operations

		/**

		* Save settings to the database.

		* @param aSettings Settings object.

		*/

		IMPORT_C void SaveSettingsL( const TIptvLiveUISettings& aSettings );

		/**

		* Read settings from database.

		* @param aSettings On return, contains current settings.

		*/

		IMPORT_C void ReadSettingsL( TIptvLiveUISettings& aSettings );

		/**

		* Save last used service and channel ids to database.

		* @param aSettings Settings object.

		*/

		IMPORT_C void SaveLastUsageL( const TIptvLiveUISettings& aSettings );

		/**

		* Read last used service and channel ids from database.

		* @param aServiceId current service id		

		* @param aSettings On return, contains current settings.

		*/

		IMPORT_C void ReadLastUsageByServiceL( const TUint32 aServiceId, 

		                                TIptvLiveUISettings& aSettings );

		/**

		* Reads the actual last watched channel and service from the database.		

		* @param aSettings On return, contains current settings (=last usage)

		*/		                                

        IMPORT_C void ReadLastUsageL( TIptvLiveUISettings& aSettings );		                                

    private: // Constructors

        /**

        *	Constructor

        *	@param	aDbFile		Filename of the database to be used

        */

        CIptvSettingsDatabase( const TFileName& aDbFile );

        /**

        *	Symbian second phase constructor. All code that might leave

        *	during construction is placed in here.

        *	@param	None

        *	@return	None

        */

    	void ConstructL();

	private: // Methods

        /**

    	* Create table for Settings and last used service and channel.

		* @param aDatabase Database.

    	*/

    	void CreateTableL( RDbNamedDatabase& aDatabase ) const;

        /**

         * 

         * Create new database if DB file is not found. 

         */

        void CreateDbL();

        /**        

         * Creates session to iptv database

         */

        void CreateDbSessionL();

		/**

		* Put in default settings.

		* @param aDatabase Database.

		*/

		void SetDefaultValuesL( RDbNamedDatabase& aDatabase ) const;

        /**               

         * Initialise database   

         */     

        void InitDbL();

    private: // Data

		/** File server session is connected in construction and closed in

			destruction */

    	RFs              iFsSession;

    	/** File name of the database which to handle */

		TFileName        iDbFile;

        /** DB session */

        RDbs iDbSession;

        /** database */

        RDbNamedDatabase iDb;

    };

#endif // __CIPTVSETTINGSDATABASE_H__

// End of File