/*

* Copyright (c) 2009-2010 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 general settings configuration.

*

*/

/*

*/

#include "eap_tools.h"

#include "eap_status.h"

#include "eap_am_export.h"

#include "eap_expanded_type.h"

#include "eap_array.h"

#include "eap_database_reference_if.h"

#include "eap_am_general_settings_symbian.h"

#include "abs_eap_am_general_settings.h"

#include "eap_automatic_variable.h"

#include "EapTraceSymbian.h"

#include "EapConversion.h"

#include "EapTlsPeapCertFetcher.h"

#include "EapPluginTools.h"

#include <EapTypePlugin.h>

#include "EapAutomatic.h"

/** @file */

// ----------------------------------------------------------------------

EAP_LITERAL_SYMBIAN(KGeneralsettingsDatabaseName, "eap_methods.dat");

EAP_LITERAL_SYMBIAN(KGeneralSettingsTableName, "eap_general_settings");

_LIT(KEapMethodEnabledValue, "enabled");

_LIT(KEapMethodDisabledValue, "disabled");

_LIT(KServiceType, "service_type");

_LIT(KServiceIndex, "service_index");

_LIT(KSQL, "SELECT %S, %S, %S, %S FROM %S WHERE %S=%d AND %S=%d");

const TUint KMaxSqlQueryLength = 512;

const TInt	KDefaultColumnInView_One = 4; // For DB view.

// ----------------------------------------------------------------------

eap_am_general_settings_symbian_c::eap_am_general_settings_symbian_c(

	abs_eap_am_tools_c * const tools,

	abs_eap_am_general_settings_c * const partner)

	: m_am_tools(tools)

	, m_partner(partner)

	, m_is_valid(false)

	, m_shutdown_was_called(false)

	, iGeneralSettingsDbCreated(EFalse)

	, iGeneralSettingsSessionOpened(EFalse)

	, iCertificateFetcher(0)

	, m_completion_status(eap_status_process_general_error)

	, m_EAPType(eap_type_none)

	, m_IndexType(0ul)

	, m_Index(0ul)

{

	if (m_am_tools == 0

		|| m_am_tools->get_is_valid() == false

		|| m_partner == 0)

	{

		return;

	}

	m_is_valid = true;

	EAP_TRACE_DEBUG(

		m_am_tools,

		TRACE_FLAGS_DEFAULT,

		(EAPL("eap_am_general_settings_symbian_c::eap_am_general_settings_symbian_c(): this=0x%08x.\n"),

		this));

}

// ----------------------------------------------------------------------

eap_am_general_settings_symbian_c::eap_am_general_settings_symbian_c(

	abs_eap_am_tools_c * const tools)

	: m_am_tools(tools)

	, m_partner(0)

	, m_is_valid(false)

	, m_shutdown_was_called(false)

	, iGeneralSettingsDbCreated(EFalse)

	, iGeneralSettingsSessionOpened(EFalse)

	, iCertificateFetcher(0)

	, m_completion_status(eap_status_process_general_error)

	, m_EAPType(eap_type_none)

	, m_IndexType(0ul)

	, m_Index(0ul)

{

	if (m_am_tools == 0

		|| m_am_tools->get_is_valid() == false)

	{

		return;

	}

	m_is_valid = true;

	EAP_TRACE_DEBUG(

		m_am_tools,

		TRACE_FLAGS_DEFAULT,

		(EAPL("eap_am_general_settings_symbian_c::eap_am_general_settings_symbian_c(): this=0x%08x.\n"),

		this));

}

// ----------------------------------------------------------------------

eap_am_general_settings_symbian_c::~eap_am_general_settings_symbian_c()

{

	EAP_TRACE_DEBUG(

		m_am_tools,

		TRACE_FLAGS_DEFAULT,

		(EAPL("eap_am_general_settings_symbian_c::~eap_am_general_settings_symbian_c(): this=0x%08x.\n"),

		this));

	EAP_TRACE_RETURN_STRING(m_am_tools, "returns: eap_am_general_settings_symbian_c::~eap_am_general_settings_symbian_c()");

	EAP_UNREFERENCED_PARAMETER(KGeneralsettingsDatabaseName_8bit);

	EAP_UNREFERENCED_PARAMETER(KGeneralSettingsTableName_8bit);

	CloseGeneralSettings();

	delete iCertificateFetcher;

	iCertificateFetcher = 0;

	EAP_ASSERT(m_shutdown_was_called == true);

}

// ----------------------------------------------------------------------

bool eap_am_general_settings_symbian_c::get_is_valid()

