Blog: Posts from March, 2012

Labels
AJAX(112) App Studio(7) 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(9) OAuth Scopes(1) OAuth2(13) Offline(20) Offline Apps(4) Offline Sync(5) Oracle(11) PKCE(2) Postgre SQL(1) PostgreSQL(2) PWA(2) QR codes(2) Rapid Application Development(5) Reading Pane(2) Release Notes(183) Reports(48) REST(29) RESTful(29) RESTful Workshop(15) RFID tags(1) SaaS(7) Security(81) SharePoint(12) SPA(6) SQL Anywhere(3) SQL Server(26) SSO(1) 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 March, 2012
Friday, March 2, 2012PrintSubscribe
Adding the Order Form Page

Let’s create a new page in the application. Switch back to the web application generator, click on the “OrderForm” project name, and press Design.

The design environment allows you to change logical aspects of the project, and consists of two primary elements. The Project Designer, on the left side of the screen, displays a list of objects or properties of the selected object. On the right side of the screen, the Project Explorer allows you to browse and manipulate pages, controllers, and user controls. At the top of the screen, there are several buttons. The Generate button regenerates the web application and displays it in a built-in browser window, called Preview. The Browse button will regenerate the application and open it in your default browser. The Exit button goes back to the web application generator.

Code On Time Project Designer and Explorer

Let’s add a new page called Order Form. In the Designer’s action bar, press New | New Page. Give this page the following settings:

Property Value
Name OrderForm
Index 1005
Title Order Form
Path Order Form
Description This is the order management form.
Style Miscellaneous
About This Page This is the order management form.
Roles (blank)

Press OK to save the page.

Order Form Page in Code On Time web application generator

We’ll need to add a container to this page to store the data views. In the Explorer, right-click on the Order Form page, and press New Container. None of the default properties need to be changed, so just press OK to save the container.

New container in Code On Time Designer

Let’s add an Orders data view. Right-click on the newly created container in the Explorer, and press New Data View. Enter the following settings for the data view.

Property Values
Controller Orders
View grid1
Show Details in List Mode False

New Orders Data View in Code On Time Designer

Press OK to save the data view.

Let’s add another data view to show Order Details. Right-click on the container again and press New Data View. Enter the following settings:

Property Values
Controller Order Details
View grid1
Show View Description False
Show View Selector False
Show Pagers False
Page Size 300
Show Modal Forms True
Filter Source dv100
Filter Field OrderID
Auto-Hide Self

New Order Details Data View

Press OK to save the data view. Press Generate in the top left corner, and wait for the Preview window to open. Log in, and you will see Order Form page on the menu bar and the site map.

Code On Time Designer Preview of generated web application

Click on the Order Form link, and you will see a list of orders.

Order Form page in Code On Time Designer Preview

Select an order, and the order details will appear underneath.

Order and Order Details in Code On Time web application Preview

Friday, March 2, 2012PrintSubscribe
Generating the Web Application

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 button underneath the Connection String field. Include the following tables: Categories, Customers, Employees, Order Details, Orders, Products, Shippers, and Suppliers.

Select tables for Order Form web application

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.

Reporting page in Code On Time web application generator

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.

Authentication and Membership screen in Code On Time web app generator

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

Web Application Features Pages in Code On Time Generator

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

Permalinks and Interactive History Option in Code On Time Generator

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.

Theme Selection Page in Code On Time Generator

The next page allows you to change the language of the application, or enable multiple culture sets. Keep the default of en-US, and press Next twice. When the Summary screen comes up, press Generate.

Summary Page in Code On Time Web App generator

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

Baseline Code On Time Generated Application

Friday, March 2, 2012PrintSubscribe
Installing ASP.NET Membership

Microsoft has created ASP.NET Membership as a built-in method of validating and storing user credentials, allowing you to manage users and roles and have an integrated security solution without any effort on your part. Industry-standard security practices are found in the design of the membership database tables and API. Leading database vendors have implemented their own versions of ASP.NET Membership.

If Code On Time detects that ASP.NET Membership tables and views are integrated by your database, then it will generate a fly-over login dialog, self-service membership enrollment, membership bar, and membership manager for your application.

ASP.NET Membership can be added to any database via the Database Connection page.

Under Membership section, press Add button, and confirm to add membership.

Install ASP.NET membership on SQL Server Connection Page in Code On Time web application generator

Code On Time application generator will install ASP.NET Membership in your database and notify you upon completion. You will see the installation log at the bottom of the web application generator window.

Press OK on the confirmation window, and press OK to exit the Database Connection Configuration screen.