/*

* Copyright (c) 2001-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:  EAP and WLAN authentication protocols.

*

*/

/*

*/

// This is enumeration of EAPOL source code.

#if defined(USE_EAP_MINIMUM_RELEASE_TRACES)

	#undef EAP_FILE_NUMBER_ENUM

	#define EAP_FILE_NUMBER_ENUM 337 

	#undef EAP_FILE_NUMBER_DATE 

	#define EAP_FILE_NUMBER_DATE 1127594498 

#endif //#if defined(USE_EAP_MINIMUM_RELEASE_TRACES)

// INCLUDE FILES

#include "EapGtcDbUtils.h"

#include "EapGtcDbDefaults.h"

#include "EapGtcDbParameterNames.h"

#include "EapSecurIDDbParameterNames.h"

const TUint KMaxSqlQueryLength = 512;

const TInt KMicroSecsInAMinute = 60000000; // 60000000 micro seconds is 1 minute.

// ================= MEMBER FUNCTIONS =======================

{

	// 1. Open/create a database	

	{

		aDatabase.Close();

	{

	}

	// 2. Create the eap-securid table to database (ignore error if exists)

	//////////////////////////////////////////////////////////////////////////////////////////////////

	HBufC* buf = HBufC::NewLC(KMaxSqlQueryLength);

	TPtr sqlStatement = buf->Des();

	sqlStatement.Format(KSQLCreateTable1, 

						&KGtcTableName, 

						&KServiceType, 

						&KServiceIndex, 

						&KTunnelingType, 

						&cf_str_EAP_GTC_identity_literal,

						&cf_str_EAP_GTC_max_session_validity_time_literal, 

	{

	}

	// 4. Check if database table contains a row for this service type and id  

	RDbView view;

	// View must be closed when no longer needed

	CleanupClosePushL(view);

	// 5. If row is not found then add it

	TInt rows = view.CountL();

	if (rows == 0)

	{		

		_LIT(KSQLInsert, "SELECT * FROM %S");

		sqlStatement.Format(KSQLInsert, &KGtcTableName);		

		CleanupClosePushL(view);

		// Get column set so we get the correct column numbers

		CDbColSet* colSet = view.ColSetL();		

		CleanupStack::PushL(colSet);

		view.InsertL();

		view.SetColL(colSet->ColNo(KServiceType), static_cast<TInt> (aIndexType));

		view.SetColL(colSet->ColNo(KServiceIndex), aIndex);

		view.SetColL(colSet->ColNo(cf_str_EAP_GTC_max_session_validity_time_literal), default_MaxSessionTime);

		view.SetColL(colSet->ColNo(KGTCLastFullAuthTime), default_FullAuthTime);		

		view.PutL();

	}

	aDatabase.Compact();

}

void EapGtcDbUtils::SetIndexL(

	RDbNamedDatabase& aDatabase, 		

	const TIndexType aIndexType,

	const TInt aIndex,

	const eap_type_value_e aTunnelingType,

	const TIndexType aNewIndexType,

	const TInt aNewIndex,

	const eap_type_value_e aNewTunnelingType)

{

	HBufC* buf = HBufC::NewLC(KMaxSqlQueryLength);

	TPtr sqlStatement = buf->Des();

	RDbView view;

	User::LeaveIfError(view.Prepare(aDatabase, TDbQuery(sqlStatement), TDbWindow::EUnlimited));

	// View must be closed when no longer needed

	CleanupClosePushL(view);

	User::LeaveIfError(view.EvaluateAll());

	TInt rows = view.CountL();

	if (rows == 0)

	{

		User::Leave(KErrNotFound);

	}

	// Get the first (and only) row

	view.FirstL();

	view.GetL();				

	// Get column set so we get the correct column numbers

	CDbColSet* colSet = view.ColSetL();

	CleanupStack::PushL(colSet);

	view.UpdateL();

    view.PutL();

}

void EapGtcDbUtils::SetConfigurationL(

	RDbNamedDatabase& aDatabase,

	const EAPSettings& aSettings, 

	const TIndexType aIndexType,

	const TInt aIndex,

	const eap_type_value_e aTunnelingType)

{

	// Check if the settings are for the correct type

	{

		User::Leave(KErrNotSupported);

	}

	HBufC* buf = HBufC::NewLC(KMaxSqlQueryLength);

	TPtr sqlStatement = buf->Des();	

	RDbView view;

	// Evaluate view

	User::LeaveIfError(view.Prepare(aDatabase, TDbQuery(sqlStatement)));

	CleanupClosePushL(view);

	User::LeaveIfError(view.EvaluateAll());	

	view.FirstL();

	view.UpdateL();

	// Get column set so we get the correct column numbers

	CDbColSet* colSet = view.ColSetL();

	CleanupStack::PushL(colSet);

	// Username

	if (aSettings.iUsernamePresent)

	{

		// Validate length.

		if(aSettings.iUsername.Length() > KMaxIdentityLengthInDB)

		{

			// Username too long. Can not be stored in DB.

			aSettings.iUsername.Length()));

			User::Leave(KErrArgument);

		}

		// Length is ok. Set the value in DB.

		view.SetColL(colSet->ColNo(cf_str_EAP_GTC_identity_literal), aSettings.iUsername);		

	}		

	// Session validity time

	if (aSettings.iSessionValidityTimePresent)

	{

		// User or device management wants to store the session validity time.

		// Convert the time to micro seconds and save.

		TInt64 validityInMicro = (aSettings.iSessionValidityTime) *  KMicroSecsInAMinute;

		view.SetColL(colSet->ColNo(cf_str_EAP_GTC_max_session_validity_time_literal), validityInMicro);

	}

	// Last full authentication time should be made zero when EAP configurations are modified.

	// This makes sure that the next authentication with this EAP would be full authentication

	// instead of reauthentication even if the session is still valid.

	view.SetColL(colSet->ColNo(KGTCLastFullAuthTime), default_FullAuthTime);

	view.PutL();

}

