We're sorry but this website doesn't work properly without JavaScript enabled. Please enable it to continue.

Linkedin- https://www.linkedin.com/in/chowdhurykaushik

#asp.net 5 #.net #net 5 #razor pages

What is GEEK

Buddha Community

Online Snacks Ordering System with ASP.NET 5 Razor Pages(Working with Data) - Part 5

Einar Hintz

1602560783

jQuery Ajax CRUD in ASP.NET Core MVC with Modal Popup

In this article, we’ll discuss how to use jQuery Ajax for ASP.NET Core MVC CRUD Operations using Bootstrap Modal. With jQuery Ajax, we can make HTTP request to controller action methods without reloading the entire page, like a single page application.

To demonstrate CRUD operations – insert, update, delete and retrieve, the project will be dealing with details of a normal bank transaction. GitHub repository for this demo project : https://bit.ly/33KTJAu.

Sub-topics discussed :

Form design for insert and update operation.
Display forms in modal popup dialog.
Form post using jQuery Ajax.
Implement MVC CRUD operations with jQuery Ajax.
Loading spinner in .NET Core MVC.
Prevent direct access to MVC action method.

Create ASP.NET Core MVC Project

In Visual Studio 2019, Go to File > New > Project (Ctrl + Shift + N).

From new project window, Select Asp.Net Core Web Application_._

Image showing how to create ASP.NET Core Web API project in Visual Studio.

Once you provide the project name and location. Select Web Application(Model-View-Controller) and uncheck HTTPS Configuration. Above steps will create a brand new ASP.NET Core MVC project.

Showing project template selection for .NET Core MVC.

Setup a Database

Let’s create a database for this application using Entity Framework Core. For that we’ve to install corresponding NuGet Packages. Right click on project from solution explorer, select Manage NuGet Packages_,_ From browse tab, install following 3 packages.

Showing list of NuGet Packages for Entity Framework Core

Now let’s define DB model class file – /Models/TransactionModel.cs.

public class TransactionModel
{
    [Key]
    public int TransactionId { get; set; }

    [Column(TypeName ="nvarchar(12)")]
    [DisplayName("Account Number")]
    [Required(ErrorMessage ="This Field is required.")]
    [MaxLength(12,ErrorMessage ="Maximum 12 characters only")]
    public string AccountNumber { get; set; }

    [Column(TypeName ="nvarchar(100)")]
    [DisplayName("Beneficiary Name")]
    [Required(ErrorMessage = "This Field is required.")]
    public string BeneficiaryName { get; set; }

    [Column(TypeName ="nvarchar(100)")]
    [DisplayName("Bank Name")]
    [Required(ErrorMessage = "This Field is required.")]
    public string BankName { get; set; }

    [Column(TypeName ="nvarchar(11)")]
    [DisplayName("SWIFT Code")]
    [Required(ErrorMessage = "This Field is required.")]
    [MaxLength(11)]
    public string SWIFTCode { get; set; }

    [DisplayName("Amount")]
    [Required(ErrorMessage = "This Field is required.")]
    public int Amount { get; set; }

    [DisplayFormat(DataFormatString = "{0:MM/dd/yyyy}")]
    public DateTime Date { get; set; }
}

C#Copy

Here we’ve defined model properties for the transaction with proper validation. Now let’s define DbContextclass for EF Core.

#asp.net core article #asp.net core #add loading spinner in asp.net core #asp.net core crud without reloading #asp.net core jquery ajax form #asp.net core modal dialog #asp.net core mvc crud using jquery ajax #asp.net core mvc with jquery and ajax #asp.net core popup window #bootstrap modal popup in asp.net core mvc. bootstrap modal popup in asp.net core #delete and viewall in asp.net core #jquery ajax - insert #jquery ajax form post #modal popup dialog in asp.net core #no direct access action method #update #validation in modal popup

1625205060

Online Snacks Ordering System with ASP.NET 5 Razor Pages(Working with Data) - Part 5

Previous (Part 4): https://youtu.be/D6-y7dnM4hE
Next (Part 6):

This is part 5 of a Razor Pages series of tutorials for an online snacks/desserts ordering system.
In this part, working with data is shown in the Visual Studio Code project. You will focus on using the SnacksContext to retrieve data for display on the home page and the ordering page, which has yet to be added to the application. The ordering page is also added in this tutorial.

