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

// CCommDbOverrideSettings class defintions

// 

//

/**

 @file

 @deprecated since v9.1. Functionality is replaced with commsdat.

*/

#include "cdbover.h"

#include "OVERRIDE.H"

#include "CDBSTD.H"

#include <commsdattypeinfov1_1.h>

EXPORT_C CCommDbOverrideSettings* CCommDbOverrideSettings::NewL(TParamList aParamList)

/** Allocates and constructs an override settings object.

The construction process automatically opens the communications database and 

connects to the DBMS. The database is closed and the connection to the DBMS 

is severed when this override object is destroyed.

This function was withdrawn in 6.0, but reintroduced in 7.0.

@param aParamList Unused except	when comparing two sets.

@return A pointer to the new override settings object. */

	{

	CCommDbOverrideSettings* r=new(ELeave) CCommDbOverrideSettings(aParamList);

	CleanupStack::PushL(r);

	r->ConstructL();

	CleanupStack::Pop(r);

	return r;

	}

EXPORT_C CCommDbOverrideSettings* CCommDbOverrideSettings::NewL(TParamList aParamList, TCommDbDatabaseType /*aDbType*/)

/** @deprecated 7.0

Allocates and constructs an override settings object.

The construction process automatically opens the communications database and connects to the DBMS. 

The database is closed and the connection to the DBMS is severed when this override object is destroyed.

Re-instated override variant of NewL function in order to maintain BC with 6.1

@param aParamList Parameter list.

@param aDbType Whether Database is IAP or ISP version. All Db's are IAP type now.

@return CCommDbOverrideSettings* the calling function takes ownership of the returned object.

*/

	{

	return CCommDbOverrideSettings::NewL(aParamList);

	}

CCommDbOverrideSettings::CCommDbOverrideSettings(TParamList aParamList)

	: iPartialFull(aParamList)

/**

Constructor 

@param aParamList An enumerator which indicates whether the override settings are partial or full. 

*/

	{}

void CCommDbOverrideSettings::ConstructL()

	{

	iDb=CCommsDatabase::NewL();

	}

EXPORT_C CCommDbOverrideSettings::~CCommDbOverrideSettings()

/** Frees all resources owned by this object, prior to its destruction. Specifically, 

it closes the communications database and severs the connection with the DBMS. */

	{

	iOverrides.ResetAndDestroy();

	iIapOverrides.Reset();

	delete iDb;

	}

EXPORT_C TInt CCommDbOverrideSettings::SetIntOverride(const TDesC& aTableName, const TDesC& aColumnName, TUint32 aValue)

/** Sets an override value for the specified unsigned integer type column in the specified table in the 

communications database.

If the column name is empty, i.e. the length of the descriptor aColumnName is zero, then the override 

value is assumed to be the overriding ID for the default record for table aTableName. This means that 

the table must be one which supports default records.

For the function to succeed:

The column must exist

The column type must be an unsigned integer

An override for this column (or the overriding default record ID) for this table must not already exist

The table must be one which supports override settings

@param aTableName  A reference to a descriptor containing the name of a table in the 

communications database. 

@param aColumnName  A reference to a descriptor containing the name of a column in table 

aTableName. If this descriptor is empty, i.e. its length is zero, then aValue is assumed to be the 

overriding ID for the default record. 

@param aValue  The override value. 

@return KErrNone on success; KErrNotSupported if the specified table does not have a default (when overriding the 

default) or the table does not support overrides; KErrNotFound if the specified table and/or column does not exist; 

KErrAlreadyExists if the specified column is already overridden. */	

	{

	TRAPD(ret,CheckL(aTableName,aColumnName,EIntValue));

	if (ret!=KErrNone)

		return ret;

	ret = FindOverride(aTableName,aColumnName,EIntValue);

	if (ret >= 0)

		{

		ret = KErrAlreadyExists;

		}

	else if (ret == KErrNotFound)

		{

		CCommDbOverride* override = new CCommDbIntOverride(aTableName,aColumnName);

		if (override != 0)

			{

			((CCommDbIntOverride*) override)->iValue = aValue;

			ret = iOverrides.Append(override);

			}

		else

			ret = KErrNoMemory;

		}

	return ret;

	}

EXPORT_C TInt CCommDbOverrideSettings::SetBoolOverride(const TDesC& aTableName, const TDesC& aColumnName, TBool aValue)

