Usage of VFP code in the back-end of Silverswitch applications

1. Usage of VFP code in the back-end of Silverswitchapplications VenelinaJordanova Venelina@VandU.eu Uwe Habermann Uwe@VandU.eu

2. VFP COM server • Can be used in any Silverlight application • Browser • At the client side • OOB with elevated trust • At the server side • At the client side • Silverlight client executes method in VFP COM server

3. VFP COM server • Execution of FXP • Execution of APP • Advantages: • COM server need not be re-registered • IIS need not be restarted

4. VFP COM server • Data access • Cursoradapter • VFP database • SQL database • All ODBC data sources • MySQL • Oracle • DB2 • … • Set-up database to use

5. VFP COM server • Business logic • Everything, but nothing visible(no user interface)

6. VFP COM server • DEFINE CLASS COMTastrade AS SESSION OLEPUBLIC • Build as “Multi-threaded COM server (dll)” • VFP9.exe must be started with Administrator rights explicitly!

7. VFP COM server DEFINE CLASS COMTastrade AS SESSION OLEPUBLIC PROCEDURE GetCustomers() USE Customer IN 0 SHARED CURSORTOXML("Customer", "lcXML", 1, 2, 0, "1") USE IN Customer RETURN lcXML

8. Use VFP COM serverattheserverside • “early binding” in Visual Studio • COM server must work at development time • Reference to COM server must be added to the server project

9. Call a VFP function private void xpgfPageFramePage1cmdProper_Click( object sender, RoutedEventArgs e) { VfxSystemDomainContext context = new VfxSystemDomainContext(); EventHandler handler = new EventHandler(ExecuteVFPCommand_Completed); var ExecuteVFPCommand = context.ExecuteCommandService("proper", xpgfPageFramePage1txtCustomername.Text.ToString(), VfxAppObject.CurrentConnectionInfo.ClientName); ExecuteVFPCommand.Completed += handler; }

10. Call a VFP function void ExecuteVFPCommand_Completed( object sender, EventArgs e) { var result = sender as InvokeOperation<string>; VfxCommandServiceResultBase ValueResult = (VfxCommandServiceResultBase)VfxSerializer. DeserializeObject<VfxCommandServiceResultBase> (result.Value); lblResult.Text = ValueResult.CommandServiceInfo.result; }

11. Action Button • Progammatical call of COM server method, procedure or new instanceof an object from the client side • Call from Button • Demo

12. Action Button • Pass multiple parameters • Pass data as parameter

13. Anyquestions?

14. Thankyouverymuchandhavefunwith Silverlight Venelina & Uwe