package com.app.Repository;

import java.util.List;
import java.util.Optional;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;

import com.app.Entity.Souscription;

public interface SouscriptionRepository extends JpaRepository<Souscription,Long>{
	@Query("select e from Souscription e where e.parcoursSous.name like :im")
	public List<Souscription> getSousByIdNameParcours(@Param("im") String name);


	//Optional<Souscription> findById(Long id);
	 @Query("SELECT s.affaire.id FROM Souscription s WHERE s.id = :idSouscription")
	    Long findAffaireIdBySouscriptionId(@Param("idSouscription") Long idSouscription);

	 @Override
	Optional<Souscription> findById(Long id);
}