{

	EAP_TRACE_DEBUG(

		m_am_tools,

		TRACE_FLAGS_DEFAULT,

		(EAPL("eap_am_general_settings_symbian_c::get_is_valid(): this=0x%08x, m_is_valid=%d.\n"),

		this,

		m_is_valid));

	EAP_TRACE_RETURN_STRING(m_am_tools, "returns: eap_am_general_settings_symbian_c::get_is_valid()");

	return m_is_valid;

}

// ----------------------------------------------------------------------

// This is documented in abs_eap_stack_interface_c::configure().

eap_status_e eap_am_general_settings_symbian_c::configure()

{

	EAP_TRACE_DEBUG(

		m_am_tools,

		TRACE_FLAGS_DEFAULT,

		(EAPL("eap_am_general_settings_symbian_c::configure(): this=0x%08x.\n"),

		this));

	EAP_TRACE_RETURN_STRING(m_am_tools, "returns: eap_am_general_settings_symbian_c::configure()");

	return EAP_STATUS_RETURN(m_am_tools, eap_status_ok);

}

// ----------------------------------------------------------------------

// This is documented in abs_eap_stack_interface_c::shutdown().

eap_status_e eap_am_general_settings_symbian_c::shutdown()

{

	EAP_TRACE_DEBUG(

		m_am_tools,

		TRACE_FLAGS_DEFAULT,

		(EAPL("eap_am_general_settings_symbian_c::shutdown(): this=0x%08x.\n"),

		this));

	EAP_TRACE_RETURN_STRING(m_am_tools, "returns: eap_am_general_settings_symbian_c::shutdown()");

	m_shutdown_was_called = true;

	return EAP_STATUS_RETURN(m_am_tools, eap_status_ok);

}

// ----------------------------------------------------------------------

void eap_am_general_settings_symbian_c::CloseGeneralSettings()

{

	EAP_TRACE_DEBUG(

		m_am_tools,

		TRACE_FLAGS_DEFAULT,

		(EAPL("eap_am_general_settings_symbian_c::CloseGeneralSettings(): this=0x%08x.\n"),

		this));

	EAP_TRACE_RETURN_STRING(m_am_tools, "returns: eap_am_general_settings_symbian_c::CloseGeneralSettings()");

	iGeneralSettingsDb.Close();

	iGeneralSettingsDbCreated = EFalse;

	iGeneralSettingsFileServerSession.Close();

	iGeneralSettingsSessionOpened = EFalse;

}

// ----------------------------------------------------------------------

void eap_am_general_settings_symbian_c::OpenGeneralSettingsL()

{

	EAP_TRACE_DEBUG(

		m_am_tools,

		TRACE_FLAGS_DEFAULT,

		(EAPL("eap_am_general_settings_symbian_c::OpenGeneralSettingsL(): this=0x%08x.\n"),

		this));

	EAP_TRACE_RETURN_STRING(m_am_tools, "returns: eap_am_general_settings_symbian_c::OpenGeneralSettingsL()");

	if(iGeneralSettingsDbCreated == EFalse

		|| iGeneralSettingsSessionOpened == EFalse)

	{

		// The general settings store DB and tables are not created. So create it.

		CreateGeneralSettingsL();

	}

}

// ----------------------------------------------------------------------

void eap_am_general_settings_symbian_c::CreateGeneralSettingsL()

