SOURCECODEPROVIDED FORALLPROGRAMS,EXERCISESOLUTIONS ANDPROJECT

This is a beginner's course in ASP.NETCore.

About the Project

A project "Find a Doctor" is completed as the course progresses.

• Registration and Login Modules

• Role based Authentication and Authorization

• SQlite as Database.

• MySQL integration of the completed project is fully explained LIVE in 22 minutes

• Doctors and patients can update their profiles and pictures

• Patients can search for doctors of various specializations and in various cities.

• AJAXbased cascading dropdowns for search

• JSON based database of cities

• Patients can upload PDF reports

• A consultation and a payment loop is fully built in this project.

• Bootstrap based UI

  
  

• Source code is provided in zipped form for each step of completion

Even though the project is "Find a Doctor", but it can be thought of as a "customer-service provider project". Hence, it can be modified for a website where customers search for plumbers, technicians, etc., or for a website where students search for teachers of various subjects.

Modules of the projectare INTERLACED with theory topics and added consistently. The last lecture finishes the project.

Following is the table of chapters covered in this video course.

Ch 1 - Razor Pages

1. L01 - Introduction to Razor Pages (20 min)
   

2. L02 - Middleware Configuration (15 min)
   

3. L03 - Integrating CSS, JS and _Layout (16 min)
   

4. L04 - Inter Page Navigation and Linking of Razor Pages with Tag Helpers (10 min)
   

5. Exercises on Ch1

6. Find a Doctor (Project Step 1 Implementation Walkthrough)

Ch1A - ASPNET Core Application Startup (can skip for later)

1. L01 - Development, Staging and Production Environments

   
   

2. L02 - Kestrel, IIS, IISHttpServer and HTTP sys

   
   

3. L03 - The launchSettings json File

   
   

4. L04 - Logging in ASPNET Core

   
   

5. L05 - Storing and Reading Configuration Key Value Data

   
   

6. L06 - Using Options Pattern to Read Configuration

   
   

7. L07 - About the UseDeveloperExceptionPage Middleware

   
   

8. L08 - Writing a Custom Exception Page
   

Ch 2 - Basic Event Handling in Razor Pages

1. L01 - How to handle a click event (14 min)
   

2. L02 - Creating an HTML FORM with Razor Pages (15 min)
   

3. L03 - How to handle a FORM submit event (10 min)
   

4. L04 - How to handle Server Side Validation (14 min)
   

5. Exercises on Ch2

6. Find a Doctor (Project Step 2 Implementation Walkthrough)

Ch 3 - Database Connectivity - I

1. L01 - Various Database Options and the initial Setup (13 min)
   

2. L02 - Getting Started with Database INSERT of Form data (23 min)
   

3. L03 - Strategy to handle a DbUpdateException (9 min)
   

4. L04 - Composite Primary Keys and Search by PK (9 min)
   

5. L05 - Displaying Data and OnGetAsync (10 min)
   

6. L06 - Deleting Records and the Anchor Tag Helper (10 min)
   

7. L07 - Updating Records (13 min)
   

8. L08 - Checkbox in a Razor Form (13 min)
   

9. L09 - Radiobuttonlist in a Razor Form (15 min)

   
   

10. Exercises on Ch3

    
    

11. Find a Doctor (Project Step 3 Implementation Walkthrough)

Ch 4 - Modularity

1. L01 - ViewImports (10 min)
   

2. L02 - Razor Components (20 min)
   

3. L03 - Currency Converter Component (10 mins)

   
   

4. Exercises on Ch4

5. Find a Doctor (Project Step 4 Implementation Walkthrough)

Ch 5 - Areas and Partial Views

1. L01 - Concept of Areas and an Authorization Scheme (17 min)
   

2. L02 - Partial Views (19:59 mins)
   

3. Find a Doctor (Project Step 5 Implementation Walkthrough)

Ch 6 - State Management

1. L01 - Reading and Writing Cookies (18 min)
   

