Working with Drop Down control in .Net Core MVC with steps

-

In previous articles we have learned about code first approach, Entity migration, crud operation in MVC .NET core, in this article i am going to demonstrate about work with drop down control in .NET Core MVC application with JQuery drop down binding.

I am going to use the same application which i have used in crud operation article. So lets start the implementation.

 


 

 

First we need to create the City and State models for that add below classes in ModelExample project.

 CityMaster.cs

 using System;  
 using System.Collections.Generic;  
 using System.ComponentModel.DataAnnotations;  
 using System.ComponentModel.DataAnnotations.Schema;  
 using System.Text;  
 namespace ModelsExample  
 {  
   [Table("CityMaster")]  
   public class CityMaster  
   {  
     [Key]  
     [Column("Id")]  
     public int Id { get; set; }  
     [Column("Name")]  
     public string Name { get; set; }  
     [Column("StateMasterId")]  
     public int StateMasterId { get; set; }  
     public virtual StateMaster StateMaster { get; set; }  
 }  
 }

  StateMaster.cs

 using System;  
 using System.Collections.Generic;  
 using System.ComponentModel.DataAnnotations;  
 using System.ComponentModel.DataAnnotations.Schema;  
 using System.Text;  
 namespace ModelsExample  
 {  
   [Table("StateMaster")]  
   public class StateMaster  
   {  
     [Key]  
     [Column("Id")]  
     public int Id { get; set; }  
     [Column("Name")]  
     public string Name { get; set; }  
   }  
 }

 To store the cityId and stateId in employee Table we need to add two properties in Employee model as below.

Employee.cs 

 using System;  
 using System.ComponentModel.DataAnnotations.Schema;  
 namespace ModelsExample  
 {  
   [Table("EmployeeMaster")]  
   public class Employee  
   {  
     [Column("Id")]  
     public int Id { get; set; }  
     [Column("Name")]  
     public string Name { get; set; }  
     [Column("Address")]  
     public string Address { get; set; }  
     [Column("CityId")]  
     public int CityId { get; set; }  
     [Column("StateId")]  
     public int StateId { get; set; }  
   }  
 }

 

Now go to view >> Package manager Console and run below migration command to add the migration

  add-migration "AddedCityAndStateMaster"

 after executing the above migration command below migration file will be created.

 using Microsoft.EntityFrameworkCore.Migrations;  
 namespace ModelsExample.Migrations  
 {  
   public partial class AddedCityAndStateMaster : Migration  
   {  
     protected override void Up(MigrationBuilder migrationBuilder)  
     {  
       migrationBuilder.AddColumn<int>(  
         name: "CityId",  
         table: "EmployeeMaster",  
         nullable: false,  
         defaultValue: 0);  
       migrationBuilder.AddColumn<int>(  
         name: "StateId",  
         table: "EmployeeMaster",  
         nullable: false,  
         defaultValue: 0);  
       migrationBuilder.CreateTable(  
         name: "StateMaster",  
         columns: table => new  
         {  
           Id = table.Column<int>(nullable: false)  
             .Annotation("SqlServer:Identity", "1, 1"),  
           Name = table.Column<string>(nullable: true)  
         },  
         constraints: table =>  
         {  
           table.PrimaryKey("PK_StateMaster", x => x.Id);  
         });  
       migrationBuilder.CreateTable(  
         name: "CityMaster",  
         columns: table => new  
         {  
           Id = table.Column<int>(nullable: false)  
             .Annotation("SqlServer:Identity", "1, 1"),  
           Name = table.Column<string>(nullable: true),           
           StateMasterId = table.Column<int>(nullable: true)  
         },  
         constraints: table =>  
         {  
           table.PrimaryKey("PK_CityMaster", x => x.Id);  
           table.ForeignKey(  
             name: "FK_CityMaster_StateMaster_StateMasterId",  
             column: x => x.StateMasterId,  
             principalTable: "StateMaster",  
             principalColumn: "Id",  
             onDelete: ReferentialAction.Restrict);  
         });  
       migrationBuilder.CreateIndex(  
         name: "IX_CityMaster_StateMasterId",  
         table: "CityMaster",  
         column: "StateMasterId");  
     }  
     protected override void Down(MigrationBuilder migrationBuilder)  
     {  
       migrationBuilder.DropTable(  
         name: "CityMaster");  
       migrationBuilder.DropTable(  
         name: "StateMaster");  
       migrationBuilder.DropColumn(  
         name: "CityId",  
         table: "EmployeeMaster");  
       migrationBuilder.DropColumn(  
         name: "StateId",  
         table: "EmployeeMaster");  
     }  
   }  
 }

We have created models and migration  now we will create business class for MasterService.

