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