Blog: Posts from September, 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 September, 2012
Tuesday, September 25, 2012PrintSubscribe
About Code On Time

Code On Time web application generator creates modern web apps straight from your database with lightning speed. In a matter of minutes, your data can be available on the web with sophisticated search, manipulation, and reporting capabilities that would otherwise take many months to build. Learn about Code On Time

Your web applications can be deployed to a dedicated or shared server. You can choose to deploy your app to Windows Azure Cloud or package the app for deployment to popular web content management systems SharePoint or DotNetNuke.

The value of organized data is proven every day by companies such as Google and Facebook. These giants of software industry have managed to turn mundane information into goldmines.

Many businesses own vast datasets of valuable information trapped in spreadsheets or on-premise databases. Exposing this data to potential consumers means web application development, which always comes with tremendous costs. Application deployment also involves hard-to-predict expenses.

Code On Time makes it possible to build an app on top of SQL Azure database and have it deployed to Microsoft’s state-of-the-art computing cloud Windows Azure. In about fifteen minutes, you can have all your data displayed in an advanced web application running in a multi-server configuration protected by firewall, enhanced with load balancing, and on-demand performance. Scale your application up and down, turn it on and off. None of it requires maintenance personnel or special knowledge. The pay-as-you-go model allows precise cost control.

If you are a resident expert in configuring network servers and databases, or have such an expert on board, then Code On Time will accelerate web application development for your team.

All generated web applications include an advanced application framework with complete source code. The framework makes it possible to have light-weight web applications with high-end user interface with a little or no effort. The framework also allows elegant extension of customized apps with business rules that can take full advantage of vast Microsoft.NET API and custom components.

Code On Time is perfect for database administrators who need to control data under their management. Instant production of web applications on top of your databases without modifying the database structure makes our product a perfect companion for daily data management tasks.

Code On Time works great for project managers and application architects as a way to visualize the project database without writing a single line of code. You can use the generated apps as makeshift data management tools that will help populate your data, making it easy to spot any inconsistencies or undue complexity. The apps will even run on your laptop with a local database and do not require actual deployment to a server. The high quality user interface of generated web applications can complement custom projects and allow your team to concentrate on essential custom code.

Tuesday, September 25, 2012PrintSubscribe
jQuery Cross-Domain Dynamic Client of a Web App

A fictitious company Northwind Traders had a fair amount of success with the statically exposed product catalog that allows third parties to display the catalog on their own web sites. An exceptionally small amount of code is required to create a jQuery cross-domain static client of the back office web app created with Code On Time.

Northwind Traders have decided to offer search capabilities of the back office web app to their premium integration partners.

A possible implementation of a search client is shown next.

If a user clicks Find without entering a search sample,  then the first one hundred products are retrieved in alphabetical order.

The search result displayed in jQuery cross-domain dynamic client of the demo web app when a search criteria is not specified

This is the result that matches “40 biscuit” search criteria.

The search result displayed in jQuery cross-domain dynamic client of the demo web app with '40 biscuit' search sample

The back office web app at http://demo.codeontime.com/northwind/pages/products.aspx displays the same exact result as follows.

The 'Quick Find' result for '40 biscuit' search sample in the demo web app created with Code On Time

The HTML page implementing a sample search client works across domains in any web browser.

<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
    <title>jQuery Cross-Domain Client</title>
    <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.1/jquery.min.js"></script>
    <script type="text/javascript">
        $(document).ready(function () {
            $('#ProductListPanel').hide();
            $('#Query').focus();
            $('#FindButton').click(function (e) {
                e.preventDefault();
                var query = '?_sortExpression=ProductName&_q=' +
                    encodeURIComponent($('#Query').val());
                $.ajax({
                    url: 'http://demo.codeontime.com/northwind/appservices/Products' + query,
                    cache: false,
                    dataType: 'jsonp',
                    success: function (data) {
                        $('#ProductList option').remove();
                        $.each(data.Products, function (index, product) {
                            $('<option>')
                                .text(
                                    product.ProductName + ' / ' +
                                    product.CategoryCategoryName + ' / ' +
                                    product.SupplierCompanyName + ' / ' +
                                    product.UnitPrice)
                                .attr('value', product.ProductID)
                                .appendTo($('#ProductList'));
                        });
                        $('#ProductListPanel').show();
                    }
                });
            });
        });
    </script>
