// 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:

// sms stack commdb util functions

// 

//

/**

 @file

*/

#include <f32file.h>

#include <e32test.h>

#include <d32comm.h>

#include <faxdefn.h>

#include <cdblen.h>

#include <cdbtemp.h>

#include "tsmscdb.h"

#include "autotest.h"

_LIT(KVodafoneSC,"+447785016005"); //Vodafone

GLREF_D RTest gTest;

GLDEF_D CCommsDatabase* TheDb;

GLDEF_C TUint32 TcpProtocolId;

GLDEF_C TUint32 UdpProtocolId;

GLDEF_C TUint32 IcmpProtocolId;

GLDEF_C TUint32 IpProtocolId;

GLDEF_C TUint32 IrmuxProtocolId;

GLDEF_C TUint32 TinyTPProtocolId;

GLDEF_C TUint32 SmsProtocolId;

GLDEF_C TUint32 WapProtocolId;

GLDEF_C TUint32 PlpProtocolId;

GLDEF_C TUint32 Link1ProtocolId;

GLDEF_C TUint32 PlpLoopProtocolId;

GLDEF_C TUint32 BtLinkManagerProtocolId;

GLDEF_C TUint32 L2capProtocolId;

GLDEF_C TUint32 RfCommProtocolId;

GLDEF_C TUint32 SdpProtocolId;

LOCAL_C void CreateLocationTableL(	TMyDialLocation aLocDataFax, TMyDialLocation aLocServSMS);

LOCAL_C void CreateModemTablesL(	TMyModemType aModemDataFax,  TMyModemType aModemServSMS,

                                    TUint aCommPortDataFax,      TUint aCommPortServSMS );

LOCAL_C void CreateChargecardTableL();

LOCAL_C TUint32 CreateISPTableL();

LOCAL_C void PopulateTemplatesL();

#ifndef MODEM_PHONE_SERVICES_SMS

// TODO - #ifndef has to be removed later

LOCAL_C void CreateInterfaceSettingsTableL();

LOCAL_C void CreateProtocolBindingsTableL();

LOCAL_C void CreateProtocolFamiliesTableL();

#endif

GLDEF_C void CreateCommDBL( TMyModemType aModemDataFax,  TMyModemType aModemServSMS,

                            TMyDialLocation aLocDataFax, TMyDialLocation aLocServSMS,

							TUint aCommPortDataFax,      TUint aCommPortServSMS )

/**

 *  @test Create a special CommDb Database for this test suite.

 */

    {

    gTest.Printf(_L("Creating the Chargecard. Modem and Location Tables\n"));

	// at first delete the old comms db file

	RFs fs;

	_LIT(KSvDbFileName,"C:\\System\\Data\\Cdbv3.dat");

	CHECKPOINT(fs.Connect()==KErrNone);

	TUint dummy;

	if(fs.Att(KSvDbFileName,dummy)==KErrNone)

	    CHECKPOINT(fs.Delete(KSvDbFileName)==KErrNone);

    fs.Close();

    TheDb=CCommsDatabase::NewL(EDatabaseTypeIAP);

    CleanupStack::PushL(TheDb);

    CHECKPOINT(TheDb->BeginTransaction()==KErrNone);

#ifndef MODEM_PHONE_SERVICES_SMS

// TODO - #ifndef has to be removed later

    CreateInterfaceSettingsTableL();

    CreateProtocolBindingsTableL();

    CreateProtocolFamiliesTableL();

#endif

//

// Write the database tables

//

    TUint32 ispId=CreateISPTableL();

    CreateChargecardTableL();

    CreateLocationTableL( aLocDataFax, aLocServSMS );

    CreateModemTablesL( aModemDataFax, aModemServSMS, aCommPortDataFax, aCommPortServSMS );

    PopulateTemplatesL();

    CCommsDbTableView* table=TheDb->OpenTableLC(TPtrC(DIAL_OUT_IAP));

    TUint32 id;

    CHECKPOINT(table->InsertRecord(id)==KErrNone);

    table->WriteTextL(TPtrC(COMMDB_NAME),_L("Test Configuration: GsmBsc Loopback"));

    table->WriteUintL(TPtrC(IAP_ISP),ispId);

//  table->WriteUintL(TPtrC(IAP_MODEM),modemId);

    CHECKPOINT(table->PutRecordChanges()==KErrNone);

//

// Set the Default

//

    TheDb->SetGlobalSettingL(TPtrC(DIAL_OUT_IAP),id);

    TheDb->SetGlobalSettingL(TPtrC(REDIAL_ATTEMPTS),3);

	TheDb->SetGlobalSettingL(TPtrC(SMS_BEARER),1); //vep

	TheDb->SetGlobalSettingL(TPtrC(SMS_RECEIVE_MODE),2); //vep

    CleanupStack::PopAndDestroy();

    CHECKPOINT(TheDb->CommitTransaction()==KErrNone);

    CleanupStack::PopAndDestroy();

    }

