Blog: Posts from August, 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 August, 2012
Friday, August 31, 2012PrintSubscribe
Creating a New Web App

Let’s create a new Web Site Factory project.

Start Code On Time web application generator and select Web Site Factory under New Project.

Creating a Web Site Factory project on the Start Page of Code On Time web application generator.

The next page will prompt to specify a name and programming language of the project.

Select the programming language of your choice and specify the following name:

Property Value
Name MyProject1

Assigning a name and programming language to the new project.

Press Create button to create the project.

The next page allows changing the Namespace and the version of Microsoft .NET Framework. Leave the default values and press Next.

Configuring the namespace and .NET Framework for the project.

This page allows specifying the Data Provider and Connection String. Select your data provider from the list.

This tutorial uses Microsoft SQL Server database engine. If you do not have a database server, consider installing Microsoft SQL Server 2012 Express.

Click on the button to the right of the Connection String field to open the Connection String Configuration page.

Selecting a Data Provider and activating the Connection String Configurator.

If you have SQL Server Express edition, specify the following:

Property Value
Server .\SQLEXPRESS
Database Northwind
Sample Tables Northwind

To the right of Database field, click on the Create button and confirm to create the database.

Creating a new database on the specified server on the Connection String Configuration page.

To the right of the Sample Tables dropdown, press Install and confirm to populate the project database with the Northwind dataset.

Installing Northwind database tables and data into the specified database.

Code On Time does not offer tools to design databases. Use your favorite database management tools, such as Microsoft SQL Server Management Studio, to work with the database schema.

Our application will have built-in user and role management system. Code On Time applications rely on the security infrastructure available in ASP.NET.

Under Membership section, press Add and confirm to add ASP.NET Membership to the database.

Adding ASP.NET Membership to the database.

You will see a confirmation when the membership has been configured.

Press OK to finish configuration of the database connection string.

Configuration of the database connection string has been finished in a Code On Time web application.

If you are using a trial version of the application generator, the project size is limited to 10 tables or views. To select a subset of tables for the project, click the Change button next to “All database tables and views are included in this project”. Include the following tables: Categories, Customers, Employees, EmployeeTerritories, Order Details, Orders, Products, Shippers, Suppliers, and Territories.

Selecting database tables and views to include in the project.

Press Next twice to reach the Reporting configuration page. Enable dynamic and static reports in the application.

Enable reporting by checking the box on the Reporting Page of the Project Wizard.

Hold down Shift key and press Next – this will skip directly to the Summary page. Press the Generate button to start creation of the web application.

Summary page of the Project Wizard.

When generation is complete, the web site will open in your default browser.

Web Site Factory web application running in a web browser.

Sunday, August 26, 2012PrintSubscribe
New Update Delivery Engine

Occasionally developers need to downgrade to the previous release of the application generator and code generation library when newly introduced features are interfering with project implementations. Code On Time release 7.0.1.0 introduces support for seamless downgrading and upgrading.

If you need to downgrade the product, then uninstall the application generator, navigate to http://codeontime.com/releases/application-generator, and choose the required version.

Upgrading of the application generation does not require uninstalling the previous version.

The following product enhancements and bug fixes are also included:

  • Enhancements to many-to-many field processing to prevent exceptions in business rules.
     
  • "Code" rules will include parameters derived from data controller fields if the type of the field is not Byte[] or Object and the field is not marked as on-demand.
     
  • App generator starts IIS Express on demand without starting the default website.
     
  • Windows Installer now shows the current version of the installed application generator.
     
  • Charts are now generated synchronously to prevent incorrect class naming in projects with large number of charts.
     
  • Enhancements to "Select" action processing.
     
  • Sql and Code business rules support implementation of server-side multi-field copy.
     
  • Report action will close a modal confirmation controller.
     
  • Various improvements to method parameter binding mechanism in Business Rules.
     
  • Business rules will bind arguments of server methods to action argument values and external values.
     
  • Code and SQL business rules can now be used to process "New" and "Select" events on the server. The phase of the business rule must be set to "Execute" for the method to be invoked. Server-side processing of “Edit” action has been removed from the application framework and replaced with “Select”.
     
  • Adding a data field directly to any category in a multi-category form works correctly.
     
  • Reporting and Export actions correctly apply access control rules.
     
  • Dalibor Uremović has contributed Croatia (hr) localication files. Thank you!
     
  • Action "Roles" property is correctly saved by designer.
     
  • Data field "Alias Field Name" property is correctly saved by designer.
Tuesday, August 14, 2012PrintSubscribe
Overview of Field Outputs

Field outputs specify the output target of commands with event set to Inserted or Inserting.

The field outputs can be found in the projects based on Microsoft SQL Server in the data controllers based on the tables with identity primary key. The outputs ensure that the ID of a newly inserted record is transferred from the server to the client.

Field Output Properties:

Property Description
Command Specifies the command that outputs data.
Controller Displays the controller that the field output belongs to.
Field Name Specifies which field the command will output data to. Usually specifies the identity-based primary key of the base data table of the data controller.

Learn to work with field outputs in the Project Designer.