330 likes | 506 Views
Migration of a VFP application into a Silverswitch solution. Venelina Jordanova Venelina@VandU.eu. Uwe Habermann Uwe@VandU.eu. Silverswitch. Silverswitch. Rapid Application Development development environment for Silverlight Silverswitch.sln Migration of VFP applications
E N D
Migration of a VFP application into a Silverswitchsolution VenelinaJordanova Venelina@VandU.eu Uwe Habermann Uwe@VandU.eu
Silverswitch • Rapid Application Development development environment for Silverlight • Silverswitch.sln • Migration of VFP applications • VFX – Silverlight Wizard • Visual Extend for VFP re-developed in C#
Silverswitch • Supported databases • VFP • SQL Server • MySQL, ADS, DB2, Oracle, …
Silverswitch • Programming • C# • VFP at the server side with COM server • Powerful method call even from client side • VFP at the client side with GUINEU • Execution also on Mac OS and in the future on other platforms
SilverswitchWhatdoesitcontain? • Template application Silverswitch.sln • Start page • Wizards • Update Project • Builders • DataGrid, PickField, Form • VFX – Silverlight Wizard • Included in VFX for VFP
Migration toSilverswitch • VFP projects • VFX projects
RequirementsfortheVFX – Silverlight Wizard • Database • Primary keys for all tables • Dataenvironment • Tables • Cursoradapters • No views • No programatical used tables
RequirementsfortheVFX – Silverlight Wizard • All controls in the form • No instantiation of controls at runtime • VFP projects • Base classes of controls are migrated • VFX projects • VFX classes of controls are migrated
Requirementsforthedevelopment • Visual FoxPro 9 • VFX 13 and Silverswitch • Visual Web Developer 2010 Express • Optional: SQL Server (Express) • Silverlight 4 Tools • WCF RIA Services 1 SP1 • Silverlight 4 Toolkit
Requirementsatthecustomer‘sside • Client • Silverlight 4 Plug-In (6 MB) • Server • Windows Server • Internet Information Server • .Net Framework 4.0
Creationof aSilverswitchapplication • Create new projectbased on template project“Silverswitch” • Don’t execute, don’t build • Run VFX – Silverlight Wizard
VFX – Silverlight Wizard • What does this wizard do? • Explanation • VFP COM server is generated • Administrator rights required!
VFX – Silverlight Wizard • Select Silverswitch solution
VFX – Silverlight Wizard • Data access • Create ADO.NET Entity Data Model • Create Domain Service • Create and register VFP COM server
VFX – Silverlight Wizard • Settings of the application object • Add VFX forms to table Vfxfopen
VFX – Silverlight Wizard • Select forms • Forms marked as included into the project get migrated by default • VFX*.scx forms do not get migrated
VFX – Silverlight Wizard • Project names for forms • Forms can be summarized to projects • Optimization of project size and download size and time
VFX – Silverlight Wizard • Select form properties • Layout similar to VFP -> select all properties • Hard-coded property values cannot be overwritten by styles
VFX – Silverlight Wizard • Select reports • Reports, marked as included into the project, get migrated by default
VFX – Silverlight Wizard • Finish! • Success messageorLog • Test!
Features oftheSilverswitchapplication • Prepared frame for the application • Splash screen • Optional login dialog • Toolbar with XAML icons • Data-driven open dialog • Internet application • Intranet application
Features oftheSilverswitchapplication • User login • Runtime localization • User management • User rights • User groups • MDI user interface
Features ofgeneratedforms • Autoedit • New, edit, delete, save, undo • Navigation • Sort and incremental search in DataGrid • Resizable, minimize, maximize
Features ofgeneratedforms • Treatment of update conflicts • Filter dialog
WhatdoestheVFX – Silverlight Wizard do? • Add forms to the solution • Entry in table Vfxfopen • Migration of forms • MVP Model-View-Presenter
WhatdoestheVFX – Silverlight Wizard do? • Example • Customer.xaml • Layout • Customer.xaml.cs • Settings • CustomerController.cs • Developer’s code • CustomerControllerBase.cs • Generated code
WhatdoestheVFX – Silverlight Wizard do? • Generates VFP COM server • Data access to VFP database using cursoradapters
VFX – Silverlight Wizard • Video tutorial (in German) available at • www.MSDN-Solve.de • and on the memory sticks
VFPizza in theCloud • Inform! • Create account • Create SQL Server database • Make project settings • Publishing with Visual Studio wizard • 2 virtual maschines recommended • http://VFPizza.CloudApp.net
VFPizza in theCloud • Video tuorial (in German) available athttp://www.MSDN-Solve.de • and on the memory sticks
Break Venelina & Uwe