{

	EAP_TRACE_DEBUG(

		m_am_tools,

		TRACE_FLAGS_DEFAULT,

		(EAPL("eap_am_general_settings_symbian_c::CreateGeneralSettingsL(): this=0x%08x.\n"),

		this));

	EAP_TRACE_RETURN_STRING(m_am_tools, "returns: eap_am_general_settings_symbian_c::CreateGeneralSettingsL()");

	// - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

	// 1. Open/create a database

	TInt error(KErrNone);

	// Connect to the DBMS server, if not connected already.

	if(iGeneralSettingsSessionOpened == EFalse)

	{

		error = iGeneralSettingsFileServerSession.Connect();

		(void)EAP_STATUS_RETURN(m_am_tools, m_am_tools->convert_am_error_to_eapol_error(error));

		User::LeaveIfError(error);

		iGeneralSettingsSessionOpened = ETrue;

	}

	TFileName aPrivateDatabasePathName;

	EapPluginTools::CreateDatabaseLC(

		iGeneralSettingsDb,

		iGeneralSettingsFileServerSession,

		error,

		KGeneralsettingsDatabaseName,

		aPrivateDatabasePathName);

	EAP_TRACE_DEBUG(

		m_am_tools,

		TRACE_FLAGS_DEFAULT,

		(EAPL("eap_am_general_settings_symbian_c::CreateGeneralSettingsL() - Created Secure DB for %S. error=%d (-11=DB already exist)\n"),

		&KGeneralsettingsDatabaseName_8bit,

		error) );

	if(error == KErrNone)

	{

		// Database is closed if it was created in EapPluginTools::CreateDatabaseLC().

		// If database exists it was not opened in EapPluginTools::CreateDatabaseLC().

		iGeneralSettingsDb.Close();

	}

	else if (error != KErrAlreadyExists)

	{

		(void)EAP_STATUS_RETURN(m_am_tools, m_am_tools->convert_am_error_to_eapol_error(error));

		User::LeaveIfError(error);

	}

	error = iGeneralSettingsDb.Open(iGeneralSettingsFileServerSession, aPrivateDatabasePathName);

	EAP_TRACE_DEBUG(

		m_am_tools,

		TRACE_FLAGS_DEFAULT,

		(EAPL("eap_am_general_settings_symbian_c::CreateGeneralSettingsL() - Open Secure DB for %S. error=%d (-11=DB already exist)\n"),

		&KGeneralsettingsDatabaseName_8bit,

		error) );

	User::LeaveIfError(error);

	// - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

	// 2. Create the tables to database (ignore error if tables exist)

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

	TPtr sqlStatement = buf->Des();

	// Create table for enabled and disabled EAP-types.

	//// NAME //////////////////// TYPE ///////////// Constant ////////////////////

	//| ServiceType				| UNSIGNED INTEGER | KServiceType				|//

	//| ServiceIndex			| UNSIGNED INTEGER | KServiceIndex				|//

	//| Enabled EAP-methods		| LONG VARBINARY   | KEapMethodEnabledValue		|//

	//| Disabled EAP-methods	| LONG VARBINARY   | KEapMethodDisabledValue	|//

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

	_LIT(KSQLCreateTable2, "CREATE TABLE %S (%S UNSIGNED INTEGER, \

		%S UNSIGNED INTEGER, \

		%S LONG VARBINARY, \

		%S LONG VARBINARY)");

	sqlStatement.Format(

		KSQLCreateTable2,

		&KGeneralSettingsTableName,

		&KServiceType,

		&KServiceIndex,

		&KEapMethodEnabledValue,

		&KEapMethodDisabledValue);

	EAP_TRACE_DEBUG(

		m_am_tools,

		TRACE_FLAGS_DEFAULT,

		(EAPL("eap_am_general_settings_symbian_c::CreateGeneralSettingsL() - SQL query formated OK\n")));

	error = iGeneralSettingsDb.Execute(sqlStatement);

	if (error != KErrNone

		&& error != KErrAlreadyExists)

	{

		(void)EAP_STATUS_RETURN(m_am_tools, m_am_tools->convert_am_error_to_eapol_error(error));

		User::Leave(error);

	}

	EAP_TRACE_DEBUG(

		m_am_tools,

		TRACE_FLAGS_DEFAULT,

		(EAPL("eap_am_general_settings_symbian_c::CreateGeneralSettingsL() Created Groups table\n")));

	// - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

	CleanupStack::PopAndDestroy( buf );

	CleanupStack::Pop(&iGeneralSettingsDb);

	CleanupStack::Pop(&iGeneralSettingsFileServerSession);

	iGeneralSettingsDbCreated = ETrue;

	EAP_TRACE_DEBUG(

		m_am_tools,

		TRACE_FLAGS_DEFAULT,

		(EAPL("eap_am_general_settings_symbian_c::CreateGeneralSettingsL(): End \n")));	

} // eap_am_general_settings_symbian_c::CreateGeneralSettingsL()

// ----------------------------------------------------------------------

void eap_am_general_settings_symbian_c::GetGeneralSettingsLongBinaryL(

	RDbView &aViev,

	const TDesC &aColName,

	HBufC8** const aMethods)

