[pezza]

Hello,

I am starting to lose all of my hair at the moment trying to implement Barclays ePDQ in to an ASP.NET shopping cart, and i was hoping that someone may be able to help me???

On first looks at the Barclays Integration Guide, it does actually include 2 scripts as examples, 1 for the encrypted data and 1 for the returned response. However, maybe it is just because i am no good at .NET, but i just cannot follow what is going on in these.

The other thing that i am struggling on, is where i have to call the script from. This is probably impossible to answer as this will be dependant on the cart, i suppose, but i am even struggling to get any proper answers from the support forum, i just get told to read the integration manual

I just cannot grasp whether the entire encryption example should be included within the final checkout page, or whether it should be a standalone page that is called from else where.

I should maybe mention that the cart that i am trying to integrate to is AbleCommerce 7.

Also, the example that handles the response data, only appears to process the transaction response to a text file, and i will need this to update the order in the database, so that is also confusing me.

Would anyone please be able to help me with this? I can provide the examples in the guide, and if necessary the integration guide from Barclays? Maybe it really is just me that is thick! but hopefully someone may be able to grasp it straight away and point me in the right direction.

Thanks In Advance

Andrew

[digioz]

Hello Andrew,

Are you talking about this ePDQ?

Internet authentication - Barclaycard Business

If so, can you post your source code that you have so far? Or have you not been able to start at all?

Also, if you could provide a link to the integration guide you are following it would help.

Thanks,
Pete

[pezza]

Hi Pete,

Thanks for your reply.

The epdq page can be found here...

ePDQ CPI technical information - Barclaycard Business

It looks like Barclaycard has changed its site and the old pages that included the integration guides has disappeared. I can try to find a PDF version and attach that if you like?

I have not started any code yet, but again i can attach the 2 scripts (as text) if that will help.

I sort of understand the process overview, it is just linking it all in, and then finding out how to get the data back in to the db.

I really appreciate any help with this.

Thanks

Andrew

[pezza]

Hi,

The webpage for the integration guide and the sample scripts are here...

Your step-by-step guide to activating ePDQ CPI - Barclaycard Business

Thanks again for taking a look at this.

Andrew

[digioz]

It looks like none of their samples are in ASP.NET. I do however see an ASP sample (although not very informative).

Have you tried emailing their support directly and asking them to see if they have ASP.NET script samples? Otherwise you may have to settle for ASP instead.

Pete

[pezza]

Hi,

Thanks for looking at this for me, much appreciated :-)

There are 2 ASP.NET scripts within the examples, one is an encryption script and the other is to handle the returned response.

The code from the encryption script is as follows...

Code:

Code Behind
VB

Public Class Example
    Inherits System.Web.UI.Page

#Region " Web Form Designer Generated Code "
    'This call is required by the Web Form Designer.
    <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
    End Sub

    Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
        'CODEGEN: This method call is required by the Web Form Designer
        'Do not modify it using the code editor.
        InitializeComponent()
    End Sub
#End Region

    Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        'Put user code to initialize the page here
	
       'The Following Creates the WebClient Object
        Dim web As New System.Net.WebClient()

       'The Header Content Type is then set 
        web.Headers.Add("Content-Type", "application/x-www-form-urlencoded")

       'PostData is then declared as data type Byte and populated with the post data 
        Dim PostData As Byte() = System.Text.Encoding.ASCII.GetBytes("clientid=[clientid]&password=[password]&oid=[orderid]&chargetype=PreAuth&currencycode=826&total=[total]")

        'The Web object is then used to upload the postdata to the Encryption URL and the response is stored in the Response variable
        Dim Response As Byte() = web.UploadData("https://secure2.epdq.co.uk/cgi-bin/CcxBarclaysEpdqEncTool.e", "POST", PostData)

        'The response from the post is then converted from Type Byte to String and stored in the session variable
        Session("Response") = (System.Text.Encoding.ASCII.GetString(Response))

    End Sub
 End Class




ASPX
VB

<%@ Page Language="vb" AutoEventWireup="false" Codebehind="Example.aspx.vb" Inherits="WebProject1.Example"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
	<HEAD>
		<title>Example</title>
		<meta name="GENERATOR" content="Microsoft Visual Studio.NET 7.0">
		<meta name="CODE_LANGUAGE" content="Visual Basic 7.0">
		<meta name="vs_defaultClientScript" content="JavaScript">
		<meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie3-2nav3-0">
	</HEAD>
	<body MS_POSITIONING="FlowLayout">
                                     'The Session Variable is then output to the FORM and on form submit is posted to the CPI 
		<FORM action="https://secure2.epdq.co.uk/cgi-bin/CcxBarclaysEpdq.e" method="post">
			<%= session("Response") %>
			<INPUT type="hidden" name="returnurl" value="http://www.store.co.uk/">
			<INPUT type="hidden" name="merchantdisplayname" value="My Store">
			<INPUT TYPE="submit" VALUE="purchase">
		</FORM>
	</body>
</HTML>

The code for the returned response handling is...

Code:

Code Behind

Public Class Response
    Inherits System.Web.UI.Page

