Code On Time: Code Generator

Blog

Code Generator

Wednesday, February 13, 2013Print Subscribe

The “Filter Expression” property allows limiting the records displayed in a specific view by an SQL compatible logical expression.

The default Orders grid view in a sample Northwind web application displays all orders.

Let’s create a new view by the name of “Orders This Month” that will only display orders placed in the current month.

Start the Project Designer. In the Project Explorer, switch to the Controllers tab. Right-click on Orders / Views / grid1 node, and press Copy.

Right-click on Views, and press Paste. A duplicate of view “grid1” will be created.

The properties screen for the new view will be open in the Project Browser. Make the following changes:

Property	New Value
Label	Orders This Month
Filter Expression	$thismonth(OrderDate)

Press OK to save. Double-click on Orders / Views / grid1 node.

Change the label:

Property	New Value
Label	All Orders

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

Navigate to the Orders page. The All Orders view will continue to display an unfiltered list of orders.

Use the View Selector dropdown in the top-right corner to switch to the Orders This Month view. Only orders placed in the current month will be displayed.

When the command is configured in order to retrieve data from the database, the Filter Expression is parsed by the application framework and any standard filter operators will be replaced by the SQL equivalent. SQL compatible logical expressions may also be used. In the example above, the filter is passed to the application framework as the following:

$thismonth(OrderDate)

The framework converts the filter to the following where expression.

"Orders"."OrderDate" between @p0 and @p1

This expression is then inserted into the select command and passed to the server.

with page_cte__ as (
select
row_number() over (order by "Orders"."OrderID") as row_number__
,"Orders"."CustomerID" "CustomerID"
,"Orders"."EmployeeID" "EmployeeID"
,"Orders"."OrderDate" "OrderDate"
,"Orders"."RequiredDate" "RequiredDate"
,"Orders"."ShippedDate" "ShippedDate"
,"Orders"."ShipVia" "ShipVia"
,"Orders"."Freight" "Freight"
,"Orders"."ShipName" "ShipName"
,"Orders"."ShipAddress" "ShipAddress"
,"Orders"."ShipCity" "ShipCity"
,"Orders"."OrderID" "OrderID"
,"Customer"."CompanyName" "CustomerCompanyName"
,"Employee"."LastName" "EmployeeLastName"
,"ShipVia"."CompanyName" "ShipViaCompanyName"
from
"dbo"."Orders" "Orders"
    left join "dbo"."Customers" "Customer" on "Orders"."CustomerID" = "Customer"."CustomerID"
    left join "dbo"."Employees" "Employee" on "Orders"."EmployeeID" = "Employee"."EmployeeID"
    left join "dbo"."Shippers" "ShipVia" on "Orders"."ShipVia" = "ShipVia"."ShipperID"

where
(
("Orders"."OrderDate" between @p0 and @p1)
)
select * from page_cte__ where row_number__ > @PageRangeFirstRowNumber 
    and row_number__ <= @PageRangeLastRowNumber

Labels: Application Builder, Code Generator, SQL Server, Web Application Generator

Saturday, December 8, 2012Print Subscribe

HR Sample App (Oracle)

Sample database HR (Human Resources) comes standard with Oracle database server. Let’s create a web application straight from this database.

Getting Oracle on Your Computer

First, download the Oracle Database Express Edition 11g Release 2 installation files.

When the download is complete, extract the zip folder. Run the file at DISK1\setup.exe. Follow the steps to install Oracle Express Edition 11g on your computer.

When the database server has been installed, log in to the management website. The link to the page is available at C:\oraclexe\app\oracle\product\11.2.0\server\Get_Started.url. In the web browser, click on the Application Express tab, and create a workspace in order to access the database.

Native vs. Managed Data Provider

Code On Time web application generator creates web apps based on Microsoft ASP.NET, a component of Microsoft.NET technology. Database vendors offer middleware that allows ASP.NET applications to communicate with their servers. Oracle offers two providers:

The ODP.NET (Oracle Data Provider) is included in the Oracle Data Access Components (ODAC) for Windows package. The provider is a managed .NET wrapper that “speaks” to unmanaged native API of Oracle database server.

Because of this mix of managed and unmanaged code, there is a need to install both 32-bit and 64-bit versions of ODP.NET when working with Windows 7 and 8. Some components of development tools for Windows support only 32-bit architecture. Each version of ODP is around 230 MB in size.

The ODP.NET, Managed Driver is less than 2 MB in size and written purely in .NET. It has better performance and is easier to configure. This is the recommended .NET provider for ASP.NET web applications.

Click on one of the links above and install one of the providers for Oracle.

Creating a Web Application

Start the code generator, and click on the Create a new web application link on the start page. Select Web Site Factory to create the project.

Assign the project a name of “HR”, select the programming language of your choice (C# or Visual Basic), and press Create.

Leave the default Namespace and Framework values and press Next.

Select the desired ODP provider in the Data Provider dropdown, and click on the “…” button next to Connection String field to access the Oracle Connection screen.

Enter your Server name, User name, and Password in the appropriate fields.

If you are working with Oracle Express Edition and using ODP.NET Managed Driver, leave the Server name blank. If you are using ODP.NET , then enter “127.0.0.1” in the Server name.

Press the Test button to test the connection string.

Press OK to dismiss the Connection Status window, and press OK to insert the configured connection string into the field.

Press Next twice to reach the Reporting page. Check the box to enable reporting.

Press Next to reach the Themes page. Select Social from the list box.

Hold down Shift, and press Next to skip to the Summary screen.

Press Generate to start the code generation. A window will open in your default web browser with the web app when complete.

Learn how to configure Custom Membership and Role Provider for your Oracle database.

Labels: Application Builder, Application Factory, ASP.NET Membership, Code Generator, Installation, Oracle, Tutorials, Web Application Generator

Friday, October 19, 2012Print Subscribe

Order Form Sample–Part 6

You will now be on the Database Connection page. If you are using a free version of the generator, you are limited to 10 tables. You can select tables to generate by clicking on the Change link underneath the Connection String field. Include the following tables: Categories, Customers, Employees, Order Details, Orders, Products, Shippers, and Suppliers.

If you have a licensed version, you can skip selection of tables.

Once the database connection has been set up, keep pressing Next until you reach the Reporting page. Check the box to enable reporting, and press Next.

On the Authentication and Membership page, you can see that ASP.NET Membership has automatically been configured, provided that you installed the membership on the connection string page. If membership had already been added to your database previously, you can just click on Status button on the connection string page to make Code On Time configure the settings automatically.

Press Next, and you will be taken to the Features page. Under Page Header, insert “Order Form Sample”.

Switch to the Permalinks and History section, and enable both checkboxes.

Press Next twice to reach the Theme page. Select Modern theme. You can view samples of all the themes at http://codeontime.com/learn/introduction/user-interface/themes-a-c.

Hold down Shift key, and press next to skip to the Summary page. Press Generate.

When the generation is completed, the new web application will open in your default browser.

Labels: Code Generator, Tutorials, Web Application Generator