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));
}
