» Home page » More about Website builders » Register or Transfer Domain » Buy SSL certificates » Buy Managed DNS

Contact:

Email at:

Website Design Products

» Domain Registration Transfer Renewal » DNS Management » Cheap Website Hosting

Website Design Services

» Website Design

Website Design Articles

WebsiteDays.com for russia ufa

Click on your region below to contact a Websitedays.com designer, or Websitedays.com sales person for info about Online Website builder system.

You can also send an email to

and we can forward your enquiry to respective designers in your area.

Almetyevsk	Arkhangelsk	Astrakhan
Barnaul	Bryansk	Chelyabinsk
Dagestanskiye Ogni	Dmitrov	Dubna
Dzerzhinsk	Ekaterinburg	Gatchina
Irkutsk	Ivanovo	Izhevsk
Kaliningrad	Kazan	Khabarovsk
Krasnoyarsk	Kubinka	Kursk
Kuznetsk	Moscow	Murmansk
Nizhni Novgorod	Novgorod	Novorossiysk
Novosibirsk	Obninsk	Omsk
Orenburg	Penza	Perm
Pervouralsk	Petrozavodsk	Pskov
Rostov-on-Don	Samara	Saratov
Sarov	Sergiev Posad	Severomorsk
Shchelkovo	Smolensk	St Petersburg
Staritsa	Stavropol	Taganrog
Tomsk	Tver	Ufa
Ulan-Ude	Ulyanovsk	Vladivostok
Volgograd	Voronezh	Yaroslavl
Yegoryevsk	Yekaterinburg	Yoshkar-Ola
Zelenodolsk	Zhukovsky

» Custom Hooks in TierDeveloper

Custom Hooks in TierDeveloper by: Ann Morris

Custom Hooks is another powerful and most demanding feature provided by TierDeveloper. Custom Hooks work like database triggers. It could be your own business logic that you can activate before or after performing some database action(s). PreHooks and PostHooks are two ways, provided by TierDeveloper, through which you can embed your own logic in the generated code. Pre hook methods are called before the database access is performed whereas post hook methods are called after the database operations are performed.

Custom hooks can be specified wherever database access is performed. It includes standard operations, query methods, bulk operations and custom operations. User can generate skeleton code for custom hooks of the selected methods or he/she can use his/her own hooks class.

For your convenience and better understanding I have listed sample code here which shows how TierDeveloper embed custom hooks in the generated code. It is pretty self-explanatory.

public void UpdateCustomerInfo(Customers objInfo)

{

try

{

... ... .... .......

CustomersHooks hooks = new CustomersHooks();

status = hooks.PreUpdateCustomerInfo((System.Data.SqlClient.SqlConnection)getConnection(), objInfo);

if (status != CustomersHooks.SUCCESS_CONTINUE)

{

SetStatus(status == CustomersHooks.FAIL_NONCONTINUE ? EStatus.eFail : EStatus.eSuccess);

ReleaseCommand();

return;

}

AddCmdParameter("@CompanyName", TDevFramework.EDataType.eVarchar, objInfo.CompanyName, TDevFramework.EParamDirection.eInput, objInfo.IsNull("CompanyName"));

... ... .... .......

ExecuteNonQuery();

status = hooks.PostUpdateCustomerInfo((System.Data.SqlClient.SqlConnection)getConnection(), objInfo);

if (status != CustomersHooks.SUCCESS_CONTINUE)

{

... ... .... .......

return;

}

SetStatus(EStatus.eSuccess);

ReleaseCommand();

}

catch (Exception e)

{

... ... .... .......

throw e;

}

public class CustomersHooks

{

public const int SUCCESS_CONTINUE = 0;

public const int SUCCESS_NONCONTINUE = 1;

public const int FAIL_NONCONTINUE = 2;

public int PreUpdateCustomerInfo( System.Data.SqlClient.SqlConnection Conn, Customers objInfo)

{

//.. .. .. . .. ..

// . .. .. .. .. Put your own code here

return SUCCESS_CONTINUE;

}

public int PostUpdateCustomerInfo( System.Data.SqlClient.SqlConnection Conn, Customers objInfo)

{

// .. .. .. .. . .. .. ..

// .. .. .. .. put your own code here.

return SUCCESS_CONTINUE;

}

About The Author

Ann Morris - I work in a software development Organization and interested in writing technical articles.

ann@alachisoft.com

This article was posted on January 07, 2005