#ifndef MODEM_PHONE_SERVICES_SMS

// TODO - #ifndef has to be removed later

GLDEF_C void CreateProtocolBindingsTableL()

	{

	// This section contains information previously stored in esk files

	// Esock reads the database to determine which protocols are defined

	// and which protocol modules to load

	CCommsDbTableView* table=TheDb->OpenTableLC(TPtrC(PROTOCOL_BINDINGS));

	table->InsertRecord(TcpProtocolId);

	table->WriteTextL(TPtrC(PROTNAME), _L("tcp"));

	table->WriteUintL(TPtrC(INDEX),4);

	table->WriteUintL(TPtrC(NUM_BINDS),2);

	table->WriteTextL(TPtrC(BIND_1),_L("ip"));

	table->WriteTextL(TPtrC(BIND_2),_L("icmp"));

	table->PutRecordChanges();

	table->InsertRecord(UdpProtocolId);

	table->WriteTextL(TPtrC(PROTNAME), _L("udp"));

	table->WriteUintL(TPtrC(INDEX),3);

	table->WriteUintL(TPtrC(NUM_BINDS),2);

	table->WriteTextL(TPtrC(BIND_1),_L("ip"));

	table->WriteTextL(TPtrC(BIND_2),_L("icmp"));

	table->PutRecordChanges();

	table->InsertRecord(IcmpProtocolId);

	table->WriteTextL(TPtrC(PROTNAME), _L("icmp"));

	table->WriteUintL(TPtrC(INDEX),2);

	table->WriteUintL(TPtrC(NUM_BINDS),1);

	table->WriteTextL(TPtrC(BIND_1),_L("ip"));

	table->PutRecordChanges();

	table->InsertRecord(IpProtocolId);

	table->WriteTextL(TPtrC(PROTNAME), _L("ip"));

	table->WriteUintL(TPtrC(INDEX),1);

	table->WriteUintL(TPtrC(NUM_BINDS),0);

	table->PutRecordChanges();

	table->InsertRecord(IrmuxProtocolId);

	table->WriteTextL(TPtrC(PROTNAME), _L("irmux"));

	table->WriteUintL(TPtrC(INDEX),1);

	table->WriteUintL(TPtrC(NUM_BINDS),0);

	table->PutRecordChanges();

	table->InsertRecord(TinyTPProtocolId);

	table->WriteTextL(TPtrC(PROTNAME), _L("tinytp"));

	table->WriteUintL(TPtrC(INDEX),2);

	table->WriteUintL(TPtrC(NUM_BINDS),0);

	table->PutRecordChanges();

	//

	// extra records for SmsStack added by AlfredH

	//

	// from smswap.sms.esk

	table->InsertRecord(SmsProtocolId);

	table->WriteTextL(TPtrC(PROTNAME), _L("sms"));

	table->WriteUintL(TPtrC(INDEX),1);

	table->WriteUintL(TPtrC(NUM_BINDS),0);

	table->PutRecordChanges();

	// from smswap.wap.esk

	table->InsertRecord(WapProtocolId);

	table->WriteTextL(TPtrC(PROTNAME), _L("wap"));

	table->WriteUintL(TPtrC(INDEX),1);

	table->WriteUintL(TPtrC(NUM_BINDS),1);

	table->WriteTextL(TPtrC(BIND_1),_L("sms"));

	table->PutRecordChanges();

	CleanupStack::PopAndDestroy();

	}

