Custom Hooks in TierDeveloper
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 herereturn SUCCESS_CONTINUE;}public int PostUpdateCustomerInfo( System.Data.SqlClient.SqlConnection Conn, Customers objInfo){	// .. .. .. .. . .. .. .. 	//	.. ..	 .. .. put your own code here.return SUCCESS_CONTINUE;}}

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

Learn How to Upgrade, Repair, Speed Up or Build a Computer Step by Step Today!

Find out how to-

• Solve Common Hardware and Software Problems
• Add Memory, DVD and Other Computer Parts
• Make Your PC Run Faster
• Protect Your Computer from Viruses & Pop-ups
• Tips and Tricks for Internet Surfing
• ... and much more!

Read the testimonies below:

"As a small business owner, this video made a world of difference to me. I used to call a computer technician at least once a week to the office for different computer problems. Now, after watching this video, I rarely have to call him, and this saves me time and money. Thank You." Robert Smith

"I got this video for my son who is 14 years old son. You guys did a great job explaining the most complicated sounding things in a way that everyone could understand! The next day, my son replaced a faulty motherboard, cleaned up my hard drive, and fixed a serious Spyware issue my computer had!" Lisa Morgan

For More Details, CLICK HERE NOW!

  Additional Resources