Manual Gateway Processing - Payment Registration Pro

Item		Qty	Total
	{{cartItem.ProductName}} SKU: {{cartItem.ProductSku}}	{{cartItem.Quantity \| number : 2}} x {{cartItem.UnitCost \| currency : '$' : 2}}	{{cartItem.UnitCost * cartItem.Quantity \| currency : '$' : 2}}
{{itemVariant.VariantHasText ? (itemVariant.VariantName + ': ' + itemVariant.VariantText) : (itemVariant.VariantGroup + ': ' + itemVariant.VariantName)}}
You have no items in your shopping cart.
Subtotal	{{minicart.cartTotals.SubTotal \| currency : '$' : 2}}

Image	Item	Qty	Total
	{{cartItem.ProductName}} SKU: {{cartItem.ProductSku}}	{{cartItem.Quantity \| number : 2}} x {{cartItem.UnitCost \| currency : '$' : 2}}	{{cartItem.UnitCost * cartItem.Quantity \| currency : '$' : 2}}
{{itemVariant.VariantHasText ? (itemVariant.VariantName + ': ' + itemVariant.VariantText) : (itemVariant.VariantGroup + ': ' + itemVariant.VariantName)}}
You have no items in your shopping cart.

Status	Order No.	Order Date	Ship To	Order Total	Pay Total	Balance
Bill Me Later Open Ready To Ship Shipped Picked Up Cancelled Incomplete On Hold Back Ordered Returned {{order.Status}}	{{order.OrderID}}	{{order.OrderDate \| date : 'M/d/yyyy'}}	{{order.ShipFirstName}} {{order.ShipLastName}}, {{order.ShipAddress1}} {{order.ShipAddress2}}, {{order.ShipCity}}, {{order.ShipState}} {{order.ShipZipcode}}	{{order.GrandTotal \| currency : '$' : 2}}	{{order.PayTotal \| currency : '$' : 2}}	{{order.GrandTotal - order.PayTotal \| currency : '$' : 2}}

Home

Product Discus...

Payment Registr...

Manual Gateway Processing

3/28/2011 7:11 AM

Scott Autry

Joined: 3/2/2011

Posts: 14

Manual Gateway Processing

We are using the manual gateway configuration.

I've noticed that once a payment is submitted, there's no way for us to process this payment manually though a terminal here because there is no way to see the actual credit card number in the Manage Subscription module.

I thought of connecting to the table via Crystal Reports and creating a report but I don't know how to decrypt the AcctNo field in the Smith_RegPayHist table.

Is there a way to see the full credit card information via the module? Am I missing something?

If there's no way to do this then the manual gateway option is useless.

Please advise ASAP....management breathing down my neck.

3/28/2011 12:26 PM

Scott Kelly

Joined: 3/11/2010

Posts: 1979

Re: Manual Gateway Processing Modified By Scott Kelly on 3/28/2011 12:27:56 PM

The view subscription page that displays the credit card unencrypted only displays subscription records so if the registration is not a recurring billing subscription then the view subscription screen does not display the records. There is a solution though! If you open the store proc "Smith_ListSubscriptionHistoryByFilter" and scroll down to the fourth line from the bottom and make the following change:

Change this:
inner join Smith_Subscription

To this:
left outer join Smith_Subscription

It will display all payment records regardless if they are subscriptions or not and show you the credit card unencrypted so you can process the credit card from your virtual terminal.

-Scott

Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce

3/28/2011 1:18 PM

Scott Autry

Joined: 3/2/2011

Posts: 14

Re: Manual Gateway Processing

Didn't work.

3/28/2011 2:25 PM

Scott Kelly

Joined: 3/11/2010

Posts: 1979

Re: Manual Gateway Processing

There are 2 other places in the same stored proc that you need to change the "inner join Smith_Subscription" to a left outer join. I missed those when I posted above.

-Scott

Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce

3/29/2011 6:35 AM

Scott Autry

Joined: 3/2/2011

Posts: 14

Re: Manual Gateway Processing Modified By Scott Autry on 3/30/2011 5:14:21 AM

Already tried that...doesn't work.

Here's the error if I change this (first insert statement):

SELECT @SearchSQL ='INSERT INTO #TempItems (PayHistID) '+

' select Smith_RegPayHist.PayHistID '+

' from Smith_RegCustomer inner join Smith_RegPayHist '+

' on Smith_RegCustomer.CustomerID=Smith_RegPayHist.CustomerID '+

' inner join Smith_Subscription '+

' on Smith_RegPayHist.CustomerID=Smith_Subscription.CustomerID '

to this:

SELECT @SearchSQL ='INSERT INTO #TempItems (PayHistID) '+

' select Smith_RegPayHist.PayHistID '+

' from Smith_RegCustomer inner join Smith_RegPayHist '+

' on Smith_RegCustomer.CustomerID=Smith_RegPayHist.CustomerID '+

' left outer join Smith_Subscription '+

' on Smith_RegPayHist.CustomerID=Smith_Subscription.CustomerID '

