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

[ Post a follow-up to this message ]

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 objec
t
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
>
>

[ Post a follow-up to this message ]

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 yo
ur
> 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 obj
ect
> with a set of parameters which writes out the basket contents into a set o
f
> 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. 

[ Post a follow-up to this message ]