Coding Standards

Table Naming Conventions

• All Table names must begin with omni_<MODULE/SUBMODULENAME>_<SPECIFIC NAME>

• Thus tables can be omni_project_master etc.

• In general table names that existed in OMNI will be carried forward without ANY changes unless OTHERWISE mentioned - all spelling names will be corrected.

Stored Procedure Naming Conventions

• All SPs will begin with omni_sp_<MODULE/SUBMODULENAME>_<SPECIFIC NAME>_<ACTION>

• So SPs will be named like omni_sp_crm_prospect_add. In general SPs used in OMNI can be carried forward but names should be changed to reflect the above convention.

UDF Naming Convention

• All UDFs should be named like: omni_fn_<ACTION><SPECIFIC NAME>

• Thus a UDF name should be like 

ActionForm Variable Naming Conventions

• ActionForm Variables should be written in Mixed Case avoiding any '_' (underscore) characters and spaces.

  • Follow the Camel Case Notation in naming variables (see: http://www.computerhope.com/jargon/c/camelcas.htm)

Page Naming Conventions

• Pages will be named as per modules and sub-modules see OMNI Solution Map for details of page names.

• In general the ACTION should precede the OBJECT being acted on, thus the page name should be AddProspect (and NOT ProspectAdd)

• All URLs must be relative URLs - links between pages should not be absolute URLs.

• In DNN 7+ all page names will have the suffix .aspx and the links should reflect that.

My Tokens Naming Conventions

• All My Tokens objects should be in a package 

UI Conventions

• All Screens must follow the Skin guidelines - no specific fonts, colors or styles should be added (ONLY available CSS Selectors should be used)

• Wherever possible DIVs should be used instead of TABLE tags - this is to ensure that the screen is responsive for smaller screens,

Other

• • Report Names - TBD

  • DNN Endpoint Method Names - TBD

Formatting

• Dates

  • All Date fields must be formatted using the UDF omni_fn_GetDate the queries used should not directly attempt to use the CONVERT or CAST or FORMAT function to format a date.

• Currency

  • All Currency fields must be formatted using the UDF   omni_fn_GetCurrency the queries used should not directly attempt to use the CONVERT or CAST or FORMAT function to format a date.