public ActionResult SearchPharmacist(int id, string pharmacist)//PDO { List <PDO> list = null; if (id != 0) { DBQueries queryObj = new DBQueries(); string sqlQuery = string.Format(queryObj.sqlGetPDOPharmacists, id, pharmacist); var result = dbCommon.ExecteReader(sqlQuery, "PDO"); list = dbCommon.ConvertToList <PDO>(result); } return(Json(list, JsonRequestBehavior.AllowGet)); }