Code On Time web applications can have “Custom” actions that trigger business rules.

For example, let’s implement a custom action on orders form to count the number of order details that belong to the order.

Creating Action

Start the Project Designer. In the Project Explorer, switch to the Controllers tab. Right-click on Orders / Actions / ag2 action group node, and press New Action.

Give this action the following properties:

Press OK to save the action.

Creating Business Rule

In the Project Explorer, right-click on Orders / Business Rules node, and press New Business Rule.

Assign the following properties:

declare @CountofOrderDetails int

select distinct @CountofOrderDetails = count(ProductID)
from "Order Details"
where OrderID = @OrderID

set @Result_ShowViewMessage = 
    'This order contains ' +
    cast(@CountofOrderDetails as nvarchar) +
    ' order details.'

Press OK to save the business rule. On the toolbar, press Browse to generate the web app.

Navigate to the Orders page. Select an order – you will see the action Count of Order Details on the form.

Click on the Count of Order Details button, and a message will appear above the view displaying the count of order details.