#Region " Web Form Designer Generated Code "

    'This call is required by the Web Form Designer.
    <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()

    End Sub

    Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
        'CODEGEN: This method call is required by the Web Form Designer
        'Do not modify it using the code editor.
        InitializeComponent()
    End Sub

#End Region

    Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        'Put user code to initialize the page here
        Dim fs, fname, path, timestamp

        If Request.ServerVariables("request_method") = "POST" Then

            fs = Server.CreateObject("Scripting.FileSystemObject")

            path = "c:\" 'set your logfile directory path here
            timestamp = Day(Date.Now) & "-" & Month(Date.Now) & "-" & Year(Date.Now)
            timestamp = timestamp & "--" & Hour(Now) & "-" & Minute(Now) & "-" & Second(Now)

            fname = fs.CreateTextFile(path & timestamp & "-" & Request.Form("oid") & ".log", True)

            fname.WriteLine("OrderID - " & Request.Form("oid"))
            fname.WriteLine("Transaction Status - " & Request.Form("transactionstatus"))
            fname.WriteLine("Total - " & Request.Form("total"))
            fname.WriteLine("ClientID - " & Request.Form("clientid"))
            fname.WriteLine("Transaction Time Stamp - " & Request.Form("datetime"))
            fname.Close()

            fname = Nothing
            fs = Nothing
        End If
    End Sub
End Class

The encryption one seems a bit more understandable to me now, although i am still struggling on where i need to place the code (or were i need to call the code page from) and also how i tell my shopping cart to use this processor. I have tried their forum, but they don't seem to willing to help me out on that bit.

The major problem i have at the moment is with the response handling script, as the example seems to pipe out to a text file, and i am struggling with this as it would need to update the shopping carts order. Again, i have asked for help on the shopping carts forum, but they just don't seem to want to help me and just keep telling me to ask Barclays. Barclays would not know the back end database of this shopping cart, so probably at best, they could only give me examples.

Does this code look as if it is pretty much complete? Other than the linking up that i will need to do to trigger the encryption and the db parameters to handle the response?

I am assuming that the encryption code needs to be added to the last checkout page, but i can't understand how it fits together, as i will also have an option to pay by PayPal, so how would it know to ask the customer which payment method/gateway they want to pay with i.e. PayPal or "Visa" (which would be my ePDQ)

Thanks

Andrew

[pezza]

Hi,

I just wanted to give an update.

I have had a reply on the shopping cart forum, that says that i would need to create a new dll (as the payment providers are created as dll's) and then the Admin side would pick up the dll as a new provider/gateway and allow me select and configure it just like all the others.

They have also said that i can use their authorizenet provider / dll as a base point and amend to include the base provider that is expected from Barclays (or words to that affect).

So, it doesn't look like i can call these scripts as individual files, the same as i did with my current shopping cart (which is ASP).

I am going to try to see if i can understand these dll's, but again the forum for the shopping cart are just really telling me what to do, but not really showing me how to do it. I guess that is because they want me to pay thousands of dollars for someone to do that

Anyway, i think i need to break apart the sections from the Barclays examples above, and then merge them in to the providers in order to generate a new ePDQ dll. I am just now worried that the examples are in VB and i have a horrible feeling that they have wrote all their code in C# so that is another obstacle in my way, especially when i have no clue on programming.

Now the begging part...

If i can manage to attempt to interpret all of this, and i can attempt the code and compiling, would you be able to glance over it to see if it seems logical and if it looks like it may work? I appreciate that you won't know how the shopping cart works, but i was hoping that you may be able to see if the flow and the logic seems right? I can send both their code for authorizenet and my attempt with the tweaks in?

Thanks In Advance

[digioz]

Sure, give coding a shot. I will be happy to review the code for you and provide feedback along the way.

Pete

[omkar.mhaiskar]

hi
I m developing web site in asp.net i was frosted because i m not getting proper script to implement. i m getting lots of script but not getting where to post credit card information at which stage send merchants info. please possible help me to solve this matter.......


thanks in advance
Omkar

[pezza]

Hi,

Well I am back again, this time I am still trying to get this blasted ePDQ working with traditional ASP (client decided not to go with the new .NET cart)

I have to say though, i am "almost" there and I am successfully handling the response back from ePDQ and the status in the database is being updated correctly. The only bit that I cannot get to work now, is the Thank You page where I now need to grab the status from the database to display details of the transaction.

The problem is, ePDQ send the order id AND status back to my routine, which updates the database, but only the order id is sent back to the Thank You page for reconciliation. This means that my Thank You page now needs to get the information from the database and the Thank You page is not working. This is a generic page that covers responses from various payment gateways including a custom routine, which is where i come in Problem is, that it uses an #include file to bring in the so-called oid and transaction status but for security purposes (enforced by EPDQ!) I have to secure the folder where this script is, and i think that is making the Thank You page return a 500 Internal Server Error.

My first question would be the hopefully simple one...is it possible to call an #include file by specifying security credentials? Or should this not be the issue?

Secondly, I know that i have my order id returned is present so maybe there is just something different that i need to do in the custom section of the Thank You page to correctly use the oid to query the database and pull back the information to display. If that is the case, can anyone help me with this?

I can obviously provide the full Thank You page code.

I would really appreciate it if someone could help me with this final piece of the jigsaw

Thank you

Andrew