Estate society app

In this lesson, I created the SQL SERVER database and tables using a script in SQL SERVER MANAGEMENT STUDIO. I created the starting BLAZOR WEB ASSEMBLY APP with RADZEN BLAZOR STUDIO

LESSON 2: INSERTION OF INCOME TYPES INTO THE APP

LESSON 3:INSERTION OF EXPENDITURE TYPES

LESSON 4: INSERTION OF GENDER DATA

LESSON 5: INSERTION OF POSITION DATA

In this lesson, I insert positions like President, Treasurer etc into the positions table.

LESSON 6:INSERTING TITLES OF COURTESY

Estate Association App:Lesson 7: Create Login Page

LESSON 8: ROLES IMPLEMENTATION

LESSON NINE: Creation of first user in the application

In this video I accomplish the following goals:-

  1. I create first app user whose email address is aminu.bello@superadmin.ng
  2. I assign this user to superadmin role
  3. The newly created user credentials is then used to login to the app using two factor authentication.

LESSON TEN:ADDITION OF PHOTO COLUMN TO RESIDENTS TABLE

In this video, I add a column called photo to residents table and I update the data service in the blazor assembly web app.

n this lesson, I insert ten plus one(eleven) streets into the Streets table.

LESSON TWELVE:CREATION OF A VIEW CALLED HOUSEFULLDETAILS

In this lesson, I create a view called HouseFullDetails in SQL SERVER. I then import this view into the data service of the BLAZOR WebAssembly application.

LESSON THIRTEEN:FURTHER MODIFICATION OF HOUSEFULLDETAILS VIEW

In this lesson, I add a derived column called FullAddress to HouseFullDetailsView. I update the Blazor App data service and model. I also generate a Blazor List Component which allows application users to browse and search for house addresses in the estate.

LESSON FOURTEEN:RECONFIGURATION OF HOUSE DROPDOWN DATAGRID CONTROL ON ADDRESIDENT COMPONENT

In this lesson, I reconfigure the house dropdown datagrid control to use the housedetails view created in the last two lessons as data source instead of house table

LESSON FIFTEEN:CREATION OF RESIDENTS VIEW IN THE DATABASE AND CREATION OF LIST COMPONENT FOR IT.

In this lesson, I create residents view in the database and I create a BLAZOR list component for it.