Saint Louis Day of DotNet Session- Get Rid of CRUD Faster, Using Silverlight and RIA Services to quickly develop CRUD applications.

Comments | Share

Thanks to all of you who attended my session at STL Day of Dotnet.  Hopefully you found it useful.  You may find a copy of my presentation here:

http://www.slideshare.net/kshaffar/stldodn-get-rid-of-crud-faster

I hope to create some follow up blog entries on this topic but in the meantime, you may download the sample project here

I have also included the script I used to build the demo.

1. New Project - Silverlight Business Application AdventureWorksHR @ C:\Code Projects\DayOfDotNet2010\
2. Build and Run. Explain what is there by default.
3. In .Web Add New Item.
   1. From Data Category select ADO.Net Entity Model
   2. Name the file AWHRModel.edmx
   3. Leave Generate form Database Selected and Click Next
   4. Create a new Connection
      1. Server: SCS10L2259\SCS10L2259
      2. Windows Authentication
      3. Database: AdventureWorks
   5. Save entity connection settings in Web.config as AdventureWorksHREntities
   6. Choose All (Person) and (HumanResources) Tables
   7. Change Name to AdventureWorksHRModel
   8. Click Finish
4. Review AWHRModel.edmx
5. Build Solution (needed for step 6c)
6. In .Web, Add New Item
   1. From Web Category select Domain Service Class
   2. Name the File AWHRDomainService.cs
   3. Select AdventureWorksHREntities(Entity Framework)
   4. Select All Entities and Enable Editing (overkill here, in practice you should pick only what you need)
   5. Click OK
7. Review AWHRDomainService.cs
8. Navigate to GetEmployees(), change it to: return this.ObjectContext.Employees.Include("Contact");
9. Navigate to: AWHRDomainService.metadata.cs (USE CTRL+, and explain its wonderful)
10. Add Include Attribute to Employee.Contact and add [Include]
11. Build.
12. Open up Home.xaml
13. Delete ScrollViewer and Contents. (Just to clean things up a bit and start with a blank slate)
14. Add a row to GRID by clicking in blue area on right
15. Open and Pin Data Sources
16. Click on Employee Drop Down
    1. Show them Options, including which query it is using by default, if there was more than one then it would show up.
    2. Be sure Datagrid is selected.
    3. Show them list of columns and Options for displaying them.
    4. Turn off everything but
       1. BirthDate
       2. CurrentFlag
       3. EmployeeId
       4. Gender
       5. LoginId
       6. MaritalStatus
       7. SalariedFlag
       8. SickLeaveHours
       9. Title
       10. VacationHours
