public IActionResult GetDiagByHospnum(string hospitalNumber) { EntityConnection con = new EntityConnection("tbl_diagnosis"); Dictionary <string, string> pairs = new Dictionary <string, string> { { "hospitalNumber", hospitalNumber } }; if (con.DisplayDiagnosis(hospitalNumber).Count > 0) { return(Ok(con.DisplayDiagnosis(hospitalNumber))); } else { //obj = new { message = hospitalNumber + "does not have a diagnosis record yet" }; string[] arr = new string[0]; return(Ok(arr)); } //string res = EntityConnection.ToJson(con.DisplayDiagnosis(hospnum)); }