2. L02 - Consent Banner with ITrackingConsentFeature (13 min)
   

3. L03 - The Concept of Session (16 min)
   

4. L04 - Serializing DateTime into Session (9 min)
   

5. L05 - When and how to use TempData (11 min)

Ch 7 - Authentication and Authorization

1. L01 - Configuring Role based Authorization (15 min)
   

2. L02 - SignIn, ReturnUrl and LocalRedirect (17 min)
   

3. L03 - Displaying User Info on each Page (7 min)
   

4. L04 - SignOutAsync with Tag Helpers (8 min)
   

5. Find a Doctor (Project Step 6 Implementation Walkthrough)

Ch 7A - Identity in ASPNET Core (can skip for later)

1. L01 - Getting Ready for Identity based Authentication

   
   

2. L02 - Adding a Login Page

   
   

3. L03 - Adding a Registration Page

   
   

4. L04 - EMail Verification of an Account

   
   

5. L05 - Resending an Account Verification EMail

   
   

6. L06 - Forgot Password Functionality

   
   

7. L07 - Reset Password Functionality

   
   

8. L08 - Claim based Authorization

   
   

9. L09 - Layout Pages and LoginPartial for Identity

   
   

10. L10 - Sign Out Functionality

Ch 8 - Database Connectivity - II

1. L01 - Dropdownlist in a Razor Form (7 min)
   

2. L02 - Uploading file(s) and Storing in a Database (16 min)
   

3. L03 - Downloading file(s) and FileResult (11 min)
   

4. Find a Doctor (Project Step 7 Implementation Walkthrough)

Ch 9 - Ajax Communication

1. L01 - Ajax based POST of a Razor FORM (13 min)
   

2. L02 - Ajax based POST without a FORM (11 min)
   

3. L03 - Parameterized AJAX GET Request to a C# function (10 min)
   

4. L04 - Ajax based EBook style Admin Panel (8 min)
   

5. L05 - Authentication and Authorization with AJAX Requests (8 min)
   

6. L06 - Inline, In-place Edit, Update, Cancel of records (13 min)
   

7. L07 - Master Slave Cascading Dropdowns with Ajax (13 min)
   

8. Find a Doctor (Project Step 8 Implementation Walkthrough)

Ch 10 - Understanding LINQ Queries

1. L01 - SingleOrDefault, Find, FirstOrDefault, Single and First (11 min)
   

2. L02 - Where, Include and ToList (10 min)
   

3. L03 - How to Sort Records (6 min)
   

4. L04 - Direct Execution of SQL Queries and Stored Procedures (9 min)
   

5. Find a Doctor (Project Step 9 Implementation Walkthrough)

Ch 11 - Database Connectivity - III

1. L01 - Status of the App_Data folder in ASP.NET Core (10 mins)
   

2. L02 - XML as a database in ASP.NET Core (9 mins)
   

3. L03 - Repository Pattern and Dependency Injection with XML as Database (16 mins)
   

Ch 12 - Docker Containerization

1. L01 - What is Docker, Dockerfile, Image and Containerization

2. L02 - Creating a Docker Image

3. L03 - Running a Docker Image

4. L04 - Using Docker Volumes to Persist Data

5. L05 - Publishing to the DockerHub with Visual Studio

6. L06 - Pull and Run the MS SQL Server Docker Image

7. L07 - Connectivity to SQL Server Running in a Docker Container

Ch 13 - Database Migrations (can skip for later)

1. L01 - Concept of Database Migration

   
   

2. L02 - Configuring Visual Studio for Database Migration

   
   

3. L03 - Your first EF Core Migration

   
   

4. L04 - Migration on Alterations to a Model

   
   

5. L05 - SQL Scripts for Migration

Ch Last - Find a Doctor Project - Last Step

1. L01 - Implementation Walkthrough

   
   

2. L02 - Containerizing and Publishing the Project to DockerHub

   
   

3. L03 - Configuring the Project for MySQL

   
   

4. L04 - Configuring the Project for SQL Server