re: CS 2007: Where is my CreditCardNumber?

anizhedathitta — Fri, 21 Jul 2006 09:14:41 GMT

what is this?its find the credit card number

Commerce Server 2007: Some Great New Posts!

Jeff Lynch [MVP] — Fri, 18 Aug 2006 05:18:01 GMT

Now that the Commerce Server development team has shipped their flagship product, they've started to publish some great new posts about using Commerce Server 2007. If you don't already subscribe to these blogs, you really should!

re: CS 2007: Where is my CreditCardNumber?

Duwayne — Fri, 13 Apr 2007 22:54:43 GMT

When you say "In the case of PurchaseOrders extend the mapping and create one from this strongly typed property to an explicit column in the CreditCardPayments table." do you mean to go to OrderObjectMappings.xml and add new "CreditCardNumber" element for <Class Name="CreditCardPayments"> and <Table Name="CreditCardPayments">? Is there anything else I am missing?

re: CS 2007: Where is my CreditCardNumber?

nihitk — Fri, 13 Apr 2007 23:25:58 GMT

Hi Duwayne,

Yes - that is all that you should need to do. The column will need to be created in the table as well - but I am assuming you will do that by generating the SQL files using OrderMapping.exe (or you should just add the column yourself as well).

Of course - you should enrypt this data and make sure you have thought through the security implications of storing this information since it is highly confidential (and that is the reason this is not provided out of the box).

Thanks,

Nihit

Thanks,

Nihit

re: CS 2007: Where is my CreditCardNumber?

dmsy — Sat, 14 Apr 2007 01:03:02 GMT

Nihit,

Thanks for the quick reply. So far this is what I have done:

In OrderObjectMappings.xml

- add <Column Name="CreditCardNumber" DataType="nvarchar" Precision="40" IsNullable="true" /> in <Table Name="CreditCardPayments">

- add <Property Name="CreditCardNumber"/> in <Class Name="CreditCardPayment">

- add <PropertyMap Property="CreditCardNumber" Column="CreditCardNumber" /> in <ClassTableMap Class="CreditCardPayment" Table="CreditCardPayments">

- add new column in CreditCardPayment matching the definition above.

- iisreset

I got an exception when calling SaveAsOrder(). I didnt do the second part for Baskets.

Error in event log

-------------------------------------------------

Event code: 3005

Event message: An unhandled exception has occurred.

Event time: 4/13/2007 2:39:58 PM

Event time (UTC): 4/13/2007 9:39:58 PM

Event ID: 9dc3986a941748c386c40cd97cd6d5a3

Event sequence: 12

Event occurrence: 2

Event detail code: 0

Application information:

Application domain: /LM/w3svc/1/Root/DHC-1-128209738988906250

Trust level: Full

Application Virtual Path: /DHC

Application Path: c:\inetpub\wwwroot\DHC\

Machine name: SVCTAG-G2GJ571

Process information:

Process ID: 1948

Process name: w3wp.exe

Account name: SVCTAG-G2GJ571\ssRunTimeUser

Exception information:

Exception type: TransactionException

Exception message: The operation is not valid for the state of the transaction.

Request information:

Request URL: http://localhost/DHC/Checkout/Checkout.aspx

Request path: /DHC/Checkout/Checkout.aspx

User host address: 127.0.0.1

User: dsy@dhccare.com

Is authenticated: True

Authentication Type: Forms

Thread account name: SVCTAG-G2GJ571\ssRunTimeUser

Thread information:

Thread ID: 5

Thread account name: SVCTAG-G2GJ571\ssRunTimeUser

Is impersonating: False

Stack trace: at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)

at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)

at Microsoft.CommerceServer.Internal.Orders.MtsHelper.ExecuteSqlCommandDataSet(String connStr, String commandText, CommandType commandType, ArrayList sqlParameterHelpers, Int32 timeout)

at Microsoft.CommerceServer.Runtime.Orders.OrderGroup.Save(Int32 maxInstances, String baseClassName, String tableInsertSprocName, PropertyColumnMapping[] stronglyTypedMappings, PropertyColumnMapping[] weaklyTypedMappings, DetailedSqlColumnInformation indexerColumnInfo)

at Microsoft.CommerceServer.Runtime.Orders.Basket.Save()

at Microsoft.CommerceServer.Runtime.Orders.Basket.SaveAsOrder(ITransaction trans)

at Microsoft.CommerceServer.Runtime.Orders.Basket.SaveAsOrder()

at Checkout_Checkout.ExecuteTransactedCheckout() in c:\Inetpub\wwwroot\DHC\Checkout\Checkout.aspx.cs:line 294

at Checkout_Checkout.bNext_Click(Object sender, EventArgs e) in c:\Inetpub\wwwroot\DHC\Checkout\Checkout.aspx.cs:line 590

at System.Web.UI.WebControls.Button.OnClick(EventArgs e)

at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)

at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)

at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)

at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)

at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

re: CS 2007: Where is my CreditCardNumber?

Tony — Mon, 22 Sep 2008 22:35:25 GMT

I get the same error, does anybody have a solution for this?