%%[[name="FormPost";type="POST"]VAR @de, @de_col, @de_statusCode, @de_statusMsg, @errorCode
SET @de = CreateObject("DataExtensionObject")
SetObjectProperty(@de, "CustomerKey", "B9E6A94B-ED80-40E8-BF8D-757653F5EB8F")
IF NOT IsNull(RequestParameter("FirstName")) THEN
SET @de_col = CreateObject("APIProperty")
SetObjectProperty(@de_col, "Name", "FirstName")
SetObjectProperty(@de_col, "Value", RequestParameter("FirstName"))
AddObjectArrayItem(@de, "Properties", @de_col)
ENDIF
IF NOT IsNull(RequestParameter("MainAccountNumber")) THEN
SET @de_col = CreateObject("APIProperty")
SetObjectProperty(@de_col, "Name", "MainAccountNumber")
SetObjectProperty(@de_col, "Value", RequestParameter("MainAccountNumber"))
AddObjectArrayItem(@de, "Properties", @de_col)
ENDIF
IF NOT IsNull(RequestParameter("EmailAddress")) THEN
SET @de_col = CreateObject("APIProperty")
SetObjectProperty(@de_col, "Name", "EmailAddress")
SetObjectProperty(@de_col, "Value", RequestParameter("EmailAddress"))
AddObjectArrayItem(@de, "Properties", @de_col)
ENDIF
IF NOT IsNull(RequestParameter("LastName")) THEN
SET @de_col = CreateObject("APIProperty")
SetObjectProperty(@de_col, "Name", "LastName")
SetObjectProperty(@de_col, "Value", RequestParameter("LastName"))
AddObjectArrayItem(@de, "Properties", @de_col)
ENDIF
SET @de_statusCode = InvokeCreate(@de, @de_statusMsg, @errorCode)
IF @de_statusCode != "OK" THEN
Redirect('https://www.cityindex.co.uk/professional-client/rebates/error/')
Else
Set @EmailAddress = RequestParameter("EmailAddress")
Set @AccountNumber = RequestParameter("MainAccountNumber")
Set @AccountNumber1 = RequestParameter("MainAccountNumber")
set @SpreadBettingTradingAccountCode = Lookup("City_Index_EDS_Feed_Client","SpreadBettingTradingAccountCode","SpreadBettingTradingAccountCode",@AccountNumber)
set @ServiceOffering = Lookup("City_Index_EDS_Feed_Client","ServiceOffering","SpreadBettingTradingAccountCode",@AccountNumber)
set @ClientAccountStatus = Lookup("City_Index_EDS_Feed_Client","ClientAccountStatus","SpreadBettingTradingAccountCode",@AccountNumber)
set @RegulatoryClassification = Lookup("City_Index_EDS_Feed_Client","RegulatoryClassification","SpreadBettingTradingAccountCode",@AccountNumber)
set @EmailAddress1 = Lookup("City_Index_EDS_Feed_Client","EmailAddress","SpreadBettingTradingAccountCode",@AccountNumber)
set @CBDID = Lookup("City_Index_EDS_Feed_Client","SalesforceContactKey","SpreadBettingTradingAccountCode",@AccountNumber)
set @CFDTradingAccountCode = Lookup("City_Index_EDS_Feed_Client","CFDTradingAccountCode","CFDTradingAccountCode",@AccountNumber1)
set @EmailAddress2 = Lookup("City_Index_EDS_Feed_Client","EmailAddress","CFDTradingAccountCode",@AccountNumber1)
if @AccountNumber == @SpreadBettingTradingAccountCode AND @EmailAddress1 == @EmailAddress Then
UpdateData('CI-UK-EN-Monthly-Cash-Rebate',2,'EmailAddress',@EmailAddress,'MainAccountNumber',@AccountNumber,'ServiceOffering',@ServiceOffering,'ClientAccountStatus',@ClientAccountStatus,'RegulatoryClassification',@RegulatoryClassification,'CBDID',@CBDID)
UpdateSingleSalesforceObject("Contact_Brand_Details__c",@CBDID,"Rebate_Optin_Account__c",@AccountNumber)
elseif @AccountNumber1 == @CFDTradingAccountCode AND @EmailAddress2 == @EmailAddress Then
set @CFDServiceOffering = Lookup("City_Index_EDS_Feed_Client","ServiceOffering","CFDTradingAccountCode",@AccountNumber1)
set @CFDClientAccountStatus = Lookup("City_Index_EDS_Feed_Client","ClientAccountStatus","CFDTradingAccountCode",@AccountNumber1)
set @CFDRegulatoryClassification = Lookup("City_Index_EDS_Feed_Client","RegulatoryClassification","CFDTradingAccountCode",@AccountNumber1)
set @CFDCBDID = Lookup("City_Index_EDS_Feed_Client","SalesforceContactKey","CFDTradingAccountCode",@AccountNumber1)
UpdateData('CI-UK-EN-Monthly-Cash-Rebate',2,'EmailAddress',@EmailAddress,'MainAccountNumber',@AccountNumber1,'ServiceOffering',@CFDServiceOffering,'ClientAccountStatus',@CFDClientAccountStatus,'RegulatoryClassification',@CFDRegulatoryClassification,'CBDID',@CFDCBDID)
UpdateSingleSalesforceObject("Contact_Brand_Details__c",@CFDCBDID,"Rebate_Optin_Account__c",@AccountNumber1)
else Redirect('https://www.cityindex.co.uk/professional-client/rebates/error/')
endif
Redirect('https://www.cityindex.co.uk/professional-client/rebates/thank-you')
endif
ENDIF]%%