Services
Technology Web App Development Mobile App Development Windows App Development Database Development UI/UX Development Cloud Development SEO Digital Marketing Guest Posting Content Writing Artificial Intelligence Data Science ERP Development CRM Development CMS Development LMS Development Business Listing Blockchain Technology Startup Promotion AI Tools Integration
Products
Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller
Developer
Article Blog Forum Interview Beginner News Startup Quiz
Users
Career
Apply Job Internship
Pricing
Login Sign Up Get a Quote

forum

home / developersection / forums / how to filtering with the entity framework is an asp.net mvc application
Ask Question
Anupam Mishra
Anupam Mishra

Other

Message

1 Answers

Anupam Mishra
Anupam Mishra 05 Feb 2016
Report Abuse
Finally, I have resolve this problem.
For Solution of above problem, we are creating  one student controller and its index view. We want to display  a Filter records(i.e. First Name,Last Name ) in index view. For this we create a search string text box in a view for searching  FirstName,LastName in student records.
this is a code of Student controller Index Action:
public ActionResult Index(string sortOrder, string searchString, string currentFilter)
{
ViewBag.NameSortParm = String.IsNullOrEmpty(sortOrder) ? "Name" : "";
ViewBag.DateSortParm = sortOrder == "Date" ? "Date_desc" : "Date";
ViewBag.CurrentFilter = searchString;
if (!String.IsNullOrEmpty(searchString))
    {
        students = students.Where(s => s.FirstName.ToUpper().Contains(searchString.ToUpper())
                               || s.LastName.ToUpper().Contains(searchString.ToUpper()));
    }
{
        students = students.Where(s => s.FirstName.ToUpper().Contains(searchString.ToUpper())
|| s.LastName.ToUpper().Contains(searchString.ToUpper()));
}
   var students = from s in db.Student  // Student is a table i.e. containing records of student
select s;
switch (sortOrder)
{
case "Name":
         students = students.OrderByDescending(s => s.FirstName);
break;
case "Date":
         students = students.OrderBy(s => s.EnrollmentDate);
break;
case "Date_desc":
         students = students.OrderByDescending(s => s.EnrollmentDate);
break;
default:
         students = students.OrderBy(s => s.FirstName);
break;
}
return View(students.ToList());
}
Now. we have changed the index view of student. Code is as Follows: 
  <h2>Student Index</h2>

    <p>

    @Html.ActionLink("Create New",  "Create")

    @using (Html.BeginForm("Index", "Student", FormMethod.Get))

     {

    <p>

        Find by name: @Html.TextBox("SearchString", ViewBag.CurrentFilter as string)  

        <input type="submit" value="Search" />
MindStick Training