// Copyright (c) 2003-2009 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:
//

/**
 @file
 @internalComponent
*/

#include "database.h"
#include "dbdef.h"
#include "filedump.h"

/**
makes logging accessible to all files

*/
extern FileDump* oMsg;

//
//
// PRIVATE PREFERENCE METHODS
//
//


TInt DBAccess::OpenPreferenceTable(TDesC &table)
/**
Opens the preference table

  @param table A reference to a descriptor containing the name of a table
  @return ETrue if Successful else EFalse 
  */
	{
	TInt valid = EFalse;
	
	if (table.Compare(TPtrC(CONNECTION_PREFERENCES)) == 0)
		{
		IAPpreference.iDirection = ECommDbConnectionDirectionOutgoing;
		
		oMsg->Dbg(_L("  Opening preference table for outgoing"));
		
		TRAPD(ret, _OpenPrefTableL());
		if (Evaluate(ret))
			{
			if (dbPrefView)
				{
				access |= DBPrefOut;
				valid = ETrue;
				}
			}
		}
	
	if (valid)
		if (access & DBUpdate)
			if (!Evaluate(dbPrefView->GotoFirstRecord()))
				valid = EFalse;
			
			return valid;
	}


TInt DBAccess::OpenPreferenceTableOnRank(TDesC &table)
/**
Open the preference table according to supplied rank and direction

  @param table A reference to a descriptor containing the name of a table
  @return ETrue if Successful else EFalse 
  */
	{
	TInt valid = EFalse;
	
	if (table.Compare(TPtrC(CONNECTION_PREFERENCES)) == 0)
		{
		IAPpreference.iDirection = ECommDbConnectionDirectionOutgoing;
		
		oMsg->Dbg(_L("  Opening preference table using rank [%d] direction [%d]"), IAPpreference.iRanking, IAPpreference.iDirection);
		
		TRAPD(ret, _OpenPrefTableOnRankL());
		if (Evaluate(ret))
			{
			if (dbPrefView)
				{
				access |= DBPrefOut;
				valid = ETrue;
				}
			}
		}
	
	if (valid)
		if (access & DBUpdate)
			if (!Evaluate(dbPrefView->GotoFirstRecord()))
				valid = EFalse;
			
			return valid;
	}


void DBAccess::_OpenPrefTableL()
/**
Opens specific tables.  This is done in it's own functions because
they put stuff on the stack that has to be popped off before a
TRAP can be called on it.

  */
	{
	dbPrefView = db->OpenConnectionPrefTableLC(IAPpreference.iDirection);
	
	CleanupStack::Pop(); // view
	}

void DBAccess::_OpenPrefTableOnRankL()
	{
	dbPrefView = db->OpenConnectionPrefTableViewOnRankLC(IAPpreference.iDirection, IAPpreference.iRanking);
	
	CleanupStack::Pop(); // view
	}


void DBAccess::ResetPreferenceFields()
/**
Set Preference Table structure to known values

  */
	{
	IAPpreference.iRanking = BADNUMVAL;
	IAPpreference.iDirection = ECommDbConnectionDirectionUnknown;
	IAPpreference.iDialogPref = ECommDbDialogPrefUnknown;
	IAPpreference.iBearer.iBearerSet = BADNUMVAL;
	IAPpreference.iBearer.iIapId = BADNUMVAL;
#ifdef __COMMDB_ROHID_SUPPORT__	
	isReadOnly = EFalse;
#endif
	}


