081 Lookup resource Helper Class for PhbkPhoneView - chempkovsky/CS82ANGULAR GitHub Wiki

Notes

Now we need the code, which updates Lookup resource database, i.e. we need the implementation of the Add, Update, Delete methods for the LpdPhone, LprPhone01, LprPhone02, LprPhone03 and LprPhone04 tables.
- with 01020-.lookupheper.cs-Wizard's script we generate Lookup resource Helper Class which implements Add, Update, Delete methods.
we have two Database contexts: PhbkDbContext and LpPhnPhBkContext
- PhbkDbContext must be used to generate generate Lookup resource Helper Class

We do not describe step by step instructions
- please repeat the steps similar to those described in the article 042
LpPhBkControllers is the destination project
- Helpers is the destination folder
PhbkPhoneView is a View to generate the class
01020-.lookupheper.cs- is a script type
- lookupheper.cs.t4 is a t4 script
phbk-phone-view.lookupheper.cs- file will be created

Click to show the picture

project structure

replace the using PhBkEntity.PhBk;-line with the using LpPhBkEntity.PhBk;
replace the using PhBkContext.PhBk;-line with the using LpPhBkContext.PhBk;
replace the PhbkDbContext db-code with the code LpPhnPhBkContext db in the phbk-employee-view.lookupheper.cs-file
Note: The Lookup resource Helper and Consumer Classes are the only two classes that need to be modified after generation. We can not use LpPhbkDbContext to generate phbk-phone-view.lookupheper.cs-file. Without additional foreign keys, the Wizard will not be able to recognize the group of tables as a lookup resource. To be recognizable as a lookup resource, LprPhone01, ..., LprPhone04 tables must have a foreign keys, which reference PhbkPhone-table. In addition LprPhone04 must have a foreign key, which references PhbkEmployee-table... In short, find and replace-approach is optimal.