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

// This contains CommDb Unit Test Cases 028.XX

// 

//

// EPOC includes

#include <e32base.h>

#include <commdb.h>

#include <d32comm.h>

// Test system includes

#include <networking/log.h>

#include <networking/teststep.h>

#include "Teststepcommdb.h"

#include "TestSuiteCommdb.h"

#include "Step_028_xx.h"

CCommDbTest028_01::CCommDbTest028_01()

	{

	// store the name of this test case

	iTestStepName = _L("step_028_01");

	}

CCommDbTest028_01::~CCommDbTest028_01()

	{}

TVerdict CCommDbTest028_01::doTestStepL( void )

	{

	if(executeStepL()==KErrNone)

		return EPass;

	return EFail;

	}

TVerdict CCommDbTest028_01::doTestStepPreambleL()

	{

	iTheDb=CCommsDatabase::NewL();

	iPrefView = iTheDb->OpenConnectionPrefTableLC();

	CleanupStack::Pop();

	return EPass;

	}

TInt CCommDbTest028_01::executeStepL()

	{

	CCommsDbConnectionPrefTableView::TCommDbIapConnectionPref pref1;

	pref1.iRanking = 1;

	pref1.iDirection = ECommDbConnectionDirectionOutgoing;

	pref1.iDialogPref = ECommDbDialogPrefPrompt;

	pref1.iBearer.iBearerSet = KCommDbBearerCSD;

	pref1.iBearer.iIapId = 1;

	iPrefView->InsertConnectionPreferenceL(pref1, EFalse);

	CCommsDbConnectionPrefTableView::TCommDbIapConnectionPref pref2;

	pref2.iRanking = 2;

	pref2.iDirection = ECommDbConnectionDirectionOutgoing;

	pref2.iDialogPref = ECommDbDialogPrefPrompt;

	pref2.iBearer.iBearerSet = KCommDbBearerCSD;

	pref2.iBearer.iIapId = 2;

	iPrefView->InsertConnectionPreferenceL(pref2, EFalse);

	CCommsDbConnectionPrefTableView::TCommDbIapConnectionPref retrievedPref;

	User::LeaveIfError(iPrefView->GotoFirstRecord());

	iPrefView->ReadConnectionPreferenceL(retrievedPref);

	if(!(retrievedPref==pref1))	//Check to see if correct preferance has been fetched

		return KErrGeneral;

	User::LeaveIfError(iPrefView->GotoNextRecord());

	iPrefView->ReadConnectionPreferenceL(retrievedPref);

	if(!(retrievedPref==pref2))	//Check to see if correct preferance has been fetched

		return KErrGeneral;

	if((iPrefView->GotoNextRecord())!=KErrNotFound)	//Make sure there are no more records.

		return KErrGeneral;

	return KErrNone;

	}

TVerdict CCommDbTest028_01::doTestStepPostambleL()

	{

		//Get rid of our view

	if(iPrefView)

		{

		delete iPrefView;

		}

	iPrefView=0;

	//Create a new view that should have the record that was added in executeStepL and

	// may have been left in by a leave condition

	iPrefView = iTheDb->OpenConnectionPrefTableLC();

	CleanupStack::Pop();

	if(iPrefView->GotoFirstRecord() == KErrNone)

		{

		iPrefView->DeleteConnectionPreferenceL();

		}

	if(iPrefView->GotoFirstRecord() == KErrNone)

		{

		iPrefView->DeleteConnectionPreferenceL();

		}

	// Cleanup after test run

	CTestStepCommDb::doTestStepPostambleL();	

	return EPass;

	}

//

CCommDbTest028_02::CCommDbTest028_02()

	{

	// store the name of this test case

	iTestStepName = _L("step_028_02");

	}

CCommDbTest028_02::~CCommDbTest028_02()

	{}

TVerdict CCommDbTest028_02::doTestStepL( void )

	{

	if(executeStepL()==KErrNone)

		return EPass;

	return EFail;

	}

TVerdict CCommDbTest028_02::doTestStepPreambleL()

	{

	iTheDb=CCommsDatabase::NewL();

	iPrefView = iTheDb->OpenConnectionPrefTableLC();

	CleanupStack::Pop();

	return EPass;

	}

