public ActionResult ParentSearch()
 {
     using (var parentContext = new SuperluminalContext())
     {
         return View("~/Views/Parent/ParentSearch.cshtml");
     }
 }
        public JsonResult GetParentNames(string term)
        {
            List<string> parentNames = new List<string>();

            if (!string.IsNullOrEmpty(term))
            {
                using (var parentContext = new SuperluminalContext())
                {
                    parentNames = parentContext.Parents.Where(p => p.FirstName.StartsWith(term)).Select(m => m.FirstName).ToList();
                }
            }
            return Json(parentNames, JsonRequestBehavior.AllowGet);
        }
        public ActionResult ParentSearchDetail(ParentSearch model)
        {
            var parentSearchList = new List<Parent>();
            var parent = new Parent();

            using (var parentContext = new SuperluminalContext())
            {
                if (model != null)
                {
                    var parentSearchDetail = (from parents in parentContext.Parents
                                              where (parents.Id == (model.Id ?? 0) || parents.Phone == (model.Phone ?? 0) || parents.FirstName.Contains(model.Name ?? ""))
                                              select new
                                              {
                                                  Id = parents.Id,
                                                  FirstName = parents.FirstName,
                                                  LastName = parents.LastName,
                                                  MiddleName = parents.MiddleName,
                                                  PostCode = parents.PostCode,
                                                  Phone = parents.Phone
                                              }).ToList();

                    foreach (var item in parentSearchDetail)
                    {
                        parent = new Parent
                        {
                            Id = item.Id,
                            FirstName = item.FirstName,
                            MiddleName = item.MiddleName,
                            LastName = item.LastName,
                            Phone = item.Phone,
                            PostCode = item.PostCode
                        };
                        parentSearchList.Add(parent);
                    }
                }
            }
            return PartialView("~/Views/Parent/_ParentSearchGrid.cshtml", parentSearchList);
        }