/** Sets an override value for a boolean type column in the specified table in the communications database.

For the function to succeed:

The column must exist

The column type must be boolean

An override for this column for this table must not already exist

The table must be one which supports override settings

@param aTableName  A reference to a descriptor containing the name of a table in the communications 

database. 

@param aColumnName  A reference to a descriptor containing the name of a column in table aTableName. 

@param aValue  The override value. 

@return KErrNone on success; KErrNotSupported if the specified table does not have a default (when overriding the 

default) or the table does not support overrides; KErrNotFound if the specified table and/or column does not exist; 

KErrAlreadyExists if the specified column is already overridden. */

	{

	TRAPD(ret,CheckL(aTableName,aColumnName,EBoolValue));

	if (ret!=KErrNone)

		return ret;

	ret = FindOverride(aTableName,aColumnName,EBoolValue);

	if (ret >= 0)

		{

		ret = KErrAlreadyExists;

		}

	else if (ret == KErrNotFound)

		{

		CCommDbOverride* override = new CCommDbBoolOverride(aTableName,aColumnName);

		if (override != 0)

			{

			((CCommDbBoolOverride*) override)->iValue = aValue;

			ret = iOverrides.Append(override);

			// if Append failed delete override

			if ( ret != KErrNone ) delete override;

			}

		else

			ret = KErrNoMemory;

		}

	return ret;

	}

EXPORT_C TInt CCommDbOverrideSettings::SetDesOverride(const TDesC& aTableName, const TDesC& aColumnName, const TDesC8& aValue)

/** Sets an override value for an 8 bit descriptor text type column in the specified table in the communications 

database.

For the function to succeed:

The column must exist

The column type must be narrow (ASCII) text

An override for this column for this table must not already exist.

The table must be one which supports override settings

In addition, the maximum length of text expected by this function is the value of the constant 

KCommsDbSvrMaxFieldLength. The length of aValue supplied by the caller cannot be greater than this value.

@param aTableName  A reference to a descriptor containing the name of a table in the communications 

database. 

@param aColumnName  A reference to a descriptor containing the name of a column in table aTableName. 

@param aValue  The override value. 

@return KErrNone on success; KErrNotSupported if the specified table does not have a default (when overriding the 

default) or the table does not support overrides; KErrNotFound if the specified table and/or column does not exist; 

KErrAlreadyExists if the specified column is already overridden.*/

	{

	TRAPD(ret,CheckL(aTableName,aColumnName,EDes8Value));

	if (ret!=KErrNone)

		return ret;

	TInt fieldWidth(0);

	CCommsDbTableView* tableView = 0;

	TRAP(ret, tableView = iDb->OpenTableLC(aTableName); CleanupStack::Pop(tableView));

	if (ret != KErrNone)

		{

		return ret;

		}

	TRAP(ret, tableView->ReadColumnMaxLengthL(aColumnName, fieldWidth));

	if (ret != KErrNone)

		{

		delete tableView;

		return ret;

		}

	if (aValue.Length()< fieldWidth)

		{

		ret = FindOverride(aTableName,aColumnName,EDes8Value);

		if (ret >= 0)

			{

			ret = KErrAlreadyExists;

			}

		else if (ret == KErrNotFound)

			{

			CCommDbOverride* override = new CCommDbDes8Override(aTableName,aColumnName);

			if (override != 0)

				{

				((CCommDbDes8Override*) override)->iValue.Copy(aValue);

				ret = iOverrides.Append(override);

				// if Append failed delete override

				if ( ret != KErrNone ) delete override;

				}

			else

				{

				ret = KErrNoMemory;

				}

			}

		}

	else

		{

			ret = KErrOverflow;

		}

	delete tableView;

	return ret;

	}

EXPORT_C TInt CCommDbOverrideSettings::SetDesOverride(const TDesC& aTableName, const TDesC& aColumnName, const TDesC16& aValue)

