/*

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

* All rights reserved.

* This component and the accompanying materials are made available

* under the terms of "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:  DM-settings 

*

*/

// INCLUDE FILES

#include <sysutil.h>

#include <nsmlconstants.h>

#include <nsmldebug.h>

#include <nsmldmconstants.h>

#include "nsmldmsettings.h"

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

//

//		CNSmlDMProfile

//

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

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

//		CNSmlDMProfile::NewL()

//		Creates a new instance of CNSmlDMProfile object. 

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

CNSmlDMProfile* CNSmlDMProfile::NewL( RDbNamedDatabase* aDatabase )

	{

	CNSmlDMProfile* self = CNSmlDMProfile::NewLC( aDatabase );

	CleanupStack::Pop();

	return self;

	}

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

//		CNSmlDMProfile::NewLC()

//		Creates a new instance of CNSmlDMProfile object. 

//		Pushes and leaves new instance into CleanupStack.

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

CNSmlDMProfile* CNSmlDMProfile::NewLC( RDbNamedDatabase* aDatabase )

	{

	CNSmlDMProfile* self = new( ELeave ) CNSmlDMProfile;

	CleanupStack::PushL( self );

	self->ConstructL( aDatabase );

	return self;

	}

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

//		CNSmlDMProfile::ConstructL()

//		Second phase constructor.

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

void CNSmlDMProfile::ConstructL( RDbNamedDatabase* aDatabase )

	{

	iDatabase = aDatabase;

	iId = ( TUint ) KNSmlNewObject;

	User::LeaveIfError( iTableProfiles.Open( *iDatabase, KNSmlDMTableProfiles ) );

    iColSetProfiles = iTableProfiles.ColSetL();

	iDisplayName = HBufC::NewL( KNSmlDmMaxProfileNameLength );

	iDMServerUsername = HBufC::NewL( KNSmlDmMaxUsernameLength );

	iDMServerPassword = HBufC::NewL( KNSmlDmMaxPasswordLength );

	iClientPassword   = HBufC::NewL( KNSmlDmSharedSecretMaxLength );

	iServerId         = HBufC::NewL( KNSmlDmServerIdMaxLength );

	iServerURL        = HBufC::NewL( KNSmlDmMaxURLLength );

	iHttpAuthUsername = HBufC::NewL( KNSmlDmMaxHttpAuthUsernameLength );

	iHttpAuthPassword = HBufC::NewL( KNSmlDmMaxHttpAuthPasswordLength );

	iProfileLock = EFalse;

	}

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

//		CNSmlDMProfile::~CNSmlDMProfile()

//		Destructor.

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

EXPORT_C CNSmlDMProfile::~CNSmlDMProfile()

	{

	delete iDisplayName;

	delete iDMServerUsername;

	delete iDMServerPassword;

	delete iClientPassword;

	delete iServerId;

	delete iServerURL;

	delete iHttpAuthUsername;

	delete iHttpAuthPassword;

	iView.Close();

	iWSView.Close();

	iRSView.Close();

	if(iColSetProfiles)

	    {

	    delete iColSetProfiles;

	    }

	iTableProfiles.Close();

	}

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

//		CNSmlDMProfile::SaveL()

//		Saves a profile ie. writes all profile data to the database.

//		If save is succesfull returns KErrNone,

//		otherwise returns negative integer (defined in EPOC error codes).

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

