--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/telephonyprotocols/psdagt/TS_PsdAgt/DbUndo.cpp	Tue Feb 02 01:41:59 2010 +0200
@@ -0,0 +1,482 @@
+// 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:
+//
+ 
+#include "DbUndo.h"
+
+
+// UNDO Class for Integers
+void CDbUndoInt::ConstructL(const TDesC &aColumn, const TUint32 &aValue)
+	{
+	iColumn.Set(aColumn);
+	iValue=aValue;
+	}
+
+CDbUndoInt *CDbUndoInt::NewL(const TDesC &aColumn, const TUint32 &aValue)
+	{
+	CDbUndoInt *undo = new(ELeave) CDbUndoInt();
+	CleanupStack::PushL(undo);
+	undo->ConstructL(aColumn, aValue);
+	CleanupStack::Pop();
+	return undo;
+	}
+
+void CDbUndoInt::UndoL(CDbAgtBase *aDb)
+	{
+	// Reset value in the table back to the values stored in this undo object
+	aDb->ModifyColumnIntL(iColumn, iValue);
+	}
+
+// UNDO Class for Booleans
+void CDbUndoBool::ConstructL(const TDesC &aColumn, const TBool &aValue)
+	{
+	iColumn.Set(aColumn);
+	iValue=aValue;
+	}
+
+CDbUndoBool *CDbUndoBool::NewL(const TDesC &aColumn, const TBool &aValue)
+	{
+	CDbUndoBool *undo = new(ELeave) CDbUndoBool();
+	CleanupStack::PushL(undo);
+	undo->ConstructL(aColumn, aValue);
+	CleanupStack::Pop();
+	return undo;
+	}
+
+void CDbUndoBool::UndoL(CDbAgtBase *aDb)
+	{
+	// Reset value in the table back to the values stored in this undo object
+	aDb->ModifyColumnBoolL(iColumn, iValue);
+	}
+
+// UNDO Class for text
+void CDbUndoText::ConstructL(const TDesC &aColumn, const TDesC16& aValue)
+	{
+	iColumn.Set(aColumn);
+	iText.Copy(aValue);
+	}
+
+CDbUndoText *CDbUndoText::NewL(const TDesC &aColumn, const TDesC16& aValue)
+	{
+	CDbUndoText *undo = new(ELeave) CDbUndoText();
+	CleanupStack::PushL(undo);
+	undo->ConstructL(aColumn, aValue);
+	CleanupStack::Pop();
+	return undo;
+	}
+
+void CDbUndoText::UndoL(CDbAgtBase *aDb)
+	{
+	// Reset text value in the table back to the text values stored in this undo object
+	aDb->ModifyColumnTextL(iColumn, iText);
+	}
+
+// UNDO Class for long text
+void CDbUndoLongText::ConstructL(const TDesC &aColumn, const HBufC* aValue)
+	{
+	iColumn.Set(aColumn);
+	// Save the long text from CommDB, allocate it!
+	iLongText = aValue->AllocL();
+	}
+
+CDbUndoLongText *CDbUndoLongText::NewL(const TDesC &aColumn, const HBufC* aValue)
+	{
+	CDbUndoLongText *undo = new(ELeave) CDbUndoLongText();
+	CleanupStack::PushL(undo);
+	undo->ConstructL(aColumn, aValue);
+	CleanupStack::Pop();
+	return undo;
+	}
+
+void CDbUndoLongText::UndoL(CDbAgtBase *aDb)
+	{
+	// Reset text value in the table back to the text values stored in this undo object
+	TPtr value(iLongText->Des());
+	aDb->ModifyColumnLongTextL(iColumn, value);
+	// Allocated in ConstructL, remeber to delete!
+	delete iLongText;
+	}
+
+// UNDO Class for Agent Extension name
+void CDbUndoAgentExt::ConstructL(const TDesC &aService, const TDesC& aAgentExt)
+	{
+	iColumn.Set(aService);
+	iText.Copy(aAgentExt);
+	}
+
+CDbUndoAgentExt *CDbUndoAgentExt::NewL(const TDesC &aService, const TDesC& aAgentExt)
+	{
+	CDbUndoAgentExt *undo = new(ELeave) CDbUndoAgentExt();
+	CleanupStack::PushL(undo);
+	undo->ConstructL(aService, aAgentExt);
+	CleanupStack::Pop();
+	return undo;
+	}
+
+void CDbUndoAgentExt::UndoL(CDbAgtBase* /*aDb*/)
+	{
+	}
+
+// Base class routines, used to open a CCommsDatabase and modify records
+CDbAgtBase::CDbAgtBase() : iQHeader(_FOFF(CDbUndoBase,iLink)), iQIter(iQHeader)
+	{
+	}
+
+void CDbAgtBase::ConstructL()
+	{
+#ifdef SYMBIAN_NON_SEAMLESS_NETWORK_BEARER_MOBILITY
+	iDb = CMDBSession::NewL(KCDVersion1_2);
+#else
+	iDb = CMDBSession::NewL(KCDVersion1_1);
+#endif
+	}
+
+CDbAgtBase::~CDbAgtBase()
+	{
+	delete iDb;
+	}
+
+
+void CDbAgtBase::SetColumnIntL(const TDesC &aColumn, const TUint32 &aValue)
+	{
+	// Used by a client to set a value in the database, also remembers the change
+	// for undo purposes later
+	
+	TUint32 OldValue;
+	CDbUndoInt *oldRecord;
+
+	// Get the current value in the table
+	TInt ValType;
+	CMDBField<TUint>* field = static_cast<CMDBField<TUint>*>(iTable->iRecords[iCurrentRecord]->GetFieldByNameL(aColumn, ValType));
+	OldValue = *field;
+
+	// Add to the undo list
+	oldRecord = CDbUndoInt::NewL(aColumn, OldValue);
+	iQHeader.AddLast(*oldRecord);
+
+	// Change the record to the new value
+	ModifyColumnIntL(aColumn, aValue);
+	}
+
+
+void CDbAgtBase::ModifyColumnIntL(const TDesC &aColumn, const TUint32 &aValue)
+	{
+	TInt ValType;
+	CMDBField<TUint>* field = static_cast<CMDBField<TUint>*>(iTable->iRecords[iCurrentRecord]->GetFieldByNameL(aColumn, ValType));
+	*field = aValue;
+	field->ModifyL(*iDb);
+	}
+
+void CDbAgtBase::SetColumnBoolL(const TDesC &aColumn, const TBool &aValue)
+	{
+	// Used by a client to set a value in the database, also remembers the change
+	// for undo purposes later
+	
+	TBool OldValue;
+	CDbUndoBool *oldRecord;
+	
+	// Get the current value in the table
+	TInt ValType;
+	CMDBField<TBool>* field = static_cast<CMDBField<TBool>*>(iTable->iRecords[iCurrentRecord]->GetFieldByNameL(aColumn, ValType));
+	OldValue = static_cast<TBool>(*field);
+
+	// Add to the undo list
+	oldRecord = CDbUndoBool::NewL(aColumn, OldValue);
+	iQHeader.AddLast(*oldRecord);
+
+	// Change the record to the new value
+	ModifyColumnBoolL(aColumn, aValue);
+	}
+
+
+void CDbAgtBase::ModifyColumnBoolL(const TDesC &aColumn, const TBool &aValue)
+	{
+	TInt ValType;
+	CMDBField<TBool>* field = static_cast<CMDBField<TBool>*>(iTable->iRecords[iCurrentRecord]->GetFieldByNameL(aColumn, ValType));
+	*field = aValue;
+	field->ModifyL(*iDb);
+	}
+
+void CDbAgtBase::SetColumnTextL(const TDesC &aColumn, const TDesC16& aValue)
+	{
+	// Used by a client to set a text value in the database, also remembers the change
+	// for undo purposes later
+	
+	TBuf16<KCommsDbSvrMaxFieldLength> OldText;
+	CDbUndoText *oldRecord;
+
+	// Get the current value in the table
+	TInt ValType;
+	CMDBField<TDesC>* field = static_cast<CMDBField<TDesC>*>(iTable->iRecords[iCurrentRecord]->GetFieldByNameL(aColumn, ValType));
+	OldText = static_cast<TDesC>(*field);
+
+	// Add to the undo list
+	oldRecord = CDbUndoText::NewL(aColumn, OldText);
+	iQHeader.AddLast(*oldRecord);
+
+	// Change the record to the new value
+	ModifyColumnTextL(aColumn, aValue);
+	}
+
+void CDbAgtBase::ModifyColumnTextL(const TDesC &aColumn, const TDesC16& aValue)
+	{
+	TInt ValType;
+	CMDBField<TDesC>* field = static_cast<CMDBField<TDesC>*>(iTable->iRecords[iCurrentRecord]->GetFieldByNameL(aColumn, ValType));
+	*field = aValue;
+	field->ModifyL(*iDb);
+	}
+
+void CDbAgtBase::SetColumnLongTextL(const TDesC &aColumn, const TDesC16& aValue)
+	{
+	// Used by a client to set a long text value in the database, also remembers the change
+	// for undo purposes later
+	
+	CDbUndoLongText *oldRecord;
+
+	// Get the current long text in the table, it is allocated in CommDB in ReadLongTextLC.
+	// The method returns a pointer into HBufC.
+	TInt ValType;
+	CMDBField<TDesC>* field = static_cast<CMDBField<TDesC>*>(iTable->iRecords[iCurrentRecord]->GetFieldByNameL(aColumn, ValType));
+	HBufC* OldLongText = HBufC::NewL(static_cast<TDesC>(*field).Length());
+	CleanupStack::PushL(OldLongText);
+	*OldLongText = *field;
+
+	// Add to the undo list
+	oldRecord = CDbUndoLongText::NewL(aColumn, OldLongText);
+	iQHeader.AddLast(*oldRecord);
+
+	// Allocated into CDbUndoLongText in ConstructL, and this one was created in CommDB so delete it!
+	// this is pushed above so clean up properly
+	CleanupStack::PopAndDestroy(OldLongText);
+
+	// Change the record to the new value
+	ModifyColumnLongTextL(aColumn, aValue);
+	}
+
+void CDbAgtBase::ModifyColumnLongTextL(const TDesC &aColumn, const TDesC16& aValue)
+	{
+	TInt ValType;
+	CMDBField<TDesC>* field = static_cast<CMDBField<TDesC>*>(iTable->iRecords[iCurrentRecord]->GetFieldByNameL(aColumn, ValType));
+	field->SetMaxLengthL(aValue.Length());
+	*field = aValue;
+	field->ModifyL(*iDb);
+	}
+
+
+void CDbAgtBase::UndoDatabaseChangesL()
+	{
+	CDbUndoBase* currentitem;
+
+	// Traverse back through the changes and reset database to the way it was
+	iQIter.SetToLast();
+
+	while((currentitem = iQIter--) != NULL)
+        {
+        // reset the value of this record in the database
+		currentitem->UndoL(this);
+        currentitem->iLink.Deque();
+        delete currentitem;
+        };
+	}
+
+// GPRS OUTGOING TABLE access class
+CDbGPRSOutgoingTable *CDbGPRSOutgoingTable::NewL()
+	{
+	CDbGPRSOutgoingTable *gprs = new(ELeave) CDbGPRSOutgoingTable();
+	CleanupStack::PushL(gprs);
+	gprs->ConstructL();
+	CleanupStack::Pop();
+	return gprs;
+	}
+
+CDbGPRSOutgoingTable::CDbGPRSOutgoingTable()
+	{
+	}
+
+void CDbGPRSOutgoingTable::ConstructL()
+	{
+	CDbAgtBase::ConstructL();
+	iTable = new CMDBRecordSet<CCDOutgoingGprsRecord>(KCDTIdOutgoingGprsRecord);
+	iTable->LoadL(*iDb);
+	iCurrentRecord = 0;
+	}
+
+CDbGPRSOutgoingTable::~CDbGPRSOutgoingTable()
+	{
+	delete iTable;
+	}
+
+// CSD DIAL OUT table class
+CDbCsdTable *CDbCsdTable::NewL()
+	{
+	CDbCsdTable *csd = new(ELeave) CDbCsdTable();
+	CleanupStack::PushL(csd);
+	csd->ConstructL();
+	CleanupStack::Pop();
+	return csd;
+	}
+
+CDbCsdTable::CDbCsdTable()
+	{
+	}
+
+void CDbCsdTable::ConstructL()
+	{
+	CDbAgtBase::ConstructL();
+	iTable = new CMDBRecordSet<CCDDialOutISPRecord>(KCDTIdDialOutISPRecord);
+	iTable->LoadL(*iDb);
+	iCurrentRecord = 0;
+	}
+
+CDbCsdTable::~CDbCsdTable()
+	{
+	delete iTable;
+	}
+
+
+// MODEM table class
+CDbModemTable *CDbModemTable::NewL()
+	{
+	CDbModemTable *modem = new(ELeave) CDbModemTable();
+	CleanupStack::PushL(modem);
+	modem->ConstructL();
+	CleanupStack::Pop();
+	return modem;
+	}
+
+CDbModemTable::CDbModemTable()
+	{
+	}
+
+void CDbModemTable::ConstructL()
+	{
+	CDbAgtBase::ConstructL();
+	iTable = new CMDBRecordSet<CCDModemBearerRecord>(KCDTIdModemBearerRecord);
+	iTable->LoadL(*iDb);
+	iCurrentRecord = 0;
+	}
+
+CDbModemTable::~CDbModemTable()
+	{
+	delete iTable;
+	}
+
+// Preference table class
+CDbPrefTable *CDbPrefTable::NewL( 
+	CMDBField<TCommDbConnectionDirection> aDirection,
+	CBearerUpdate aBearerUpdate,
+	TBool aReadOnly,
+	TUint32 aDialogPref )
+	{
+	CDbPrefTable *pref = new(ELeave) CDbPrefTable();
+	CleanupStack::PushL(pref);
+	pref->iDirection = static_cast<TCommDbConnectionDirection>(aDirection);
+	pref->iBearerUpdate.iBearerSet = aBearerUpdate.iBearerSet;
+	pref->iBearerUpdate.iIapId = aBearerUpdate.iIapId;
+	pref->iReadOnly = aReadOnly;
+	pref->iDialogPref = aDialogPref;
+	pref->ConstructL();
+	CleanupStack::Pop();
+	return pref;
+	}
+
+CDbPrefTable::CDbPrefTable()
+	{
+	}
+
+void CDbPrefTable::ConstructL()
+	{
+	CDbAgtBase::ConstructL();
+	iPrefTable = new (ELeave) CMDBRecordSet<CCDConnectionPrefsRecord>(KCDTIdConnectionPrefsRecord);
+	iPrefTable->LoadL(*iDb);
+	
+	iOldPrefs.iRanking = (static_cast<CCDConnectionPrefsRecord*>(iPrefTable->iRecords[iCurrentPrefRecord]))->iRanking;
+	iOldPrefs.iDirection = static_cast<TCommDbConnectionDirection>((static_cast<CCDConnectionPrefsRecord*>(iPrefTable->iRecords[iCurrentPrefRecord]))->iDirection);
+	iOldPrefs.iDialogPref = (static_cast<CCDConnectionPrefsRecord*>(iPrefTable->iRecords[iCurrentPrefRecord]))->iDialogPref;
+	iOldPrefs.iBearer.iBearerSet = (static_cast<CCDConnectionPrefsRecord*>(iPrefTable->iRecords[iCurrentPrefRecord]))->iBearerSet;
+	iOldPrefs.iBearer.iIapId = (static_cast<CCDConnectionPrefsRecord *>(iPrefTable->iRecords[iCurrentPrefRecord]))->iDefaultIAP;
+	
+	iCurrentPrefRecord = 0;
+	((CCDConnectionPrefsRecord *)iPrefTable->iRecords[iCurrentPrefRecord])->iDialogPref = iDialogPref;
+	((CCDConnectionPrefsRecord *)iPrefTable->iRecords[iCurrentPrefRecord])->iBearerSet = iBearerUpdate.iBearerSet;
+	((CCDConnectionPrefsRecord *)iPrefTable->iRecords[iCurrentPrefRecord])->iDefaultIAP = iBearerUpdate.iIapId;
+	if(iReadOnly)
+		{
+		iPrefTable->iRecords[iCurrentPrefRecord]->SetAttributes(ECDProtectedWrite);
+		}
+	iPrefTable->iRecords[iCurrentPrefRecord]->ModifyL(*iDb);
+	}
+
+CDbPrefTable::~CDbPrefTable()
+	{
+	if(iPrefTable)
+		{
+		// Don't care if this fails since we're in the destructor anyway (but need to trap any leaves as we can't leave from a destructor)
+		TRAP_IGNORE(RevertPreferenceTableL());
+		}
+	delete iTable;
+	delete iPrefTable;
+	}
+
+void CDbPrefTable::RevertPreferenceTableL()
+	{	
+	// Revert back to old ones
+	iCurrentPrefRecord = 0;
+	// iOldPrefs has the old info
+	((CCDConnectionPrefsRecord *)iPrefTable->iRecords[iCurrentPrefRecord])->iDialogPref = iOldPrefs.iDialogPref;
+	((CCDConnectionPrefsRecord *)iPrefTable->iRecords[iCurrentPrefRecord])->iBearerSet = iOldPrefs.iBearer.iBearerSet;
+	((CCDConnectionPrefsRecord *)iPrefTable->iRecords[iCurrentPrefRecord])->iDefaultIAP = iOldPrefs.iBearer.iIapId;
+	if(iReadOnly)
+		{
+		iPrefTable->iRecords[iCurrentPrefRecord]->SetAttributes(ECDProtectedWrite);
+		}
+	iPrefTable->iRecords[iCurrentPrefRecord]->ModifyL(*iDb);
+	}
+
+// IAP table class
+CDbIapTable *CDbIapTable::NewL(const TDesC16& aIapName)
+	{
+	CDbIapTable *iap = new(ELeave) CDbIapTable();
+	CleanupStack::PushL(iap);
+	iap->ConstructL();
+	iap->iIapName.Copy( aIapName );
+	CleanupStack::Pop();
+	return iap;
+	}
+
+CDbIapTable::CDbIapTable()
+	{
+	}
+
+void CDbIapTable::ConstructL()
+	{
+	CDbAgtBase::ConstructL();
+	}
+
+void CDbIapTable::GetBearerSetIapIdL(TUint32& aIapId)
+	{
+	CCDIAPRecord* iRecord = static_cast<CCDIAPRecord*>(CCDRecordBase::RecordFactoryL(KCDTIdIAPRecord));
+	iRecord->iRecordName = iIapName;
+
+	//iTable = new CMDBRecordSet<CCDIAPRecord>();
+	//CleanupStack::Pop(iTable);
+	iRecord->LoadL(*iDb);
+	aIapId = iRecord->RecordId();
+	iCurrentRecord = 0;
+	}
+
+CDbIapTable::~CDbIapTable()
+	{
+	delete iTable;
+	}