/** Sets an override value for a 16 bit descriptor text type column in the specified table in the communications 

database.

For the function to succeed:

The column must exist

The column type must be wide (UNICODE) text

An override for this column for this table must not already exist

The table must be one which supports override settings

In addition, the maximum length of text expected by this function is the value of the constant 

KCommsDbSvrMaxFieldLength. The length of aValue supplied by the caller cannot be greater than this value.

@param aTableName  A reference to a descriptor containing the name of a table in the communications database. 

@param aColumnName  A reference to a descriptor containing the name of a column in table aTableName. 

@param aValue  The override value. 

@return KErrNone on success; KErrNotSupported if the specified table does not have a default (when overriding the 

default) or the table does not support overrides; KErrNotFound if the specified table and/or column does not exist; 

KErrAlreadyExists if the specified column is already overridden. */

	{

	TRAPD(ret,CheckL(aTableName,aColumnName,EDes16Value));

	if (ret!=KErrNone)

		return ret;

	TInt fieldWidth(0);

	CCommsDbTableView* tableView = 0;

	TRAP(ret, tableView = iDb->OpenTableLC(aTableName); CleanupStack::Pop(tableView));

	if (ret != KErrNone)

		{

		return ret;

		}

	TRAP(ret, tableView->ReadColumnMaxLengthL(aColumnName, fieldWidth));

	if (ret != KErrNone)

		{

		delete tableView;

		return ret;

		}

	if (aValue.Length()< fieldWidth)

		{

		ret = FindOverride(aTableName,aColumnName,EDes16Value);

		if (ret >= 0)

			{

			ret = KErrAlreadyExists;

			}

		else if (ret == KErrNotFound)

			{

			CCommDbOverride* override = new CCommDbDes16Override(aTableName,aColumnName);

			if (override != 0)

				{

				((CCommDbDes16Override*) override)->iValue.Copy(aValue);

				ret = iOverrides.Append(override);

				// if Append failed delete override

				if ( ret != KErrNone ) delete override;

				}

			else

				{

				ret = KErrNoMemory;

				}

			}

		}

	else

		{

			ret = KErrOverflow;

		}

	delete tableView;

	return ret;

	}

EXPORT_C TInt CCommDbOverrideSettings::SetLongDesOverride(const TDesC& aTableName, const TDesC& aColumnName, const TDesC& aValue)

/** Sets an override value for a long text type column in a specified table in the communications database.

For the function to succeed:

The column must exist

The column type is assumed to be arbitrarily long text (within the limits defined by descriptors)

An override for this column for this table must not already exist

The table must be one which supports override settings

@param aTableName  A reference to a descriptor containing the name of a table in the communications 

database. 

@param aColumnName  A reference to a descriptor containing the name of a column in table aTableName. 

@param aValue  The override value. 

@return KErrNone on success; KErrNotSupported if the specified table does not have a default (when overriding the 

default) or the table does not support overrides; KErrNotFound if the specified table and/or column does not exist; 

KErrAlreadyExists if the specified column is already overridden. */

	{

	TRAPD(ret,CheckL(aTableName,aColumnName,ELongDesValue));

	if (ret!=KErrNone)

		return ret;

	ret = FindOverride(aTableName,aColumnName,ELongDesValue);

	if (ret >= 0)

		{

		ret = KErrAlreadyExists;

		}

	else if (ret == KErrNotFound)

		{

		CCommDbOverride* override = 0;

		TRAP(ret,(override=CCommDbLongDesOverride::NewL(aTableName,aColumnName,aValue)));

		if (ret==KErrNone)

			{

			ret = iOverrides.Append(override);

			// if Append failed delete override

			if ( ret != KErrNone ) delete override;

			}

		}

	return ret;

	}

EXPORT_C TInt CCommDbOverrideSettings::GetIntOverride(const TDesC& aTableName, const TDesC& aColumnName, TUint32& aValue)

/** Gets an override value for an unsigned integer type column in the specified table in the communications 

database. 

If the column name is empty, i.e. the length of the descriptor aColumnName is zero, then the override 

value is assumed to be the overriding Id for the default record for table aTableName.

For this function to succeed:

An override for this column (or the the overriding default record Id) for this table must exist

The table must be one which supports override settings

@param aTableName  A reference to a descriptor containing the name of a table in the communications 

database. 

@param aColumnName  A reference to a descriptor containing the name of a column in table aTableName. 

@param aValue  An unsigned integer type passed by the caller. On successful return from this function, it 

contains the override value. 

@return KErrNone on success; KErrNotFound if the specified table and/or column has not been overridden or does not 

exist */

	{

	TInt index=FindOverride(aTableName,aColumnName,EIntValue);

	if (index < 0)

		return KErrNotFound;

	aValue=((CCommDbIntOverride*)(iOverrides[index]))->iValue;

	return KErrNone;

	}

EXPORT_C TInt CCommDbOverrideSettings::GetBoolOverride(const TDesC& aTableName, const TDesC& aColumnName, TBool& aValue)

