Migrating VFP forms with the free Silverlight Wizard

Migrating VFP forms with the free Silverlight Wizard of the d. FPUG Venelina Jordanova Uwe Habermann Venelina@Vand. U. eu Uwe@Vand. U. eu

Agenda Saturday 2: 15 - 3: 30 Migrating VFP forms with the free Silverlight Wizard of the d. FPUG 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

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 solution 11: 30 – 12: 15 Converting reports to Silverswitch and running VFP reports in Silverswitch 12: 15 – 12: 45 What else do I need to know

Who is talking? * Venelina Jordanova * Master Degree in CS * Fox. Pro Entwicklerin seit FPD 2. 0 * MCP für SQL Server und Application Architecture * Uwe Habermann * Diplom-Informatiker * Fox. Pro Entwickler seit FPW 2. 5 * MCP für Visual Fox. Pro

V&U Ltd. – We and You * Development in Varna, Bulgaria * Projects with VFP and Silverlight * Visual Extend, Silverswitch * High quality for low prices * www. Vand. U. eu * Info@Vand. U. eu

One year since SWFOX 2010 * Visual Studio 2010, Silverlight 4 * Migration of existing VFP applications with wizards to Silverlight

One year since SWFOX 2010 * d. FPUG – Silverlight Wizard * VFX – Silverlight Wizard * Silverswitch

The result * www. vandu. eu/VFPizza. htm

Migrated application * Internet application * Desktop application * Execute VFP Code * At the client * At the server * Supported databases * DBC * SQL Server * MDI user interface

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

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

Why Silverlight? * Fulfills all wishes of VFP developers * FREE development tools * FREE distribution to customers

What is Silverlight? * Silverlight is a powerful development platform for creating engaging, interactive user experiences for Web, Desktop and mobile applications when online or offline

Requirements for developers * * * Visual Fox. Pro 9 d. FPUG – Silverlight Wizard Sedna – Upsizing Wizard Visual Web Developer 2010 Express SQL Server 2008 (Express) Silverlight 4 Tools

Requirements for customers * Client * Silverlight 4 Plug-In (6 MB) * Server * Windows Server * Internet Information Server *. Net Framework 4. 0

Example Migration of Tastrade VFP sample application Uses VFP database Coming not complete with last versions of VFP * But complete on the memory sticks * *

Tastrade * A short view at Tastrade

What does the d. FPUG – 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

What does the d. FPUG – Silverlight Wizard do? * Works with any VFP application * Any?

Requirements for the d. FPUG – Silverlight Wizard * Database * Primary key in every table * Dataenvironment * All tables * No views or cursoradapters * No programmatical use of tables supported

Requirements for the d. FPUG – 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

d. FPUG – Silverlight Wizard How does it work? * Upsizing to SQL Server * Create Silverlight Business Application * ADO. NET Entity Data Model * Domain Service * d. FPUG – Silverlight Wizard * Test * Business logic

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

Create a Silverlight Business Application * New project * Data model (connection, data access) * Domain service (web service)

New project * Template project * Silverlight Business Application

What does it contain? * Client project (Tastrade) * Silverlight project * Forms * Main. Page. xaml * Home. xaml * About. xaml

What does it contain? * Server project (Tastrade. Web) * Startup project, start page * Folder for data model * Folder for domain service * Tastrade. xap * First test

Add data model * ADO. NET Entity Data Model * Connection to SQL Server database * Server: * Database: . SQLEXPRESS Tastrade * Build project!

Add domain service * 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!

The server project is ready! Now the client project and is done by the d. FPUG – Silverlight Wizard

d. FPUG – Silverlight Wizard * Freeware * On the memory sticks * FREE migration of VFP projects to Silverlight * Layout of forms * Execution of forms

d. FPUG – 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

d. FPUG – Silverlight Wizard * Finish! * Forms are opened in the VFP Form Designer * Controls are read * Silverlight forms are created * Test

Where can I run the application? * Windows * Internet-Explorer * Firefox * Chrome * Opera * (Safari officially not supported)

Where can I run the application? * Mac OS * Safari * Firefox * Chrome * Opera

Where can I run the application? * In the future on Linux * Firefox * Chrome * Right now Silverlight Plug-In Version 3. 99

The result * Migrated layout * Execution possible

A short view at the generated files * * <form name>. xaml. cs Main. Page. xaml. cs

What to do now? Code examples * Save employee. Domain. Data. Source. Submit. Changes(); * Next employee. Domain. Data. Source. Data. View. Move. Current. To. Next(); * Previous employee. Domain. Data. Source. Data. View. Move. Current. To. Prev();

Advantages * Quickly and simply generated base for a Silverlight development

Restriction * Silverlight application runs with * SQL Server database * But not with VFP database

d. FPUG – Silverlight Wizard * Video tutorial (in German) available at http: //www. MSDN-Solve. de * and on the memory sticks

Any questions?

Thank you very much and have fun with VFP and Silverlight Venelina & Uwe