Implementing Managerial/ Reporting Relationships In Blazor Using RADZEN

Radzen Blazor Studio
1

LESSON ONE:

In this video, I create three tables Employees, Departments and Genders. I create the needed relationships between them. I create a self join relationship on the Employee table between EmployeeID and ManagerID columns. I then proceed to create the initial BLAZOR app. I reduce the number of columns on the employees grid and I adjust the widths of the remaining columns. I change the text of the Employee1 field on the Add/Edit form to Manager and I change the name and the route of the Employees razor component using Visual Studio 2022.

2

Source code for lesson one can be found at GitHub - benjaminsqlserver/ManagerialRelationships

3

LESSON 2

Lesson Objectives:

  1. Implement Derived Property FullName in the Employee Model class
  2. Use this property as the text value for the Manager/Supervisor dropdown.
  3. Ensure that the datagrid automatically reloads after an employee object is created or updated
  4. Ensure that most recently added employees are displayed at the top of the datagrid.

Source code and database code can be found at GitHub - benjaminsqlserver/ManagerialRelationships at Implement_Derived_Property