package com.dacrt.SBIABackend.repository;


import java.util.List;
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.stereotype.Repository;

import com.dacrt.SBIABackend.dto.UnitsDtoStatus;
import com.dacrt.SBIABackend.entity.Strategiesdetprocesses;
import com.dacrt.SBIABackend.entity.Unitprocesses;
import com.dacrt.SBIABackend.entity.Units;
import com.dacrt.SBIABackend.entity.Userunits;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Repository;


//import com.dacrt.SBIABackend.security.dto.ParamsDto;
import com.dacrt.SBIABackend.security.entity.Params;
import com.dacrt.SBIABackend.security.entity.Users;

@Repository
public interface StrategiesdetprocessesRepository extends JpaRepository<Strategiesdetprocesses,Integer>,JpaSpecificationExecutor<Strategiesdetprocesses>{
	

	
	@Transactional
	@Modifying
	@Query(" DELETE FROM Strategiesdetprocesses e where e.strategyid = ?1 ")
	void borrarStrategybyIdStrategy(int idestrategy);
	
	
	//boolean existsByStrategyidAndProcessid(int strategydetid, int unitid);
	
	boolean existsByStrategyidAndUnitprocessid(int strategydetid, int unitprocessid);
	
	boolean existsByStrategyid(int strategydetid);

	
}