Add tables to database
Course Content
0 / 133 completedConnect to SQL Server Database and Create a Table
Introduction
Create New Project
Install SqlClient Package
Contact Form - Traditional validation
Contact Form - Add Messages to Database
Contact Form - Validation using Attributes and Model Binding
Contact Form - Create the Form
Contact Form - Send Confirmation Emails
Update EmailSender
Send Emails
Messages - List received messages
Delete Messages
Message Details
Messages - Add Table Pagination
Books - List the books
Create Books - Build the Form
Create Books - Insert Books in Database
Edit Books - Update image
Edit Books - Update Database
Delete books
Books - Add sort functionality
Fix empty images error
Edit Books - Create the Form
Create books table and add images
Books - Add search functionality
Books - Add pagination
Create Books - Upload images
Users - Display Users
Profile - Update Profile
ForgotPassword - Create the Form
Users - Add Pagination
Enable Session Middleware
About Sessions
Register - Update Navbar
Register - Create the Form
Register - Create new Account
Register - Create Authenticated Session
Login - Create the Form
Login - Create Authenticated Session
Authorization - Create Attributes
Logout
Authorization - Use Attributes
ForgotPassword - Save Reset Token
ResetPassword - Update the Password
ResetPassword - Create the Form
ForgotPassword - Send Reset Token
Profile - Create Update Form
Register - Access Control
Add tables to database
Register - Send Confirmation Email
Users - Read Users from Database
Profile - Show Profile
Create Order Tables
Home page - Create Sections
Shopping Cart - Introduction
Home page - Create Book Items
Home page - Read Book Items from Database
Shopping Cart - Add Icon
Shopping Cart - Read cookie on the server
Book Details - Read book details from database
Shopping Cart - Update cookie using Javascript
Book Details - Display book details in razor page
Book Search - Add Search Functionality
Book Search - Create the Search Form
Book Search - List Book Items
Book Search - Implement Pagination
Cart Details - Create Page Template
Cart Details - Create OrderItem Class
Cart Details - Convert Cookie to Dictionary
Cart Details - List Cart Items
Cart Details - Add Subtract Delete Items
Cart Details - Order Summary
Admin Orders - OrderItemInfo and OrderInfo
Admin Orders - List Orders
Admin Orders - Read Orders from Database
Admin Orders - Add Pagination
Cart Details - Create Orders
Admin Order Details - Read Order Details from Database
Admin Order Details - Show Order Details in the Page
Client Orders
Admin Order Details - Update Payment Status and Order Status
Update Layout File
Client Order Details
Create paypal application
Checkout - Display Order Summary
Checkout - Add Handler Methods
Checkout - Add PayPal Buttons
Checkout - Get Paypal Access Token
Checkout - Implement OnPostCreateOrder
Checkout - Implement OnPostCompleteOrder
Use Rich Text Editor
Multilingual Support and Localisation
Store and Read the connection string from appsettings.json
Drop-down Lists Select Elements
Publish ASP.NET Core Web Application to IIS Server
Create Project and Database
Install Entity Framework Packages
Create ApplicationDbContext
Add Products to Database
Create Product Model and Products Table
Read Products
Add Dropdown Item to Navbar
Create ProductDto Model
Create Product - Form Validation
Create Product - Create the Form
Update Product - Update Details
Create Product - Save Products
Update Product - Show Product Details
Delete Product
Read Products - Search
Read Products - Pagination
Read Products - Sort
ContactDto Model
Create Contact & Attachment models and database tables
Contact Form - Create the contact form
Contact List - Pagination
Contact Form - Save the contact
Contact Details - Read the details from the database
Contact List - Show the contact list
Contact Details - Display the details
Contact Details - Download attachments
Delete Contacts
Send Emails using Brevo SendinBlue
Setup DbContext
IdentityDbContext and ApplicationUser
Create Roles
Scaffold Identity Items
Authorization
Edit Login Page
Edit Navbar and Logout Page
Edit Register Page
Role-based Authorization