Question

How do I get the status of an order from its order product's OrderProductInserting event sub-process?

18:32 Apr 15, 2023

Hi community,

When an order is completed (status), we need to prevent users from adding order product either by clicking the + button, or by data import.

So I enabled the Before record added event of OrderProduct, and created the OrderProductInserting event sub-process trying to stop new orderproduct added if its relating order's status is completed.

I have tried successfully to stop orderproduct from adding as the code screenshots provided here. But what I don't know is how to get the order's status from within the method OrderProductInserting() so that I can call the ThrowInsertException() function to stop the order product added.

Any code example will be very appreciated!

Andrew

2 comments

Best reply

Dmytro Vovchenko

15:54 Apr 19, 2023

Hello Andrew,

Here is an example of how to read OrderStatus Id inside the event process:

var order = Entity.GetTypedColumnValue&lt;Guid&gt;("OrderId");
			var orderESQ = new EntitySchemaQuery(UserConnection.EntitySchemaManager, "Order");
			orderESQ.UseAdminRights = true;
			orderESQ.AddColumn("Id");
			orderESQ.AddColumn("Status");
			var entity = orderESQ.GetEntity(UserConnection, order);
    		var status = entity.GetColumnValue("StatusId").ToString();
    		if (status == "{Completed OrderStatus Id}"){
    			// DO Something
    		}

Dmytro Vovchenko

15:54 Apr 19, 2023

Hello Andrew,

Here is an example of how to read OrderStatus Id inside the event process:

var order = Entity.GetTypedColumnValue&lt;Guid&gt;("OrderId");
			var orderESQ = new EntitySchemaQuery(UserConnection.EntitySchemaManager, "Order");
			orderESQ.UseAdminRights = true;
			orderESQ.AddColumn("Id");
			orderESQ.AddColumn("Status");
			var entity = orderESQ.GetEntity(UserConnection, order);
    		var status = entity.GetColumnValue("StatusId").ToString();
    		if (status == "{Completed OrderStatus Id}"){
    			// DO Something
    		}

Andrew Sheng

11:38 Apr 20, 2023

Hi Dmytro, appreciate very much for the help. It works!

Show all comments