Blog: Posts from August, 2011

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 August, 2011
Tuesday, August 23, 2011PrintSubscribe
Enhanced Charts, Sample Databases

New release of Code On Time web app generator includes a collection of bug fixes and enhancements.

  • Chart support was enhanced to allow X axes with grouping for data fields of type Date and DateTime. For example, create an ASP.NET 4.0 project with the sample  Northwind database and activate Project Designer. Find Orders data controller on All Controllers tab and create a new view of type Chart. Configure the data fields of the chart as shown in the picture.
     
    image
     
    Generate the sample app and activate the new view. You will see a chart of orders groups by quarter. You can now print the chart by clicking on  print icon in the pager area of the chart view.
     
    image
     
  • It is now possible to create a database straight from the web app generator database connection configuration string.
     
    image
     
  • Sample databases are support for MS SQL Server. For example, you can create Northwind sample with just a few clicks.

    image
     
  • User interface of the Project Wizard has been changed to present Business Logic Layer, Membership and Authentication, and Features pages as tabbed views.
     
  • URL Hashing is the new EASE feature available in Unlimited edition. The purpose of this feature is to encrypt any hyperlinks produced by Navigate action, Hyperlink Format String, and History. URL Hashing will also ensure that any attempts to specify URL parameters other than _link or ReturnUrl  will result in Access Denied message. This allows to provide assurance that only authorized commands are passed to the application. The tutorial will be available shortly. 
     
  • New projects will not be trying to treat table/view names with “_” in them as the source of grouping schema. This property can be enabled on Features page if needed. Most developers will not want this feature to be enabled.
     
  • Repeating patterns of words in labels of the baseline app are now detected. The code generator will reduce any patters with up to four words.
     
  • The issue with master detail navigation and switching between grid and form views has been resolved. 
     
  • Multiple selection in grid views with a single primary key will affect Report and Actions items on the action bar. Only selected records are included in the output of reports and export actions if a multi-row selection is detected.
     
  • SQL Server’s hierarchyid and geography fields are now correctly processed. It is now possible to create an application from Adventure Works 2008 R2 without any errors.
     
  • The bug with "View Details" arrow in Project Designer views has been fixed.
     
  • Check Box List now fully supports context fields, which allows implementing cascading dependencies on many-to-many fields.
     
  • Memory management in the code generator has been improved to further increase the speed of code generation. The benefits will be visible in Premium and Unlimited editions on quad-core machines.
     
  • Hyperlink Format String with lookups is working correctly with NULL values when Relationship Explorer or URL Hashing is enabled.
     
  • Rendering of an automatic report from the view with multiple image fields will result in a correctly generated report.
  • Friday, August 12, 2011PrintSubscribe
    Reporting Enhancements & Web App Publishing

    Code On Time has released the new update that includes several enhancements and bug fixes.

    Reporting in has been enhanced to print a form-layout if report is activated from a form views. Reports will now print Charts and images. Reports support explicit portrait and landscape orientation and multiple font sizes. You can create a permanent report template and have it customized in Visual Studio. We are working on a tutorial covering all of these topics.

    All web apps now offer “publish” option on the start page of the code generator. Publishing results in a production of file set ready for deployment to your web server.

    Form-style layout and support for images were included in ASP.NET 4.0 version only. We expect to bring reporting capabilities of ASP.NET 3.5 web apps in line with ASP.NET 4.0 when SharePoint Factory is released to production.

    • Version of the web application code generator is displayed in the status bar.
       
    • Navigation between records in a form view will result in correct printing and exporting of the current record only. Previously complete list of records was included in the export record set and printed reports if user navigating between records in a form view.
       
    • Code Generator now supports new expression stringFormatExpression.
       
    • Report  template in ASP.NET 4.0 will produce a report for Chart views. This report will take in account any user defined filters.
       
    • Pattern escaping for SQL Server has been implemented. Quick Find and other search operations resulting in LIKE comparison will have the value escapted to allow finding symbols %, _, and [.
      Read about it at http://msdn.microsoft.com/en-us/library/ms179859.aspx.
       
    • Clearing of a user-defined filter in a view via "x" button in the filter description will only clear the filters from the fields that are not hidden. Previously this was causing incorrect behavior in Project Designer and some other instances.
       
    • Custom report templates are now supported. Select any view in a data controller (gridf1, editForm1) and indicate that you want to have a report template. Generate the project. You will find the report template in ~/Reports folder of your application (Web Site Factory) or in the class library (Web App Factory and Azure Factory).  Click “develop” link next in the Actions column on the start page of the code generator and modify report template as needed. The report will be engaged whenever requested from the corresponding view.
       
    • Report template for grid /data sheet views automatically determines the page orientation. You can choose a specific page orientation if you edit Orientation property of a data controller view.
       
    • Report template now supports Font Size property. Select X-Small, Small, Medium, Large, or X-Large font size for a given data controller view.
       
    • Upgrading of the product edition will cause the project to be re-generated to reflect new features.
       
    • Web App Factory and Web Site Factory now support publishing. Select this option to produce a set of files ready for deployment to your server.  You can publish an app on the start page of the project wizard.
        
    • "Small" and "toll" image thumbnails are fitted better in the image preview rectangle rendered for binary / image fields.
       
    • Modal forms now support annotations. If you select a modal form then you will notice a clip icon next to form navigation buttons (up and down arrows).
       
    • Annotations are now supported with Windows Authentication
       
    • “Print” icon is now displayed in modal views next to form navigation buttons if any “ReportAs…” is available.
       
    • Resizing of modal views with tabbed categories has been improved. Switching of tabs will allow the tab content to take the maximum available size and scroll if the content does not fit on 4/5 of the page height.
       
    • VB.NET "Handles" clause in code-behind class methods is produced only for for master, aspx, or ascx pages to remove the conflict with certain name patterns in business rule methods.
       
    • Context field values are now included in "Details" page link when a user click on the arrow next to lookup fields.
       
    • Test Bench preview will start the preview with URL parameters that allows saving of the data in form views.
    Wednesday, July 27, 2011PrintSubscribe
    User ID/ Name Lookup, EASE, Access Control Rules, …

    New update delivers the first component of EASE (Enterprise Application Services Engine). Use Access Control Rules to implement sophisticated data segmentation in multi-tenant applications.

    Here is the list of the latest enhancements:

    • Access Control Rules are included in Premium and Unlimited edition.
    • Data controller fields can now be marked as “hidden” under General section of field’s property page in Project Designer. Hidden fields are included in all data views but not visible to end users. This feature may be useful in implementing application-wide access control rules.
      image
    • Lookup fields with Items Style now support Copy property for multi-field copy. Read the access control rules tutorial to see an example.
       
    • It is now possible to create a user account straight from a lookup field with Items Style of User Id Lookup or User Name Lookup. Only users authorized to access membership manager will be able to create new user accounts. See access control rules tutorial for an example.
       
    • Component DataViewTextBox now correctly refers to the new Ajax Control Toolkit implementation of Auto Complete Behavior. See example at /blog/2010/03/custom-search-bar-with-auto-complete.html.
       
    • Significant enhancements to the speed of code generation. Web App Generator creates code up to 40% faster. 
       
    • Sandbox project in Web App Factory now has its own AssemblyInfo.* file to prevent MSBuild "fatal error" in the progress log.
       
    • Controller.cs(vb) has been split in 4 files to improve the speed of code generation and simplify maintenance.
    Continue to Access Control Rules