
Create a bookstore web project in Visual Studio 2022 using ASP.NET Core MVC with ado.net, organizing the solution into entities, services, and a web project while connecting to a database.
Explore a full ASP.NET core and ADO.NET e-commerce book store demo, covering login, cart, orders, admin management, and a many-to-many book-category model with Entity Framework.
Create a bookstore database in SQL Server with tables for bookstore, book category, book, book author, user, cart, and order, using primary keys and identity.
Create category and order tables with primary keys and identity, define id, book id, name, price, quantity, total amount, user id, order date, and set the appsettings.json connection string.
Create a login partial view, inject IHttpContextAccessor, and display login links or the username from session; register IHttpContextAccessor as a singleton and run to view login and register links.
Implement an authentication service to validate users via username and password, return an authenticated user, and retrieve the corresponding role by role id for login.
Create a login view model with username and password and integrate it with an account controller and authentication service to validate users and establish session data.
Design a home page in the home controller, map book data to a view model, and implement index and details views to display books, authors, categories, and add-to-cart functionality.
Demonstrates saving a book to the cart in an ASP.NET Core app by validating the user session, authenticating the user, and inserting cart data into the database.
Create a cart feature in asp.net core by building a view component that reads session cart and user id, fetches cart details via a book service, and updates cart icon.
Develop a cart controller using a book service, fetch the user's cart from session in the index action, and display items with a grand total in razor view, including logout.
Edit cart item quantities in an ASP.NET Core with ADO.NET course by loading the cart via user id, displaying a Razor edit view, and updating quantity via post action.
Update cart quantities and total amounts in an ASP.NET Core with ADO.NET project using post actions, edit workflows, and redirect to index to reflect changes.
Learn to delete a cart item by id in an ASP.NET Core with ADO.NET project, using a cart service to execute the delete and redirect to the cart index.
Explore implementing the address detail page and change address workflow in an ASP.NET Core cart-to-payment flow, including billing detail view model, session-based user retrieval, and address updates via post method.
Update user address and contact details via a change address form, using an ASP.NET Core with ADO.NET project and a post to update the user record.
Add items to the order by inserting into order details, fetch the user cart by ID, bulk copy to the order date master, then show success and delete cart items.
Design an orders controller in ASP.NET Core with ADO.NET, retrieving all orders for admins or user-specific orders, and prepare order detail data for the view.
Explore implementing and displaying orders in an ASP.NET Core app, wiring up order header and order details, and rendering a list of orders in a table through the orders controller.
Apply a bootstrap bootswatch theme to an ASP.NET Core project by adding a CSS file, updating layout and header navigation, and refining pages like orders and login.
Add a new bookstore controller with create and index actions, wiring dependency injection for the bookstore service and supporting http get and post methods.
Demonstrates edit and delete operations for a bookstore in ASP.NET Core, using a bookstore service to fetch by id, update details, and delete by id via controllers and Razor views.
Implement a complete author CRUD in an ASP.NET Core with ADO .NET project by building an authors controller, service, and Razor views for index, create, edit, and delete.
Build and integrate a categories controller and views in an ASP.NET Core app, wiring category data through a bookstore and authors services to support a many-to-many book-category relationship.
Build a books controller with list and create methods, using a book view model, category checkboxes, and dropdowns for bookstores and authors.
Add a new book with category via http post, including image upload and a book view model. Use ado.net to insert the book and its categories into the database.
Create and enforce one-to-many relationships between books, authors, and stores using foreign keys, inner joins, and a book list view model to display author and store names.
Explore implementing a many-to-many relationship between books and categories in ASP.NET Core with ADO.NET, including a book_category join table, foreign keys, and cascade delete.
Update book features, integrating create and edit workflows with a book view model and category lists. Use get book with categories, post actions, and a bookstore service to persist changes.
Delete a book by its id using the bookstore service and redirect to the index. Also implement deleting a category by id and navigate the workflow from adding to deletion.
Authorize features behind the admin role and hide bookstore menu items using http context accessor and session checks, demonstrating role-based UI control in an ASP.NET Core project.
This Course complete the following topics like
1. How to start Project in Visual Studio 2022 with Target framework 7.0
2. How to Connect Database with ADO .NET in ASP.NET CORE MVC
3. Start Book Store Project , Real Time scratched project
4. Repository pattern with 3-tier architecture
5. Session to store User Credential
6. Action Filter to handle User Session
7. Controller to View for rendering the UI
8. DI : Dependency Injection to create object in IOC Container
9. Service Layer to design business logics
10. Theme Concept
11. Bootswatch theme
12. Relationship between the object
13. SQL Connection to create connection with Database
14. Sql Command for Quering with the database table
15. Sql DataReader to read data from Database server
16. Stroed Prcedure to handle Project Functions
17. Middleware to Render Request and response pipeline
18. ViewBag, ViewData and TempData , use for transfer data from controller to view
19. Partial View for navigation
20 View Component for showing cart items
21 Html Helper to show UI in Razor Views
22. Use Tag helpers
23. Paging Searching and Sort the data
24 Repository Pattern to Handle Data Function
25 Generic Function to handle common things
26 Modular monolithic application for book store ecommerce project
27. Ecommerce project for storing book, Purchase book, Cart Option, Order Options
28. Basic Functionality of Shoping cart