</head>
<body>
    <input id="Query" type="text" />
    <button id="FindButton">
        Find</button>
    <div id="ProductListPanel">
        <select id="ProductList" size="10">
        </select>
    </div>
</body>
</html>

The page statically links jQuery library from CDN provided by Google.

The search starts when a user clicks on the Find button.

The “click” handler declares a query variable that contains “_sortExpression” and “_q” parameters. The first parameter specifies the sort order of returned products. The search parameter “_q” is the sample for the Quick Find feature of the web app.

Next, the “click” handler invokes ajax method to retrieve data from the web app. The key parameters of the method are url and dataType. The first parameter defines the REST URI of Products data controller. The second parameter indicates that a cross-domain web request must be executed by jQuery library.

If the request is successful, then a list of products populates the list box.

Monday, September 24, 2012PrintSubscribe
jQuery Cross-Domain Static Client of a Web App

Integration with other service providers is a key to success of many SaaS business applications. The mail order company Northwind Traders has decided to expose their product catalog to third parties to increase sales. A back office web app has been created with Code On Time and configured to expose the product catalog.

An integration partner can put together a simple HTML page to display a list of products from http://demo.codeontime.com/northwind with a very few lines of code.

<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
    <title>jQuery Cross-Domain Client</title>
    <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.1/jquery.min.js"></script>
    <script src="http://demo.codeontime.com/northwind/appservices/Products?_instance=ProductCatalog">
    </script>
    <script type="text/javascript">
        $(document).ready(function () {
            $.each(MyCompany.ProductCatalog.Products, function (index, product) {
                $('<option>')
                    .text(
                        product.ProductName + ' / ' +
                        product.CategoryCategoryName + ' / ' +
                        product.SupplierCompanyName + ' / ' +
                        product.UnitPrice)
                    .attr('value', product.ProductID)
                    .appendTo($('#ProductList'));
            });
        });
    </script>
</head>
<body>
    <select id="ProductList" size="20">
    </select>
</body>
</html>

The first script tag links jQuery library to the page straight from the Google’s CDN.

The second script references http://demo.codeontime.com/northwind/appservices/Products. This URL points to the demo web app. The highlighted component /appservices/Products references the REST URI of the Products data controller. The _instance parameter instructs the application to construct a JavaScript property with the name of ProductCatalog. The property will be assigned to MyCompany global variable that matches the namespace of the application.

The script executes as soon as the page has been loaded in the browser and iterates through MyCompany.ProductCatalog.Products array to populate the select element ProductList defined in the page body.

This is how the page will look if you have it opened in your default web browser.

A jQuery cross-domain static client of a web app in action

If you open the page straight from the hard drive in Internet Explorer, then you many need to allow running scripts for the list of products to get displayed.

Internet Explorer will prompt to Allow Blocked Content if the jQuery cross-domain static client file is opened directly from the file system

The product catalog is dynamically constructed by the web app every time it is requested.

This is how the array of products look in debug mode if global variable MyCompany is inspected in Visual Studio.

Global variable 'MyCompany' of a jQuery cross-domain static client of the demo web app is inspected in Visual Studio at runtime

If more than one resource pointing to the demo app controller is linked to the page then data will be available as properties of MyCompany global variable.

The Product Catalog data is downloaded by a web browser from the demo web app regardless of the domain of the HTML page or web platform that has served the page. This opens tremendous opportunities of integrating data in the third-party solutions.