LESSON ONE (DATABASE CREATION)
Transact-SQL script to create the database, tables and insert data can be found at VehicleMonitoringDBScript/VehicleMonitoringDB.sql at main · benjaminsqlserver/VehicleMonitoringDBScript · GitHub
LESSON ONE (DATABASE CREATION)
Transact-SQL script to create the database, tables and insert data can be found at VehicleMonitoringDBScript/VehicleMonitoringDB.sql at main · benjaminsqlserver/VehicleMonitoringDBScript · GitHub
LESSON TWO: Creation of Baseline Blazor App Using RADZEN Blazor Studio
In this video, I create the starting Blazor app using RADZEN BLAZOR STUDIO. I connect the app to the database created in lesson one. I also create the CRUD Pages for all the tables in the database.
Source code for this lesson can be found at GitHub - benjaminsqlserver/VehicleMonitoringSystem at ApplicationBaseline
LESSON THREE: How To Change The Height And Width Of Dialogs For Add and Edit Pages
One of my viewers asked me this question. In this video, I show you how to do this using Visual Studio 2022.
Source code can be found at GitHub - benjaminsqlserver/VehicleMonitoringSystem at ChangeHeightAndWithOfDialogs
LESSON FOUR: Implementation of Speed Classification Entity
In this video we create the database table for SpeedClassification entity, enter some data into it and create BLAZOR CRUD Pages for it.
Source code for this video can be found at GitHub - benjaminsqlserver/VehicleMonitoringSystem at ImplementionOfSpeedClassificationEntity
LESSON FIVE: DASHBOARD PART ONE
In this video, I create a dashboard that displays the following statistics:-
Number of slow vehicles in the last one month.
Number of vehicles that ran at normal speed in the last one month.
Number of vehicles that exceeded the speed limit for the last one month.
I show you how to use a Radzen Blazor Component called RadialGauge.
Source code can be found at GitHub - benjaminsqlserver/VehicleMonitoringSystem at RadzenRadialGauge.
Please support my work and buy me a cup of coffee at https://buymeacoffee.com/benjaminsqlserver
Lesson SIX: Dashboard Part II (List Of Traffic Offenders)
Source code can be pulled from GitHub - benjaminsqlserver/VehicleMonitoringSystem at TrafficOffenders
LESSON SEVEN: COSMETIC CHANGES
In this lesson, I make some changes to improve the look and feel of the app.
Access lesson source code at GitHub - benjaminsqlserver/VehicleMonitoringSystem at CosmeticChanges
Support my work at https://buymeacoffee.com/benjaminsqlserver
LESSON EIGHT: Implementing Security Part 1
In this lesson we create login page, pages to create users, roles and we also implement multifactor authentication using email.
Source code can be found at GitHub - benjaminsqlserver/VehicleMonitoringSystem at SecurityPart1
LESSON NINE: Implementing Security Part 2
In this lesson, I show you how to apply authorization (role based management) to pages. I also show you how to apply authorization (role based management) to menu items. Source code can be found at GitHub - benjaminsqlserver/VehicleMonitoringSystem at SecurityPart2