ALTER PROC dbo.CheckSafae4(@FromDate VARCHAR(10),@ToDate VARCHAR(10) ,@IdSoom INT,@IdSafar NUMERIC(30,0))AS
DECLARE @isok BIT=0
DECLARE @isok2 BIT=0
DECLARE @StartDate DATE = dbo.PersianToEn(@FromDate) , @EndDate DATE = dbo.PersianToEn(@ToDate)
SET @isok = cast((SELECT COUNT(f.Id) FROM dbo.Safar f WHERE @StartDate BETWEEN f.FromDate AND f.ToDate AND f.Id <> @IdSafar AND f.IdSoom=@IdSoom) AS bit)
SET @isok2 = CAST((SELECT COUNT(f.Id) FROM dbo.Safar f WHERE @EndDate BETWEEN f.FromDate AND f.ToDate AND f.Id <> @IdSafar AND f.IdSoom=@IdSoom) AS bit)
IF @isok=1
BEGIN
SELECT @isok
RETURN
END
IF @isok2=1
BEGIN
SELECT @isok2
RETURN
END
SELECT CAST('0' AS bit)