public IActionResult GetVisitByHospnum(string hospitalNumber) { EntityConnection con = new EntityConnection("tbl_visit"); Dictionary <string, string> pairs = new Dictionary <string, string> { { "hospitalNumber", hospitalNumber } }; if (con.DisplayVisitValues(hospitalNumber).Count > 0) { return(Ok(con.DisplayVisitValues(hospitalNumber))); } else { obj = new { message = hospitalNumber + "does not have a visit record" }; return(NotFound(obj)); } //string res = EntityConnection.ToJson(con.DisplayVisitValues(hospnum)); }