EXPORT_C TInt CNSmlDMProfile::SaveL()

	{

	_DBG_FILE("CNSmlDMProfile::SaveL(): begin");

	if ( iDatabase->InTransaction() )

		{

		return ( KErrAccessDenied );

		}	

	iDatabase->Begin();

	CNSmlDMCrypt* crypt = new(ELeave) CNSmlDMCrypt;

	CleanupStack::PushL(crypt);

	if ( iId == ( TUint ) KNSmlNewObject )

		{

		// Check OOD before saving a New profile

		RFs fs;

		User::LeaveIfError( fs.Connect() );

		CleanupClosePushL(fs);

		if (SysUtil::FFSSpaceBelowCriticalLevelL(&fs, KNSmlDmSettingsFatMinSize))

			{

			iDatabase->Rollback();

			CleanupStack::PopAndDestroy(2); // crypt, fs

			return KErrDiskFull;

			// do not write

			}

		CleanupStack::PopAndDestroy(); //fs

		//new profile

		iTableProfiles.InsertL();

		TableProfilesSetColDesL( KNSmlDMProfileDisplayName,	*iDisplayName );

		TableProfilesSetColIntL( KNSmlDMProfileIAPId, iIAPId );

		TableProfilesSetColIntL( KNSmlDMProfileTransportId, iTransportId );

		TableProfilesSetColDesL( KNSmlDMProfileServerUsername, *iDMServerUsername );

		TableProfilesSetColDesL( KNSmlDMProfileServerPassword, crypt->EncryptedL( *iDMServerPassword) );	

		TableProfilesSetColDesL( KNSmlDMProfileClientPassword,            crypt->EncryptedL( *iClientPassword) );	

		TableProfilesSetColDesL( KNSmlDMProfileServerURL, *iServerURL );

		TableProfilesSetColDesL( KNSmlDMProfileServerId,   *iServerId );

		TableProfilesSetColIntL( KNSmlDMProfileServerAlertedAction,		iServerAlertAction );

		TableProfilesSetColIntL( KNSmlDMProfileAuthenticationRequired, iAuthenticationRequired );

		TableProfilesSetColIntL( KNSmlDMProfileCreatorId,				iCreatorId );

		TableProfilesSetColIntL( KNSmlDMProfileDeleteAllowed,			iDeleteAllowed );

		TableProfilesSetColIntL( KNSmlDMProfileSessionId,				iDMSessionId );

		TableProfilesSetColIntL( KNSmlDMProfileHidden, iProfileHidden );

		TableProfilesSetColIntL( KNSmlDMProfileHttpAuthUsed, iHttpAuthUsed );

		TableProfilesSetColDesL( KNSmlDMProfileHttpAuthUsername, *iHttpAuthUsername );

		TableProfilesSetColDesL( KNSmlDMProfileHttpAuthPassword, crypt->EncryptedL( *iHttpAuthPassword ) );

		TableProfilesSetColIntL(KNSmlDMProfileLock,iProfileLock);

		iId = iTableProfiles.ColUint( iColSetProfiles->ColNo( KNSmlDMProfileId) ); // Use autoincrement

		iId+= KMaxDataSyncID;

		iTableProfiles.SetColL( iColSetProfiles->ColNo( KNSmlDMProfileId ), iId );

		iTableProfiles.PutL();

		}

	else

		{

		//existing profile

		HBufC* sqlStatement = HBufC::NewLC( KDMSQLGetProfile().Length() + KNSmlDmMaxIntegerLength );

		TPtr sqlStatementPtr = sqlStatement->Des();

		sqlStatementPtr.Format( KDMSQLGetProfile, iId );

		PrepareViewL( sqlStatementPtr, iView.EUpdatable );

		CleanupStack::PopAndDestroy();  // sqlStatement

		if ( iView.FirstL() )

			{

			iView.GetL();

			iView.UpdateL();

			ViewSetColDesL( KNSmlDMProfileDisplayName, *iDisplayName );

			ViewSetColIntL( KNSmlDMProfileTransportId, iTransportId );

			ViewSetColIntL( KNSmlDMProfileIAPId, iIAPId );

			ViewSetColDesL( KNSmlDMProfileServerUsername, *iDMServerUsername );

			ViewSetColDesL( KNSmlDMProfileServerPassword, crypt->EncryptedL( *iDMServerPassword ) );

			ViewSetColDesL( KNSmlDMProfileClientPassword,            crypt->EncryptedL( *iClientPassword) );	

			ViewSetColDesL( KNSmlDMProfileServerURL, *iServerURL );

			ViewSetColDesL( KNSmlDMProfileServerId, *iServerId );

			ViewSetColIntL( KNSmlDMProfileServerAlertedAction,		iServerAlertAction );

			ViewSetColIntL( KNSmlDMProfileAuthenticationRequired, iAuthenticationRequired );

			ViewSetColIntL( KNSmlDMProfileCreatorId, iCreatorId );

			ViewSetColIntL( KNSmlDMProfileDeleteAllowed, iDeleteAllowed );

			ViewSetColIntL( KNSmlDMProfileSessionId, iDMSessionId);

			ViewSetColIntL( KNSmlDMProfileHidden, iProfileHidden );

			ViewSetColIntL( KNSmlDMProfileHttpAuthUsed, iHttpAuthUsed );

			ViewSetColDesL( KNSmlDMProfileHttpAuthUsername, *iHttpAuthUsername );

			ViewSetColDesL( KNSmlDMProfileHttpAuthPassword, crypt->EncryptedL( *iHttpAuthPassword ) );

			ViewSetColIntL( KNSmlDMProfileLock, iProfileLock );

			iView.PutL();

			}

		else

			{

			iDatabase->Rollback();

			CleanupStack::PopAndDestroy();  //crypt

			return KErrNotFound;

			}

		}

	CleanupStack::PopAndDestroy();  //crypt

	CommitAndCompact();

	_DBG_FILE("CNSmlDMProfile::SaveL(): end");

	return KErrNone;

	}

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

//		CNSmlDMProfile::IsNew()

//		Returns true if profile is new, otherwise false.

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

EXPORT_C TBool CNSmlDMProfile::IsNew() const

	{

	return ( iId == ( TUint ) KNSmlNewObject );

	}

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

//		CNSmlDMProfile::StrValue()

//		Returns a given string value.

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

