How to filter the records in MVC | ASPMANTRA | Asp.Net,MVC,AngularJs,Jquery,Javascript,Sql Server AND WCF snippets and tutorial

How to filter the records in MVC

Introduction: In this article today I am going to explain how to filter the records in MVC
filter the records in MVC

Description:

In this example I and shown detail of register users and want to filter the records on the username. To implement the search functionality follows the given steps:
I have a class file in Models (User_Registration.cs) and having structure as shown below: 

using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;

public class User_Registration
    {
        [Key]
        public int Id { get; set; }
       [Required(ErrorMessage="Please Enter UserName")]
        public string User_Name { get; set; }
          [Required(ErrorMessage = "Please Enter First Name")]
        public string First_Name { get; set; }
      [Required(ErrorMessage = "Please Enter Last Name")]
        public string Last_Name { get; set; }
       [DataType(DataType.Upload)]
        public string Profile_Image { get; set; }
    [Required(ErrorMessage = "Please Enter Password")]
        public string Password { get; set; }
        [RegularExpression(@"^([0-9a-zA-Z]([\+\-_\.][0-9a-zA-Z]+)*)+@(([0-9a-zA-Z][-\w]*[0-9a-zA-Z]*\.)+[a-zA-Z0-9]{2,3})$",ErrorMessage = "Please Enter Email ID")]
        public string EmailId { get; set; }
       [Required(ErrorMessage = "Please Enter Gender")]
        public string Sex { get; set; }
        [Required(ErrorMessage = "Please Select Qualification")]
        [ForeignKey("Master_Qualification")]
        public int EducationId { get; set; }
       [Required(ErrorMessage = "Please Select Country")]
        [ForeignKey("Master_Country")]
        public int CountryId { get; set; }
       [Required(ErrorMessage = "Please Enter Phone No")]
        public int Phone_No { get; set; }
     [Required(ErrorMessage = "Please Select the terma & Conditions")]
        public bool Terms { get; set; }

        public virtual Master_Country Master_Country { get; set; }
        public virtual Master_Qualification Master_Qualification { get; set; }
    }

I want to show the users detail and want to filter the records on username. Write the below given code in Controller show the details and filter the records.

Controller:
private ProjectContext db = new ProjectContext();

        public ActionResult Index(string search)
        { 
            var user_registrations = db.User_Registrations.Include(u => u.Master_Country).Include(u => u.Master_Qualification);
          
            if(!String.IsNullOrEmpty(search))
            {
                user_registrations = user_registrations.Where(s => s.User_Name.Contains(search));
            }        
            return View(user_registrations.ToList());
        }

Add the view for Controller and design as code given below.

View:
@model IEnumerable<UserRegistration.Models.User_Registration>

@{
    ViewBag.Title = "Index";
}
<p>
    @Html.ActionLink("Create New", "Create")
        @using (Html.BeginForm("Index", "UserRegistration", FormMethod.Get))
        {   
           //textbox to filter the records
         <p> UserName: @Html.TextBox("search") <input type="submit" value="Search" /></p>
        }
</p>
<table class="table">
    <tr>
        <th>
           UserName
        </th>
        <th>
           First Name
        </th>
        <th>
           Last Name
        </th>
        <th>
          Profile Image
        </th>      
        <th>
           EmailId
        </th>
        <th>
            Sex
        </th>
        <th>
            Qualification
        </th>
        <th>
         Country Name
        </th>
        <th>
            Phone No
        </th>
        <th>      
        </th>
        <th></th>
    </tr>
@foreach (var item in Model) {
    <tr style="border-right:1px solid #000;">
        <td>
            @Html.DisplayFor(modelItem => item.User_Name)
        </td>
        <td>
            @Html.DisplayFor(modelItem => item.First_Name)
        </td>
        <td>
            @Html.DisplayFor(modelItem => item.Last_Name)
        </td>
        <td>
           <img src="@Url.Content(item.Profile_Image)" alt="Image" height="100px" width="100px" />
        </td>     
        <td>
            @Html.DisplayFor(modelItem => item.EmailId)
        </td>
        <td>
            @Html.DisplayFor(modelItem => item.Sex)
        </td>
        <td>
            @Html.DisplayFor(modelItem => item.Master_Qualification.Qualification)
        </td>
        <td>
           @Html.DisplayFor(modelItem => item.Master_Country.Country_Name)
        </td>
        <td>
            @Html.DisplayFor(modelItem => item.Phone_No)
        </td>     
        <td>
            @Html.ActionLink("Edit", "Edit", new { id=item.Id }) |
            @Html.ActionLink("Details", "Details", new { id=item.Id }) |
            @Html.ActionLink("Delete", "Delete", new { id=item.Id })
        </td>
    </tr>
}
</table>

Now build the project and run. Check the result.


Post a Comment

[blogger]

MKRdezign

Contact Form

Name

Email *

Message *

Powered by Blogger.
Javascript DisablePlease Enable Javascript To See All Widget