GLDEF_C void CreateProtocolFamiliesTableL()

	{

	TUint32 Id;

	CCommsDbTableView* table=TheDb->OpenTableLC(TPtrC(PROTOCOL_FAMILIES));

	table->InsertRecord(Id);

	table->WriteTextL(TPtrC(FAMILY_NAME),_L("TCPIP"));

	table->WriteTextL(TPtrC(PFR_FILENAME),_L("tcpip.prt"));

	table->WriteTextL(TPtrC(PROT_SETTINGS),TPtrC(GLOBAL_TCPIP_SETTINGS));

	table->WriteUintL(TPtrC(PROT_SETTINGS_REFERENCE),1);

	table->WriteUintL(TPtrC(P1),TcpProtocolId);

	table->WriteUintL(TPtrC(P2),UdpProtocolId);

	table->WriteUintL(TPtrC(P3),IcmpProtocolId);

	table->WriteUintL(TPtrC(P4),IpProtocolId);

	table->PutRecordChanges();

	table->InsertRecord(Id);

	table->WriteTextL(TPtrC(FAMILY_NAME),_L("IRDA"));

	table->WriteTextL(TPtrC(PFR_FILENAME),_L("irda.prt"));

	table->WriteUintL(TPtrC(PROT_SETTINGS_REFERENCE),1);

	table->WriteUintL(TPtrC(P1),IrmuxProtocolId);

	table->WriteUintL(TPtrC(P2),TinyTPProtocolId);

	table->PutRecordChanges();

 	//

	// extra records for SmsStack added by AlfredH

 	//

 	// from smswap.sms.esk

 	table->InsertRecord(Id);

 	table->WriteTextL(TPtrC(FAMILY_NAME),_L("SMS"));

 	table->WriteTextL(TPtrC(PFR_FILENAME),_L("smsprot.prt"));

 	table->WriteUintL(TPtrC(PROT_SETTINGS_REFERENCE),1);

 	table->WriteUintL(TPtrC(P1),SmsProtocolId);

 	table->PutRecordChanges();

 	// from smswap.wap.esk

 	table->InsertRecord(Id);

 	table->WriteTextL(TPtrC(FAMILY_NAME),_L("WAP"));

 	table->WriteTextL(TPtrC(PFR_FILENAME),_L("wapprot.prt"));

 	table->WriteUintL(TPtrC(PROT_SETTINGS_REFERENCE),1);

 	table->WriteUintL(TPtrC(P1),WapProtocolId);

	table->PutRecordChanges();

	CleanupStack::PopAndDestroy();

	}

LOCAL_C void CreateInterfaceSettingsTableL()

	{

	TUint32 id;

	CCommsDbTableView* table=TheDb->OpenTableLC(TPtrC(INTERFACE_SETTINGS));

	table->InsertRecord(id);

	table->WriteTextL(TPtrC(NIF),TPtrC(ETHINT));

	table->WriteUintL(TPtrC(NIF_REFERENCE),1);

	table->WriteTextL(TPtrC(PACKET_DRIVER),_L("EtherPkt"));

	table->WriteUintL(TPtrC(PACKET_DRIVER_REFERENCE),1);

	table->WriteTextL(TPtrC(LOGICAL_DEVICE),_L("ethercard"));

	table->WriteTextL(TPtrC(LOGICAL_DEVICE_NAME),_L("EtherCard"));

	table->WriteUintL(TPtrC(LOGICAL_DEVICE_REFERENCE),1);

#if !defined(__WINS__)

	table->WriteTextL(TPtrC(PHYSICAL_DEVICE),_L("Ether3com"));

	table->WriteTextL(TPtrC(PHYSICAL_DEVICE_NAME),_L("EtherCard.3com"));

	table->WriteUintL(TPtrC(PHYSICAL_DEVICE_REFERENCE),1);

#else

	table->WriteTextL(TPtrC(PHYSICAL_DEVICE),_L("EtherWins"));

	table->WriteTextL(TPtrC(PHYSICAL_DEVICE_NAME),_L("EtherCard.wins"));

	table->WriteUintL(TPtrC(PHYSICAL_DEVICE_REFERENCE),1);

#endif

	table->PutRecordChanges();

	table->InsertRecord(id);

	table->WriteTextL(TPtrC(NIF),_L("ppp"));

	table->WriteUintL(TPtrC(NIF_REFERENCE),1);

	table->WriteTextL(TPtrC(LOGICAL_DEVICE),_L("ECOMM"));

	table->WriteTextL(TPtrC(LOGICAL_DEVICE_NAME),_L("Comm"));

	table->WriteUintL(TPtrC(LOGICAL_DEVICE_REFERENCE),1);

	table->WriteTextL(TPtrC(PHYSICAL_DEVICE),TPtrC(_L("ECDRV")));

	table->WriteTextL(TPtrC(PHYSICAL_DEVICE_NAME),_L("Comm.Wins"));

	table->WriteUintL(TPtrC(PHYSICAL_DEVICE_REFERENCE),1);

	table->PutRecordChanges();

	table->InsertRecord(id);

	table->WriteTextL(TPtrC(NIF),_L("tnif"));

	table->PutRecordChanges();

	CleanupStack::PopAndDestroy();

	}

