// 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 022.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_022_xx.h"

//

//	Test step 022.01

//

// constructor

CCommDbTest022_01::CCommDbTest022_01()

	{

	// store the name of this test case

	iTestStepName = _L("step_022_01");

	}

// destructor

CCommDbTest022_01::~CCommDbTest022_01()

	{

	}

TVerdict CCommDbTest022_01::doTestStepPreambleL()

	{	

	openDbL();

	return EPass;

	}

TInt CCommDbTest022_01::executeStepL()

	{

	TInt ret=KErrGeneral;

	//Open a view on the IAP table, then check the records returned

	iTheView = iTheDb->OpenIAPTableViewMatchingBearerSetLC( KCommDbBearerCSD, ECommDbConnectionDirectionOutgoing);

	CleanupStack::Pop();

	CDBLEAVE( iTheView->GotoFirstRecord(), KErrNone );

	TBuf<KCommsDbSvrMaxFieldLength> value;

	iTheView->ReadTextL( TPtrC(COMMDB_NAME), value );

	if( !value.Compare(_L("Record #1")) )

		{

		CDBLEAVE( iTheView->GotoNextRecord(), KErrNone );

		iTheView->ReadTextL( TPtrC(COMMDB_NAME), value);

		if ( !value.Compare(_L("Record #2")) )

		{

			//There should be no more records

			CDBLEAVE( iTheView->GotoNextRecord(), KErrNotFound );

			ret = KErrNone;

		}

	}

	return ret;

	}

TVerdict CCommDbTest022_01::doTestStepL( )

	{

	Log(_L("Step 022.01 called "));

	if ( executeStepL() == KErrNone )

		iTestStepResult = EPass;

	else

		iTestStepResult = EFail;

	return iTestStepResult;

	}

//

//	Test step 022.02

//

// constructor

CCommDbTest022_02::CCommDbTest022_02()

	{

	// store the name of this test case

	iTestStepName = _L("step_022_02");

	}

// destructor

CCommDbTest022_02::~CCommDbTest022_02()

	{

	}

TVerdict CCommDbTest022_02::doTestStepPreambleL()

	{	

	openDbL();

	return EPass;

	}

TInt CCommDbTest022_02::executeStepL()

	{

	TInt ret=KErrGeneral;

	//Open a view on the IAP table, then check the records returned

	iTheView = iTheDb->OpenIAPTableViewMatchingBearerSetLC( KCommDbBearerCSD, ECommDbConnectionDirectionIncoming);

	CleanupStack::Pop();

	CDBLEAVE( iTheView->GotoFirstRecord(), KErrNone );

	TBuf<KCommsDbSvrMaxFieldLength> value;

	iTheView->ReadTextL( TPtrC(COMMDB_NAME), value );

	if( !value.Compare(_L("Record #3")) )

		{

		CDBLEAVE( iTheView->GotoNextRecord(), KErrNone );

		iTheView->ReadTextL( TPtrC(COMMDB_NAME), value);

		if ( !value.Compare(_L("Record #4")) )

			{

			CDBLEAVE( iTheView->GotoNextRecord(), KErrNone );

			iTheView->ReadTextL( TPtrC(COMMDB_NAME), value);

			if ( !value.Compare(_L("Record #6")) )

				{

				//There should be no more records

				CDBLEAVE( iTheView->GotoNextRecord(), KErrNotFound );

				ret = KErrNone;

				}

			}

	}

	return ret;

	}

TVerdict CCommDbTest022_02::doTestStepL( )

	{

	Log(_L("Step 022.02 called "));

	if ( executeStepL() == KErrNone )

		iTestStepResult = EPass;

	else

		iTestStepResult = EFail;

	return iTestStepResult;

	}

//

//	Test step 022.03

//

// constructor

CCommDbTest022_03::CCommDbTest022_03()

	{

	// store the name of this test case

	iTestStepName = _L("step_022_03");

	}

// destructor

CCommDbTest022_03::~CCommDbTest022_03()

	{

	}

TVerdict CCommDbTest022_03::doTestStepPreambleL()

	{	

	openDbL();

	return EPass;

	}

