1 / 44

Migrating VFP forms with the free Silverlight Wizard of the dFPUG

Migrating VFP forms with the free Silverlight Wizard of the dFPUG. Venelina Jordanova Venelina@VandU.eu. Uwe Habermann Uwe@VandU.eu. Agenda Saturday. 2:15 - 3:30 Migrating VFP forms with the free Silverlight Wizard of the dFPUG

burton-saunders
Download Presentation

Migrating VFP forms with the free Silverlight Wizard of the dFPUG

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Migrating VFP forms with the free Silverlight Wizard of the dFPUG VenelinaJordanova Venelina@VandU.eu Uwe Habermann Uwe@VandU.eu

  2. Agenda Saturday 2:15 - 3:30 Migrating VFP forms with the free Silverlight Wizard of the dFPUG 3:45 - 5:00 Migration of a VFP application into a Silverswitch solution for Visual Studio 5:15 - 5:45 Extending a Silverlight application with a webcam and multi-touch 5:45 - 6:30 Usage of VFP code in the back-end of Silverswitch applications

  3. Agenda Sunday 8:30 - 9:45 Programming VFP Code in the front-end of Silverswitch applications 10:00 - 11:15 Conversion of a VFX application into a Silverswitch solution11:30 – 12:15 Converting reports to Silverswitch and running VFP reports in Silverswitch12:15 – 12:45 What else do I need to know

  4. Who istalking? • Venelina Jordanova • Master Degree in CS • FoxPro Entwicklerin seit FPD 2.0 • MCP für SQL Server und Application Architecture • Uwe Habermann • Diplom-Informatiker • FoxPro Entwicklerseit FPW 2.5 • MCP für Visual FoxPro • Uwe Habermann • Diplom-Informatiker • FoxPro Entwicklerseit FPW 2.5 • MCP für Visual FoxPro • Venelina Jordanova • Master Degree in CS • FoxPro Entwicklerin seit FPD 2.0 • MCP für SQL Server und Application Architecture

  5. V&U Ltd. – WeandYou • Development in Varna, Bulgaria • Projects with VFP and Silverlight • Visual Extend, Silverswitch • High quality for low prices • www.VandU.eu • Info@VandU.eu

  6. Oneyearsince SWFOX 2010 • Visual Studio 2010, Silverlight 4 • Migration of existing VFP applications with wizards to Silverlight

  7. Oneyearsince SWFOX 2010 • dFPUG – Silverlight Wizard • VFX – Silverlight Wizard • Silverswitch

  8. The result • www.VandU.eu/VFPizza.htm

  9. Migratedapplication • Internet application • Desktop application • Execute VFP Code • At the client • At the server • Supported databases • DBC • SQL Server • MDI user interface

  10. Why Silverlight? • Internet applications • Desktop applications • Platform independent • Data binding • Execution of VFP Code • Use of VFP databases

  11. Why Silverlight? • Modern user interface • XAML • Multi-touch support • Animations, reflections, shadows…

  12. Why Silverlight? • Fulfills all wishes of VFP developers • FREE development tools • FREE distribution to customers

  13. Whatis Silverlight? • Silverlight is a powerful development platform for creating engaging, interactive user experiences for Web, Desktop and mobile applications when online or offline

  14. Requirementsfordevelopers • Visual FoxPro 9 • dFPUG – Silverlight Wizard • Sedna – Upsizing Wizard • Visual Web Developer 2010 Express • SQL Server 2008 (Express) • Silverlight 4 Tools

  15. Requirementsforcustomers • Client • Silverlight 4 Plug-In (6 MB) • Server • Windows Server • Internet Information Server • .Net Framework 4.0

  16. Example • Migration of Tastrade • VFP sample application • Uses VFP database • Coming not complete with lastversions of VFP • But complete on the memory sticks

  17. Tastrade • A short view at Tastrade

  18. WhatdoesthedFPUG – Silverlight Wizard do? • Migration of the layout and the data binding of forms • Generation of Silverlight forms into a Silverlight Business Application • Generation of links to start forms

  19. WhatdoesthedFPUG – Silverlight Wizard do? • Works with any VFP application • Any?

  20. RequirementsforthedFPUG– Silverlight Wizard • Database • Primary key in every table • Dataenvironment • All tables • No views or cursoradapters • No programmatical use of tables supported

  21. RequirementsforthedFPUG – Silverlight Wizard • All controls in the form • No programmatical instantiation of visual controls at runtime • Migration of base classes of controls • No migration of code

  22. dFPUG – Silverlight WizardHow does it work? • Upsizing to SQL Server • Create Silverlight Business Application • ADO.NET Entity Data Model • Domain Service • dFPUG – Silverlight Wizard • Test • Business logic

  23. SQL Server Upsizing Wizard • Use Upsizing Wizard of Sedna! • http://vfpx.codeplex.com/wikipage?title=Sedna • Upsize VFP database to SQL Server • Structure • Data

  24. Create aSilverlight Business Application • New project • Data model (connection, data access) • Domain service (web service)

  25. New project • Template project • Silverlight Business Application

  26. Whatdoesitcontain? • Client project (Tastrade) • Silverlight project • Forms • MainPage.xaml • Home.xaml • About.xaml

  27. Whatdoesitcontain? • Server project (Tastrade.Web) • Startup project, start page • Folder for data model • Folder for domain service • Tastrade.xap • First test

  28. Add datamodel • ADO.NET Entity Data Model • Connection to SQL Server database • Server: .\SQLEXPRESS • Database: Tastrade • Build project!

  29. Add domainservice • Domain Service Class • Actually web service • Select tables • General rule: set all checkmarks • Code for data access gets generated • A short view at the code • Build solution!

  30. The server project is ready!Now the client projectand is done by thedFPUG – Silverlight Wizard 

  31. dFPUG – Silverlight Wizard • Freeware • On the memory sticks  • FREE migration of VFP projects to Silverlight • Layout of forms • Execution of forms

  32. dFPUG – Silverlight Wizard • 1. What does this wizard do? • 2. Select VFP project • 3. Select Silverlight Business Application • 4. Select forms • 5. Select properties • Properties, which should be set by styles, should not be migrated

  33. dFPUG – Silverlight Wizard • Finish! • Forms are opened in the VFP Form Designer • Controls are read • Silverlight forms are created • Test

  34. Wherecan I runtheapplication? • Windows • Internet-Explorer • Firefox • Chrome • Opera • (Safariofficially not supported)

  35. Wherecan I runtheapplication? • Mac OS • Safari • Firefox • Chrome • Opera

  36. Wherecan I runtheapplication? • In the future on Linux • Firefox • Chrome • Right now Silverlight Plug-In Version 3.99

  37. The result • Migrated layout • Execution possible

  38. A shortviewatthegeneratedfiles • <form name>.xaml • <form name>.xaml.cs • MainPage.xaml • MainPage.xaml.cs

  39. Whatto do now?Code examples • Save employeeDomainDataSource.SubmitChanges(); • Next employeeDomainDataSource.DataView.MoveCurrentToNext(); • Previous employeeDomainDataSource.DataView.MoveCurrentToPrev();

  40. Advantages • Quickly and simply generated base for a Silverlight development

  41. Restriction • Silverlight application runs with • SQL Server database • But not with VFP database

  42. dFPUG – Silverlight Wizard • Video tutorial (in German) available athttp://www.MSDN-Solve.de • and on the memory sticks

  43. Anyquestions?

  44. Thankyouverymuchandhavefunwith VFP and Silverlight Venelina & Uwe

More Related