Blog: Posts from December, 2012

Labels
AJAX(112) App Studio(6) 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(177) 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(8) OAuth Scopes(1) OAuth2(11) Offline(20) Offline Apps(4) Offline Sync(5) Oracle(10) PKCE(2) PostgreSQL(2) PWA(2) QR codes(2) Rapid Application Development(5) Reading Pane(2) Release Notes(178) Reports(48) REST(29) RESTful(29) RESTful Workshop(15) RFID tags(1) SaaS(7) Security(80) SharePoint(12) SPA(6) SQL Anywhere(3) SQL Server(26) Stored Procedure(4) Teamwork(15) Tips and Tricks(87) Tools for Excel(2) 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
Posts from December, 2012
Saturday, December 29, 2012PrintSubscribe
Overview of Batch Edit

The “Batch Edit” action allows users to change field values of multiple records at the same time. In order for the action to work properly, multiple selection must be enabled.

Inline Batch Edit

To perform a batch edit, first check the boxes next to several rows in a grid. Using the context menu, click on the “Batch Edit” action.

Activating the Batch Edit action in the row context menu.

Check the box underneath the field that you want to update and enter a new value.

Batch updating the Contact Title field.

Press the Update Selection button to save the value. All rows that were checked will be updated.

All checked rows were updated.

Form Batch Edit

Batch edit can also be performed in the form. Check the boxes next to the rows to update. Use the context menu to select Batch Edit (Form) action.

Activating the 'Batch Edit (Form)' option.

Again, check the boxes under the field that will be updated, and insert a value.

Updating the Contact Title field.

Press Update Selection button. The field values will be updated for the checked rows.

The field values have been updated.

Enabling Batch Edit for a Single Controller

Batch editing is not enabled by default in Code On Time web applications. For example, the Suppliers controller does not have the action available.

Batch Edit option not available in Suppliers.

Let’s enable batch edit for the Suppliers controller.

Start the web application generator. Click on the project name, and select Settings. Click on Features.

Make the following changes:

Property Value
Enable multiple-selection in all grid views… true
Enable batch editing in all data controllers… true

Press Finish to skip to the Summary page. Click Refresh, and check the box next to Suppliers controller. Continue to regenerate the web application.

Refreshing the Suppliers controller.

When the web application is loaded in your browser, navigate to the Suppliers page. The Batch Edit options will be available in the row context menu.

Suppliers now has the 'Batch Edit' command.

Saturday, December 29, 2012PrintSubscribe
Configuring “Save and Next” Button

A commonly integrated feature in many business applications is a button to save and move to the next record in form view. This allows users to rapidly change many records.

Let’s implement a “Save and Next” action on the Orders form.

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

Creating a new action on the form of Orders controller.

Assign the following values:

Property Value
Command Name Update
Command Argument Next
Header Text Next
When Last Command Name Edit

Press OK to save the action. Drop a100 – Update, Next when Edit | Next action node on the left side of a1 – Edit to place it first in the form.

Dropping action 'a100' on the left side of 'a1'.     Action 'a100' placed first on the form.

Right-click on Orders / Business Rules, and press New Business Rule.

Creating a new business rule for Orders controller.

Assign these values:

Property Value
Type JavaScript
Command Name Update
Command Argument Next
Phase After
Script
if (this.validateInput()) {
    this.preventDefault();
    this.dataView()._advance(1);
}

Press OK to save. On the toolbar, press Browse.

Navigate to the Orders page, and start editing a record.

Editing a record, and pressing 'Next' to save and edit the next record.

Press the Next button – the record will save and the next record will be displayed.

The next record is displayed.

Return to the grid and notice that the changes have been applied.

The changes have been applied to the order records.

Saturday, December 29, 2012PrintSubscribe
On-Demand Handler Property

The Products table in the Northwind database includes a foreign key reference to CategoryID column of Categories table. Code On Time generator adds the CategoryName field in the Products controller through automatic denormalization. In addition to the CategoryName field, let’s denormalize the Picture field in order to include it in the Products grid.

Start the web application generator. Click on the project name, and select Settings. Click on Business Logic Layer option. Switch to the Denormalization Map section, and paste in the following:

dbo.Products => dbo.Categories
Picture

Defining a Denormalization Field Map in the Project Wizard.

Press Finish to skip to the Summary page, and then press Refresh. Check the box next to Products controller, and continue to refresh the project.

Refreshing the Products controller.

On the Summary page, click on Design to bring up the Project Designer.

In the Project Explorer, switch to the Controllers tab. Double-click on Products / Fields / CategoryPicture (Byte[], read-only) field node.

Selecting 'CategoryPicture' field of Products controller.

Change the following values:

Property New Value
On Demand Handler CategoriesPicture

This will prompt the application framework to populate the field using the same handler that populates the Picture field in Categories controller. Press OK to save the field.

Drop Products / Fields / CategoryPicture (Byte[], read-only) field node onto Products / Views / grid1.

Dropping 'CategoryPicture' field node onto view 'grid1'.     Data field for 'CategoryPicture' instantiated in view 'grid1'.

On the toolbar, press Browse. Navigate to the Products page. The Category Picture column will now be populated with images.

Field 'Category Picture' is populated with pictures from the Categories table.