void LoadBookOfBusiness(string employeeId, string campaignId)
{
	// service.xxx classes are auto-generated xml clases from the WSDL
	service.CustomerData customer = null;
	
	// GetCustomerDataSOAP inherits from System.Web.Services.Protocols.SoapHttpClientProtocol
	using (service.GetCustomerDataSOAP soap = new service.GetCustomerDataSOAP())
	{
		service.Transaction transaction = new service.Transaction();
		service.Header header = new service.Header();
		service.SecurityHeaderType securityHeaderType = new service.SecurityHeaderType();
		service.BinarySecurityTokenType binarySecurityTokenType = new service.BinarySecurityTokenType();
	
		transaction.Trans_name = "CustomerDataTrans";
	
		binarySecurityTokenType.Value = Guid.NewGuid().ToString();
		securityHeaderType.BinarySecurityToken = binarySecurityTokenType;
		header.Security = securityHeaderType;
		header.Transaction = transaction;
	
		soap.Url = "<service url>";
		soap.HeaderValue = header;

		// removed cert retrieval procedd
		soap.ClientCertificates.Add(new X509Certificate2());
	
		Request request = new Request();
		request.EmployeeId = employeeId;
		request.CampaignId = campaignId;
	
		soap.Timeout = 300000;
	
		try
		{
			customer = soap.GetCustomerData(request);
		}
		catch (Exception e)
		{
			Log(e);
		}
	}
	
	if (customer == null)
		return;
	
	using (MemoryStream customerDataStream = new MemoryStream())
	{
		XmlSerializer customerDataSerializer = new XmlSerializer(typeof(service.CustomerData));
		XmlTextWriter customerDataWriter = new XmlTextWriter(customerDataStream, Encoding.UTF8);
		customerDataSerializer.Serialize(customerDataWriter, customer);
	
		SqlParameter customerDataParameter = new SqlParameter("@CustomerData", SqlDbType.Xml);
	
		string xml = Encoding.UTF8.GetString(customerDataStream.ToArray())
			.Replace(" xmlns=\"cusomter_data_namespace\"", "")
			.Replace(" encoding=\"utf-8\"", "");
	
		customerDataParameter.Value = xml;
	
		SQL.ExecuteNonQuery("dbo.usp_OrderProcess_LoadBookOfBusiness__test",
			new SqlParameter("@EmployeeId", (object)employeeId),
			new SqlParameter("@ProductCampaignsID", (object)campaignId),
			customerDataParameter
		);
	}
}

ALTER PROCEDURE [dbo].[usp_OrderProcess_LoadBookOfBusiness__test]
	@EmployeeID char(32),
	@CampaignID char(32),
	@CustomerData xml
AS
SET NOCOUNT ON

DECLARE 
	@mailListID int

EXEC dbo.usp_OrderProcess_LogBookOfBusiness @EmployeeID, @CustomerData

DECLARE 
	@mailLists table ( 
		EmployeeID char(32),
		MailListID int 
	)

DECLARE 
	@mailListItems table ( 
		MailListItemID int, 
		PersonUID varchar(100) 
	)

DECLARE 
	@customers table (
		MailListItemID int,
		EmployeeID char(32),
		PersonUID varchar(100),
		FirstName varchar(50),
		LastName varchar(50),
		Salutation varchar(100),
		AddrStreet varchar(100),
		AddrCity varchar(30),
		AddrState char(2),
		AddrZipCode varchar(10),
		DOB varchar(15)
	)

DECLARE 
	@contracts table (
		PersonUID varchar(100),
		PolNumber varchar(100)
	)

INSERT @customers (
	EmployeeID,
	PersonUID,
	FirstName,
	LastName,
	Salutation,
	AddrStreet,
	AddrCity,
	AddrState,
	AddrZipCode,
	DOB
)
SELECT
	Customer.value('../../EmployeeId[1]', 'varchar(15)'),
	Customer.value('PersonUID[1]', 'varchar(100)'),
	Customer.value('FirstName[1]', 'varchar(50)'),
	Customer.value('LastName[1]', 'varchar(50)'),
	Customer.value('Salutation[1]', 'varchar(100)'),
	Customer.value('AddrStreet[1]', 'varchar(100)'),
	Customer.value('AddrCity[1]', 'varchar(30)'),
	Customer.value('AddrState[1]', 'char(2)'),
	Customer.value('AddrZipCode[1]', 'varchar(10)'),
	Customer.value('DOB[1]', 'varchar(15)')
FROM @CustomerData.nodes('//Customers/Customer') as Customers(Customer)

INSERT @contracts
SELECT 
	[Contract].value('../../PersonUID[1]', 'varchar(100)'),
	[Contract].value('PolNumber[1]', 'varchar(100)')
FROM @CustomerData.nodes('//Contracts/Contract') as Contracts([Contract]);

INSERT dbo.MailList (
	EmployeeID
)
OUTPUT 
	inserted.EmployeeID,
	inserted.MailListID
INTO @mailLists
SELECT
	@EmployeeID

SELECT
	@mailListID = MailListID
FROM @mailLists


INSERT dbo.MailList_Item (
	MailListID, 
	PersonUID,
	FirstName, 
	LastName, 
	Address1, 
	City, 
	[State],
	PostalCode
	DateOfBirth
)
OUTPUT
	inserted.MailListItemID
INTO @mailListItems
SELECT 
	MailListID,
	PersonUID,
	FirstName, 
	LastName,
	AddrStreet, 
	AddrCity, 
	AddrState, 
	AddrZipCode, 
	CONVERT(datetime, DOB)
FROM @customers c

UPDATE c
SET
	c.MailListItemID = mli.MailListItemID
FROM @customers c
INNER JOIN @mailListItems mli
	ON c.PersonUID = mli.PersonUID

INSERT dbo.MailList_Item_AdditionalInfo (
	MailListItemID, 
	Salutation
)
SELECT
	MailListItemID,
	Salutation
FROM @customers

INSERT INTO dbo.MailList_Item_Contracts(
	MailListItemID, 
	PolicyNumber
)
SELECT
	c.MailListItemID, 
	_c.PolNumber
FROM @customers c
INNER JOIN @contracts _c
	ON c.PersonUID = _c.PersonUID

UPDATE bi
SET 
	MailListID = @mailListID
FROM dbo.Basket_Item bi
WHERE EXISTS (
	SELECT 1 FROM dbo.Basket b
	WHERE bi.BasketID = b.BasketID
	AND b.EmployeeID = @EmployeeID
)
AND EXISTS (
	SELECT 1 FROM dbo.Campaigns cp
	WHERE cp.ProdID = bi.ProdID
	AND cp.CampaignID = @CampaignID
)