/** Gets an override value for a boolean type column in the specified table in the communications database.

For this function to succeed:

An override for this column for this table must exist

The table must be one which supports override settings

@param aTableName  A reference to a descriptor containing the name of a table in the communications 

database. 

@param aColumnName  A reference to a descriptor containing the name of a column in table aTableName. 

@param aValue  A boolean type passed by the caller. On successful return from this function, it contains 

the override value. 

@return KErrNone on success; KErrNotFound if the specified table and/or column has not been overridden or does not 

exist. */

	{

	TInt index=FindOverride(aTableName,aColumnName,EBoolValue);

	if (index < 0)

		return KErrNotFound;

	aValue=((CCommDbBoolOverride*)(iOverrides[index]))->iValue;

	return KErrNone;

	}

EXPORT_C TInt CCommDbOverrideSettings::GetDesOverride(const TDesC& aTableName, const TDesC& aColumnName, TDes8& aValue)

/** Gets an override value for an 8 bit descriptor text type column in the specified table in the communications

 database.

For this function to succeed:

An override for this column for this table must exist

The table must be one which supports override settings

@param aTableName  A reference to a descriptor containing the name of a table in the communications 

database. 

@param aColumnName  A reference to a descriptor containing the name of a column in table aTableName. 

@param aValue  An 8 bit type descriptor passed by the caller. On successful return from this function, it 

contains the override value. This parameter must be as long as KCommsDbSvrMaxFieldLength or the function will fail.

@return KErrNone on success; KErrNotFound if the specified table and/or column has not been overridden or does not 

exist; KErrOverflow if the aValue parameter was too small.*/

	{

	TInt fieldWidth(0);

	TInt returnValue = KErrNone;

	CCommsDbTableView* tableView = 0;

	TRAP(returnValue, tableView = iDb->OpenTableLC(aTableName); CleanupStack::Pop(tableView));

	if (returnValue != KErrNone)

		{

		return returnValue;

		}

	TRAP(returnValue, tableView->ReadColumnMaxLengthL(aColumnName, fieldWidth));

	if (returnValue != KErrNone)

		{

		delete tableView;

		return returnValue;

		}

	//TG-hack to restrict OutgoingGPRS/APN to 252 chars to avoid overflow

	TInt maxLength = aValue.MaxLength();

	if((aTableName.CompareF(TPtrC(KCDTypeNameOutgoingWCDMA)) == 0 || aTableName.CompareF(TPtrC(KCDTypeNameIncomingWCDMA)) == 0 ) 

		&& aColumnName.CompareF(TPtrC(KCDTypeNameGPRSAPN)) == 0)

		{

		fieldWidth = 252;	// KGSNNameLength from etelpckt.h

		}

	if (aValue.MaxLength() >= fieldWidth)

		{

		TInt index=FindOverride(aTableName,aColumnName,EDes8Value);

		if (index >= 0)

			{

			aValue.Copy(((CCommDbDes8Override*)(iOverrides[index]))->iValue);

			}

		else

			{

			returnValue = KErrNotFound;

			}

		}

	else

		{

		returnValue = KErrOverflow;

		}

	delete tableView;

	return returnValue ;

	}

EXPORT_C TInt CCommDbOverrideSettings::GetDesOverride(const TDesC& aTableName, const TDesC& aColumnName, TDes16& aValue)

/**Gets an override value for a 16 bit descriptor text type column in the specified table in the communications 

database.

For this function to succeed:

An override for this column for this table must exist

The table must be one which supports override settings

@param aTableName  A reference to a descriptor containing the name of a table in the communications 

database. 

@param aColumnName  A reference to a descriptor containing the name of a column in table aTableName. 

@param aValue  A 16 bit type descriptor passed by the caller. On successful return from this function, it 

contains the override value. This parameter must be as long as KCommsDbSvrMaxFieldLength or the function will fail.

@return KErrNone on success; KErrNotFound if the specified table and/or column has not been overridden or does not 

exist; KErrOverflow if the aValue parameter was too small.*/

	{

	TInt fieldWidth(0);

	TInt returnValue = KErrNone;

	CCommsDbTableView* tableView = 0;

	TRAP(returnValue, tableView = iDb->OpenTableLC(aTableName); CleanupStack::Pop(tableView));

	if (returnValue != KErrNone)

		{

		return returnValue;

		}

	TRAP(returnValue, tableView->ReadColumnMaxLengthL(aColumnName, fieldWidth));

	if (returnValue != KErrNone)

		{

		delete tableView;

		return returnValue;

		}

	if (aValue.MaxLength() >= fieldWidth)

		{

		TInt index=FindOverride(aTableName,aColumnName,EDes16Value);

		if (index >= 0)

			{

			aValue.Copy(((CCommDbDes16Override*)(iOverrides[index]))->iValue);

			}

		else

			{

			returnValue = KErrNotFound;

			}

		}