Need to Capture the Order after submit

[BillEisenman]

Where exactly does the order get sent to the DB. I need to capture it and sent it to our Order Processing DB also.

[AbleMods]

Where exactly does the order get sent to the DB. I need to capture it and sent it to our Order Processing DB also.

Not sure precisely what you mean by "where" other than the obvious. The order is stored during the checkout process. The checkout page code is located in the ~/ConLib/OnePageCheckout.ascx user control.

Storing an order is actually performed via the basket instance calling a compiled method. It's not something you can interact with without full source code as it's part of the CommerceBuilder API.

You're probably better off retrieving the order AFTER checkout is complete within the ~/Checkout/Receipt.aspx page. At that point all Able code has acted upon the basket and the order has been stored to the Able db.

[BillEisenman]

It is as I expected. I have already created stored procedures in the ac7 db to retrieve the information that I need. I still would rather get it live though. Do you think that AbleCommerce would allow me access to thee code for customization?

[AbleMods]

It is as I expected. I have already created stored procedures in the ac7 db to retrieve the information that I need. I still would rather get it live though. Do you think that AbleCommerce would allow me access to thee code for customization?

I almost never go straight to the database. The CommerceBuilder data classes have alot of additional functionality that doesn't exist in the db.

The API source code is available for purchase. Just contact Able and they'll be happy to discuss it with you.

[afm]

Where exactly does the order get sent to the DB. I need to capture it and sent it to our Order Processing DB also.

The basket is converted to an order in the PaymentForms (i.e. \Checkout\PaymentForms\CreditCardPaymentForm.ascx). It looks pretty easy to capture the order:

Code: Select all

CheckoutResponse checkoutResponse = Token.Instance.User.Basket.Checkout(checkoutRequest);
if (checkoutResponse.Success)
{
    // Insert code to capture order here [i.e. CaptureOrder(checkoutResponse.OrderId);]
    if (CheckedOut != null) CheckedOut(this, new CheckedOutEventArgs(checkoutResponse.OrderId));
    Response.Redirect(NavigationHelper.GetReceiptUrl(checkoutResponse.OrderId));
}

[BillEisenman]

Thank you very much for your insight Andy. I will try it later this weekend or on Monday.