#endif

LOCAL_C void CreateChargecardTableL()

/**

 *  @test ChargeCard Database Entry

 */

    {

    TUint32 id;

    CCommsDbTableView* table1=TheDb->OpenTableLC(TPtrC(CHARGECARD));

    CHECKPOINT(table1->InsertRecord(id)==KErrNone);

    table1->WriteTextL(TPtrC(COMMDB_NAME),_L("Dummy BT Chargecard"));

    table1->WriteTextL(TPtrC(CHARGECARD_ACCOUNT_NUMBER),_L("144,12345678"));

    table1->WriteTextL(TPtrC(CHARGECARD_PIN),_L("0000"));

    table1->WriteTextL(TPtrC(CHARGECARD_LOCAL_RULE),_L("HG"));

    table1->WriteTextL(TPtrC(CHARGECARD_NAT_RULE),_L("HFG"));

    table1->WriteTextL(TPtrC(CHARGECARD_INTL_RULE),_L("HEFG"));

    CHECKPOINT(table1->PutRecordChanges()==KErrNone);

    CHECKPOINT(table1->InsertRecord(id)==KErrNone);

    table1->WriteTextL(TPtrC(COMMDB_NAME),_L("Dummy Mercury Chargecard"));

    table1->WriteTextL(TPtrC(CHARGECARD_ACCOUNT_NUMBER),_L("0500800800,,8944223457573566"));

    table1->WriteTextL(TPtrC(CHARGECARD_PIN),_L("****"));

    table1->WriteTextL(TPtrC(CHARGECARD_LOCAL_RULE),_L("HG"));

    table1->WriteTextL(TPtrC(CHARGECARD_NAT_RULE),_L("J,K,0FG"));

    table1->WriteTextL(TPtrC(CHARGECARD_INTL_RULE),_L("HEFG"));

    CHECKPOINT(table1->PutRecordChanges()==KErrNone);

    CleanupStack::PopAndDestroy();

    }

LOCAL_C void CreateLocationTableL( TMyDialLocation aLocDataFax, TMyDialLocation aLocServSMS )