{

	EAP_TRACE_DEBUG(

		m_am_tools,

		TRACE_FLAGS_DEFAULT,

		(EAPL("eap_am_general_settings_symbian_c::GetGeneralSettingsLongBinaryL(): this=0x%08x.\n"),

		this));

	EAP_TRACE_RETURN_STRING(m_am_tools, "returns: eap_am_general_settings_symbian_c::GetGeneralSettingsLongBinaryL()");

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

	CDbColSet* colSet = aViev.ColSetL();

	CleanupStack::PushL(colSet);

	TDbColNo colNoReference = 0;

	colNoReference = colSet->ColNo(aColName);

	switch (aViev.ColType(colNoReference))

	{

		case EDbColLongBinary:

		{

			EAP_TRACE_DATA_DEBUG(

				m_am_tools,

				TRACE_FLAGS_DEFAULT,

				(EAPL("eap_am_general_settings_symbian_c::GetGeneralSettingsLongBinaryL() - Long Binary column"),

				aColName.Ptr(),

				aColName.Size()));

			// A stream is needed for LONG columns in DB.

			RDbColReadStream readStream;

			// Get the value from DB.

			HBufC8* valueBuf = HBufC8::NewLC(aViev.ColLength(colNoReference)); // Buffer for the data.

			TPtr8 value8 = valueBuf->Des();

			readStream.OpenLC(aViev, colNoReference);

			readStream.ReadL(value8, aViev.ColLength(colNoReference));

			readStream.Close();

			CleanupStack::PopAndDestroy(&readStream);

			EAP_TRACE_DATA_DEBUG(

				m_am_tools,

				TRACE_FLAGS_DEFAULT,

				(EAPL("eap_am_general_settings_symbian_c::GetGeneralSettingsLongBinaryL(): LONG BINARY value from DB"),

				value8.Ptr(), 

				value8.Size()));

			*aMethods = HBufC8::New(value8.Size());

			// This to avoid the use of clean up stack for output parameter.

			if ((*aMethods) != 0)

			{

				TPtr8 aDbBinaryColumnValuePtr = (*aMethods)->Des();			

				aDbBinaryColumnValuePtr.Copy(value8);

				EAP_TRACE_DATA_DEBUG(

					m_am_tools,

					TRACE_FLAGS_DEFAULT,

					(EAPL("eap_am_general_settings_symbian_c::GetGeneralSettingsLongBinaryL(): LONG BINARY value to caller"),

					aDbBinaryColumnValuePtr.Ptr(), 

					aDbBinaryColumnValuePtr.Size()));

			}

			else

			{

				User::Leave(KErrNoMemory);

			}

			CleanupStack::PopAndDestroy(valueBuf);

			break;

		}

		default:

			EAP_TRACE_ERROR(

				m_am_tools,

				TRACE_FLAGS_ERROR,

				(EAPL("ERROR: eap_am_general_settings_symbian_c::GetGeneralSettingsLongBinaryL(): Unsupported DB field:%d = %S\n"),

				aViev.ColType(colNoReference),

				&aColName));	

			User::Leave(KErrNotSupported);

			break;

	} // End: switch ()

	CleanupStack::PopAndDestroy(colSet);

}

// ----------------------------------------------------------------------

void eap_am_general_settings_symbian_c::GetGeneralSettingsDataL(

	const TUint indexType,

	const TUint index,

	HBufC8** const aEnabledEapMethods,

	HBufC8** const aDisabledEapMethods)

{

	EAP_TRACE_DEBUG(

		m_am_tools,

		TRACE_FLAGS_DEFAULT,

		(EAPL("eap_am_general_settings_symbian_c::GetGeneralSettingsDataL(): iGeneralSettingsSessionOpened=%d, iGeneralSettingsDbCreated=%d"),

		iGeneralSettingsSessionOpened,

		iGeneralSettingsDbCreated));

	EAP_TRACE_RETURN_STRING(m_am_tools, "returns: eap_am_general_settings_symbian_c::GetGeneralSettingsDataL()");

	*aEnabledEapMethods = 0;

	*aDisabledEapMethods = 0;

	if(iGeneralSettingsSessionOpened == EFalse)

	{

		EAP_TRACE_ERROR(

			m_am_tools,

			TRACE_FLAGS_ERROR,

			(EAPL("eap_am_general_settings_symbian_c::GetGeneralSettingsDataL(): ERROR: General settings session not opened!")));

		User::Leave(KErrSessionClosed);

	}	

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

	TPtr sqlStatement = buf->Des();

	sqlStatement.Format(

		KSQL,

		&KServiceType,

		&KServiceIndex,

		&KEapMethodEnabledValue,

		&KEapMethodDisabledValue,

		&KGeneralSettingsTableName,

		&KServiceType,

		indexType,

		&KServiceIndex,

		index);

	RDbView view;

	User::LeaveIfError(view.Prepare(

		iGeneralSettingsDb, 

		TDbQuery(sqlStatement), 

		TDbWindow::EUnlimited,

		RDbView::EReadOnly));

	CleanupClosePushL(view);

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

	if (view.IsEmptyL())

	{				

		EAP_TRACE_DEBUG(

			m_am_tools,

			TRACE_FLAGS_DEFAULT,

			(EAPL("eap_am_general_settings_symbian_c::GetGeneralSettingsDataL(): No entries in this table (%S) RETURN EMPTY VALUE"),

			&KGeneralSettingsTableName_8bit));

		EAP_TRACE_DATA_DEBUG(

			m_am_tools,

			TRACE_FLAGS_DEFAULT,

			(EAPL("eap_am_general_settings_symbian_c::GetGeneralSettingsDataL():sqlStatement"),

			sqlStatement.Ptr(), 

			sqlStatement.Size()));

		CleanupStack::PopAndDestroy(&view);