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