public JsonResult GetSearchPatients(vwSearchPatients objView) { try { var objSearchPatients = (from p in objDBContext.vwSearch where p.PracticeID == objView.PracticeID select p).ToList(); if (objView.FirstName != null && objView.FirstName != "") objSearchPatients = objSearchPatients.Where(p => p.FirstName == objView.FirstName).ToList(); if (objView.LastName != null && objView.LastName != "") objSearchPatients = objSearchPatients.Where(p => p.LastName == objView.LastName).ToList(); if (objView.PhoneNumber1 != null && objView.PhoneNumber1 != "") objSearchPatients = objSearchPatients.Where(p => p.PhoneNumber1 == objView.PhoneNumber1).ToList(); if (objView.ProviderID != 0 && objView.ProviderID != null) objSearchPatients = objSearchPatients.Where(p => p.ProviderID == objView.ProviderID).ToList(); if (objView.InsuranceName != null && objView.InsuranceName != "") objSearchPatients = objSearchPatients.Where(p => p.InsuranceName == objView.InsuranceName).ToList(); if (objView.Date_Of_Birth != null) objSearchPatients = objSearchPatients.Where(p => p.Date_Of_Birth == objView.Date_Of_Birth).ToList(); if (objView.FromDate != null) objSearchPatients = objSearchPatients.Where(p => p.FromDate >= objView.FromDate).ToList(); if (objView.ToDate != null) objSearchPatients = objSearchPatients.Where(p => p.ToDate >= objView.FromDate).ToList(); if (objSearchPatients != null) { return Json(objSearchPatients, JsonRequestBehavior.AllowGet); } else { return Json(new { result = "No Data found" }, JsonRequestBehavior.AllowGet); } //return Json(objView, JsonRequestBehavior.AllowGet); } catch(Exception ex) { return Json(new { result = ex.Message }, JsonRequestBehavior.AllowGet); } }
public ActionResult SearchEncounters(vwSearchPatients objView) { try { int PracticeID = Convert.ToInt32(Session["sespracticeid"]); objView.PracticeID = PracticeID; IEnumerable<vwSearchPatients> objSearchPatients = (from p in db.vwSearch where p.PracticeID == objView.PracticeID select p).ToList(); if (objView.FirstName != null && objView.FirstName != "") objSearchPatients = objSearchPatients.Where(p => p.FirstName == objView.FirstName).ToList(); if (objView.LastName != null && objView.LastName != "") objSearchPatients = objSearchPatients.Where(p => p.LastName == objView.LastName).ToList(); if (objView.PhoneNumber1 != null && objView.PhoneNumber1 != "") objSearchPatients = objSearchPatients.Where(p => p.PhoneNumber1 == objView.PhoneNumber1).ToList(); if (objView.ProviderID != 0 && objView.ProviderID != null) objSearchPatients = objSearchPatients.Where(p => p.ProviderID == objView.ProviderID).ToList(); if (objView.InsuranceName != null && objView.InsuranceName != "") objSearchPatients = objSearchPatients.Where(p => p.InsuranceName == objView.InsuranceName).ToList(); if (objView.Date_Of_Birth != null) objSearchPatients = objSearchPatients.Where(p => p.Date_Of_Birth == objView.Date_Of_Birth).ToList(); if (objView.FromDate != null) objSearchPatients = objSearchPatients.Where(p => p.FromDate >= objView.FromDate).ToList(); if (objView.ToDate != null) objSearchPatients = objSearchPatients.Where(p => p.ToDate >= objView.FromDate).ToList(); //if (objSearchPatients.Count()>0) //{ // //return Json(objSearchPatients, JsonRequestBehavior.AllowGet); //} //else //{ // return Json(new { result = "No Data found" }, JsonRequestBehavior.AllowGet); //} //return Json(objView, JsonRequestBehavior.AllowGet); return PartialView("PartialViews/PatEncSearchGrid", objSearchPatients); } catch (Exception ex) { return Json(new { result = ex.Message }, JsonRequestBehavior.AllowGet); } }