Business Rules/Logic

Labels
AJAX(112) App Studio(9) Apple(1) Application Builder(245) Application Factory(207) ASP.NET(95) ASP.NET 3.5(45) ASP.NET Code Generator(72) ASP.NET Membership(28) Azure(18) Barcode(2) Barcodes(3) BLOB(18) Business Rules(1) Business Rules/Logic(140) BYOD(13) Caching(2) Calendar(5) Charts(29) Cloud(14) Cloud On Time(2) Cloud On Time for Windows 7(2) Code Generator(54) Collaboration(11) command line(1) Conflict Detection(1) Content Management System(12) COT Tools for Excel(26) CRUD(1) Custom Actions(1) Data Aquarium Framework(122) Data Sheet(9) Data Sources(22) Database Lookups(50) Deployment(22) Designer(178) Device(1) DotNetNuke(12) EASE(20) Email(6) Features(101) Firebird(1) Form Builder(14) Globalization and Localization(6) How To(1) Hypermedia(2) Inline Editing(1) Installation(5) JavaScript(20) Kiosk(1) Low Code(3) Mac(1) Many-To-Many(4) Maps(6) Master/Detail(36) Microservices(4) Mobile(63) Mode Builder(3) Model Builder(3) MySQL(10) Native Apps(5) News(18) OAuth(9) OAuth Scopes(1) OAuth2(13) Offline(20) Offline Apps(4) Offline Sync(5) Oracle(11) PKCE(2) Postgre SQL(1) PostgreSQL(2) PWA(2) QR codes(2) Rapid Application Development(5) Reading Pane(2) Release Notes(184) Reports(48) REST(29) RESTful(29) RESTful Workshop(15) RFID tags(1) SaaS(7) Security(81) SharePoint(12) SPA(6) SQL Anywhere(3) SQL Server(26) SSO(1) Stored Procedure(4) Teamwork(15) Tips and Tricks(87) Tools for Excel(3) Touch UI(93) Transactions(5) Tutorials(183) Universal Windows Platform(3) User Interface(338) Video Tutorial(37) Web 2.0(100) Web App Generator(101) Web Application Generator(607) Web Form Builder(40) Web.Config(9) Workflow(28)
Archive
Blog
Business Rules/Logic
Monday, August 6, 2012PrintSubscribe
Drag & Drop Everywhere, Validators & Converters

Code On Time web application generator release 6.0.0.32 makes possible true rapid line-of-business application development with complete support for drag & drop and Cut/Copy/Paste of elements in the logical application hierarchy.

The release also introduces and integrated uniform business rules model. The business rules engine of generated applications supports JavaScript, SQL, and C#/Visual Basic business rules. Developers can quickly create validators and converters to perform data validation and conversion on the client, on the database engine tier, or on the application server tier.

Attention: the client script and theme processor now uses the folder [Documents]\Code OnTime\Client to locate the custom files. If you have developed custom scripts then review custom input elements tutorial and move your files to the new location prior to the installation of the update.

