.Net Core Mvc With Dapper - The Complete Course Full Scratch

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