Mô tả

This course is for Beginners to ASP.NET having some knowledge of C# or similar programming languages.

In this course, I will show you how to use SqlClient to connect to the database and to execute SQL queries. In addition, I will show you how to implement the traditional authentication using Sessions.

We will use Visual Studio 2022 to connect to the SQL Server and to create the database/tables. So we don’t need to install SSMS (SQL Server Management Studio).

In this course, you will learn:

- How to create an ASP.NET Core Web Application with Razor Pages

- How to create databases and tables using SQL Server and Visual Studio 2022

- How to update the layout of the application

- How to use Session data

- How to use Cookies

- How to validate forms using attributes and model binding

- How to send emails using ASP.NET Core and SendGrid

- How to Implement Authentication and Role based Authorization

- How to reset user password

- How to perform CRUD operations (Create, Read, Update and Delete) on the database using ASP.NET and ADO (no Entity Framework)

- How to perform CRUD operations using Entity Framework

- How to use pagination (Split data on multiple pages)

- How to add advanced search functionalities

- How to upload images to the server

To follow this course, you need to install the following tools

- Visual Studio 2022

- Microsoft SQL Server

Also it is necessary to install two components into Visual Studio: “ASP.NET and web Development” and “.NET Desktop development”

Bạn sẽ học được gì

Yêu cầu

Nội dung khoá học

10 sections

Introduction

2 lectures
Introduction
06:39
Source Code
00:03

Manage the Contact Form

16 lectures
Introduction
03:03
Create New Project
00:49
Connect to SQL Server Database and Create a Table
02:49
Install SqlClient Package
00:48
Contact Form - Create the Form
08:18
Contact Form - Traditional validation
10:10
Contact Form - Validation using Attributes and Model Binding
13:42
Contact Form - Add Messages to Database
03:29
Send Emails
06:18
Contact Form - Send Confirmation Emails
02:01
Update EmailSender
01:04
Messages - List received messages
14:47
Messages - Add Table Pagination
09:48
Message Details
08:49
Delete Messages
03:54
Source Code
00:03

CRUD Operations on Books

15 lectures
Introduction
03:13
Create books table and add images
04:24
Books - List the books
15:18
Books - Add search functionality
06:03
Books - Add pagination
09:52
Books - Add sort functionality
13:56
Create Books - Build the Form
15:43
Create Books - Upload images
03:14
Create Books - Insert Books in Database
03:48
Edit Books - Create the Form
13:51
Edit Books - Update image
03:53
Edit Books - Update Database
03:30
Delete books
06:57
Fix empty images error
01:06
Source Code
00:03

Authentication and Authorization

27 lectures
Introduction
04:21
Add tables to database
02:09
About Sessions
04:20
Enable Session Middleware
01:51
Register - Update Navbar
04:23
Register - Create the Form
10:55
Register - Create new Account
05:50
Register - Send Confirmation Email
02:18
Register - Create Authenticated Session
02:42
Register - Access Control
02:38
Login - Create the Form
08:17
Login - Create Authenticated Session
04:34
Logout
02:26
Authorization - Create Attributes
05:37
Authorization - Use Attributes
05:31
ForgotPassword - Create the Form
06:23
ForgotPassword - Send Reset Token
06:13
ForgotPassword - Save Reset Token
03:23
ResetPassword - Create the Form
10:38
ResetPassword - Update the Password
06:41
Profile - Show Profile
06:41
Profile - Create Update Form
15:36
Profile - Update Profile
09:37
Users - Read Users from Database
06:09
Users - Display Users
05:45
Users - Add Pagination
07:28
Source Code
00:03

Create Orders