TInt CCommDbTest022_03::executeStepL()

	{

	TInt ret=KErrGeneral;

	//Open a view on the IAP table, then check the records returned

	iTheView = iTheDb->OpenIAPTableViewMatchingBearerSetLC( KCommDbBearerWcdma, ECommDbConnectionDirectionOutgoing);

	CleanupStack::Pop();

	CDBLEAVE( iTheView->GotoFirstRecord(), KErrNone );

	TBuf<KCommsDbSvrMaxFieldLength> value;

	iTheView->ReadTextL( TPtrC(COMMDB_NAME), value );

	if( !value.Compare(_L("Record #5")) )

		{

		CDBLEAVE( iTheView->GotoNextRecord(), KErrNone );

		iTheView->ReadTextL( TPtrC(COMMDB_NAME), value);

		if ( !value.Compare(_L("Record #7")) )

		{

			//There should be no more records

			CDBLEAVE( iTheView->GotoNextRecord(), KErrNotFound );

			ret = KErrNone;

		}

	}

	return ret;

	}

TVerdict CCommDbTest022_03::doTestStepL( )

	{

	Log(_L("Step 022.03 called "));

	if ( executeStepL() == KErrNone )

		iTestStepResult = EPass;

	else

		iTestStepResult = EFail;

	return iTestStepResult;

	}

//

//	Test step 022.04

//

// constructor

CCommDbTest022_04::CCommDbTest022_04()

	{

	// store the name of this test case

	iTestStepName = _L("step_022_04");

	}

// destructor

CCommDbTest022_04::~CCommDbTest022_04()

	{

	}

TVerdict CCommDbTest022_04::doTestStepPreambleL()

	{	

	openDbL();

	return EPass;

	}

TInt CCommDbTest022_04::executeStepL()

	{

	TInt ret=KErrGeneral;

	//Open a view on the IAP table, then check the records returned

	iTheView = iTheDb->OpenIAPTableViewMatchingBearerSetLC( KCommDbBearerCSD, ECommDbConnectionDirectionOutgoing);

	CleanupStack::Pop();

	CDBLEAVE( iTheView->GotoFirstRecord(), KErrNone );

	TBuf<KCommsDbSvrMaxFieldLength> value;

	iTheView->ReadTextL( TPtrC(COMMDB_NAME), value );

	if( !value.Compare(_L("Record #1")) )

		{

		CDBLEAVE( iTheView->GotoNextRecord(), KErrNone );

		iTheView->ReadTextL( TPtrC(COMMDB_NAME), value);

		if ( !value.Compare(_L("Record #2")) )

		{

			//There should be no more records

			CDBLEAVE( iTheView->GotoNextRecord(), KErrNotFound );

			ret = KErrNone;

		}

	}

	return ret;

	}

TVerdict CCommDbTest022_04::doTestStepL( )

	{

	Log(_L("Step 022.04 called "));

	if ( executeStepL() == KErrNone )

		iTestStepResult = EPass;

	else

		iTestStepResult = EFail;

	return iTestStepResult;

	}

//

//	Test step 022.05

//

// constructor

CCommDbTest022_05::CCommDbTest022_05()

	{

	// store the name of this test case

	iTestStepName = _L("step_022_05");

	}

// destructor

CCommDbTest022_05::~CCommDbTest022_05()

	{

	}

TVerdict CCommDbTest022_05::doTestStepPreambleL()

	{	

	openDbL();

	return EPass;

	}

TInt CCommDbTest022_05::executeStepL()

	{

	TInt ret=KErrGeneral;

	//Open a view on the IAP table, then check the records returned

	iTheView = iTheDb->OpenIAPTableViewMatchingBearerSetLC( KCommDbBearerWcdma, ECommDbConnectionDirectionIncoming);

	CleanupStack::Pop();

	CDBLEAVE( iTheView->GotoFirstRecord(), KErrNone );

	TBuf<KCommsDbSvrMaxFieldLength> value;

	iTheView->ReadTextL( TPtrC(COMMDB_NAME), value );

	if( !value.Compare(_L("Record #9")) )

		{

		CDBLEAVE( iTheView->GotoNextRecord(), KErrNone );

		iTheView->ReadTextL( TPtrC(COMMDB_NAME), value);

		if ( !value.Compare(_L("Record #10")) )

		{

			//There should be no more records

			CDBLEAVE( iTheView->GotoNextRecord(), KErrNotFound );

			ret = KErrNone;

		}

	}

	return ret;

	}

TVerdict CCommDbTest022_05::doTestStepL( )

	{

	Log(_L("Step 022.05 called "));

	if ( executeStepL() == KErrNone )

		iTestStepResult = EPass;

	else

		iTestStepResult = EFail;

	return iTestStepResult;

	}

//

//	Test step 022.06

//

// constructor

