public ActionResult Search(string Services) { actyouthservicesdb_Entities DE = new actyouthservicesdb_Entities(); var result = DE.Services.Where(x => x.Name.StartsWith(Services)).ToList(); return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult About(string sortOrder, string searchString) { /*code for search and sort/filters*/ ViewBag.NameSortParm = String.IsNullOrEmpty(sortOrder) ? "Name_desc" : ""; var services = from s in db.Services select s; if (!string.IsNullOrEmpty(searchString)) { services = services.Where(s => s.Name.ToUpper().Contains(searchString.ToUpper()) || s.Description.ToUpper().Contains(searchString.ToUpper())); } switch (sortOrder) { case "Name_desc": services = services.OrderByDescending(s => s.Name); break; case "Date": services = services.OrderBy(s => s.Description); break; default: services = services.OrderBy(s => s.Name); break; } /*get map*/ actyouthservicesdb_Entities DE = new actyouthservicesdb_Entities(); return(View(services.ToList())); }