EXPORT_C const TDesC& CNSmlDMProfile::StrValue( TNSmlDMProfileData aProfileItem ) const

	{	

	HBufC* result = 0;

	switch ( aProfileItem )

		{

		case ( EDMProfileDisplayName ) :

			{

			result = iDisplayName;

			}

		break;

		case ( EDMProfileServerUsername ) :

			{

			result = iDMServerUsername;

			}

		break;

		case ( EDMProfileServerPassword ) :

			{

			result = iDMServerPassword;

			}

		break;

		case ( EDMProfileClientPassword ) :

			{

			result = iClientPassword;

			}

		break;

		case ( EDMProfileServerURL ) :

			{

			result = iServerURL;

			}

		break;

		case ( EDMProfileServerId ) :

			{

			result = iServerId;

			}

		break;

		case ( EDMProfileHttpAuthUsername ) :

			{

			result = iHttpAuthUsername;

			}

		break;

		case ( EDMProfileHttpAuthPassword ) :

			{

			result = iHttpAuthPassword;

			}

		break;

		default:

			{

			User::Panic( KNSmlIndexOutOfBoundStr, KNSmlPanicIndexOutOfBound );

			}

		}

	return *result; 

	}

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

//		CNSmlDMProfile::IntValue()

//		Returns a given int value.

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

EXPORT_C TInt CNSmlDMProfile::IntValue( TNSmlDMProfileData aProfileItem ) const

	{	

	TInt result( 0 );

	switch ( aProfileItem )

		{

		case ( EDMProfileId ) :

			{

			result = iId;

			}

		break;

		case ( EDMProfileIAPId ) :

			{

			result = iIAPId;

			}

		break;

		case ( EDMProfileTransportId ) :

			{

			result = iTransportId;

			}

		break;

		case ( EDMProfileSessionId ) :

			{

			result = iDMSessionId;

			}

		break;

		case ( EDMProfileServerAlertAction ) :

			{

			result = iServerAlertAction;

			}

		break;

		case ( EDMProfileAuthenticationRequired ) :

			{

			result = iAuthenticationRequired;

			}

		break;

		case ( EDMProfileCreatorId ) :

			{

			result = iCreatorId;

			}

		break;

		case ( EDMProfileDeleteAllowed ) :

			{

			result = iDeleteAllowed;

			}

		break;

		case ( EDMProfileHttpAuthUsed ) :

			{

			result = iHttpAuthUsed;

			}

		break;

		case ( EDMProfileHidden ) :

			{

			result = iProfileHidden;

			}

		break;

		case EDMProfileLock :

		    {

		    	result = iProfileLock;

		    }

		break;    

		default:

			{

			User::Panic( KNSmlIndexOutOfBoundStr, KNSmlPanicIndexOutOfBound );

			}

		}

	return result;

	}

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

//		CNSmlDMProfile::SetStrValue()

//		Sets a given string value.

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

EXPORT_C void CNSmlDMProfile::SetStrValue( TNSmlDMProfileData aProfileItem, const TDesC& aNewValue )

	{

	switch ( aProfileItem )

		{

		case ( EDMProfileDisplayName ) :

			{

			*iDisplayName = aNewValue;

			}

		break;

		case ( EDMProfileServerUsername ) :

			{

			*iDMServerUsername = aNewValue;

			}

		break;

		case ( EDMProfileServerPassword ) :

			{

			*iDMServerPassword = aNewValue;

			}

		break;

		case ( EDMProfileClientPassword ) :

			{

			*iClientPassword = aNewValue;

			}

		break;

		case ( EDMProfileServerURL ) :

			{

			*iServerURL = aNewValue;

			}

		break;

		case ( EDMProfileServerId ) :

			{

			*iServerId = aNewValue;

			}

		break;

		case ( EDMProfileHttpAuthUsername ) :

			{

			*iHttpAuthUsername = aNewValue;

			}

		break;

		case ( EDMProfileHttpAuthPassword ) :

			{

			*iHttpAuthPassword = aNewValue;

			}

		break;

		default:

			{

			User::Panic( KNSmlIndexOutOfBoundStr, KNSmlPanicIndexOutOfBound );

			}

		}

	}	

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

//		CNSmlDMProfile::SetIntValue()

//		Sets a given int value.

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

EXPORT_C void CNSmlDMProfile::SetIntValue( TNSmlDMProfileData aProfileItem, const TInt aNewValue )

	{

	switch ( aProfileItem )

		{

		case ( EDMProfileId ) :

			{

			iId = aNewValue;

			}

		break;

		case ( EDMProfileIAPId ) :

			{

			iIAPId = aNewValue;

			}

		break;

		case ( EDMProfileTransportId ) :

			{

			iTransportId = aNewValue;

			}

		break;

		case ( EDMProfileSessionId ) :

			{

			iDMSessionId = aNewValue;

			}

		break;

		case ( EDMProfileServerAlertAction ) :

			{

			iServerAlertAction = aNewValue;

			}

		break;

		case ( EDMProfileAuthenticationRequired ) :

			{

			iAuthenticationRequired = aNewValue;

			}

		break;

		case ( EDMProfileCreatorId ) :

			{

			iCreatorId = aNewValue;

			}

		break;

		case ( EDMProfileDeleteAllowed ) :

			{

			iDeleteAllowed = aNewValue;

			}

		break;

		case ( EDMProfileHidden ) :

			{

			iProfileHidden = aNewValue;

			}

		break;

		case ( EDMProfileHttpAuthUsed ) :

			{

			iHttpAuthUsed = aNewValue;