|
Home > Archive > Commerce Server General > March 2006 > Orders Database in commerce server 2002
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Orders Database in commerce server 2002
|
|
| senthilkumar 2006-03-01, 7:56 am |
| Hi,
Can we use the Orders Table in the commerce server 2002 for storing the
order details.
how to use these tables?
how the Orders are stored in Orders Tables from the aspx page after the
order is placed?
how can we retrieve the details of the Order from Database?
Regards
Senthilkumar
| |
| Ravi Shankar 2006-03-01, 5:52 pm |
| Replies Inline.
All answers available in the documentation which should've installed on your
developer station or available in MSDN library at
http://msdn.microsoft.com/library/?....asp?frame=true
--
Ravi Shankar
"senthilkumar" wrote:
> Hi,
>
> Can we use the Orders Table in the commerce server 2002 for storing the
> order details.
The Orders + a few other tables are USED to store orders.
> how to use these tables?
One does NOT write directly to these tables. When you execute a
basket.SaveAsOrder(), the basket object calls the underlying DBStorage object
with a set of parameters which writes out the basket contents into a set of
tables (3-4 I think)
> how the Orders are stored in Orders Tables from the aspx page after the
> order is placed?
By calling the basket.SaveAsOrder call
> how can we retrieve the details of the Order from Database?
Using the PurchaseOrder Number (vTrackingNumber which is returned on a
Basket.SaveAsOrder call) along with the user_id through a
OrderContext.GetPurchaseOrder(...) call.
>
>
> Regards
> Senthilkumar
>
>
| |
| senthilkumar 2006-03-13, 2:47 am |
| Hi Ravi Shankar,
I got an idea with the Link provided by you Thanks a lot.
With Regards
Senthilkumar
Ravi Shankar wrote:[vbcol=seagreen]
> Replies Inline.
>
> All answers available in the documentation which should've installed on your
> developer station or available in MSDN library at
> http://msdn.microsoft.com/library/?....asp?frame=true
> --
> Ravi Shankar
>
>
> "senthilkumar" wrote:
>
> The Orders + a few other tables are USED to store orders.
>
> One does NOT write directly to these tables. When you execute a
> basket.SaveAsOrder(), the basket object calls the underlying DBStorage object
> with a set of parameters which writes out the basket contents into a set of
> tables (3-4 I think)
>
> By calling the basket.SaveAsOrder call
>
> Using the PurchaseOrder Number (vTrackingNumber which is returned on a
> Basket.SaveAsOrder call) along with the user_id through a
> OrderContext.GetPurchaseOrder(...) call.
|
|
|
|
|