public IActionResult GetVitByHospnum(string hospitalNumber) { EntityConnection con = new EntityConnection("tbl_vitalsigns"); Dictionary <string, string> pairs = new Dictionary <string, string> { { "hospitalNumber", hospitalNumber } }; if (con.DisplayVitalValues(hospitalNumber).Count > 0) { return(Ok(con.DisplayVitalValues(hospitalNumber))); } else { obj = new { message = hospitalNumber + "does not have a vital sign record yet" }; return(NotFound(obj)); } //string rec = EntityConnection.ToJson(con.DisplayVitalValues(hospnum)); }