Windows Server

Guest

Hi all,

I'm trying to find a way to delete orders in CS.
I cannot find any PurchaseOrder.Delete() method in the base class
library documentation.

An (not preferred) alternative would be to do this using raw SQL
commands : identify the physical tables used by the PurchaseOrder
object, their mutual relationships etc (not very pretty indeed).

It is the case or is there another way to do this ?

We are building an ASP.NET application on top of Commerce Server 2002
SP3 (on Windows 2000).

Thanks,

AMS.

Nihit Kaul [MSFT] · Guest

This is what you need to use:

OrderGroupManager.DeleteOrderGroupFromDisk Method (PIA)

You can look this up in the docs for more details and also look at the
BizDesk code see some working sample code (I looked into it, since I
realized that the bizdesk deletes Orders so there has to be some API for
deleting it). Infact if you are doing a bulk delete, searching and deleting
through BizDesk might be your least expensive option.

You can find the related code in your BizDesk VDir under:
orders\INCLUDE\requisition_util.asp

Thanks,

Nihit Kaul[MSFT]
Commerce Server
http://blogs.msdn.com/nihitk

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
--------------------
Newsgroups: microsoft.public.commerceserver.general
From: nihitk@online.microsoft.com (Nihit Kaul [MSFT])
Organization: Microsoft
Date: Wed, 17 Aug 2005 21:36:07 GMT
Subject: RE: How to delete a PurchaseOrder from ASP.NET ?
X-Tomcat-NG: microsoft.public.commerceserver.general
MIME-Version: 1.0
Content-Type: multipart/alternative;
boundary="--Next.Tomcat.Message.With.ASCII.and.RTF.8973497230230"
Content-Transfer-Encoding: 7bit

Hi AMS,

You are right in that there is no easy way to delete PurchaseOrders, mainly
because only Baskets are typically deleted and there was no real data
mangement API seperate from the runtime APIs in CS 2002.

I would suggest you see if the DBStorage class is of any use in your
scenario (since it has a DeleteData API), else raw SQL is the only way to
delete this data. If you are simply cleaning out the whole database, then
you should look into the Requisition.sql file as well
(SDK\Samples\SiteCreate folder), though if you have extended the database
etc. it will not help you much.

Thanks,

Nihit Kaul[MSFT]
Commerce Server
http://blogs.msdn.com/nihitk

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
--------------------
From: ams8764@netscape.net
Newsgroups: microsoft.public.commerceserver.general
Subject: How to delete a PurchaseOrder from ASP.NET ?
Date: 16 Aug 2005 03:25:44 -0700
Organization: http://groups.google.com
Lines: 19
Message-ID: <1124187944.000362.251130@o13g2000cwo.googlegroups.com>
NNTP-Posting-Host: 62.23.237.17
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1124187949 15249 127.0.0.1 (16 Aug 2005
10:25:49 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 16 Aug 2005 10:25:49 +0000 (UTC)
User-Agent: G2/0.2
Complaints-To: groups-abuse@google.com
Injection-Info: o13g2000cwo.googlegroups.com; posting-host=62.23.237.17;
posting-account=PZ8s3Q0AAAAmg38VabALoICeANiC6nY1
Path:
TK2MSFTNGXA01.phx.gbl!TK2MSFTFEED02.phx.gbl!tornado.fastwebnet.it!tiscali!ne
wsfeed1.ip.tiscali.net!news.maxwell.syr.edu!postnews.google.com!o13g2000cwo.
googlegroups.com!not-for-mail
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:3211
X-Tomcat-NG: microsoft.public.commerceserver.general

Hi all,

I'm trying to find a way to delete orders in CS.
I cannot find any PurchaseOrder.Delete() method in the base class
library documentation.

An (not preferred) alternative would be to do this using raw SQL
commands : identify the physical tables used by the PurchaseOrder
object, their mutual relationships etc (not very pretty indeed).

It is the case or is there another way to do this ?

We are building an ASP.NET application on top of Commerce Server 2002
SP3 (on Windows 2000).

Thanks,

AMS.

Nihit Kaul [MSFT] · Guest

Hi AMS,

You are right in that there is no easy way to delete PurchaseOrders, mainly
because only Baskets are typically deleted and there was no real data
mangement API seperate from the runtime APIs in CS 2002.

I would suggest you see if the DBStorage class is of any use in your
scenario (since it has a DeleteData API), else raw SQL is the only way to
delete this data. If you are simply cleaning out the whole database, then
you should look into the Requisition.sql file as well
(SDK\Samples\SiteCreate folder), though if you have extended the database
etc. it will not help you much.

Thanks,

Nihit Kaul[MSFT]
Commerce Server
http://blogs.msdn.com/nihitk

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
--------------------
From: ams8764@netscape.net
Newsgroups: microsoft.public.commerceserver.general
Subject: How to delete a PurchaseOrder from ASP.NET ?
Date: 16 Aug 2005 03:25:44 -0700
Organization: http://groups.google.com
Lines: 19
Message-ID: <1124187944.000362.251130@o13g2000cwo.googlegroups.com>
NNTP-Posting-Host: 62.23.237.17
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1124187949 15249 127.0.0.1 (16 Aug 2005
10:25:49 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 16 Aug 2005 10:25:49 +0000 (UTC)
User-Agent: G2/0.2
Complaints-To: groups-abuse@google.com
Injection-Info: o13g2000cwo.googlegroups.com; posting-host=62.23.237.17;
posting-account=PZ8s3Q0AAAAmg38VabALoICeANiC6nY1
Path:
TK2MSFTNGXA01.phx.gbl!TK2MSFTFEED02.phx.gbl!tornado.fastwebnet.it!tiscali!ne
wsfeed1.ip.tiscali.net!news.maxwell.syr.edu!postnews.google.com!o13g2000cwo.
googlegroups.com!not-for-mail
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:3211
X-Tomcat-NG: microsoft.public.commerceserver.general

Hi all,

I'm trying to find a way to delete orders in CS.
I cannot find any PurchaseOrder.Delete() method in the base class
library documentation.

An (not preferred) alternative would be to do this using raw SQL
commands : identify the physical tables used by the PurchaseOrder
object, their mutual relationships etc (not very pretty indeed).

It is the case or is there another way to do this ?

We are building an ASP.NET application on top of Commerce Server 2002
SP3 (on Windows 2000).

Thanks,

AMS.

Guest

That is really helpful.
Thanks a lot !

AMS

	Windows Server Forum Index -> Commerce Server	All times are GMT
Page 1 of 1