Add Interface called IMasterService in businessService Project under Definition folder as below.

 using ModelsExample;  
 using System;  
 using System.Collections.Generic;  
 using System.Text;  
 namespace BusinessLayerExample.Definition  
 {  
   public interface IMasterService  
   {  
     List<StateMaster> GetStateMaster();  
     List<CityMaster> GetCityMaster(int StateId);  
   }  
 }

 Add Class called MasterService in businessService Project under Implementation folder as below. 

 using BusinessLayerExample.Definition;  
 using ModelsExample;  
 using System;  
 using System.Collections.Generic;  
 using System.Linq;  
 using System.Text;  
 namespace BusinessLayerExample.Implementation  
 {  
   public class MasterService : IMasterService  
   {  
     private readonly SampleDbContext sampleDbObj;  
     public MasterService(SampleDbContext sampleDbObj)  
     {  
       this.sampleDbObj = sampleDbObj;  
     }  
     public List<CityMaster> GetCityMaster(int StateId)  
     {  
       return sampleDbObj.cityMasters.Where(obj => obj.StateId == StateId).ToList();  
     }  
     public List<StateMaster> GetStateMaster()  
     {  
       return sampleDbObj.stateMasters.ToList();  
     }  
   }  
 }

 Now we need to add controller for MasterData in MVC project under Controller folder as below

 MasterDataController.cs 

 using BusinessLayerExample.Definition;  
 using Microsoft.AspNetCore.Mvc;  
 using System;  
 using System.Collections.Generic;  
 using System.Linq;  
 using System.Threading.Tasks;  
 namespace Project_structiure_Example.Controllers  
 {  
   public class MasterDataController : Controller  
   {  
     private readonly IMasterService masterService;  
     public MasterDataController(IMasterService masterService)  
     {  
       this.masterService = masterService;  
     }  
     [HttpGet]  
     public IActionResult GetCity(int StateId)  
     {  
       var cityData= masterService.GetCityMaster(StateId);  
       return Json(cityData);  
     }  
   }  
 }

 Now we need to modify the EmployeeController in order to fill the dropdown in view.

 using BusinessLayerExample.Definition;  
 using Microsoft.AspNetCore.Mvc;  
 using ModelsExample;  
 using System;  
 using System.Collections.Generic;  
 using System.Linq;  
 using System.Threading.Tasks;  
 namespace Project_structiure_Example.Controllers  
 {  
   public class EmployeeController : Controller  
   {  
     public readonly IEmployeeService employeeService;  
     public readonly IMasterService masterService;  
     public EmployeeController(IEmployeeService employeeServiceObj,IMasterService masterService)  
     {  
       employeeService = employeeServiceObj;  
       this.masterService = masterService;  
     }  
     public IActionResult Index()  
     {  
       var employees = employeeService.GetEmplyees();  
       return View(employees);  
     }  
     [HttpGet]  
     public IActionResult SaveEmployee()  
     {  
       ViewBag.StateMaster= masterService.GetStateMaster();  
       return View(new Employee());  
     }  
     [HttpPost]  
     public IActionResult SaveEmployee(Employee employee)  
     {  
      var result= employeeService.SaveEmployee(employee);  
       if(result)  
       {  
         return RedirectToAction("Index");  
       }  
       else  
       {  
         return View(employee);  
       }  
     }  
     [HttpGet]  
     public IActionResult UpdateEmployee(int id)  
     {  
       var employee = employeeService.GetEmplyees(id);  
       return View(employee);  
     }  
     [HttpPost]  
     public IActionResult UpdateEmployee(Employee employee)  
     {  
       var result = employeeService.UpdateEmployee(employee);  
       if (result)  
       {  
         return RedirectToAction("Index");  
       }  
       else  
       {  
         return View(employee);  
       }  
     }  
     [HttpGet]  
     public IActionResult DeleteEmployee(int id)  
     {  
       var employee = employeeService.GetEmplyees(id);  
       return View(employee);  
     }  
     [HttpPost]  
     public IActionResult DeleteEmployee(int id,Employee emp)  
     {  
       var result = employeeService.DeleteEmployee(id);  
       if (result)  
       {  
         return RedirectToAction("Index");  
       }  
       else  
       {  
         return View(emp);  
       }  
     }  
   }  
 }

 

Now we need use the viewbag.StateMaster value in SaveEmployee view in DropDownListFor control.

SaveEmployee.chtml

 @*  
   For more information on enabling MVC for empty projects, visit https://go.microsoft.com/fwlink/?LinkID=397860  
 *@  
 @using ModelsExample  
 @model Employee  
 @{  
 }  
 @section Scripts  
 {  
 <script type="text/javascript">  
   $(document).ready(function () {  
     $("#StateId").change(function () {  
       var stateId = $(this).val();  
       $.get("/MasterData/GetCity?StateId=" + stateId, function (data) {  
         var city = $("#CityId");  
         city.html('');  
         city.append($("<option/>", { value: "0", text: "Select" }));  
         if (data && data.length > 0) {  
           $.each(data, function (index, item) {  
             city.append($("<option/>", { value: item.id, text: item.name }));  
           });  
         }  
       });  
     });  
   });  
 </script>  
 }  
 @using (Html.BeginForm())  
 {  
   <h1>Enter Employee Details</h1>  
   <div>  
     @Html.LabelFor(model => model.Name)  
   </div>  
   <div>  
     @Html.TextBoxFor(model => model.Name)  
   </div>  
   <div>  
     @Html.LabelFor(model => model.Address)  
   </div>  
   <div>  
     @Html.TextBoxFor(model => model.Address)  
   </div>  
   <div>  
     @Html.LabelFor(model => model.StateId)  
   </div>  
   <div>  
     @Html.DropDownListFor(model => model.StateId, new SelectList(ViewBag.StateMaster, "Id", "Name", 0), "Select")  
   </div>  
   <div>  
     @Html.LabelFor(model => model.CityId)  
   </div>  
   <div>  
     @Html.DropDownListFor(model => model.CityId, new SelectList(Enumerable.Empty<SelectListItem>(), "Id", "Name", 0), "Select")  
   </div>  
   <hr />  
   <div>  
     <input type="submit" value="Submit" /> @Html.ActionLink("Back to employees", "Index")  
   </div>  
 }

 In above code you can see that we have used dropdownlistfor for biding the statemaster. We have added section script for registering the state dropdown change event using Jquery.In the Change event we have called the Getcity api to fetch the cities based on the state dropdown selection.

