public async saveTenant (payload: any, userId: number) {
  try {
    const tenant = new Tenant()
    if (payload.email) {
      tenant.email = payload.email
    }
    if (payload.phone_number) {
      tenant.phone_number = payload.phone_number
    }
    tenant.nom = payload.nom.trim()
    tenant.pnom = payload.pnom.trim()
    tenant.userId = userId 
  
    tenant.save()
  } catch (err) {
    throw new Error('Duplicate entry detected. Please use a unique value.')
  }

 }

  async addTenant({ request, response, session, auth }: HttpContext) {
    try {
      const payload = await request.validateUsing(postTenant)
      // const existingUser = await Tenant.findBy('nom', payload.nom, 'pnom', payload.pnom)
      this.saveTenant (payload, auth?.user?.id ??  -1)

      session.flash('success', {
        message: `Votre locataire a été enregistré avec succès ! 🏡✨`
      })
      return response.redirect().back()
    } catch (err) {
      session.flash({ showOTP: false });
      if (err.code === 'ER_DUP_ENTRY') { return response.status(400).json({ message: 'Duplicate entry detected. Please use a unique value.', }); }
      if (typeof err === 'object' && err?.code === 'E_ROW_NOT_FOUND') {
        session.flash('errors', {
          message: "Une erreur est survenue lors de l'ajout de votre locataire. Veuillez recommencer !"
        })
      } else {
        session.flash('errors', {
          message: (err?.messages ?? err?.messages)
        })
      }

      return response.redirect().back()
    }
  }

 ........