MCL/sf/mw/accesssec: eapol/eapol_framework/eapol_symbian/am/type/mschapv2/symbian/plugin/src/EapMsChapV2DbUtils.cpp@bad0cc58d154 (annotated)

0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	1	/*
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	2	* Copyright (c) 2001-2006 Nokia Corporation and/or its subsidiary(-ies).
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	3	* All rights reserved.
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	4	* This component and the accompanying materials are made available
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	5	* under the terms of the License "Eclipse Public License v1.0"
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	6	* which accompanies this distribution, and is available
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	7	* at the URL "http://www.eclipse.org/legal/epl-v10.html".
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	8	*
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	9	* Initial Contributors:
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	10	* Nokia Corporation - initial contribution.
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	11	*
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	12	* Contributors:
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	13	*
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	14	* Description: EAP and WLAN authentication protocols.
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	15	*
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	16	*/
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	17
2 1c7bc153c08e Revision: 201001 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 0 diff changeset	18	/*
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	19	* %version: 56 %
2 1c7bc153c08e Revision: 201001 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 0 diff changeset	20	*/
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	21
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	22	// This is enumeration of EAPOL source code.
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	23	#if defined(USE_EAP_MINIMUM_RELEASE_TRACES)
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	24	#undef EAP_FILE_NUMBER_ENUM
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	25	#define EAP_FILE_NUMBER_ENUM 294
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	26	#undef EAP_FILE_NUMBER_DATE
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	27	#define EAP_FILE_NUMBER_DATE 1127594498
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	28	#endif //#if defined(USE_EAP_MINIMUM_RELEASE_TRACES)
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	29
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	30
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	31	// INCLUDE FILES
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	32
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	33	#include "EapMsChapV2DbUtils.h"
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	34	#include "EapMsChapV2DbDefaults.h"
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	35	#include "EapMsChapV2DbParameterNames.h"
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	36
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	37	#include <EapTraceSymbian.h>
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	38	#include "EapPluginTools.h"
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	39
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	40	const TUint KMaxSqlQueryLength = 512;
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	41	const TInt KMicroSecsInAMinute = 60000000; // 60000000 micro seconds is 1 minute.
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	42
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	43	// ================= MEMBER FUNCTIONS =======================
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	44
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	45	void EapMsChapV2DbUtils::OpenDatabaseL(
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	46	RDbNamedDatabase& aDatabase,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	47	RFs& aFileServerSession,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	48	const TIndexType aIndexType,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	49	const TInt aIndex,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	50	const eap_type_value_e aTunnelingType)
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	51	{
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	52	EAP_TRACE_DEBUG_SYMBIAN(
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	53	(_L("EapMsChapV2DbUtils::OpenDatabaseL(): - Start - aIndexType=%d, aIndex=%d, aTunnelingType=0xfe%06x%08x\n"),
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	54	aIndexType,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	55	aIndex,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	56	aTunnelingType.get_vendor_id(),
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	57	aTunnelingType.get_vendor_type()));
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	58
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	59	EAP_TRACE_RETURN_STRING_SYMBIAN(_L("returns: EapMsChapV2DbUtils::OpenDatabaseL()\n"));
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	60
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	61	// 1. Open/create a database
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	62
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	63	TInt error(KErrNone);
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	64	TFileName aPrivateDatabasePathName;
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	65
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	66	EapPluginTools::CreateDatabaseLC(
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	67	aDatabase,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	68	aFileServerSession,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	69	error,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	70	KEapMsChapV2DatabaseName,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	71	aPrivateDatabasePathName);
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	72
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	73	if(error == KErrNone)
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	74	{
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	75	aDatabase.Close();
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	76	}
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	77	else if (error != KErrAlreadyExists)
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	78	{
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	79	User::LeaveIfError(error);
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	80	}
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	81
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	82	EAP_TRACE_DEBUG_SYMBIAN((_L("EapMsChapV2DbUtils::OpenDatabaseL(): - calls aDatabase.Open()\n")));
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	83
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	84	error = aDatabase.Open(aFileServerSession, aPrivateDatabasePathName);
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	85
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	86	EAP_TRACE_DEBUG_SYMBIAN((_L("EapMsChapV2DbUtils::OpenDatabaseL(): - Opened private DB for EAP-MsChapV2. error=%d\n"), error));
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	87
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	88	User::LeaveIfError(error);
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	89
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	90	// 2. Create the MSCHAPv2 table to database (ignore error if database exists)
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	91	// Table columns:
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	92	//// NAME ///////////////////////////////////////////////// TYPE ////////////// Constant /////////
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	93	//\| ServiceType \| UNSIGNED INTEGER \| KServiceType \|//
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	94	//\| ServiceIndex \| UNSIGNED INTEGER \| KServiceIndex \|//
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	95	//\| TunnelingTypeVendorId \| UNSIGNED INTEGER \| KTunnelingTypeVendorId \|//
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	96	//\| TunnelingType \| UNSIGNED INTEGER \| KTunnelingType \|//
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	97	//\| EAP_MSCHAPV2_password_prompt \| UNSIGNED INTEGER \| cf_str_EAP_MSCHAPV2_password_prompt_literal \|//
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	98	//\| EAP_MSCHAPV2_username \| VARCHAR(255) \| cf_str_EAP_MSCHAPV2_username_literal \|//
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	99	//\| EAP_MSCHAPV2_password \| VARCHAR(255) \| cf_str_EAP_MSCHAPV2_password_literal \|//
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	100	//\| EAP_MSCHAPv2_max_session_validity_time \| BIGINT \| cf_str_EAP_MSCHAPv2_max_session_validity_time_literal \|//
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	101	//\| EAP_MSCHAPv2_last_full_authentication_time \| BIGINT \| KMSCHAPv2LastFullAuthTime \|//
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	102	//////////////////////////////////////////////////////////////////////////////////////////////////
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	103
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	104	EAP_TRACE_DEBUG_SYMBIAN((_L("EapMsChapV2DbUtils::OpenDatabaseL(): calls HBufC::NewLC()\n")));
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	105
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	106	HBufC* buf = HBufC::NewLC(KMaxSqlQueryLength);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	107	TPtr sqlStatement = buf->Des();
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	108
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	109	_LIT(KSQLCreateTable1, "CREATE TABLE %S \
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	110	(%S UNSIGNED INTEGER, \
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	111	%S UNSIGNED INTEGER, \
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	112	%S UNSIGNED INTEGER, \
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	113	%S UNSIGNED INTEGER, \
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	114	%S UNSIGNED INTEGER, \
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	115	%S VARCHAR(255), \
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	116	%S VARCHAR(255), \
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	117	%S BIGINT, \
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	118	%S BIGINT)");
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	119
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	120	EAP_TRACE_DEBUG_SYMBIAN((_L("EapMsChapV2DbUtils::OpenDatabaseL(): calls sqlStatement.Format()\n")));
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	121
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	122	sqlStatement.Format(KSQLCreateTable1,
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	123	&KMsChapV2TableName,
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	124	&KServiceType,
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	125	&KServiceIndex,
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	126	&KTunnelingTypeVendorId,
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	127	&KTunnelingType,
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	128	&cf_str_EAP_MSCHAPV2_password_prompt_literal,
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	129	&cf_str_EAP_MSCHAPV2_username_literal,
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	130	&cf_str_EAP_MSCHAPV2_password_literal,
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	131	&cf_str_EAP_MSCHAPv2_max_session_validity_time_literal,
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	132	&KMSCHAPv2LastFullAuthTime);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	133
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	134	EAP_TRACE_DEBUG_SYMBIAN((_L("EapMsChapV2DbUtils::OpenDatabaseL(): calls aDatabase.Execute()\n")));
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	135
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	136	error = aDatabase.Execute(sqlStatement);
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	137	if (error != KErrNone && error != KErrAlreadyExists)
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	138	{
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	139	EAP_TRACE_DEBUG_SYMBIAN((_L("ERROR: EapMsChapV2DbUtils::OpenDatabaseL(): aDatabase.Execute() error=%d\n"),
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	140	error));
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	141
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	142	User::Leave(error);
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	143	}
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	144
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	145	// 4. Check if database table contains a row for this service type and id
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	146
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	147	EAP_TRACE_DEBUG_SYMBIAN((_L("EapMsChapV2DbUtils::OpenDatabaseL(): calls sqlStatement.Format()\n")));
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	148
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	149	_LIT(KSQLQueryRow, "SELECT %S FROM %S WHERE %S=%d AND %S=%d AND %S=%d AND %S=%d");
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	150	sqlStatement.Format(KSQLQueryRow,
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	151	&cf_str_EAP_MSCHAPV2_username_literal,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	152	&KMsChapV2TableName,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	153	&KServiceType,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	154	aIndexType,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	155	&KServiceIndex,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	156	aIndex,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	157	&KTunnelingTypeVendorId,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	158	aTunnelingType.get_vendor_id(),
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	159	&KTunnelingType,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	160	aTunnelingType.get_vendor_type());
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	161
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	162	RDbView view;
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	163
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	164	EAP_TRACE_DEBUG_SYMBIAN((_L("EapMsChapV2DbUtils::OpenDatabaseL(): calls view.Prepare()\n")));
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	165
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	166	error = view.Prepare(aDatabase, TDbQuery(sqlStatement), TDbWindow::EUnlimited);
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	167
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	168	EAP_TRACE_DEBUG_SYMBIAN((_L("EapMsChapV2DbUtils::OpenDatabaseL(): view.Prepare() error=%d\n"),
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	169	error));
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	170
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	171	User::LeaveIfError(error);
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	172	// View must be closed when no longer needed
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	173	CleanupClosePushL(view);
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	174
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	175	EAP_TRACE_DEBUG_SYMBIAN((_L("EapMsChapV2DbUtils::OpenDatabaseL(): calls view.EvaluateAll()\n")));
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	176
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	177	error = view.EvaluateAll();
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	178
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	179	EAP_TRACE_DEBUG_SYMBIAN((_L("EapMsChapV2DbUtils::OpenDatabaseL(): view.EvaluateAll() error=%d\n"),
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	180	error));
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	181
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	182	User::LeaveIfError(error);
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	183
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	184	// 5. If row is not found then add it
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	185
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	186	EAP_TRACE_DEBUG_SYMBIAN((_L("EapMsChapV2DbUtils::OpenDatabaseL(): calls view.CountL()\n")));
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	187
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	188	TInt rows = view.CountL();
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	189
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	190	EAP_TRACE_DEBUG_SYMBIAN((_L("EapMsChapV2DbUtils::OpenDatabaseL(): view.CountL() rows=%d\n"),
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	191	rows));
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	192
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	193	CleanupStack::PopAndDestroy(&view);
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	194	if (rows == 0)
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	195	{
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	196	_LIT(KSQLInsert, "SELECT * FROM %S");
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	197	sqlStatement.Format(KSQLInsert, &KMsChapV2TableName);
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	198
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	199	EAP_TRACE_DEBUG_SYMBIAN((_L("EapMsChapV2DbUtils::OpenDatabaseL(): calls view.Prepare()\n")));
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	200
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	201	error = view.Prepare(aDatabase, TDbQuery(sqlStatement), TDbWindow::EUnlimited, RDbView::EInsertOnly);
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	202
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	203	EAP_TRACE_DEBUG_SYMBIAN((_L("EapMsChapV2DbUtils::OpenDatabaseL(): view.Prepare() error=%d\n"),
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	204	error));
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	205
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	206	User::LeaveIfError(error);
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	207	CleanupClosePushL(view);
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	208
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	209	// Get column set so we get the correct column numbers
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	210	EAP_TRACE_DEBUG_SYMBIAN((_L("EapMsChapV2DbUtils::OpenDatabaseL(): calls view.ColSetL()\n")));
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	211
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	212	CDbColSet* colSet = view.ColSetL();
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	213	CleanupStack::PushL(colSet);
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	214
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	215	EAP_TRACE_DEBUG_SYMBIAN((_L("EapMsChapV2DbUtils::OpenDatabaseL(): calls view.InsertL()\n")));
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	216
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	217	view.InsertL();
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	218	view.SetColL(colSet->ColNo(KServiceType), static_cast<TInt> (aIndexType));
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	219	view.SetColL(colSet->ColNo(KServiceIndex), aIndex);
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	220	view.SetColL(colSet->ColNo(KTunnelingTypeVendorId), aTunnelingType.get_vendor_id());
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	221	view.SetColL(colSet->ColNo(KTunnelingType), aTunnelingType.get_vendor_type());
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	222
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	223	view.SetColL(colSet->ColNo(cf_str_EAP_MSCHAPV2_password_prompt_literal), default_EAP_password_prompt);
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	224
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	225	view.SetColL(colSet->ColNo(cf_str_EAP_MSCHAPV2_username_literal), default_EAP_username);
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	226
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	227	view.SetColL(colSet->ColNo(cf_str_EAP_MSCHAPV2_password_literal), default_EAP_password);
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	228
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	229	view.SetColL(colSet->ColNo(cf_str_EAP_MSCHAPv2_max_session_validity_time_literal), default_MaxSessionTime);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	230
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	231	view.SetColL(colSet->ColNo(KMSCHAPv2LastFullAuthTime), default_FullAuthTime);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	232
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	233	view.PutL();
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	234
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	235	CleanupStack::PopAndDestroy(colSet);
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	236	CleanupStack::PopAndDestroy(&view);
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	237	}
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	238
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	239	aDatabase.Compact();
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	240
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	241	CleanupStack::PopAndDestroy( buf );
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	242	CleanupStack::Pop( &aDatabase );
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	243	CleanupStack::Pop( &aFileServerSession );
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	244	}
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	245
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	246
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	247	void EapMsChapV2DbUtils::SetIndexL(
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	248	RDbNamedDatabase& aDatabase,
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	249	const TIndexType aIndexType,
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	250	const TInt aIndex,
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	251	const eap_type_value_e aTunnelingType,
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	252	const TIndexType aNewIndexType,
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	253	const TInt aNewIndex,
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	254	const eap_type_value_e aNewTunnelingType)
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	255	{
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	256	EAP_TRACE_DEBUG_SYMBIAN(
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	257	(_L("EapMsChapV2DbUtils::SetIndexL(): -Start- aIndexType=%d, aIndex=%d, aTunnelingType=0xfe%06x%08x\n"),
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	258	aIndexType,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	259	aIndex,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	260	aTunnelingType.get_vendor_id(),
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	261	aTunnelingType.get_vendor_type()));
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	262
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	263	EAP_TRACE_DEBUG_SYMBIAN(
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	264	(_L("EapMsChapV2DbUtils::SetIndexL(): -Start- aNewIndexType=%d, aNewIndex=%d, aNewTunnelingType=0xfe%06x%08x\n"),
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	265	aNewIndexType,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	266	aNewIndex,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	267	aNewTunnelingType.get_vendor_id(),
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	268	aNewTunnelingType.get_vendor_type()));
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	269
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	270	EAP_TRACE_RETURN_STRING_SYMBIAN(_L("returns: EapMsChapV2DbUtils::SetIndexL()\n"));
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	271
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	272	HBufC* buf = HBufC::NewLC(KMaxSqlQueryLength);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	273	TPtr sqlStatement = buf->Des();
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	274
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	275	_LIT(KSQL, "SELECT * FROM %S WHERE %S=%d AND %S=%d AND %S=%d AND %S=%d");
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	276
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	277	sqlStatement.Format(KSQL,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	278	&KMsChapV2TableName,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	279	&KServiceType,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	280	aIndexType,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	281	&KServiceIndex,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	282	aIndex,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	283	&KTunnelingTypeVendorId,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	284	aTunnelingType.get_vendor_id(),
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	285	&KTunnelingType,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	286	aTunnelingType.get_vendor_type());
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	287
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	288	RDbView view;
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	289
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	290	User::LeaveIfError(view.Prepare(aDatabase, TDbQuery(sqlStatement), TDbWindow::EUnlimited));
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	291
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	292	// View must be closed when no longer needed
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	293	CleanupClosePushL(view);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	294
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	295	User::LeaveIfError(view.EvaluateAll());
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	296
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	297	TInt rows = view.CountL();
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	298
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	299	if (rows == 0)
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	300	{
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	301	User::Leave(KErrNotFound);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	302	}
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	303
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	304	// Get the first (and only) row
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	305	view.FirstL();
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	306	view.GetL();
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	307
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	308	// Get column set so we get the correct column numbers
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	309	CDbColSet* colSet = view.ColSetL();
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	310
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	311	CleanupStack::PushL(colSet);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	312
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	313	view.UpdateL();
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	314
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	315	view.SetColL(colSet->ColNo(KServiceType), static_cast<TUint>(aNewIndexType));
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	316	view.SetColL(colSet->ColNo(KServiceIndex), aNewIndex);
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	317	view.SetColL(colSet->ColNo(KTunnelingTypeVendorId), aNewTunnelingType.get_vendor_id());
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	318	view.SetColL(colSet->ColNo(KTunnelingType), aNewTunnelingType.get_vendor_type());
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	319
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	320	view.PutL();
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	321
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	322	CleanupStack::PopAndDestroy(colSet);
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	323	CleanupStack::PopAndDestroy(&view);
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	324	CleanupStack::PopAndDestroy(buf);
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	325	}
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	326
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	327	void EapMsChapV2DbUtils::SetConfigurationL(
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	328	RDbNamedDatabase& aDatabase,
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	329	const EAPSettings& aSettings,
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	330	const TIndexType aIndexType,
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	331	const TInt aIndex,
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	332	const eap_type_value_e aTunnelingType)
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	333	{
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	334	EAP_TRACE_DEBUG_SYMBIAN(
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	335	(_L("EapMsChapV2DbUtils::SetConfigurationL(): -Start- aIndexType=%d, aIndex=%d, aTunnelingType=0xfe%06x%08x\n"),
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	336	aIndexType,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	337	aIndex,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	338	aTunnelingType.get_vendor_id(),
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	339	aTunnelingType.get_vendor_type()));
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	340
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	341	EAP_TRACE_RETURN_STRING_SYMBIAN(_L("returns: EapMsChapV2DbUtils::SetConfigurationL()\n"));
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	342
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	343	EAP_TRACE_SETTINGS(&aSettings);
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	344
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	345	// Check if the settings are for the correct type
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	346	if (aSettings.iEAPExpandedType != (*EapExpandedTypeMsChapv2.GetType())
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	347	&& aSettings.iEAPExpandedType != (*EapExpandedPlainMsChapv2.GetType()))
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	348	{
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	349	User::Leave(KErrNotSupported);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	350	}
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	351
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	352	HBufC* buf = HBufC::NewLC(KMaxSqlQueryLength);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	353	TPtr sqlStatement = buf->Des();
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	354
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	355	RDbView view;
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	356
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	357	_LIT(KSQLQuery, "SELECT * FROM %S WHERE %S=%d AND %S=%d AND %S=%d AND %S=%d");
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	358
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	359	sqlStatement.Format(KSQLQuery,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	360	&KMsChapV2TableName,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	361	&KServiceType,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	362	aIndexType,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	363	&KServiceIndex,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	364	aIndex,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	365	&KTunnelingTypeVendorId,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	366	aTunnelingType.get_vendor_id(),
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	367	&KTunnelingType,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	368	aTunnelingType.get_vendor_type());
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	369
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	370	// Evaluate view
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	371	User::LeaveIfError(view.Prepare(aDatabase, TDbQuery(sqlStatement)));
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	372
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	373	CleanupClosePushL(view);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	374
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	375	User::LeaveIfError(view.EvaluateAll());
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	376
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	377	view.FirstL();
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	378
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	379	view.UpdateL();
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	380
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	381	// Get column set so we get the correct column numbers
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	382	CDbColSet* colSet = view.ColSetL();
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	383	CleanupStack::PushL(colSet);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	384
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	385	// Username
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	386	if (aSettings.iUsernamePresent)
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	387	{
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	388	// Validate length.
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	389	if(aSettings.iUsername.Length() > KMaxUsernameLengthInDB)
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	390	{
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	391	// Username too long. Can not be stored in DB.
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	392
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	393	EAP_TRACE_DEBUG_SYMBIAN((_L("ERROR: EapMsChapV2DbUtils::SetConfigurationL(): Too long Username. Length=%d \n"),
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	394	aSettings.iUsername.Length()));
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	395
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	396	User::Leave(KErrArgument);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	397	}
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	398
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	399	// Length is ok. Set the value in DB.
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	400	view.SetColL(colSet->ColNo(cf_str_EAP_MSCHAPV2_username_literal), aSettings.iUsername);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	401	}
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	402
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	403	// Password existence.
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	404	if (aSettings.iPasswordExistPresent
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	405	&& !aSettings.iPasswordExist)
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	406	{
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	407	// Clear password from database.
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	408	view.SetColL(colSet->ColNo(cf_str_EAP_MSCHAPV2_password_literal), KNullPasswordData);
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	409	view.SetColNullL(colSet->ColNo(cf_str_EAP_MSCHAPV2_password_literal));
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	410	}
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	411
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	412	// Password
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	413	if (aSettings.iPasswordPresent)
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	414	{
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	415	// Validate length.
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	416	if(aSettings.iPassword.Length() > KMaxPasswordLengthInDB)
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	417	{
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	418	// Password too long. Can not be stored in DB.
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	419
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	420	EAP_TRACE_DEBUG_SYMBIAN((_L("ERROR: EapMsChapV2DbUtils::SetConfigurationL(): Too long Password. Length=%d \n"),
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	421	aSettings.iPassword.Length()));
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	422
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	423	User::Leave(KErrArgument);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	424	}
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	425
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	426	// Length is ok. Set the value in DB.
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	427	view.SetColL(colSet->ColNo(cf_str_EAP_MSCHAPV2_password_literal), aSettings.iPassword);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	428
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	429	}
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	430
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	431	if (aSettings.iShowPassWordPromptPresent)
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	432	{
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	433	// If password was supplied set password prompting off
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	434	if (aSettings.iShowPassWordPrompt == EFalse)
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	435	{
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	436	view.SetColL(colSet->ColNo(cf_str_EAP_MSCHAPV2_password_prompt_literal), EEapDbFalse );
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	437	}
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	438	else
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	439	{
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	440	view.SetColL(colSet->ColNo(cf_str_EAP_MSCHAPV2_password_prompt_literal), EEapDbTrue );
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	441	}
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	442	}
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	443
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	444	// Session validity time
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	445	if (aSettings.iSessionValidityTimePresent)
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	446	{
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	447	// User or device management wants to store the session validity time.
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	448	// Convert the time to micro seconds and save.
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	449
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	450	TInt64 validityInMicro = (aSettings.iSessionValidityTime) * KMicroSecsInAMinute;
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	451
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	452	view.SetColL(colSet->ColNo(cf_str_EAP_MSCHAPv2_max_session_validity_time_literal), validityInMicro);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	453
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	454	// If max session validity time is supplied and non-zero, set password prompting ON.
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	455	// It doesn't matter even if the password is supplied. If max session validity is supplied,
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	456	// it means user needs to provide a password hence prompt should appear.
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	457
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	458	if( validityInMicro != 0)
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	459	{
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	460	view.SetColL(colSet->ColNo(cf_str_EAP_MSCHAPV2_password_prompt_literal), EEapDbTrue);
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	461	}
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	462	}
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	463
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	464	// Last full authentication time should be made zero when EAP configurations are modified.
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	465	// This makes sure that the next authentication with this EAP would be full authentication
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	466	// instead of reauthentication even if the session is still valid.
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	467
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	468	view.SetColL(colSet->ColNo(KMSCHAPv2LastFullAuthTime), default_FullAuthTime);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	469
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	470	EAP_TRACE_DEBUG_SYMBIAN((_L("EapMsChapV2DbUtils::SetConfigurationL(): Session Validity: Resetting Full Auth Time since settings are modified\n")));
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	471
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	472	view.PutL();
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	473
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	474	CleanupStack::PopAndDestroy(colSet);
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	475	CleanupStack::PopAndDestroy(&view);
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	476	CleanupStack::PopAndDestroy(buf);
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	477	}
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	478
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	479	void EapMsChapV2DbUtils::GetConfigurationL(
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	480	RDbNamedDatabase& aDatabase,
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	481	EAPSettings& aSettings,
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	482	const TIndexType aIndexType,
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	483	const TInt aIndex,
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	484	const eap_type_value_e aTunnelingType)
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	485	{
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	486	EAP_TRACE_DEBUG_SYMBIAN(
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	487	(_L("EapMsChapV2DbUtils::GetConfigurationL(): -Start- aIndexType=%d, aIndex=%d, aTunnelingType=0xfe%06x%08x\n"),
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	488	aIndexType,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	489	aIndex,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	490	aTunnelingType.get_vendor_id(),
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	491	aTunnelingType.get_vendor_type()));
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	492
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	493	EAP_TRACE_RETURN_STRING_SYMBIAN(_L("returns: EapMsChapV2DbUtils::GetConfigurationL()\n"));
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	494
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	495	HBufC* buf = HBufC::NewLC(KMaxSqlQueryLength);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	496	TPtr sqlStatement = buf->Des();
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	497
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	498	RDbView view;
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	499
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	500	// Form the query
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	501	_LIT(KSQLQuery, "SELECT * FROM %S WHERE %S=%d AND %S=%d AND %S=%d AND %S=%d");
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	502
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	503	sqlStatement.Format(KSQLQuery,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	504	&KMsChapV2TableName,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	505	&KServiceType,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	506	aIndexType,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	507	&KServiceIndex,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	508	aIndex,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	509	&KTunnelingTypeVendorId,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	510	aTunnelingType.get_vendor_id(),
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	511	&KTunnelingType,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	512	aTunnelingType.get_vendor_type());
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	513
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	514	// Evaluate view
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	515	User::LeaveIfError(view.Prepare(aDatabase, TDbQuery(sqlStatement)));
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	516
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	517	CleanupClosePushL(view);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	518
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	519	User::LeaveIfError(view.EvaluateAll());
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	520
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	521	// Get the first (and only) row
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	522	view.FirstL();
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	523	view.GetL();
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	524
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	525	// Get column set so we get the correct column numbers
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	526	CDbColSet* colSet = view.ColSetL();
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	527	CleanupStack::PushL(colSet);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	528
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	529	aSettings.iEAPExpandedType = *EapExpandedTypeMsChapv2.GetType();
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	530
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	531	// Username
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	532	TPtrC username = view.ColDes(colSet->ColNo(cf_str_EAP_MSCHAPV2_username_literal));
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	533	aSettings.iUsername.Copy(username);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	534	aSettings.iUsernamePresent = ETrue;
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	535
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	536	// Password existence.
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	537	aSettings.iPasswordExistPresent = ETrue;
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	538	aSettings.iPasswordExist = ! view.IsColNull(colSet->ColNo(cf_str_EAP_MSCHAPV2_password_literal));
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	539
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	540	#if defined(USE_EAP_PASSWORD_READ_FROM_DATABASE)
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	541	// Password
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	542	TPtrC password = view.ColDes(colSet->ColNo(cf_str_EAP_MSCHAPV2_password_literal));
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	543	aSettings.iPassword.Copy(password);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	544	aSettings.iPasswordPresent = ETrue;
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	545	#else
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	546	EAP_TRACE_DEBUG_SYMBIAN((_L("WARNING: EapMsChapV2DbUtils::GetConfigurationL(): Password read is disabled\n")));
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	547	#endif //#if defined(USE_EAP_PASSWORD_READ_FROM_DATABASE)
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	548
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	549	aSettings.iShowPassWordPromptPresent = ETrue;
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	550
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	551	TUint aShow = view.ColUint(colSet->ColNo(cf_str_EAP_MSCHAPV2_password_prompt_literal));
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	552	if(aShow == EEapDbFalse)
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	553	{
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	554	aSettings.iShowPassWordPrompt = EFalse;
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	555	}
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	556	else
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	557	{
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	558	aSettings.iShowPassWordPrompt = ETrue;
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	559	}
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	560
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	561	// Session validity time
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	562	TInt64 maxSessionTimeMicro = view.ColInt64(colSet->ColNo(cf_str_EAP_MSCHAPv2_max_session_validity_time_literal));
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	563
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	564	// Convert the time to minutes.
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	565	TInt64 maxSessionTimeMin = maxSessionTimeMicro / KMicroSecsInAMinute;
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	566
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	567	aSettings.iSessionValidityTime = static_cast<TUint>(maxSessionTimeMin);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	568	aSettings.iSessionValidityTimePresent = ETrue;
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	569
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	570	CleanupStack::PopAndDestroy(colSet);
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	571	CleanupStack::PopAndDestroy(&view);
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	572	CleanupStack::PopAndDestroy(buf);
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	573
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	574	EAP_TRACE_SETTINGS(&aSettings);
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	575	}
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	576
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	577	void EapMsChapV2DbUtils::CopySettingsL(
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	578	RDbNamedDatabase& aDatabase,
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	579	const TIndexType aSrcIndexType,
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	580	const TInt aSrcIndex,
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	581	const eap_type_value_e aSrcTunnelingType,
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	582	const TIndexType aDestIndexType,
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	583	const TInt aDestIndex,
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	584	const eap_type_value_e aDestTunnelingType)
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	585	{
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	586	EAP_TRACE_DEBUG_SYMBIAN(
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	587	(_L("EapMsChapV2DbUtils::CopySettingsL(): -Start- aSrcIndexType=%d, aSrcIndex=%d, aSrcTunnelingType=0xfe%06x%08x\n"),
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	588	aSrcIndexType,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	589	aSrcIndex,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	590	aSrcTunnelingType.get_vendor_id(),
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	591	aSrcTunnelingType.get_vendor_type()));
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	592
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	593	EAP_TRACE_DEBUG_SYMBIAN(
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	594	(_L("EapMsChapV2DbUtils::CopySettingsL(): -Start- aDestIndexType=%d, aDestTunnelingType=0xfe%06x%08x\n"),
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	595	aDestIndexType,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	596	aDestIndex,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	597	aDestTunnelingType.get_vendor_id(),
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	598	aDestTunnelingType.get_vendor_type()));
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	599
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	600	EAP_TRACE_RETURN_STRING_SYMBIAN(_L("returns: EapMsChapV2DbUtils::CopySettingsL()\n"));
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	601
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	602	HBufC* buf = HBufC::NewLC(KMaxSqlQueryLength);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	603	TPtr sqlStatement = buf->Des();
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	604
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	605	_LIT(KSQL, "SELECT * FROM %S WHERE %S=%d AND %S=%d AND %S=%d AND %S=%d");
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	606
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	607	sqlStatement.Format(KSQL,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	608	&KMsChapV2TableName,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	609	&KServiceType,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	610	aSrcIndexType,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	611	&KServiceIndex,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	612	aSrcIndex,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	613	&KTunnelingTypeVendorId,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	614	aSrcTunnelingType.get_vendor_id(),
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	615	&KTunnelingType,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	616	aSrcTunnelingType.get_vendor_type());
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	617
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	618	RDbView view;
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	619
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	620	User::LeaveIfError(view.Prepare(aDatabase, TDbQuery(sqlStatement), TDbWindow::EUnlimited));
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	621
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	622	// View must be closed when no longer needed
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	623	CleanupClosePushL(view);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	624
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	625	User::LeaveIfError(view.EvaluateAll());
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	626
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	627	TInt rows = view.CountL();
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	628
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	629	if (rows == 0)
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	630	{
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	631	User::Leave(KErrNotFound);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	632	}
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	633
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	634	// Get the first (and only) row
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	635	view.FirstL();
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	636
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	637	view.GetL();
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	638
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	639	view.InsertCopyL();
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	640
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	641	// Get column set so we get the correct column numbers
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	642	CDbColSet* colSet = view.ColSetL();
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	643
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	644	CleanupStack::PushL(colSet);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	645
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	646	view.SetColL(colSet->ColNo(KServiceType), static_cast<TUint>(aDestIndexType));
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	647	view.SetColL(colSet->ColNo(KServiceIndex), aDestIndex);
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	648	view.SetColL(colSet->ColNo(KTunnelingTypeVendorId), aDestTunnelingType.get_vendor_id());
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	649	view.SetColL(colSet->ColNo(KTunnelingType), aDestTunnelingType.get_vendor_type());
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	650
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	651	view.PutL();
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	652
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	653	CleanupStack::PopAndDestroy(colSet);
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	654	CleanupStack::PopAndDestroy(&view);
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	655	CleanupStack::PopAndDestroy(buf);
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	656	}
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	657
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	658	void EapMsChapV2DbUtils::DeleteConfigurationL(
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	659	const TIndexType aIndexType,
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	660	const TInt aIndex,
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	661	const eap_type_value_e aTunnelingType)
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	662	{
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	663	EAP_TRACE_DEBUG_SYMBIAN(
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	664	(_L("EapMsChapV2DbUtils::DeleteConfigurationL(): -Start- aIndexType=%d, aIndex=%d, aTunnelingType=0xfe%06x%08x\n"),
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	665	aIndexType,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	666	aIndex,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	667	aTunnelingType.get_vendor_id(),
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	668	aTunnelingType.get_vendor_type()));
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	669
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	670	EAP_TRACE_RETURN_STRING_SYMBIAN(_L("returns: EapMsChapV2DbUtils::DeleteConfigurationL()\n"));
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	671
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	672	RDbNamedDatabase aDatabase;
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	673	RFs aFileServerSession;
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	674
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	675	TInt error(KErrNone);
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	676	TFileName aPrivateDatabasePathName;
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	677
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	678	error = aFileServerSession.Connect();
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	679	EAP_TRACE_DEBUG_SYMBIAN((_L("EapMsChapV2DbUtils::DeleteConfigurationL(): - aFileServerSession.Connect(), error=%d\n"), error));
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	680	User::LeaveIfError(error);
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	681
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	682	EapPluginTools::CreateDatabaseLC(
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	683	aDatabase,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	684	aFileServerSession,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	685	error,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	686	KEapMsChapV2DatabaseName,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	687	aPrivateDatabasePathName);
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	688
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	689	if(error == KErrNone)
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	690	{
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	691	// Database was created so it was empty. No need for further actions.
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	692	aDatabase.Destroy();
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	693	CleanupStack::PopAndDestroy(&aDatabase);
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	694	CleanupStack::PopAndDestroy(&aFileServerSession);
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	695	return;
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	696	}
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	697	else if (error != KErrAlreadyExists)
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	698	{
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	699	User::LeaveIfError(error);
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	700	}
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	701
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	702	EAP_TRACE_DEBUG_SYMBIAN((_L("EapMsChapV2DbUtils::DeleteConfigurationL(): - calls aDatabase.Open()\n")));
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	703
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	704	error = aDatabase.Open(aFileServerSession, aPrivateDatabasePathName);
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	705
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	706	EAP_TRACE_DEBUG_SYMBIAN((_L("EapMsChapV2DbUtils::DeleteConfigurationL(): - Opened private DB for EAP-MsChapV2. error=%d\n"), error));
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	707
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	708	User::LeaveIfError(error);
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	709
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	710	HBufC* buf = HBufC::NewLC(KMaxSqlQueryLength);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	711	TPtr sqlStatement = buf->Des();
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	712
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	713	// Main settings table
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	714	_LIT(KSQL, "SELECT * FROM %S WHERE %S=%d AND %S=%d AND %S=%d AND %S=%d");
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	715
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	716	sqlStatement.Format(KSQL,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	717	&KMsChapV2TableName,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	718	&KServiceType,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	719	aIndexType,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	720	&KServiceIndex,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	721	aIndex,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	722	&KTunnelingTypeVendorId,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	723	aTunnelingType.get_vendor_id(),
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	724	&KTunnelingType,
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	725	aTunnelingType.get_vendor_type());
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	726
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	727	// Evaluate view
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	728	RDbView view;
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	729	User::LeaveIfError(view.Prepare(aDatabase,TDbQuery(sqlStatement), TDbWindow::EUnlimited));
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	730	CleanupClosePushL(view);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	731	User::LeaveIfError(view.EvaluateAll());
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	732
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	733	// Delete rows
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	734	if (view.FirstL())
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	735	{
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	736	do {
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	737	view.DeleteL();
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	738	} while (view.NextL() != EFalse);
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	739	}
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	740
18 bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	741	CleanupStack::PopAndDestroy(&view);
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	742	CleanupStack::PopAndDestroy(buf);
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	743	CleanupStack::PopAndDestroy(&aDatabase);
bad0cc58d154 Revision: 201029 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: 2 diff changeset	744	CleanupStack::PopAndDestroy(&aFileServerSession);
0 c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	745	}
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	746
c8830336c852 Revision: 200949 Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com> parents: diff changeset	747	// End of File

author	Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
	Tue, 31 Aug 2010 15:16:37 +0300
branch	RCL_3
changeset 18	bad0cc58d154
parent 2	1c7bc153c08e
child 19	c74b3d9f6b9e
permissions	-rw-r--r--