...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
Overview
On this lesson, we are going to review the “Upload” control that will help us to allocate files under an specific repository in Wayfast. File uploading is a feature for accepting and managing images, videos, PDFs, or other documents. A file uploader looks like a button on a website that opens a dialogue box where they can choose, attach, and submit files. Let’s understand how we can setup this control in simple steps!
Preconditions
1-Create a new table in SQL
Initially we need to create a new table in our database to connect the “Upload” action with the Wayfast repository where we are going to allocate the files.
| Code Block | ||
|---|---|---|
| ||
CREATE TABLE [dbo].[Hola_Mundo_UploadFiles]( [NEWGuid] [varchar](max) NULL, [RepositoryId] [int] NULL, [UserId] [int] NULL ) GO |
2-Create a new stored procedure
This stored procedure establish the connection between the table for upload and the Wayfast repository using the RepositoryID as key parameter to identify in which place this should be stored.
...
Using this stored procedure, we will handle the file insertion on the table where we allocate all the files in the repository.
How to create an Upload control?
Now that we have the table and the stored procedure created, we can start creating the “Upload” control. Let’s synchronize first the objects created in database to make sure that they are now visible in Wayfast.
...
In our later example, we created the control and the action to upload files. We know that this action trigger a return value as “FieldID” that we can use to make them visible, for example, on a grid table. Let’s check how we can show this information from “Upload” control in our application and make these files available to be listed or downloadable.
Preconditions
1-Create a new stored procedure to get all the files uploaded
This stored procedure will select all the files from Hola_Mundo_UploadFiles table and retrieving the information from the Wayfast repository where we stored the uploaded files.
...
Now that we insert the “RepositoryID” into the UploadFiles table, we can use the information to display all the files in grid table under any page in the application.
2-Create a new dataset to get the information from Upload Files table
Before start with the grid table, it’s necessary to create a new dataset in the page.
...
We can take note on the relationship between the “Upload” control and this dataset by clicking on “Add Relationship” button. Now we are ready to make the files visible in the screen.
...
How to list all the uploaded files in the application?
Navigate to “Controls” section and focus again on the “Upload” control previously created in the lesson.
...
Below the “Attach Document” section, we can find the “File” and “Download” columns that shows the information from all the listed files that the user uploaded in the application. If the user wants to download, click on the icon and the file is automatically retrieved from the repository where we stored.
...
How to display an image uploaded into a Wayfast Repository?
select Img='<img src=image.ashk?IdRepositorio='+Cast(@RepositoryId, Varchar)
Recap
In the first part, we revised the preconditions to create a new table in database to stored all the uploaded files in our repository. We understand the important connection between the “Upload” control and the action for this purpose. In the second part, we dove into all the uploaded files in the repository and display them on a grid table that every user can check to download the stored information.