diff -r bad0cc58d154 -r c74b3d9f6b9e eapol/eapol_framework/eapol_symbian/am/type/aka/symbian/plugin/src/EapAkaUiDataConnection.cpp
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/eapol/eapol_framework/eapol_symbian/am/type/aka/symbian/plugin/src/EapAkaUiDataConnection.cpp	Wed Sep 01 12:23:57 2010 +0100
@@ -0,0 +1,276 @@
+/*
+* Copyright (c) 2001-2006 Nokia Corporation and/or its subsidiary(-ies).
+* All rights reserved.
+* This component and the accompanying materials are made available
+* under the terms of the License "Eclipse Public License v1.0"
+* which accompanies this distribution, and is available
+* at the URL "http://www.eclipse.org/legal/epl-v10.html".
+*
+* Initial Contributors:
+* Nokia Corporation - initial contribution.
+*
+* Contributors:
+*
+* Description:  EAP and WLAN authentication protocols.
+*
+*/
+
+/*
+* %version: 15.1.3.1.2 %
+*/
+
+// This is enumeration of EAPOL source code.
+#if defined(USE_EAP_MINIMUM_RELEASE_TRACES)
+	#undef EAP_FILE_NUMBER_ENUM
+	#define EAP_FILE_NUMBER_ENUM 184 
+	#undef EAP_FILE_NUMBER_DATE 
+	#define EAP_FILE_NUMBER_DATE 1127594498 
+#endif //#if defined(USE_EAP_MINIMUM_RELEASE_TRACES)
+
+#include <e32base.h>
+#include "EapAkaDbUtils.h"
+#include "EapAkaDbParameterNames.h"
+#include "EapAkaDbDefaults.h"
+#include <EapAkaUiConnection.h>
+#include <EapAkaUiDataConnection.h>
+#include <EapAkaUiAkaData.h>
+#include "eap_am_trace_symbian.h"
+
+const TUint KMaxSqlQueryLength = 256;
+
+CEapAkaUiDataConnection::CEapAkaUiDataConnection(CEapAkaUiConnection * aUiConn)
+: iIsOpened(EFalse)
+, iUiConn(aUiConn)
+, iColSet(NULL)
+, iDataPtr(NULL)
+{
+}
+
+
+CEapAkaUiDataConnection::~CEapAkaUiDataConnection()
+{
+    if (iUiConn)
+    {
+        Close();
+        iUiConn = NULL;
+    }
+}
+
+
+TInt CEapAkaUiDataConnection::Open()
+{
+    if (iIsOpened)
+    {
+        return KErrAlreadyExists;
+    }
+
+    TInt err = iUiConn->GetDatabase(iDatabase);
+    if (err != KErrNone)
+    {
+        return err;
+    }
+
+    iIsOpened = ETrue;
+    return KErrNone;
+}
+
+
+TInt CEapAkaUiDataConnection::GetData(CEapAkaUiAkaData ** aDataPtr)
+{
+    if (aDataPtr == NULL)
+    {
+        return KErrArgument;
+    }
+    if (iIsOpened == EFalse)
+    {
+        return KErrSessionClosed;
+    }
+    iDataPtr = new CEapAkaUiAkaData();
+    if (!iDataPtr)
+    {
+        return KErrNoMemory;
+    }
+
+    TRAPD(err, FetchDataL());
+    if (err != KErrNone)
+    {
+		delete iDataPtr;
+		iDataPtr = NULL;
+		
+		delete iColSet;
+		iColSet = NULL;
+
+        iView.Close();
+        
+        return err;
+    }
+
+    *aDataPtr = iDataPtr;
+
+    return KErrNone;
+}
+
+
+TInt CEapAkaUiDataConnection::Update()
+{
+    TRAPD(err, iView.UpdateL());
+    if (err != KErrNone)
+    {
+        return err;
+    }
+
+	// Check if length of username and realm are less than the max length possible in DB.
+	if(iDataPtr->GetManualUsername().Length() > KMaxManualUsernameLengthInDB
+		|| iDataPtr->GetManualRealm().Length() > KMaxManualRealmLengthInDB)
+	{
+		// Username or realm too long. Can not be stored in DB.
+		EAP_TRACE_DEBUG_SYMBIAN((_L("CEapAkaUiDataConnection::Update: Too long username or realm. Length: UN=%d, Realm=%d\n"),
+			iDataPtr->GetManualUsername().Length(),
+			iDataPtr->GetManualRealm().Length()));
+		
+		return KErrArgument;
+	}
+    
+    TRAP(err, iView.SetColL(iColSet->ColNo(cf_str_EAP_AKA_manual_username_literal), iDataPtr->GetManualUsername()));
+	if (err != KErrNone)
+	{
+		return err;
+	}
+
+    TRAP(err, iView.SetColL(iColSet->ColNo(cf_str_EAP_AKA_manual_realm_literal), iDataPtr->GetManualRealm()));
+	if (err != KErrNone)
+	{
+		return err;
+	}
+
+    if (*(iDataPtr->GetUseManualUsername()))
+    {
+        TRAP(err, iView.SetColL(iColSet->ColNo(cf_str_EAP_AKA_use_manual_username_literal), EAKAUseManualUsernameYes));
+		if (err != KErrNone)
+		{
+			return err;
+		}
+    }
+    else
+    {
+        TRAP(err, iView.SetColL(iColSet->ColNo(cf_str_EAP_AKA_use_manual_username_literal), EAKAUseManualUsernameNo));
+		if (err != KErrNone)
+		{
+			return err;
+		}
+    }
+
+    if (*(iDataPtr->GetUseManualRealm()))
+    {
+        TRAP(err, iView.SetColL(iColSet->ColNo(cf_str_EAP_AKA_use_manual_realm_literal), EAKAUseManualRealmYes));
+		if (err != KErrNone)
+		{
+			return err;
+		}
+    }
+    else
+    {
+        TRAP(err, iView.SetColL(iColSet->ColNo(cf_str_EAP_AKA_use_manual_realm_literal), EAKAUseManualRealmNo));
+		if (err != KErrNone)
+		{
+			return err;
+		}
+    }
+
+	// Last full authentication time should be made zero when EAP configurations are modified.
+	// This makes sure that the next authentication with this EAP would be full authentication
+	// instead of reauthentication even if the session is still valid.
+	
+	TRAP(err, iView.SetColL(iColSet->ColNo(KAKALastFullAuthTime), default_FullAuthTime));
+    if (err != KErrNone)
+    {
+        return err;
+    }
+
+	EAP_TRACE_DEBUG_SYMBIAN((_L("Session Validity: Resetting Full Auth Time since EAP-AKA settings are modified\n")));
+
+    TRAP(err, iView.PutL());
+        
+    return err;
+}
+
+
+TInt CEapAkaUiDataConnection::Close()
+{
+    if (iIsOpened == EFalse)
+    {
+        return KErrNone;
+    }
+
+	delete iDataPtr;
+	iDataPtr = NULL;
+	
+	delete iColSet;
+	iColSet = NULL;
+
+    iView.Close();
+
+    iUiConn = NULL;
+    
+    return KErrNone;
+}
+
+
+void CEapAkaUiDataConnection::FetchDataL()
+{
+	HBufC* buf = HBufC::NewLC(KMaxSqlQueryLength);
+	TPtr sqlStatement = buf->Des();
+
+	// Form the query. Query everything.
+	_LIT(KSQLQuery, "SELECT * FROM %S WHERE %S=%d AND %S=%d AND %S=%d");
+	sqlStatement.Format(KSQLQuery,
+						&KAkaTableName,
+						&KServiceType,
+						iUiConn->GetIndexType(),
+						&KServiceIndex,
+						iUiConn->GetIndex(),
+						&KTunnelingType, 
+						iUiConn->GetTunnelingType());
+	// Evaluate view
+	User::LeaveIfError(iView.Prepare(iDatabase, TDbQuery(sqlStatement)));
+	User::LeaveIfError(iView.EvaluateAll());	
+	// Get the first (and only) row
+	iView.FirstL();
+	iView.GetL();				
+	// Get column set so we get the correct column numbers
+	delete iColSet;
+	iColSet = NULL;
+	iColSet = iView.ColSetL();
+
+	// Start fetching the values
+
+	// use manual username
+	TUint intValue = iView.ColUint(iColSet->ColNo(cf_str_EAP_AKA_use_manual_username_literal));
+    if (intValue == 0)
+    {
+        *(iDataPtr->GetUseManualUsername()) = EFalse;
+    }
+    else
+    {
+        *(iDataPtr->GetUseManualUsername()) = ETrue;
+    }
+
+	// use manual realm
+	intValue = iView.ColUint(iColSet->ColNo(cf_str_EAP_AKA_use_manual_realm_literal));
+    if (intValue == 0)
+    {
+        *(iDataPtr->GetUseManualRealm()) = EFalse;
+    }
+    else
+    {
+        *(iDataPtr->GetUseManualRealm()) = ETrue;
+    }
+
+    // manual username
+    iDataPtr->GetManualUsername().Copy(iView.ColDes16(iColSet->ColNo(cf_str_EAP_AKA_manual_username_literal)));
+
+	// manual realm
+	iDataPtr->GetManualRealm().Copy(iView.ColDes16(iColSet->ColNo(cf_str_EAP_AKA_manual_realm_literal)));
+
+    CleanupStack::PopAndDestroy(buf);
+}