public async Task <ActionResult <IEnumerable <Compte> > > Search(string name)
        {
            try
            {
                var result = await compteRepository.SearchCompte(name);

                if (result.Any())
                {
                    return(Ok(result));
                }

                return(NotFound());
            }
            catch (Exception)
            {
                return(StatusCode(StatusCodes.Status500InternalServerError,
                                  "Error retrieving data from the database"));
            }
        }