The following features, enhancements, and bug fixes are included in this release:

  • Complete drag & drop and Cut/Copy/Paste support on all levels of hierarchies on Pages, Controllers, and User Controls tabs in Project Designer.
     
  • Single-click implementation of generic validators and converters in supported in Project Designer. Developers can extend the generated business rules with custom business logic.
     
  • Page-level and controller-level caching is implemented in Project Designer. This has significantly improved the speed of Project Designer. The projects with the large number of data controllers and pages will see the most improvement with up to 100 times faster execution of many design operations.
     
  • Command node in Project Explorer offers “Reset to Baseline” action. The action will reset the command text to the current baseline version of it.
     
  • Pager in grid views can now be displayed at the top and/or bottom of the view. The default location is the bottom of the view. The property can be configured in page data views.
     
  • The page numbers in the pager now display the index of the first and last pages if the number of pages is greater than 10.
     
  • Action FileName can be handled in business rules to provide a custom file name for a file produced in response to a command specified in CommandArgument of the ControllerAction attribute. Calling UpdateFieldValue method will cause the output file name to change.
     
  • Static lookup items have dedicated hierarchy nodes in Project Explorer.
     
  • Data controller views support Convert to Grid and Convert to Form options in Project Explorer. Form views use categories to group the data fields bound to the view. All other types of views, such as Grid and Data Sheet, do not support categories. The new options are provided to make possible quick conversion of view types.
     
  • The first “select” command is automatically associated with a new view created in Designer.
     
  • JavaScript business rules allow handling the "After" phase for Select|New|AnyOtherAction.
     
  • JavaScript business rules allow handling "Before" phase of "Select" action.
     
  • Application framework blacklists “Code” business rules after the first execution to prevent multiple invocations.
     
  • SQL Business Rules support access to all "flat" properties of the Arguments property. For example, @Arguments_Trigger or @Arguments_CommandName.
     
  • Dragging a foreign key data field to a master data view on the Pages tab will configure a master-detail relationship.
     
  • Dragging a field on a data controller view will create a data field in the view. The data field is placed in the category if the view is a form.
     
  • Renaming a data controller field will change the command text alias of the field and field references in the entire application.
     
  • Application framework has improved speed of command text parsing at runtime.
     
  • Action buttons rendered in 'Row' scope are rendered under the first data column if
    “Action Column” scope is also enabled.
     
  • Fields with custom format strings will result in a "string" elements created in "Export to Spreadsheet" data feeds to prevent the possible data type clash.
     
  • Page is correctly selected in designer when renamed.
     
  • Virtualization node set plugin "Move" will move data fields to view/category and action to action group.
     
  • Node set plugin "Arrange(DataFields|ActionGroups|Actions|Categories|Views)" does not switch the context of the node set.
  • Role-based trimming is performed when automatic reports are created. The fields with "roles" attribute will be automatically trimmed and hidden from the report when needed.
     
  • The tabs are displayed correctly in the form view categories with conditional visibility.
     
  • JavaScript Business Rules processor of client library always replaces field name references with 'this.fieldValue' and 'this.updateFieldValue' methods even if the field is not defined in the active data view.
     
  • Annotation controls are displayed correctly when activated in modal form views.
     
  • DotNetNuke Factory projects will work with rooted and virtual path deployment models of the portal without any changes to the app source code.
     
  • Data access objects will not try to update the read-only fields if a read-only field has been changed.
     
  • Business rule "Script" property is not deleted when other rule attributes are changed.
     
  • Application framework allows overriding YearsBack and YearsForward properties that control the month and quarter filtering.
  • using System;
    namespace MyCompany.Data
    {
        public partial class DateRangeFilterFunction
        {
            public override int YearsBack
            {
                get
                {
                    return 25;
                }
            }
            public override int YearsForward
            {
                get
                {
                    return 5;
                }
            }
        }
    }
     
Wednesday, August 1, 2012PrintSubscribe
Handling “Custom” Actions

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.

New Action context menu option for action group in the Project Explorer.

Give this action the following properties:

Property Value
Command Name Custom
Command Argument CountOfOrders
Header Text Count of Order Details

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.

New Business Rule context menu option for Business Rules node in the Project Explorer.

Assign the following properties:

Property Value
Type SQL
Command Name Custom
Command Argument CountOfOrders
Phase Execute
Script
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.

Count of Order Details button displayed 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.

When Count of Order Details is pressed, a message is displayed above the view.

Wednesday, July 25, 2012PrintSubscribe
Data Action Notifications

Notifications can be displayed as confirmations after any data manipulation operations.

Let’s implement a code business rule to display a notification after every Update, Insert, and Delete action.

Enable shared business rules. Generate the web app.

Start the Project Designer. On the toolbar, press Develop to open the project in Visual Studio.

In the Solution Explorer, double-click on ~\App_Code\Rules\SharedBusinessRules.cs(vb).

Replace the existing code with the following:

C#:

using System;
using System.Data;
using System.Collections.Generic;
using System.Linq;
using MyCompany.Data;

namespace MyCompany.Rules
{
    public partial class SharedBusinessRules : MyCompany.Data.BusinessRules
    {
        protected override void AfterSqlAction(ActionArgs args, ActionResult result)
        {
            base.AfterSqlAction(args, result);
            if (result.Errors.Count == 0 && args.CommandName == "Update" ||
                args.CommandName == "Insert" || args.CommandName == "Delete")
            {
                Result.ShowAlert("The action {0} has been completed.", args.CommandName);
                Result.Continue();
            }
        }
    }
}

Visual Basic:

Imports MyCompany.Data
Imports System
Imports System.Collections.Generic
Imports System.Data
Imports System.Linq

Namespace MyCompany.Rules

    Partial Public Class SharedBusinessRules
        Inherits MyCompany.Data.BusinessRules

        Protected Overrides Sub AfterSqlAction(args As ActionArgs, result As ActionResult)
            If (result.Errors.Count = 0 And Arguments.CommandName = "Update" Or
                Arguments.CommandName = "Insert" Or Arguments.CommandName = "Delete") Then
                result.ShowAlert("The action {0} has been completed.", Arguments.CommandName)
            End If
        End Sub

    End Class
End Namespace

Save the file. Press Ctrl+F5 to run the web application from Visual Studio.

Navigate to any page, edit a record, and save. A popup window will open, displaying a notification.

Data Action Notification displayed in a popup window.