TInt CCommDbTest028_02::executeStepL()

	{

	CCommsDbConnectionPrefTableView::TCommDbIapConnectionPref pref1;

	pref1.iRanking = 1;

	pref1.iDirection = ECommDbConnectionDirectionOutgoing;

	pref1.iDialogPref = ECommDbDialogPrefPrompt;

	pref1.iBearer.iBearerSet = KCommDbBearerCSD;

	pref1.iBearer.iIapId = 1;

	iPrefView->InsertConnectionPreferenceL(pref1, EFalse);

	CCommsDbConnectionPrefTableView::TCommDbIapConnectionPref pref2;

	pref2.iRanking = 2;

	pref2.iDirection = ECommDbConnectionDirectionOutgoing;

	pref2.iDialogPref = ECommDbDialogPrefPrompt;

	pref2.iBearer.iBearerSet = KCommDbBearerCSD;

	pref2.iBearer.iIapId = 2;

	iPrefView->InsertConnectionPreferenceL(pref2, EFalse);

	CCommsDbConnectionPrefTableView::TCommDbIapConnectionPref retrievedPref;

	User::LeaveIfError(iPrefView->GotoFirstRecord());

	iPrefView->ReadConnectionPreferenceL(retrievedPref);

	while (iPrefView->GotoNextRecord()!=KErrNotFound)	//Move through to last record

		{}

	User::LeaveIfError(iPrefView->GotoPreviousRecord());

	iPrefView->ReadConnectionPreferenceL(retrievedPref);

	if(!(retrievedPref==pref2))	//Check to see if correct preferance has been fetched

		return KErrGeneral;

	User::LeaveIfError(iPrefView->GotoPreviousRecord());

	iPrefView->ReadConnectionPreferenceL(retrievedPref);

	if(!(retrievedPref==pref1))	//Check to see if correct preferance has been fetched

		return KErrGeneral;

	if(iPrefView->GotoPreviousRecord()!=KErrNotFound)	//Check that there are no more records

		return KErrGeneral;

	return KErrNone;

	}

TVerdict CCommDbTest028_02::doTestStepPostambleL()

	{

		//Get rid of our view

	if(iPrefView)

		{

		delete iPrefView;

		}

	iPrefView=0;

	//Create a new view that should have the record that was added in executeStepL and

	// may have been left in by a leave condition

	iPrefView = iTheDb->OpenConnectionPrefTableLC();

	CleanupStack::Pop();

	if(iPrefView->GotoFirstRecord() == KErrNone)

		{

		iPrefView->DeleteConnectionPreferenceL();

		}

	if(iPrefView->GotoFirstRecord() == KErrNone)

		{

		iPrefView->DeleteConnectionPreferenceL();

		}

	// Cleanup after test run

	CTestStepCommDb::doTestStepPostambleL();	

	return EPass;

	}

//

CCommDbTest028_03::CCommDbTest028_03()

	{

	// store the name of this test case

	iTestStepName = _L("step_028_03");

	}

CCommDbTest028_03::~CCommDbTest028_03()

	{}

TVerdict CCommDbTest028_03::doTestStepL( void )

	{

	if(executeStepL()==KErrNone)

		return EPass;

	return EFail;

	}

TVerdict CCommDbTest028_03::doTestStepPreambleL()

	{

	iTheDb=CCommsDatabase::NewL();

	iPrefView = iTheDb->OpenConnectionPrefTableLC();

	CleanupStack::Pop();

	return EPass;

	}