17. Drag and Drop Employee onto top Row of Home.xaml
18. Size it appropriately, fixed left and top, realtive right ans bottom (click on circle)
19. Build and Run. (notice all our columns are there as expected) READ DONE!
20. Go back to visual studio, and end debugging
21. Open Home.xaml(Now let's clean up those columns a bit.)
22. Click the DataGrid and Open up Properties
23. Find and Expand Columns Collection
24. Reorder Columns so they are more Natural
25. Change employeeIDColumn header to Employee Number
26. Change loginIDColumn Layout.Width to SizeToCells
27. Change titleColumn Layout.Width to SizeToCells
28. Build an Run. (there that looks a bit better)
29. Return To Visual Studio, Stop Debugging and Open Home.xaml
30. Open up ToolBox, Find Scrollviewer, Drag it onto row 2 of Home.xaml
31. Size it appropriately, Change Vertical and Horizontal alignment to Top and Left
32. Open Data Sources Window and Expand Employee.
33. From the Drop Down, select Details
34. Change Contact to Details View
35. Drag Employee inside Scrollviewer on Home.xaml and size appropriately.
36. Build and RUN.
37. Return to Visual Studio, End Debugging and open up Home.xaml
38. Add a middle Row to the Root Grid.
39. Open Toolbox and Drag a StackPanel to middle row.
40. Size appropriately and change Orientation to Horizontal.
41. Drag on 4 buttons into StackPanel
42. Select all 4 using Ctrl+Click and change
    1. Width=100
    2. Margin=10,0,10,0
43. Open up Properties For Button 1 and Change
    1. Name: SaveChangesButton (click next to Button at top of properties
    2. Content: Save Changes
44. Open up Properties For Button 2 and Change
    1. Name: CancelChangesButton (click next to Button at top of properties
    2. Content: Cancel Changes
45. Open up Properties For Button 3 and Change
    1. Name: AddEmployeeButton (click next to Button at top of properties
    2. Content: Add Employee
46. Open up Properties For Button 4 and Change
    1. Name: DeleteEmployeeButton (click next to Button at top of properties
    2. Content: Delete Employee
47. Double Click SaveChangesButton. This Generates a SaveChangesButton_Click event in Home.xaml.cs
48. Add the following code to SaveChangesButton_Click
    1. employeeDomainDataSource.SubmitChanges();
49. Return to Home.xaml and double click CancelChangesButton
    1. (Can anyone tell me what to type here?)
    2. employeeDomainDataSource.RejectChanges();
50. Return to Home.xaml and double click AddEmployeeButton
            Employee emp = new Employee();
            emp.NationalIDNumber = "0";
            emp.ModifiedDate = System.DateTime.Now;
            emp.BirthDate = System.DateTime.Now.AddYears(-21);
            emp.HireDate = System.DateTime.Now;
   emp.rowguid=Guid.NewGuid();
            emp.Contact = new Contact();
            emp.Contact.rowguid = Guid.NewGuid();
            emp.Contact.ModifiedDate = System.DateTime.Now;
            emp.Contact.PasswordHash = "Hashed";
            emp.Contact.PasswordSalt = "salty";
            employeeDomainDataSource.DataView.Add(emp);
            employeeDomainDataSource.DataView.MoveCurrentTo(emp);
51. Return to Home.xaml and double click DeleteEmployeeButton(Note in order to Delete an employee must remove delete trigger on HumanResource.Employee)
   if (System.Windows.Browser.HtmlPage.Window.Confirm("Are you sure? (Note employee will not be deleted until changes are saved.)"))
   {
      employeeDomainDataSource.DataView.Remove(employeeDomainDataSource.DataView.CurrentItem);
   }
52. (Now let's add a smidge of error handling)
    1. Open Home.xaml
    2. Navigate to employeeDomainDataSource
    3. Add SubmittedChanges event
    4. private void employeeDomainDataSource_SubmittedChanges(object sender, SubmittedChangesEventArgs e)
        {
            StringBuilder sb = new StringBuilder();
            if (e.HasError)
                sb.Append(e.Error.ToString());
            foreach (Entity ent in e.EntitiesInError)
            {
                foreach (ValidationResult verr in ent.ValidationErrors)
                {
                    sb.AppendLine(verr.ErrorMessage);
                }
            }
 
            if (e.HasError)
            {
                System.Windows.MessageBox.Show(sb.ToString(), "Submit Changes Error", 
System.Windows.MessageBoxButton.OK);
                e.MarkErrorAsHandled();
            }
        }
 
 
53. Build and Run
54. Test Change
    1. Pick someone change their hours
    2. Submit Changes.
    3. Pick someone new
    4. Change title, Cancel Changes
    5. Refresh page.
    6. Validate Changes.
55. Test Add Employee
    1. Add New Employee
    2. Fill Out all relevant fields.
    3. Submit Changes.
    4. Refresh
    5. Validate Changes
56. Test Delete Employee
    1. Delete previously added employee.
    2. Cancel Changes.
    3. Delete previously added employee.
    4. Submit Changes
    5. Refresh and Validate
57. Return to Visual Studio
58. Navigate to AWHRDomainService.metadata.cs
59. Add [RegularExpression("[M,F]")] to Gender Property of Employee
60. Navigate to Home.xaml
61. For Cancel and Save buttons, open up Properties, and Create a DataBinding for the IsEnabled Property ElementName=employeeDomainDataSource, Path=HasChanges
62. Drag a BusyIndicator onto top Row of Home.xaml
63. Bind IsBusy Property to ElementName=employeeDomainDataSource, Path=IsBusy
64. Open Assets.Resources.ApplicationStrings.resx and change ApplicationName to AdventureWorks HR System
65. Build, Run and Test