c# MVC SEARCH function

I have a form in .NET MVC page. the fields are : Account Number: , Arrival Date :. when the user enters the account number and arrival date and hit on SEARCH button all the data related to the patient should be displayed from the database in the grid or table below the SEARCH button.

Please help me with this.

Thanks,

Palak Patil

Getting a error :

"'Object does not contain a definition for 'Where' and no extension method 'Where' accepting a first arguement of type 'object' could be found ( are you missing using a directive or assembly reference?"

I have pasted my "customapp.cshtml" page which lists all the patient details. Whenn the user clicks on "Search" hyperlink on this page it takes him to "details.cshtml" page that includes search page.

PLEASE HELP ME WITH THIS ERROR.

My "Home controller" page :

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using ibexcustomapp.Models;
using System.IO;
namespace ibexcustomapp.Controllers
{
public class HomeController : Controller
{ //IbexImageRetrievalEntities1 db = new IbexImageRetrievalEntities1();
//const int pageSize = 100;
[HttpGet]
public ActionResult customapp(ibexPatient pat)
{
int PatID = pat.PatID;
string AccountNumber = pat.AccountNumber;
string MedicalRecordNumber = pat.MedicalRecordNumber;
string FirstName = pat.FirstName;
string LastName = pat.LastName;
string IbexFile = pat.Ibexfile;
//string ArrivalDate = pat.ArrivalDate;
//var Customapp = db.ibexPatients
// //.OrderBy(p => p.PatID)
// .Skip((page - 1) * pageSize)
// .Take(pageSize)
// .ToList();
return View();
}
//public class HomeController : Controller
//{ // [HttpPost]
public ActionResult Index(string option, string search)
{
IbexImageRetrievalEntities1 db = new IbexImageRetrievalEntities1();
if (option == "Account Number")
{
return View(db.ibexPatients.Where(x => x.AccountNumber == search || search == null).ToList());
}
else if (option == "Medical Record Number")
{
return View(db.ibexPatients.Where(x => x.MedicalRecordNumber == search || search == null).ToList());
}
else if (option == "First Name")
{
return View(db.ibexPatients.Where(x => x.FirstName == search || search == null).ToList());
}
else
{
return View(db.ibexPatients.Where(x => x.LastName == search || search == null).ToList());
}
}
//private ActionResult View(object p)
//{ // throw new NotImplementedException();
//}
}
}

MY "customapp.cshtml" PAGE :

@model IList
@{
ViewBag.Title = "customapp";
}
@*
Ibex Patients
*@
"float:left ; color:darkorange">
@Html.ActionLink("SEARCH", "Index", null, new { @style = "font-size : larger; color : Blue;" })

@using (Html.BeginForm())

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ahmed Abdi7y ago
Hi palak!I have implemented exactly the same search feature you are looking for in my clinic project demo under the report part.Article link ---->https://www.c-sharpcorner.com/article/clinic-management-project-using-asp-net-mvc-5/
Palak Patil7y ago
Getting a error :

"'Object does not contain a definition for 'Where' and no extension method 'Where' accepting a first arguement of type 'object' could be found ( are you missing using a directive or assembly reference?"

I have pasted my "customapp.cshtml" page which lists all the patient details. Whenn the user clicks on "Search" hyperlink on this page it takes him to "details.cshtml" page that includes search page.

PLEASE HELP ME WITH THIS ERROR.

My "Home controller" page :
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using ibexcustomapp.Models;
using System.IO;
namespace ibexcustomapp.Controllers
{
public class HomeController : Controller
{ //IbexImageRetrievalEntities1 db = new IbexImageRetrievalEntities1();
//const int pageSize = 100;
[HttpGet]
public ActionResult customapp(ibexPatient pat)
{
int PatID = pat.PatID;
string AccountNumber = pat.AccountNumber;
string MedicalRecordNumber = pat.MedicalRecordNumber;
string FirstName = pat.FirstName;
string LastName = pat.LastName;
string IbexFile = pat.Ibexfile;
//string ArrivalDate = pat.ArrivalDate;
//var Customapp = db.ibexPatients
// //.OrderBy(p => p.PatID)
// .Skip((page - 1) * pageSize)
// .Take(pageSize)
// .ToList();
return View();
}
//public class HomeController : Controller
//{ // [HttpPost]
public ActionResult Index(string option, string search)
{
IbexImageRetrievalEntities1 db = new IbexImageRetrievalEntities1();
if (option == "Account Number")
{
return View(db.ibexPatients.Where(x => x.AccountNumber == search || search == null).ToList());
}
else if (option == "Medical Record Number")
{
return View(db.ibexPatients.Where(x => x.MedicalRecordNumber == search || search == null).ToList());
}
else if (option == "First Name")
{
return View(db.ibexPatients.Where(x => x.FirstName == search || search == null).ToList());
}
else
{
return View(db.ibexPatients.Where(x => x.LastName == search || search == null).ToList());
}
}
//private ActionResult View(object p)
//{ // throw new NotImplementedException();
//}
}
}
MY "customapp.cshtml" PAGE :
@model IList
@{
ViewBag.Title = "customapp";
}
@*
Ibex Patients
*@



"float:left ; color:darkorange">

@Html.ActionLink("SEARCH", "Index", null, new { @style = "font-size : larger; color : Blue;" })
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()
class="form-horizontal">
@*
ibexPatient
*@

c# MVC SEARCH function

Ibex Patients

ibexPatient