+- Softwarez.Info - Software's World! (https://softwarez.info)
+-- Forum: Library Zone (https://softwarez.info/Forum-Library-Zone)
+--- Forum: Video Tutorials (https://softwarez.info/Forum-Video-Tutorials)
+--- Thread: .Net Core Mvc With Dapper - The Complete Course Full Scratch (/Thread-Net-Core-Mvc-With-Dapper-The-Complete-Course-Full-Scratch)
.Net Core Mvc With Dapper - The Complete Course Full Scratch - AD-TEAM - 12-16-2024
![[Image: ac943506a3d6038ab787a906984762fe.jpg]](https://i124.fastpic.org/big/2024/1216/fe/ac943506a3d6038ab787a906984762fe.jpg)
.Net Core Mvc With Dapper - The Complete Course Full Scratch
Published 8/2024
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 3.91 GB | Duration: 7h 0m
Ecommerce Project using Dapper Micro ORM with Stored Procedure
What you'll learn
Dapper Fundamentals Tutorials , How Dapper Communicate with database objects. How Dapper Handle Relationships like one to one and one to many and many to many
Complete Example of Ecommerce Project in .NET 8 with Dapper Technique. In project we have Some modules like UI, Product catalogue , cart and Order Details
How Dapper Handle Authentication and Authorization using efficient manner. Dapper communicate with database table create a session. Use Filters to Authorize
In this project we have a Repository pattern with Dependency Injection to handle Dapper Communication. We have a Dashboard for Admin and Customer. Admin Manage
Product Catalogue. Right now payment option is under processing but we will add later using stripe method and razor pay
Dapper Communicate with database table using stored procedure.
Requirements
Student must have basic Programming skills about C# and ASP .NET Web Frameworks
Description
Dapper Fundamentals Tutorials , How Dapper Communicate with database objects. How Dapper Handle Relationships like one to one and one to many and many to many. Complete Example of Ecommerce Project in .NET 8 with Dapper Technique. In project we have Some modules like UI, Product catalogue , cart and Order Details. How Dapper Handle Authentication and Authorization using efficient manner. Dapper communicate with database table create a session. Use Filters to Authorize. In this project we have a Repository pattern with Dependency Injection to handle Dapper Communication. We have a Dashboard for Admin and Customer. Admin Manage. Product Catalogue. Right now payment option is under processing but we will add later using stripe method and razor pay. Dapper Communicate with database table using stored procedure.- Modules of the Ecommerce ProjectAdmin Module - CRUD Operation on Product and Category Catalogue , Manage Customer OrderCustomer Module - Add Item into Cart and Proceed OrderDapper Connection - Using one to many and many to many mappingDapper Security - Custom User Account with Hased passwordSeed User Information using DapperRepository Pattern with Dependency Injection.Dapper Methods which is Used in Project- ExecuteAsync, QueryAsync,QueryFirstOrDefault, Split TablesAccess data from database table via stored procedue.Filters - Customer Request filter by their roles. In this project , i use custom Authorize Filter for customer request
Overview
Section 1: Introduction
Lecture 1 Ecommerce Project Demo using Dapper
Lecture 2 Getting Started with Ecommerce Project using Dapper
Section 2: Controller, Services and Stored Procedures
Lecture 3 Product Controller with action names
Lecture 4 Stored Procedure on Category Table
Lecture 5 Category Service
Lecture 6 Category Controller
Lecture 7 Views For Category Controller
Lecture 8 Product Controller Part-1
Section 3: Utility Service
Lecture 9 Interface for Utility Service
Lecture 10 Implementation of utility Service
Section 4: Continue with Product Controller
Lecture 11 Add and Update Product Service
Lecture 12 Continue with Product Controller
Lecture 13 Delete Product
Lecture 14 View for Get All Products
Lecture 15 View for Create Update Action method
Section 5: Home Page Design
Lecture 16 Home Page action method and View
Section 6: User Management
Lecture 17 User Role and Their Relationship Query for Create Table
Lecture 18 Stored Procedure for Add Role and Add User
Lecture 19 Data Seeder Class
Lecture 20 Register Data Seeder in Program file
Lecture 21 ViewModels for Accounts
Lecture 22 Register and login Service
Lecture 23 Register and Login Action Method
Lecture 24 Login Partial Page
Lecture 25 Register your Authentication Handlers
Lecture 26 Get User Roles
Lecture 27 Authorization Filter
Lecture 28 Get UserId Service
Section 7: Continue with Controllers
Lecture 29 Cart Table and Details action method of Ecommerce Project
Lecture 30 Modify Existing Stored Procedure
Lecture 31 Product Detail Action Method Part-1
Lecture 32 Cart Service : Get Cart Items
Lecture 33 Add cart Item
Lecture 34 Test to add Cart Item
Section 8: Cart Controller
Lecture 35 Cart Controller Part-1
Lecture 36 Show Cart Items
Lecture 37 View Components
Lecture 38 Session Configuration
Lecture 39 Show Cart Icons with Quantity
Lecture 40 Stored Procedure for Increment and Decrement Quantity
Lecture 41 Service for Increment and Decrement Quantity
Lecture 42 Update cart Quantity
Lecture 43 Signout Functions
Lecture 44 Delete cart Item By ID
Section 9: Cart Summary
Lecture 45 Cart Summary Page
Lecture 46 User Profiles Table Script and Stored Procedure
Lecture 47 Services for User Profile
Lecture 48 Create User Profile
Lecture 49 Create or Update User Profile
Lecture 50 Cart Summary
Lecture 51 Payment Status and OrderStatus
Lecture 52 OrderHeader and OrderDetails Table
Lecture 53 Stored Procedure for OrderHeader and Order Details Table
Lecture 54 Services for Order header and Order details table
Lecture 55 Generate a Order
Section 10: Theme Setup
Lecture 56 Apply Bootswatch theme
Lecture 57 Update Navigation
Lecture 58 Protect Routes
Section 11: Orders Controller
Lecture 59 Stored Procedure for OrderHeader
Lecture 60 Get All Order Repository
Lecture 61 Get All Order UI
Lecture 62 Bug Fixes with UI
Lecture 63 Order Dashboard For Customer
Lecture 64 Download Complete Code
Lecture 65 Access Denied Page
Beginners Who want to Learn Dapper with ASP. NET
![[Image: Y18kaZFR_o.jpg]](https://images2.imgbox.com/3e/28/Y18kaZFR_o.jpg)