We are done with our basic code now we can run the application and check the output.

drop down

 
save output

 

Comments

Post a Comment

Popular posts from this blog

Implement Logging in CSV file using Nlog in .net core MVC application- part 2

-
Image
In previous article " Implement Nlog in .Net core MVC application part 1 "  I have demonstrated how we can implement basic setup of NLog in .core mvc application. In previous article we have logged the exceptions in flat file system. In this article I will show you how you can write the exception and custom logs in csv file. Writing logs in csv file can enable us better readability of logs in tabular form.       Lets start the implementation of it, I going to use the same example project used in previous demonstration. Modify the Nlog.config file as follows, added new target and rule for logging logs in csv file. <?xml version="1.0" encoding="utf-8" ?> <nlog xmlns="http://www.nlog-project.org/schemas/NLog.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.nlog-project.org/schemas/NLog.xsd NLog.xsd" autoReload="true" throwExceptions="fal
Read more

Implement Nlog in .Net core MVC application part 1

-
Image
Logging is a very important part of the enterprise application/web application. Setting up the logging correctly not only beneficial for long term maintenance of the application but also it is useful tool to find out the RCA in case of mission critical bug arises. Therefor we will going to discuss the various logging technique implementation using Nlog library package. In this article we will going to use .net core application for demonstration but you can implement it in .net framework application also. So lets start the implementation of Nlog in .net core MVC application. Open visual studio 2019/17 and create the new project as shown below.     Select Asp.net core Web App (Model-View-Controller) and provide the project name in project name text box.   Now on next screen click on create button this will create MVC app with .net core Now go to solution explorer and right click on project and click on Manage Nuget Package. Now in Nuget package manager install below listed Nlog packages.
Read more

Angular User Session Timeout example step by step

-
Image
This functionality let the user know that their session is about to expire and that they would be logged out if they didn’t take action. I have written this functionality in Angular for my latest application.  If you are new to Angular 6 then read my article about Setting up Angular 6 step by step before jump to this article to get handy in Angular 6. Dealing with timers in Angular can be significantly different when using React components and subscriptions. The basic premises remains the same, though. We’ll have a service with a timer that will provide a Subject to which consumers of the service can subscribe. A React Subject provides an easy mechanism to trigger a “next” subscription to alert consumers that the timer has expired.   import { Injectable } from '@angular/core'; import { Observable, Subject, Subscription, BehaviorSubject} from 'rxjs/Rx'; @Injectable() export class IdleTimeoutService { private _count: number = 0;
Read more

Disable backspace key using Jquery

-
Disable backspace key in HTML form using Jquery in simple steps. While user enters data into application if user accidentally  press backspace button then it will redirect to previous page and all entered data would be lost. to eliminate this event we can disable the backspace key using Jquery. Following is the JQuery script tag you can add to the web page $(document).keydown(function (e) { var nodeName = e.target.nodeName.toLowerCase(); if (e.which === 8) { if ((nodeName === 'input' && e.target.type === 'text') || nodeName === 'textarea') { // do nothing } else { e.preventDefault(); } } }); The above code can be used seamlessly with any web technology you are using. Hope this will help you in your web application. Happy coding:)
Read more

Devexpress Datebox date formatting in angular 6 with example

-
The Devexpress DateBox in Angular is a widget that displays the date and time in one of DevExtreme predefined formats or a format defined in an external localization library, or a type in the required date/time value. In this article, the i will provide you different date-format which we can set on DateBox to show date and time to user. Following is the code snippet to add Datebox in your Angular form if the you want to capture only date      <dx-date-box [value]="now" displayFormat="EEEE, MMM dd" type="date" > </dx-date-box> Following is the custom formats we can set and depending upon its converted values will be shown. "dd-MM-yyyy" => 28-10-2018 "EEEE, MMM dd" => Sunday, Oct 28 "dd MMM yyyy EEEE" => 28 Oct 2018 Sunday "dd-MM-yyyy EEEE" => 28-10-2018 Sunday alternatively you can change the format as way you want Following is
Read more