TInt DBAccess::CheckPreferenceFieldsL()
/**
Makes sure we have all preference fields set

  @return ETrue if successful or EFalse
  */
	{
	oMsg->Dbg(_L("  Checking preference fields..."));
	
	if (IAPpreference.iRanking == BADNUMVAL || 
		IAPpreference.iDirection == ECommDbConnectionDirectionUnknown ||
		IAPpreference.iDialogPref == ECommDbDialogPrefUnknown ||
		IAPpreference.iBearer.iBearerSet == BADNUMVAL )
		{
		iLastError = E_NOTENOUGHDATA;
		LastErrorMessage.Set(errorCode[E_NOTENOUGHDATA]);
		return EFalse;
		}
	// now check if the optional field was supplied - if not, zero it
	if (IAPpreference.iBearer.iIapId == BADNUMVAL)
		IAPpreference.iBearer.iIapId = 0;
	
	oMsg->Msg(_L("All preference fields valid"));
	return ETrue;
	}


TInt DBAccess::SetPrefValue(TInt index)
/**
Attempts to open the preference table, or set a particular field

  @param index Index in the Table
  @return ETrue if successful or EFalse
  */
	{
	TInt valid = EFalse;
	TLex temp = TargetCols[ColCount].Value;
	TInt tempInt = 0;
	
	// once we have the ranking value, we can open the database
	if (TargetCols[ColCount].Name.Compare(TPtrC(CONNECT_PREF_RANKING)) == 0)
		{
		if (Evaluate(temp.Val(tempInt)))
			{
			TPtrC table = tableArray[index];
			
			ResetPreferenceFields();
			IAPpreference.iRanking = tempInt;
			
			if (access & DBInsert)
				{
				if (OpenPreferenceTable(table))
					valid = ETrue;
				}
			else if (access & DBUpdate)
				{
				// open record we want to edit
				if (OpenPreferenceTableOnRank(table))
					valid = ETrue;
				}
			}
		}
	else
		{
		// set IAP value
		if(Evaluate(temp.Val(tempInt)))
			{
			if (TargetCols[ColCount].Name.Compare(TPtrC(CONNECT_PREF_DIALOG_PREF)) == 0)
				{
				IAPpreference.iDialogPref = (TCommDbDialogPref)tempInt;
				oMsg->Dbg(_L("  Dialog preference set to %d"), IAPpreference.iDialogPref);
				valid = ETrue;
				}
			else if (TargetCols[ColCount].Name.Compare(TPtrC(CONNECT_PREF_IAP)) == 0)
				{
				IAPpreference.iBearer.iIapId = tempInt;
				oMsg->Dbg(_L("  Bearer ID set to %d"), IAPpreference.iBearer.iIapId);
				valid = ETrue;
				}
			else if (TargetCols[ColCount].Name.Compare(TPtrC(CONNECT_PREF_DIRECTION)) == 0)
				{
				IAPpreference.iDirection = (TCommDbConnectionDirection)tempInt;
				oMsg->Dbg(_L("  Bearer Direction set to %d"), IAPpreference.iDirection);
				valid = ETrue;
				}
			else if (TargetCols[ColCount].Name.Compare(TPtrC(CONNECT_PREF_BEARER_SET)) == 0)
				{
				IAPpreference.iBearer.iBearerSet = tempInt;
				oMsg->Dbg(_L("  Bearer Set set to %d"), IAPpreference.iBearer.iBearerSet);
				valid = ETrue;
				}
#ifdef __COMMDB_ROHID_SUPPORT__
			else if (TargetCols[ColCount].Name.Compare(TPtrC(COMMDB_READ_ONLY)) == 0)
				{
				oMsg->Dbg(_L("  ReadOnly set to %d"), tempInt);
				valid = ETrue;
				}
#endif
			else
				{
				iLastError = E_INCORRECTCOLNAME;
				LastErrorMessage.Set(errorCode[E_INCORRECTCOLNAME]);
				}
			}
		else
			{
			iLastError = E_INCORRECTTYPE;
			LastErrorMessage.Set(errorCode[E_INCORRECTTYPE]);
			}
		}
	
	return valid;
	}

TInt DBAccess::ConnectionPreferencesTable(TDesC &table)
	{
	
	if (table.Compare(TPtrC(CONNECTION_PREFERENCES)) == 0)
		{
		return ETrue;
		}
	
	return EFalse;
	}