33 lectures
Introduction
05:07
Create Order Tables
04:34
Home page - Create Sections
12:30
Home page - Create Book Items
10:09
Home page - Read Book Items from Database
13:08
Shopping Cart - Introduction
05:18
Shopping Cart - Add Icon
04:54
Shopping Cart - Update cookie using Javascript
13:09
Shopping Cart - Read cookie on the server
02:27
Book Details - Read book details from database
05:20
Book Details - Display book details in razor page
09:25
Book Search - Create the Search Form
13:41
Book Search - List Book Items
09:41
Book Search - Add Search Functionality
05:07
Book Search - Implement Pagination
10:09
Cart Details - Create Page Template
08:18
Cart Details - Create OrderItem Class
02:10
Cart Details - Convert Cookie to Dictionary
04:35
Cart Details - List Cart Items
07:55
Cart Details - Add Subtract Delete Items
09:17
Cart Details - Order Summary
10:20
Cart Details - Create Orders
18:33
Admin Orders - OrderItemInfo and OrderInfo
09:17
Admin Orders - Read Orders from Database
04:44
Admin Orders - List Orders
11:44
Admin Orders - Add Pagination
06:58
Admin Order Details - Read Order Details from Database
08:00
Admin Order Details - Show Order Details in the Page
10:52
Admin Order Details - Update Payment Status and Order Status
11:11
Client Orders
06:21
Client Order Details
06:56
Update Layout File
04:23
Source Code
00:03

PayPal Integration

8 lectures
Create paypal application
02:56
Checkout - Display Order Summary
09:05
Checkout - Add PayPal Buttons
05:07
Checkout - Add Handler Methods
04:06
Checkout - Get Paypal Access Token
03:32
Checkout - Implement OnPostCreateOrder
07:35
Checkout - Implement OnPostCompleteOrder
05:03
Source Code
00:02

Bonus

5 lectures
Use Rich Text Editor
05:08
Multilingual Support and Localisation
11:29
Drop-down Lists / Select Elements
17:39
Store and Read the connection string from appsettings.json
05:49
Publish ASP.NET Core Web Application to IIS Server
05:12

[ NEW ] CRUD Operations Using Entity Framework

19 lectures
Introduction
02:25
Create Project and Database
02:29
Install Entity Framework Packages
01:11
Create ApplicationDbContext
03:20
Create Product Model and Products Table
03:59
Add Products to Database
01:39
Read Products
07:33
Add Dropdown Item to Navbar
03:11
Create ProductDto Model
02:27
Create Product - Create the Form
06:30
Create Product - Form Validation
05:18
Create Product - Save Products
04:23
Update Product - Show Product Details
08:06
Update Product - Update Details
05:55
Delete Product
03:36
Read Products - Pagination
09:20
Read Products - Search
05:16
Read Products - Sort
14:26
Source Code
00:02

[ NEW ] Contact Form Using Entity Framework

13 lectures
Introduction
06:45
Create Contact & Attachment models and database tables
05:46
ContactDto Model
02:04
Contact Form - Create the contact form
08:42
Contact Form - Save the contact
11:35
Contact List - Show the contact list
07:54
Contact List - Pagination
05:35
Contact Details - Read the details from the database
04:08
Contact Details - Display the details
05:33
Contact Details - Download attachments
06:32
Delete Contacts
06:00
Send Emails using Brevo / SendinBlue
14:30
Source Code
00:02

[ NEW ] Authentication Using Identity and Entity Framework

12 lectures
Introduction
02:07
Create Project and Database
02:17
Setup DbContext
05:24
IdentityDbContext and ApplicationUser
04:54
Create Roles
03:41
Scaffold Identity Items
03:52
Edit Register Page
09:07
Edit Login Page
04:12
Edit Navbar and Logout Page
03:26
Authorization
04:52
Role-based Authorization
07:53
Source Code
00:02

Đánh giá của học viên

Chưa có đánh giá
Course Rating
5
0%
4
0%
3
0%
2
0%
1
0%

Bình luận khách hàng

Viết Bình Luận

Bạn đánh giá khoá học này thế nào?

image

Đăng ký get khoá học Udemy - Unica - Gitiho giá chỉ 50k!

Get khoá học giá rẻ ngay trước khi bị fix.