public JsonResult ObterConsultaPorPaciente(int id_paciente)
 {
     try
     {
         return(new JsonResult(_consultaService.ConsultaPorPaciente(id_paciente))
         {
             StatusCode = 200
         });
     }
     catch (ConsultaNaoExisteException exception)
     {
         return(new JsonResult(exception.Message)
         {
             StatusCode = 406
         });
     }
     catch (NaoFoiPossivelConectarNoBancoDeDadosException exception)
     {
         return(new JsonResult(exception.Message)
         {
             StatusCode = 406
         });
     }
     catch (Exception exception)
     {
         return(new JsonResult(exception.Message)
         {
             StatusCode = 500
         });
     }
 }