|
![]() |
||
![]() |
![]() |
|
![]() |
|
![]() |
Custom Hooks in TierDeveloper - Articles SurfingCustom 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;}}
RELATED SITES
Copyright © 1995 - 2024 Photius Coutsoukis (All Rights Reserved). |
![]() |
![]() Aging Arts and Crafts Auto and Trucks Automotive Business Business and Finance Cancer Survival Career Classifieds Computers and Internet Computers and Technology Cooking Culture Education Education #2 Entertainment Etiquette Family Finances Food and Drink Food and Drink B Gadgets and Gizmos Gardening Health Hobbies Home Improvement Home Management Humor Internet Jobs Kids and Teens Learning Languages Leadership Legal Legal B Marketing Marketing B Medical Business Medicines and Remedies Music and Movies Online Business Opinions Parenting Parenting B Pets Pets and Animals Poetry Politics Politics and Government Real Estate Recreation Recreation and Sports Science Self Help Self Improvement Short Stories Site Promotion Society Sports Travel and Leisure Travel Part B Web Development Wellness, Fitness and Diet World Affairs Writing Writing B |