Skip to end of metadata
Go to start of metadata

You are viewing an old version of this content. View the current version.

Compare with Current View Version History

« Previous Version 9 Next »

Overview

The purpose of this lesson is explain Actions in Wayfast. In previous lessons, we analyzed how to create controls and how they can connect to a dataset. Actions are events that allow us to trigger application interactions including communicating with a database, an API or executing a DLL. In this example we will review how to create an action to store information in a database.

Preconditions

In previous lessons, we talked about Dataset and Controls and how we can create them in our project’s page. Let’s review what are the necessary controls to make the interaction between the app and a database:

  1. Inputbox: This control will allow us to insert data into our database

  2. Button: This control will trigger the insert and it should be connected to the Action that we are going to create

  3. Grid_column: This control will display the values that we have stored into our database

Following this instructions, we can easily build and connect any form page to fill information in minutes.

Click on “Preview” button to verify how the application is depicted in developer environment.  

Now that we have the page created, we will need a Stored Procedure to save the input information in the frontend. Let’s navigate to our database manager, in this example, we are going to open the SQL Server Manager to create the stored procedure. Make sure that we are pointing to the right database that we associate to this project in Wayfast. 

CREATE PROCEDURE spHola_Mundo_AccionesTest_Insert
  @Data1  nvarchar(50)
  @Data2  nvarchar(50)
AS
  BEGIN
    INSERT Hola_Mundo_AccionesTest(Data1,Data2)
	SELECT @Data1, @Data2
  END
GO

@Data1 and @Data2 are connected to the inputbox controls and the grid_column controls previously created in Wayfast. Once that the Stored Procedure is created, we can go back to Wayfast application and synchronize the Stored Procedure in the environment.

Focus on any active requirement and click on “End Task” button

This step is only needed for synchronization of the new Table and Stored Procedure generated in database.

Now we have the new objects available in Wayfast Application to associate with Controls and Actions.

How to create an Action?

Return to Page’s information details.

Click on “Button” link and select “Actions” tab. Then click on “New Action” button to generate this new relation.

A new popup is displayed on screen.

Complete the “Name of the Action” field with the identification for this new action, then select “Stored Procedure” in “Action Groups” since we created a stored procedure in our database for this purpose. Wayfast will display 2 options on “Action” field:

  • FORM is used in Wayfast as unique execution in the whole page. 

  • LIST is an action that can be executed as many times that it’s requested. Mostly this is needed when the page has multiple registries in grid views.

In this example, we are going to execute the action over the entire form.

Make sure that the search on “Stored Procedure” lookup field remain the created stored procedure in database. Once we select the right procedure, we can observe that Wayfast automatically detect the parameters: “Data1” and “Data2”.

These parameters should also be added in the “Parameters” text field “&InpData1” and “&InpData2”. They have to be separated by commas.

Finally choose the instance (environment) where we are going to apply the Actions setting.

Click on “Accept” and the new action is created and connected to the Application.

Run the app

Let’s verify the new action running the application, click on “Preview” button on the page and input new values. Then click on “Add” button which is the control associated to the action that we made recently.

In case we want to verify that the functionality is working as expected in database, open the SQL Server Manager and check if the table has the new input values inserted through the app.

How to update Database with an Action?

One of the common scenarios in the interaction between dataset and actions is the one where the database is updated with new input values but it's not reflected on screen at the moment that was triggered. Let’s analyze what we need to check and how the new action is connected to the Dataset.

Focus on “Dataset” section and click on “Edit” icon related to the corresponding dataset.

A popup is displayed with dataset information. Turn to “Data Binding” tab

Focus on “Control run” field and search by the “Button” control that trigger the insert into our database. Then click on “Add Relationship” button. This interaction will update the input data on page in real time.  

 Click on “Preview” button again on Page

Input new data and click on “Add” button. Every time that we click on the button, the Dataset will be executed and consequently, the information will be refreshed in the grid.

In few minutes, we setup a form to store all the information that we want in database and what is better, this new data is available in real time on the frontend for all the users.

Recap

In the first part, we revised the preconditions to create pages with a basic structure (dataset and controls) and then we learnt how to create new actions that can be related to these Controls previously added. In the second part, we verified how the interaction is executed in the application and how this can be edited to adjust the interaction regarding what we display and what we insert in the database.

  • No labels