Search and Core Library Enhancements

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
Friday, December 16, 2011PrintSubscribe
Search and Core Library Enhancements

Code On Time has released update 6.0.0.17 that includes several enhancements and bug fixes described below.

  • Search in Quick Find or Automatic Search Bar will clear the selected record and hide any related details link to previously selected master. Applying a filter will also reset the selected record.
     
  • Date and numeric “fuzzy” values are now accepted in automatic search bar and filter filters. For example, users can now enter "Thu" in the search field of DateTime type or enter a date as 12162011 (for 12/16/2011).
     
  • Virtual method HandleException can be implemented to perform global exception processing for all exceptions raised when actions are executed.
     
  • Data access objects and BLOB processing code of the application framework now uses class ControllerUtilities to determine the "standard" views that must be used to execute SELECT / UPDATE / INSERT / DELETE operations.
     
    All operations with the exception of INSERT are using "editForm1". INSERT is using "createForm1". The utility class allows overriding the decision making process, which allows a non-generic view name to be returned for certain data controller when executing specific actions.
     
  • Calls to UpdateFieldValue in the business rule method execute in response to Command Name = "Custom" and Command Argument = "abc.." will refresh updated fields.
    This can be used as an alternative to "Calculated" fields to update values in the record in response to user-initiated action.
     
  • BLOB processing will allow caching if IE 6,7,8 is downloading the binary object over SSL. Otherwise it is impossible to see the downloaded file on the client.
     
  • Time dropdown is displayed for fields with Data Format String of "{0:g} or "{0:G}". The dropdown now correctly handles am/pm values.
     
  • User-defined filter "'Field' Does Not Equal 'Empty'" will now work correctly.
     
  • Prevents an exception raised when an empty area of Project Explorer is clicked and selected node is not available.
     
  • Fixed the bug with processing of "_display" argument that can specified in the URL along with data controller URL parameters.
     
  • Preview and Generate actions executed from within Project Designer will not raise and exception if IIS Express is not installed on the computer. The code generator will try to use the local web development server that comes standard with Visual Studio.
     
  • Code generator validates presence of resources referenced in the "*.*proj" files of generated projects. If the resource (file) does not exist then the reference is excluded.
    The major side effect is the ability to change the theme in the projects other than Web Site Factory without breaking the generated web app. Developers can try all available themes in all types of projects without issues.
     
  • Various cosmetic changes to the code generator UI.

Examples of ControllerUtilities class and sample implementation of HandleException are presented below.

The first class instructs the application framework to use myCreateForm when application data access objects are trying to insert records through MyController data controller.

The second class shows how to display a custom message instead of a generic error reported by SQL Server when DELETE statement fails due to foreign key constraints.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace MyCompany.Data
{

    public partial class ControllerUtilities
    {
        public override string GetActionView(string controller, string view, string action)
        {
            if (controller == "MyController" && action == "Insert")
                return "myCreateForm";
            return base.GetActionView(controller, view, action);
        }
    }
}

namespace MyCompany.Data
{

    public partial class Controller
    {
        protected override void HandleException(Exception ex, ActionArgs args, ActionResult result)
        {
            if (ex.Message.Contains("DELETE"))
                result.Errors.Add("Can't delete a record");
            else
                base.HandleException(ex, args, result);
        }
    }
}