CCommDbTest022_06::CCommDbTest022_06()

	{

	// store the name of this test case

	iTestStepName = _L("step_022_06");

	}

// destructor

CCommDbTest022_06::~CCommDbTest022_06()

	{

	}

TVerdict CCommDbTest022_06::doTestStepPreambleL()

	{	

	openDbL();

	return EPass;

	}

TInt CCommDbTest022_06::executeStepL()

	{

	TInt ret=KErrGeneral;

	//Open a view on the IAP table, then check the records returned

	iTheView = iTheDb->OpenIAPTableViewMatchingBearerSetLC( KCommDbBearerWcdma, ECommDbConnectionDirectionIncoming);

	CleanupStack::Pop();

	CDBLEAVE( iTheView->GotoFirstRecord(), KErrNone );

	TBuf<KCommsDbSvrMaxFieldLength> value;

	iTheView->ReadTextL( TPtrC(COMMDB_NAME), value );

	if( !value.Compare(_L("Record #9")) )

		{

		CDBLEAVE( iTheView->GotoNextRecord(), KErrNone );

		iTheView->ReadTextL( TPtrC(COMMDB_NAME), value);

		if ( !value.Compare(_L("Record #10")) )

		{

			//There should be no more records

			CDBLEAVE( iTheView->GotoNextRecord(), KErrNotFound );

			ret = KErrNone;

		}

	}

	return ret;

	}

TVerdict CCommDbTest022_06::doTestStepL( )

	{

	Log(_L("Step 022.06 called "));

	if ( executeStepL() == KErrNone )

		iTestStepResult = EPass;

	else

		iTestStepResult = EFail;

	return iTestStepResult;

	}

//

//	Test step 022.07

//

// constructor

CCommDbTest022_07::CCommDbTest022_07()

	{

	// store the name of this test case

	iTestStepName = _L("step_022_07");

	}

// destructor

CCommDbTest022_07::~CCommDbTest022_07()

	{

	}

TVerdict CCommDbTest022_07::doTestStepPreambleL()

	{	

	openDbL();

	return EPass;

	}

TInt CCommDbTest022_07::executeStepL()

	{

	TInt ret=KErrGeneral;

	//Open a view on the IAP table, then check the records returned

	iTheView = iTheDb->OpenIAPTableViewMatchingBearerSetLC( KCommDbBearerCSD, ECommDbConnectionDirectionIncoming);

	CleanupStack::Pop();

	CDBLEAVE( iTheView->GotoFirstRecord(), KErrNone );

	TBuf<KCommsDbSvrMaxFieldLength> value;

	iTheView->ReadTextL( TPtrC(COMMDB_NAME), value );

	if( !value.Compare(_L("Record #3")) )

		{

		CDBLEAVE( iTheView->GotoNextRecord(), KErrNone );

		iTheView->ReadTextL( TPtrC(COMMDB_NAME), value);

		if ( !value.Compare(_L("Record #4")) )

			{

			CDBLEAVE( iTheView->GotoNextRecord(), KErrNone );

			iTheView->ReadTextL( TPtrC(COMMDB_NAME), value);

			if ( !value.Compare(_L("Record #6")) )

				{

				//There should be no more records

				CDBLEAVE( iTheView->GotoNextRecord(), KErrNotFound );

				ret = KErrNone;

				}

			}

	}

	return ret;

	}

TVerdict CCommDbTest022_07::doTestStepL( )

	{

	Log(_L("Step 022.07 called "));

	if ( executeStepL() == KErrNone )

		iTestStepResult = EPass;

	else

		iTestStepResult = EFail;

	return iTestStepResult;

	}

//

//	Test step 022.08

//

// constructor

CCommDbTest022_08::CCommDbTest022_08()

	{

	// store the name of this test case

	iTestStepName = _L("step_022_08");

	}

// destructor

CCommDbTest022_08::~CCommDbTest022_08()

	{

	}

TVerdict CCommDbTest022_08::doTestStepPreambleL()

	{	

	openDbL();

	return EPass;

	}

TInt CCommDbTest022_08::executeStepL()

	{

	TInt ret=KErrGeneral;

	//Open a view on the IAP table, then check the records returned

	iTheView = iTheDb->OpenIAPTableViewMatchingBearerSetLC( KCommDbBearerLAN, ECommDbConnectionDirectionIncoming);

	CleanupStack::Pop();

	CDBLEAVE( iTheView->GotoFirstRecord(), KErrNone );

	TBuf<KCommsDbSvrMaxFieldLength> value;