/**

 *  @test Location Database Entries

 */

    {

#ifdef MODEM_PHONE_SERVICES_SMS

    CCommsDbTableView* table4;

    TUint32 id1, id2,id3,id4;

// Office Location

    table4 = TheDb->OpenTableLC(TPtrC(LOCATION));

    CHECKPOINT(table4->InsertRecord(id1)==KErrNone);

    table4->WriteTextL(TPtrC(COMMDB_NAME),_L("Office"));

    table4->WriteTextL(TPtrC(LOCATION_INTL_PREFIX_CODE),_L("00"));

    table4->WriteTextL(TPtrC(LOCATION_NAT_PREFIX_CODE),_L("0"));

    table4->WriteTextL(TPtrC(LOCATION_NAT_CODE),_L("44"));

    table4->WriteTextL(TPtrC(LOCATION_AREA_CODE),_L("171"));

    table4->WriteTextL(TPtrC(LOCATION_DIAL_OUT_CODE),_L("9,"));

    table4->WriteTextL(TPtrC(LOCATION_DISABLE_CALL_WAITING_CODE),KNullDesC);

    table4->WriteBoolL(TPtrC(LOCATION_MOBILE),EFalse);

    table4->WriteBoolL(TPtrC(LOCATION_USE_PULSE_DIAL),EFalse);

    table4->WriteBoolL(TPtrC(LOCATION_WAIT_FOR_DIAL_TONE),EFalse);

    table4->WriteUintL(TPtrC(LOCATION_PAUSE_AFTER_DIAL_OUT),(TUint32)0);

    CHECKPOINT(table4->PutRecordChanges()==KErrNone);

    CleanupStack::PopAndDestroy();

    table4 = NULL;

// Office (without dial out code) Location

    table4 = TheDb->OpenTableLC(TPtrC(LOCATION));

    CHECKPOINT(table4->InsertRecord(id2)==KErrNone);

    table4->WriteTextL(TPtrC(COMMDB_NAME),_L("Office Direct Dial"));

    table4->WriteTextL(TPtrC(LOCATION_INTL_PREFIX_CODE),_L("00"));

    table4->WriteTextL(TPtrC(LOCATION_NAT_PREFIX_CODE),_L("0"));

    table4->WriteTextL(TPtrC(LOCATION_NAT_CODE),_L("44"));

    table4->WriteTextL(TPtrC(LOCATION_AREA_CODE),_L("171"));

    table4->WriteTextL(TPtrC(LOCATION_DIAL_OUT_CODE),KNullDesC);

    table4->WriteTextL(TPtrC(LOCATION_DISABLE_CALL_WAITING_CODE),KNullDesC);

    table4->WriteBoolL(TPtrC(LOCATION_MOBILE),EFalse);

    table4->WriteBoolL(TPtrC(LOCATION_USE_PULSE_DIAL),EFalse);

    table4->WriteBoolL(TPtrC(LOCATION_WAIT_FOR_DIAL_TONE),EFalse);

    table4->WriteUintL(TPtrC(LOCATION_PAUSE_AFTER_DIAL_OUT),(TUint32)0);

    CHECKPOINT(table4->PutRecordChanges()==KErrNone);

    CleanupStack::PopAndDestroy();

    table4 = NULL;

// Mobile Network

    table4 = TheDb->OpenTableLC(TPtrC(LOCATION));

    CHECKPOINT(table4->InsertRecord(id3)==KErrNone);

    table4->WriteTextL(TPtrC(COMMDB_NAME),_L("Mobile"));

    table4->WriteTextL(TPtrC(LOCATION_INTL_PREFIX_CODE),_L("+"));

    table4->WriteTextL(TPtrC(LOCATION_NAT_PREFIX_CODE),_L("0"));

    table4->WriteTextL(TPtrC(LOCATION_NAT_CODE),_L("44"));

    table4->WriteTextL(TPtrC(LOCATION_AREA_CODE),KNullDesC);

    table4->WriteTextL(TPtrC(LOCATION_DIAL_OUT_CODE),KNullDesC);

    table4->WriteTextL(TPtrC(LOCATION_DISABLE_CALL_WAITING_CODE),KNullDesC);

    table4->WriteBoolL(TPtrC(LOCATION_MOBILE),ETrue);

    table4->WriteBoolL(TPtrC(LOCATION_USE_PULSE_DIAL),EFalse);

    table4->WriteBoolL(TPtrC(LOCATION_WAIT_FOR_DIAL_TONE),EFalse);

    table4->WriteUintL(TPtrC(LOCATION_PAUSE_AFTER_DIAL_OUT),(TUint32)0);

    CHECKPOINT(table4->PutRecordChanges()==KErrNone);

    CleanupStack::PopAndDestroy();

    table4 = NULL;

// Home

    table4 = TheDb->OpenTableLC(TPtrC(LOCATION));

    CHECKPOINT(table4->InsertRecord(id4)==KErrNone);

    table4->WriteTextL(TPtrC(COMMDB_NAME),_L("Home"));

    table4->WriteTextL(TPtrC(LOCATION_INTL_PREFIX_CODE),_L("00"));

    table4->WriteTextL(TPtrC(LOCATION_NAT_PREFIX_CODE),_L("0"));

    table4->WriteTextL(TPtrC(LOCATION_NAT_CODE),_L("44"));

    table4->WriteTextL(TPtrC(LOCATION_AREA_CODE),_L("181"));

    table4->WriteTextL(TPtrC(LOCATION_DIAL_OUT_CODE),KNullDesC);

    table4->WriteTextL(TPtrC(LOCATION_DISABLE_CALL_WAITING_CODE),KNullDesC);

    table4->WriteBoolL(TPtrC(LOCATION_MOBILE),EFalse);

    table4->WriteBoolL(TPtrC(LOCATION_USE_PULSE_DIAL),ETrue);

    table4->WriteBoolL(TPtrC(LOCATION_WAIT_FOR_DIAL_TONE),ETrue);

    table4->WriteUintL(TPtrC(LOCATION_PAUSE_AFTER_DIAL_OUT),(TUint32)0);

    CHECKPOINT(table4->PutRecordChanges()==KErrNone);

    CleanupStack::PopAndDestroy();

    table4 = NULL;

	if ( aLocDataFax != EDialLocationChooseManual )

		{

		if ( aLocDataFax == EOffice )

			TheDb->SetGlobalSettingL(TPtrC(LOCATION_DATA_FAX),id1);

		else if ( aLocDataFax == EOfficeDirect )

			TheDb->SetGlobalSettingL(TPtrC(LOCATION_DATA_FAX),id2);

		else if ( aLocDataFax == EMobile )

			TheDb->SetGlobalSettingL(TPtrC(LOCATION_DATA_FAX),id3);

		else if ( aLocDataFax == EHome )

			TheDb->SetGlobalSettingL(TPtrC(LOCATION_DATA_FAX),id4);

		else

			User::Invariant();

		}

	else

		{

		gTest.Printf(_L("\nPlease select the location from which you are dialling for data modem:\n"));

		gTest.Printf(_L("a) Office\n"));

		gTest.Printf(_L("b) Office Direct Dial\n"));

		gTest.Printf(_L("c) Mobile\n"));

		gTest.Printf(_L("d) Home\n"));

		TUint32 ch=gTest.Getch();

		if (ch=='a' || ch=='A')

			TheDb->SetGlobalSettingL(TPtrC(LOCATION_DATA_FAX),id1);

		else if (ch=='b' || ch=='B')

			TheDb->SetGlobalSettingL(TPtrC(LOCATION_DATA_FAX),id2);

		else if (ch=='c' || ch=='C')

			TheDb->SetGlobalSettingL(TPtrC(LOCATION_DATA_FAX),id3);

		else if (ch=='d' || ch=='D')

			TheDb->SetGlobalSettingL(TPtrC(LOCATION_DATA_FAX),id4);

		else

			User::Invariant();

		}

	if ( aLocServSMS != EDialLocationChooseManual )

		{

		if ( aLocServSMS == EOffice )

			TheDb->SetGlobalSettingL(TPtrC(LOCATION_PHONE_SERVICES_SMS),id1);

		else if ( aLocServSMS == EOfficeDirect )

			TheDb->SetGlobalSettingL(TPtrC(LOCATION_PHONE_SERVICES_SMS),id2);

		else if ( aLocServSMS == EMobile )

			TheDb->SetGlobalSettingL(TPtrC(LOCATION_PHONE_SERVICES_SMS),id3);

		else if ( aLocServSMS == EHome )

			TheDb->SetGlobalSettingL(TPtrC(LOCATION_PHONE_SERVICES_SMS),id4);

		else

			User::Invariant();

		}

	else

		{

		gTest.Printf(_L("\nPlease select the location from which you are dialling for modem for sms service:\n"));

		gTest.Printf(_L("a) Office\n"));

		gTest.Printf(_L("b) Office Direct Dial\n"));

		gTest.Printf(_L("c) Mobile\n"));

		gTest.Printf(_L("d) Home\n"));

		TUint32 ch=gTest.Getch();

		if (ch=='a' || ch=='A')

			TheDb->SetGlobalSettingL(TPtrC(LOCATION_PHONE_SERVICES_SMS),id1);

		else if (ch=='b' || ch=='B')

			TheDb->SetGlobalSettingL(TPtrC(LOCATION_PHONE_SERVICES_SMS),id2);

		else if (ch=='c' || ch=='C')

			TheDb->SetGlobalSettingL(TPtrC(LOCATION_PHONE_SERVICES_SMS),id3);

		else if (ch=='d' || ch=='D')

			TheDb->SetGlobalSettingL(TPtrC(LOCATION_PHONE_SERVICES_SMS),id4);

		else

			User::Invariant();

		}

#else // no MODEM_PHONE_SERVICES_SMS defined (old commdb)

	aLocDataFax = aLocServSMS;

    TUint32 ch = 'c';

	if ( aLocServSMS != EDialLocationChooseManual )

		{

		if ( aLocServSMS == EOffice )

			ch = 'a';

		else if ( aLocServSMS == EOfficeDirect )

			ch = 'b';

		else if ( aLocServSMS == EMobile )

			ch = 'c';

		else if ( aLocServSMS == EHome )

			ch = 'd';

		else

			User::Invariant();

		}

	else

        {

	    gTest.Printf(_L("\nPlease select the location from which you are dialling:\n"));

	    gTest.Printf(_L("a) Office\n"));

	    gTest.Printf(_L("b) Office Direct Dial\n"));

	    gTest.Printf(_L("c) Mobile\n"));

	    gTest.Printf(_L("d) Home\n"));

	    ch=gTest.Getch();

        }

	CCommsDbTableView* table4=TheDb->OpenTableLC(TPtrC(LOCATION));

	TUint32 id;

	CHECKPOINT(table4->InsertRecord(id)==KErrNone);

	if (ch=='a' || ch=='A')

		{

// Office Location

		table4->WriteTextL(TPtrC(COMMDB_NAME),_L("Office"));

		table4->WriteTextL(TPtrC(LOCATION_INTL_PREFIX_CODE),_L("00"));

		table4->WriteTextL(TPtrC(LOCATION_NAT_PREFIX_CODE),_L("0"));

		table4->WriteTextL(TPtrC(LOCATION_NAT_CODE),_L("44"));

		table4->WriteTextL(TPtrC(LOCATION_AREA_CODE),_L("171"));

		table4->WriteTextL(TPtrC(LOCATION_DIAL_OUT_CODE),_L("9,"));

		table4->WriteTextL(TPtrC(LOCATION_DISABLE_CALL_WAITING_CODE),KNullDesC);

		table4->WriteBoolL(TPtrC(LOCATION_MOBILE),EFalse);

		table4->WriteBoolL(TPtrC(LOCATION_USE_PULSE_DIAL),EFalse);

		table4->WriteBoolL(TPtrC(LOCATION_WAIT_FOR_DIAL_TONE),EFalse);

		table4->WriteUintL(TPtrC(LOCATION_PAUSE_AFTER_DIAL_OUT),(TUint32)0);

		}

	else if (ch=='b' || ch=='B')

		{

// Office (without dial out code) Location

		table4->WriteTextL(TPtrC(COMMDB_NAME),_L("Office Direct Dial"));

		table4->WriteTextL(TPtrC(LOCATION_INTL_PREFIX_CODE),_L("00"));

		table4->WriteTextL(TPtrC(LOCATION_NAT_PREFIX_CODE),_L("0"));

		table4->WriteTextL(TPtrC(LOCATION_NAT_CODE),_L("44"));

		table4->WriteTextL(TPtrC(LOCATION_AREA_CODE),_L("171"));

		table4->WriteTextL(TPtrC(LOCATION_DIAL_OUT_CODE),KNullDesC);

		table4->WriteTextL(TPtrC(LOCATION_DISABLE_CALL_WAITING_CODE),KNullDesC);

		table4->WriteBoolL(TPtrC(LOCATION_MOBILE),EFalse);

		table4->WriteBoolL(TPtrC(LOCATION_USE_PULSE_DIAL),EFalse);

		table4->WriteBoolL(TPtrC(LOCATION_WAIT_FOR_DIAL_TONE),EFalse);

		table4->WriteUintL(TPtrC(LOCATION_PAUSE_AFTER_DIAL_OUT),(TUint32)0);

		}

	else if (ch=='c' || ch=='C')