Perform Master Detail CRUD operations in AspNet Core (Part 2)

In the previous part of this article series you were introduced to the sample application we are building. You also created the EF Core model consisting of Team, TeamMember, and AppDbContext classes. In this part we will add TeamsController to the web application perform CRUD operations on the Teams table. Open the same project that we created in the previous part and add two enumerations to the Models folder named DataDisplayModes and DataEntryTargets.

#asp.net #asp.net core #.net #.net core #c# #visual studio

What is GEEK

Buddha Community

Perform Master Detail CRUD operations in AspNet Core (Part 2)
Einar  Hintz

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

Perform Master Detail CRUD operations in AspNet Core (Part 2)

In the previous part of this article series you were introduced to the sample application we are building. You also created the EF Core model consisting of Team, TeamMember, and AppDbContext classes. In this part we will add TeamsController to the web application perform CRUD operations on the Teams table. Open the same project that we created in the previous part and add two enumerations to the Models folder named DataDisplayModes and DataEntryTargets.

#asp.net #asp.net core #.net #.net core #c# #visual studio

Perform Master Detail CRUD operations in AspNet Core (Part 3)

In the previous part of this article series you created the TeamsController that performs CRUD operations on the Teams table. In this part you will continue to develop the app by creating TeamMembersController. The TeamMembersController performs CRUD operations on the TeamMembers table. Begin by adding TeamMembersController class into the Controllers folder. The following figure shows both the controllers in the Controllers folder.

#asp.net #asp.net core #.net #.net core #c# #visual studio

Aketch  Rachel

Aketch Rachel

1618924620

Perform Master Detail CRUD operations in AspNet Core (Part 5)

In Part 4 of this article series we added the Main view, _Teams partial, and _TeamMembers partial. Recollect that _Teams partial and _TeamMembers partial show a Team or TeamMember record in read-only, insert, or update mode. This is done with the help of six partials - three belonging to _Teams partial and three belonging to _TeamMembers partial.

#asp.net #asp.net core #.net #.net core #c# #vosual studio

Eric  Bukenya

Eric Bukenya

1619505988

Perform Master Detail CRUD operations in AspNet Core (Part 6)

In Part 5 of this series you created three partials namely _ShowTeam, _InsertTeam, and _UpdateTeam. In this part you will add the remaining three partials viz. _ShowTeamMember, _InsertTeamMember, and _UpdateTeamMember. For your quick reference let’s take a look at the organization of partials again:

http://www.binaryintellect.net/articles/6f9cfcff-6723-48d8-8a8b-bb5474da8ff4.aspx

#asp.net #asp.net core #.net #.net core #c# #visual studio