This step-by-step Razor Pages tutorial series demonstrates how to create a Razor Pages application from scratch, and how to add common functionality to it including communicating with a database, working with forms, and sending an email.

Like || Share || Spread || Love

Make sure you subscribe to our YouTube Channel and never miss our latest video:- http://bit.ly/Kaushik-roy-chowdhury-subscribe

Completed Project Source Code: https://github.com/krchome/Snacks

Buy me a coffee
https://www.buymeacoffee.com/5m1piIG

Support The Channel By Donations:
https://www.patreon.com/deveducator

For more updates Follow us on:-

Linkedin- https://www.linkedin.com/in/chowdhurykaushik

#asp.net 5 #.net #net 5 #razor pages

1625201400

Snacks Ordering System with ASP.NET 5 Razor Pages (Database Migration) - Part 4

Previous (Part 3): https://youtu.be/_qO1mEOhZ8w
Next (Part 5): https://youtu.be/-i-GrNNo1bo
This is part 4 of a Razor Pages series of tutorials for an online snacks/desserts ordering system.
In this part, database migration is done to the Visual Studio Code project. This creates the database through EF Core using SQLite. The seeding of the database Product table is done in code.

This step-by-step Razor Pages tutorial series demonstrates how to create a Razor Pages application from scratch, and how to add common functionality to it including communicating with a database, working with forms, and sending an email.

Like || Share || Spread || Love

Make sure you subscribe to our YouTube Channel and never miss our latest video:- http://bit.ly/Kaushik-roy-chowdhury-subscribe

Completed Project Source: https://github.com/krchome/Snacks

Buy me a coffee
https://www.buymeacoffee.com/5m1piIG

Support The Channel By Donations:
https://www.patreon.com/deveducator

For more updates Follow us on:-

Linkedin- https://www.linkedin.com/in/chowdhurykaushik

#asp.net 5 #.net #net 5 #razor pages

1625197740

Snacks Ordering System with ASP.NET 5 Razor Pages (Add Model) - Part 3

https://www.youtube.com/watch?v=_qO1mEOhZ8wPrevious (Part2): https://youtu.be/lPHY4XxBs0E
Next (Part 4):
This is part 3 of a Razor Pages series of tutorials for an online snacks/desserts ordering system.
In this part, the Product Model is added to the Visual Studio Code project.

This step-by-step Razor Pages tutorial series demonstrates how to create a Razor Pages application from scratch, and how to add common functionality to it including communicating with a database, working with forms, and sending an email.

Like || Share || Spread || Love
#ASPNET5 #RazorPagesOnlineOrderingFromScratch #RazorPagesWithVSCode

Make sure you subscribe to our YouTube Channel and never miss our latest video:- http://bit.ly/Kaushik-roy-chowdhury-subscribe

Completed Project Source: https://github.com/krchome/Snacks
Support The Channel By Donations:
https://www.patreon.com/deveducator

For more updates Follow us on:-

Linkedin- https://www.linkedin.com/in/chowdhurykaushik

Like || Share || Spread || Love

Make sure you subscribe to our YouTube Channel and never miss our latest video:- http://bit.ly/Kaushik-roy-chowdhury-subscribe

Support The Channel By Donations:
https://www.patreon.com/deveducator

For more updates Follow us on:-

Linkedin- https://www.linkedin.com/in/chowdhurykaushik

#asp.net 5 #net 5 #.net #razor pages

1625194081

Snacks Ordering System with ASP.NET 5 Razor Pages (Add New Page) - Part 2

Previous (Part 1): https://youtu.be/SMi0DlWf8KA
Next (Part 3): https://youtu.be/_qO1mEOhZ8w
This is part 2 of a Razor Pages series of tutorials for an online snacks/desserts ordering system.
In this part, the About Page is added to the Visual Studio Code project.

This step-by-step Razor Pages tutorial series demonstrates how to create a Razor Pages application from scratch, and how to add common functionality to it including communicating with a database, working with forms, and sending an email.

Like || Share || Spread || Love
#ASPNET5 #RazorPagesOnlineOrderingFromScratch #RazorPagesWithVSCode

Make sure you subscribe to our YouTube Channel and never miss our latest video:- http://bit.ly/Kaushik-roy-chowdhury-subscribe

Completed Project Source: https://github.com/krchome/Snacks
Support The Channel By Donations:
https://www.patreon.com/deveducator

For more updates Follow us on:-

Linkedin- https://www.linkedin.com/in/chowdhurykaushik