void EapGtcDbUtils::GetConfigurationL(

	RDbNamedDatabase& aDatabase,

	EAPSettings& aSettings, 

	const TIndexType aIndexType,

	const TInt aIndex,

	const eap_type_value_e aTunnelingType)

{

	HBufC* buf = HBufC::NewLC(KMaxSqlQueryLength);

	TPtr sqlStatement = buf->Des();	

	RDbView view;

	// Form the query

	// Evaluate view

	User::LeaveIfError(view.Prepare(aDatabase, TDbQuery(sqlStatement)));

	CleanupClosePushL(view);

	User::LeaveIfError(view.EvaluateAll());

	// Get the first (and only) row

	view.FirstL();

	view.GetL();

	// Get column set so we get the correct column numbers

	CDbColSet* colSet = view.ColSetL();

	CleanupStack::PushL(colSet);

	// Username

	TPtrC username = view.ColDes(colSet->ColNo(cf_str_EAP_GTC_identity_literal));

	aSettings.iUsername.Copy(username);

	aSettings.iUsernamePresent = ETrue;

	// Session validity time	

	TInt64 maxSessionTimeMicro = view.ColInt64(colSet->ColNo(cf_str_EAP_GTC_max_session_validity_time_literal));

	// Convert the time to minutes.	

	TInt64 maxSessionTimeMin = maxSessionTimeMicro / KMicroSecsInAMinute;

	aSettings.iSessionValidityTime = static_cast<TUint>(maxSessionTimeMin);

	aSettings.iSessionValidityTimePresent = ETrue;

}

void EapGtcDbUtils::CopySettingsL(

	RDbNamedDatabase& aDatabase, 		

	const TIndexType aSrcIndexType,

	const TInt aSrcIndex,

	const eap_type_value_e aSrcTunnelingType,

	const TIndexType aDestIndexType,

	const TInt aDestIndex,

	const eap_type_value_e aDestTunnelingType)

{

	HBufC* buf = HBufC::NewLC(KMaxSqlQueryLength);

	TPtr sqlStatement = buf->Des();

	RDbView view;

	User::LeaveIfError(view.Prepare(aDatabase, TDbQuery(sqlStatement), TDbWindow::EUnlimited));

	// View must be closed when no longer needed

	CleanupClosePushL(view);

	User::LeaveIfError(view.EvaluateAll());

	TInt rows = view.CountL();

	if (rows == 0)

	{

		User::Leave(KErrNotFound);

	}

	// Get the first (and only) row

	view.FirstL();

	view.GetL();

	view.InsertCopyL();

	// Get column set so we get the correct column numbers

	CDbColSet* colSet = view.ColSetL();

	CleanupStack::PushL(colSet);

	view.SetColL(colSet->ColNo(KServiceType), static_cast<TUint>(aDestIndexType));

    view.SetColL(colSet->ColNo(KServiceIndex), aDestIndex);

    view.PutL();

}

void EapGtcDbUtils::DeleteConfigurationL(	

	const TIndexType aIndexType,

	const TInt aIndex,

	const eap_type_value_e aTunnelingType)

{