package com.dacrt.SBIABackend.repository;

import java.util.Optional;

import javax.transaction.Transactional;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;

import com.dacrt.SBIABackend.entity.Evalunitpos;
import com.dacrt.SBIABackend.entity.Evalunits;

public interface EvalunitposRepository extends JpaRepository<Evalunitpos,Integer>,JpaSpecificationExecutor<Evalunitpos>{
	
	@Query("SELECT e FROM Evalunitpos e WHERE e.id =?1")
	Optional<Evalunitpos> findByEvalprocessid(int id);
	
	@Query(value=" SELECT u FROM Evalunitpos u WHERE u.id= ?1 ")
	Evalunitpos getById(int id);
	
	boolean existsById(Integer id);
	
	
	@Query(value=" SELECT max(u.id) FROM Evalunitpos u")
	int getMaxRecord();
	
	@Transactional
	@Modifying
	@Query(" DELETE FROM Evalunitpos e where e.id = ?1 ")
	void deleteEvalunitPosibyid(Integer id);
	

}