UserAgent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 09bf03f9-afd2-48e3-ae9a-a916aa527638
InnerException: String was not recognized as a valid DateTime.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.DateTimeParse.Parse
StackTrace:
Message: DotNetNuke.Services.Exceptions.PageLoadException: String was not recognized as a valid DateTime. ---> System.FormatException: String was not recognized as a valid DateTime. at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles) at System.Convert.ToDateTime(String value) at Smith.DNN.Modules.Registration.ViewSubscriptionHistory.loadDate(Object str) at ASP.desktopmodules_smithregistrationmanagesub_viewsubscriptionhistory_ascx.__DataBinding__control31(Object sender, EventArgs e) at System.Web.UI.Control.OnDataBinding(EventArgs e) at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) at System.Web.UI.Control.DataBindChildren() at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) at System.Web.UI.Control.DataBindChildren() at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) at System.Web.UI.WebControls.GridView.CreateRow(Int32 rowIndex, Int32 dataSourceIndex, DataControlRowType rowType, DataControlRowState rowState, Boolean dataBind, Object dataItem, DataControlField[] fields, TableRowCollection rows, PagedDataSource pagedDataSource) at System.Web.UI.WebControls.GridView.CreateChildControls(IEnumerable dataSource, Boolean dataBinding) at System.Web.UI.WebControls.CompositeDataBoundControl.PerformDataBinding(IEnumerable data) at System.Web.UI.WebControls.GridView.PerformDataBinding(IEnumerable data) at System.Web.UI.WebControls.DataBoundControl.OnDataSourceViewSelectCallback(IEnumerable data) at System.Web.UI.WebControls.DataBoundControl.PerformSelect() at Smith.DNN.Modules.Registration.ViewSubscriptionHistory.BindgrdViewSubscriptions() at Smith.DNN.Modules.Registration.ViewSubscriptionHistory.Page_Load(Object sender, EventArgs e) at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace ---
Source:
Server Name: LATITUDE

Here's the error if I change the second insert statement:

AbsoluteURLReferrer:
UserAgent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: c095ceb3-f9b1-4b41-884c-ab773e9fc622
InnerException: Unable to cast object of type 'System.DBNull' to type 'System.String'.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: ASP.desktopmodules_smithregistrationmanagesub_viewsubscriptionhistory_ascx.__DataBinding__control25
StackTrace:
Message: DotNetNuke.Services.Exceptions.PageLoadException: Unable to cast object of type 'System.DBNull' to type 'System.String'. ---> System.InvalidCastException: Unable to cast object of type 'System.DBNull' to type 'System.String'. at ASP.desktopmodules_smithregistrationmanagesub_viewsubscriptionhistory_ascx.__DataBinding__control25(Object sender, EventArgs e) at System.Web.UI.Control.OnDataBinding(EventArgs e) at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) at System.Web.UI.Control.DataBindChildren() at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) at System.Web.UI.Control.DataBindChildren() at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) at System.Web.UI.WebControls.GridView.CreateRow(Int32 rowIndex, Int32 dataSourceIndex, DataControlRowType rowType, DataControlRowState rowState, Boolean dataBind, Object dataItem, DataControlField[] fields, TableRowCollection rows, PagedDataSource pagedDataSource) at System.Web.UI.WebControls.GridView.CreateChildControls(IEnumerable dataSource, Boolean dataBinding) at System.Web.UI.WebControls.CompositeDataBoundControl.PerformDataBinding(IEnumerable data) at System.Web.UI.WebControls.GridView.PerformDataBinding(IEnumerable data) at System.Web.UI.WebControls.DataBoundControl.OnDataSourceViewSelectCallback(IEnumerable data) at System.Web.UI.WebControls.DataBoundControl.PerformSelect() at Smith.DNN.Modules.Registration.ViewSubscriptionHistory.BindgrdViewSubscriptions() at Smith.DNN.Modules.Registration.ViewSubscriptionHistory.Page_Load(Object sender, EventArgs e) at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace ---
Source:
Server Name: LATITUDE

3/30/2011 10:35 AM

Scott Kelly

Joined: 3/11/2010

Posts: 1979

Re: Manual Gateway Processing

There is an easy solution to this, open up the ManageSubscription1.ascx page and locate the “account number” column in the datagrid. Uncomment the line highlighted in yellow and comment the line highlighted in aqua and the credit card numbers will be displayed unencrypted

<asp:TemplateColumn HeaderText="Account Number" SortExpression="acctno" HeaderStyle-HorizontalAlign="Left">

<asp:LabelID="lblAcctNo" runat="server" Text='<%#Account((string)DataBinder.Eval(Container.DataItem,"AcctNo")) %>'></asp:Label>

<%-- <asp:Label ID="Label3" runat="server" Text='<%# (DataBinder.Eval(Container,"DataItem.AcctNo")) %>'></asp:Label>--%>

</ItemTemplate>

</asp:TemplateColumn>

Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce

Page 1 of 1

Home

Product Discus...

Payment Registr...

Manual Gateway Processing

You have no items in your shopping cart.

You have 1 item in your shopping cart.

{{multiCartItemsStr.replace('[COUNT]', minicart.cartList.length)}}

Item(s): {{minicart.countCart().Number | number : 2}}

Questions? Contact us for answers!

Services

DNN Modules

Support

Contact Us