﻿----------------------------Hammad 2022-06-25-----


alter procedure [dbo].[Emp_GetDayOffAndHoliday] 
(
	 @StartDate AS DATETIME ,
    @EndDate AS DATETIME ,
    @employeeCode int

)
AS


 declare @TimeScheduleTypeCode int 
declare @Count int 
declare @QueryCount1 int 
declare @QueryCount2 int 
declare @Dayoff int 


SET @Count = 0


 select  top(1) @TimeScheduleTypeCode = TimeScheduleTypeCode from EmployeesExtend where  EmployeeExtendCode = @employeeCode

 WHILE (@StartDate <= @EndDate)
BEGIN

select @Dayoff=  dbo.GetDayOffByDate(@StartDate)
select @QueryCount1 = COUNT(*) from TimeScheduleTypes where TimeScheduleTypeCode=@TimeScheduleTypeCode and(DayoffNumber2=@Dayoff or DayoffNumber1=@Dayoff)

select @QueryCount2 = COUNT(*) from HolidaysMap where DayDate=@StartDate


if @QueryCount1 >0 or  @QueryCount2 >0
  set @Count=@Count+1
 

SET @StartDate = convert(varchar(30), dateadd(day,1, @StartDate), 101); 

END

select @Count as dayCount
GO
 ----------------------------End 2022-06-25-----
 -----------------------Sayed 2022-06-26------------
 GO
ALTER TABLE dbo.TimeAttend202207  ADD DVacationCode tinyint NULL
GO
UPDATE TM SET TM.DVacationCode=V.VacationCode FROM dbo.TimeAttend202207 TM INNER JOIN dbo.VacationType V ON TM.Department=V.Abbreviation
GO
 GO
ALTER TABLE dbo.TimeAttend202208  ADD DVacationCode tinyint NULL
GO
UPDATE TM SET TM.DVacationCode=V.VacationCode FROM dbo.TimeAttend202208 TM INNER JOIN dbo.VacationType V ON TM.Department=V.Abbreviation
GO
 GO
ALTER TABLE dbo.TimeAttend202209  ADD DVacationCode tinyint NULL
GO
UPDATE TM SET TM.DVacationCode=V.VacationCode FROM dbo.TimeAttend202209 TM INNER JOIN dbo.VacationType V ON TM.Department=V.Abbreviation
GO
 GO
ALTER TABLE dbo.TimeAttend202210  ADD DVacationCode tinyint NULL
GO
UPDATE TM SET TM.DVacationCode=V.VacationCode FROM dbo.TimeAttend202210 TM INNER JOIN dbo.VacationType V ON TM.Department=V.Abbreviation
GO
ALTER TABLE dbo.TimeAttend202211  ADD DVacationCode tinyint NULL
GO
UPDATE TM SET TM.DVacationCode=V.VacationCode FROM dbo.TimeAttend202211 TM INNER JOIN dbo.VacationType V ON TM.Department=V.Abbreviation
GO
ALTER TABLE dbo.TimeAttend202212  ADD DVacationCode tinyint NULL
GO
UPDATE TM SET TM.DVacationCode=V.VacationCode FROM dbo.TimeAttend202212 TM INNER JOIN dbo.VacationType V ON TM.Department=V.Abbreviation
GO

---------------------------End 2022-06-26------------------------