TInt CCommDbTest028_03::executeStepL()

	{

	CCommsDbConnectionPrefTableView::TCommDbIapConnectionPref pref1;

	pref1.iRanking = 1;

	pref1.iDirection = ECommDbConnectionDirectionIncoming;

	pref1.iDialogPref = ECommDbDialogPrefPrompt;

	pref1.iBearer.iBearerSet = KCommDbBearerCSD;

	pref1.iBearer.iIapId = 3;

	iPrefView->InsertConnectionPreferenceL(pref1, EFalse);

	CCommsDbConnectionPrefTableView::TCommDbIapConnectionPref pref2;

	pref2.iRanking = 2;

	pref2.iDirection = ECommDbConnectionDirectionOutgoing;

	pref2.iDialogPref = ECommDbDialogPrefPrompt;

	pref2.iBearer.iBearerSet = KCommDbBearerCSD;

	pref2.iBearer.iIapId = 2;

	iPrefView->InsertConnectionPreferenceL(pref2, EFalse);

	delete iPrefView;	//Create a new view to look only at outgoing records.

	iPrefView=NULL;

	iPrefView=iTheDb->OpenConnectionPrefTableLC(ECommDbConnectionDirectionOutgoing);

	CleanupStack::Pop(iPrefView);

	CCommsDbConnectionPrefTableView::TCommDbIapConnectionPref retrievedPref;

	User::LeaveIfError(iPrefView->GotoFirstRecord());

	iPrefView->ReadConnectionPreferenceL(retrievedPref);

	if(!(retrievedPref==pref2))	//First record in this table should be pref2

		return KErrGeneral;

	if(iPrefView->GotoNextRecord()!=KErrNotFound)	//There should be no more records in this view.

		return KErrGeneral;

	return KErrNone;

	}

TVerdict CCommDbTest028_03::doTestStepPostambleL()

	{

		//Get rid of our view

	if(iPrefView)

		{

		delete iPrefView;

		}

	iPrefView=0;

	//Create a new view that should have the record that was added in executeStepL and

	// may have been left in by a leave condition

	iPrefView = iTheDb->OpenConnectionPrefTableLC();

	CleanupStack::Pop();

	if(iPrefView->GotoFirstRecord() == KErrNone)

		{

		iPrefView->DeleteConnectionPreferenceL();

		}

	if(iPrefView->GotoFirstRecord() == KErrNone)

		{

		iPrefView->DeleteConnectionPreferenceL();

		}

	// Cleanup after test run

	CTestStepCommDb::doTestStepPostambleL();	

	return EPass;

	}

//

CCommDbTest028_04::CCommDbTest028_04()

	{

	// store the name of this test case

	iTestStepName = _L("step_028_04");

	}

CCommDbTest028_04::~CCommDbTest028_04()

	{}

TVerdict CCommDbTest028_04::doTestStepL( void )

	{

	if(executeStepL()==KErrNone)

		return EPass;

	return EFail;

	}

TVerdict CCommDbTest028_04::doTestStepPreambleL()

	{

	iTheDb=CCommsDatabase::NewL();

	iPrefView = iTheDb->OpenConnectionPrefTableLC();

	CleanupStack::Pop();

	return EPass;

	}

TInt CCommDbTest028_04::executeStepL()

	{

	CCommsDbConnectionPrefTableView::TCommDbIapConnectionPref pref1;

	pref1.iRanking = 1;

	pref1.iDirection = ECommDbConnectionDirectionIncoming;

	pref1.iDialogPref = ECommDbDialogPrefPrompt;

	pref1.iBearer.iBearerSet = KCommDbBearerCSD;

	pref1.iBearer.iIapId = 3;

	iPrefView->InsertConnectionPreferenceL(pref1, EFalse);

	CCommsDbConnectionPrefTableView::TCommDbIapConnectionPref pref2;

	pref2.iRanking = 2;

	pref2.iDirection = ECommDbConnectionDirectionOutgoing;

	pref2.iDialogPref = ECommDbDialogPrefPrompt;

	pref2.iBearer.iBearerSet = KCommDbBearerCSD;

	pref2.iBearer.iIapId = 2;

	iPrefView->InsertConnectionPreferenceL(pref2, EFalse);

	delete iPrefView;	//Create a new view to look only at incoming records.

	iPrefView=NULL;

	iPrefView=iTheDb->OpenConnectionPrefTableLC(ECommDbConnectionDirectionIncoming);

	CleanupStack::Pop(iPrefView);

	CCommsDbConnectionPrefTableView::TCommDbIapConnectionPref retrievedPref;

	User::LeaveIfError(iPrefView->GotoFirstRecord());

	iPrefView->ReadConnectionPreferenceL(retrievedPref);

	if(!(retrievedPref==pref1))	//First record in this table should be pref1

		return KErrGeneral;

	if(iPrefView->GotoNextRecord()!=KErrNotFound)	//There should be no more records in this view.

		return KErrGeneral;

	return KErrNone;

	}

TVerdict CCommDbTest028_04::doTestStepPostambleL()

	{

		//Get rid of our view

	if(iPrefView)

		{

		delete iPrefView;

		}

	iPrefView=0;

	//Create a new view that should have the record that was added in executeStepL and

	// may have been left in by a leave condition

	iPrefView = iTheDb->OpenConnectionPrefTableLC();

	CleanupStack::Pop();

	if(iPrefView->GotoFirstRecord() == KErrNone)

		{

		iPrefView->DeleteConnectionPreferenceL();

		}

	if(iPrefView->GotoFirstRecord() == KErrNone)

		{

		iPrefView->DeleteConnectionPreferenceL();

		}

	// Cleanup after test run

	CTestStepCommDb::doTestStepPostambleL();	

	return EPass;

	}

//

CCommDbTest028_05::CCommDbTest028_05()

	{

	// store the name of this test case

	iTestStepName = _L("step_028_05");

	}

CCommDbTest028_05::~CCommDbTest028_05()

	{}

TVerdict CCommDbTest028_05::doTestStepL( void )

	{

	if(executeStepL()==KErrNone)

		return EPass;

	return EFail;

	}

TVerdict CCommDbTest028_05::doTestStepPreambleL()

	{

	iTheDb=CCommsDatabase::NewL();

	iPrefView = iTheDb->OpenConnectionPrefTableLC();

	CleanupStack::Pop();

	return EPass;

	}

TInt CCommDbTest028_05::executeStepL()

	{

	CCommsDbConnectionPrefTableView::TCommDbIapConnectionPref pref1;

	pref1.iRanking = 1;

	pref1.iDirection = ECommDbConnectionDirectionOutgoing;

	pref1.iDialogPref = ECommDbDialogPrefPrompt;

	pref1.iBearer.iBearerSet = KCommDbBearerCSD;

	pref1.iBearer.iIapId = 1;

	iPrefView->InsertConnectionPreferenceL(pref1, EFalse);

	CCommsDbConnectionPrefTableView::TCommDbIapConnectionPref pref2;

	pref2.iRanking = 2;

	pref2.iDirection = ECommDbConnectionDirectionOutgoing;

	pref2.iDialogPref = ECommDbDialogPrefPrompt;

	pref2.iBearer.iBearerSet = KCommDbBearerCSD;

	pref2.iBearer.iIapId = 2;

	iPrefView->InsertConnectionPreferenceL(pref2, EFalse);

	delete iPrefView;	//Create a new view to look only at incoming records.

	iPrefView=NULL;

	iPrefView=iTheDb->OpenConnectionPrefTableLC(ECommDbConnectionDirectionIncoming);

	CleanupStack::Pop(iPrefView);

	if(iPrefView->GotoPreviousRecord()!=KErrNotFound)	//There should be no records in this table.

		return KErrGeneral;

	return KErrNone;

	}

TVerdict CCommDbTest028_05::doTestStepPostambleL()

	{

		//Get rid of our view

	if(iPrefView)

		{

		delete iPrefView;

		}

	iPrefView=0;

	//Create a new view that should have the record that was added in executeStepL and

	// may have been left in by a leave condition

	iPrefView = iTheDb->OpenConnectionPrefTableLC();

	CleanupStack::Pop();

	if(iPrefView->GotoFirstRecord() == KErrNone)

		{

		iPrefView->DeleteConnectionPreferenceL();

		}

	if(iPrefView->GotoFirstRecord() == KErrNone)

		{

		iPrefView->DeleteConnectionPreferenceL();

		}

	// Cleanup after test run

	CTestStepCommDb::doTestStepPostambleL();	

	return EPass;

	}

//

CCommDbTest028_06::CCommDbTest028_06()

	{

	// store the name of this test case

	iTestStepName = _L("step_028_06");

	}

CCommDbTest028_06::~CCommDbTest028_06()

	{}

TVerdict CCommDbTest028_06::doTestStepL( void )

	{

	if(executeStepL()==KErrNone)

		return EPass;

	return EFail;

	}

TVerdict CCommDbTest028_06::doTestStepPreambleL()

	{

	iTheDb=CCommsDatabase::NewL();

	iPrefView = iTheDb->OpenConnectionPrefTableLC();

	CleanupStack::Pop();

	return EPass;

	}

TInt CCommDbTest028_06::executeStepL()

	{

	CCommsDbConnectionPrefTableView::TCommDbIapConnectionPref pref1;