﻿ --------------------------------------- Hammad 2024-06-11 ----------------

SET IDENTITY_INSERT [dbo].[EmailTemplateType] ON 
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode], [RequestTypeCode], [HaveUserAccount])
VALUES (414, N'Send Notification Start Period Evaluation ', N'  إرسال التنبيه الى لبداية فترة النقيم', 0, 8, NULL, 1)
GO
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode], [RequestTypeCode], [HaveUserAccount]) 
VALUES (415, N'Send Notification End Period Evaluation ', N'  إرسال التنبيه الى لنهابة فترة النقيم', 0, 8, NULL, 1)
GO
SET IDENTITY_INSERT [dbo].[EmailTemplateType] OFF
GO

INSERT [dbo].[EmailTemplate] ( [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode], [GeneralTypeCode], [JobTypeCode], [MessageTemplate])
VALUES (N'Send Notification Start Period Evaluation ', N'  إرسال التنبيه الى لبداية فترة النقيم', 414, N' إرسال التنبيه الى لبداية فترة النقيم ', N'إرسال التنبيه الى لبداية فترة النقيم', 1, NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[EmailTemplate] ( [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode], [GeneralTypeCode], [JobTypeCode], [MessageTemplate])
VALUES (N'Send Notification End Period Evaluation ', N'  إرسال التنبيه الى لنهاية فترة النقيم', 415, N' إرسال التنبيه الى لنهاية فترة النقيم ', N'إرسال التنبيه الى لنهاية فترة النقيم', 1, NULL, NULL, NULL, NULL)
GO
  --------------------------------------- End 2024-06-11 ----------------
  --------------------------------------- Hammad 2024-06-12 -------------
  INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId], [ConfigDescription]) 
VALUES (N'WFOvertimeDependOnVacation', N' Overtime Depend On Vacation', N'   الوقت الإضافى معتمد على اجازة  ', N'true', 2, 23, 1, 1, NULL, NULL, 3, N'   الوقت الإضافى معتمد على اجازة  ')
GO
  --------------------------------------- End 2024-06-12 ----------------
  --------------------------------------- AK 2024-06-12 ---------
INSERT INTO [dbo].[SecurityPrivilegeEndPoints] ([Id],[ApiName],[AreaName],[ControllerName],[ActionName],[HTTPMethod]) VALUES (1382,NULL,NULL,N'CandidateInvitation',N'GetCandidateInvitationSearch',N'Post')
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPoints] ([Id],[ApiName],[AreaName],[ControllerName],[ActionName],[HTTPMethod]) VALUES (1383,NULL,NULL,N'CandidateInvitation',N'GetSendInvitation',N'Get')
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPoints] ([Id],[ApiName],[AreaName],[ControllerName],[ActionName],[HTTPMethod]) VALUES (1384,NULL,NULL,N'CandidateInvitation',N'PostSendInvitation',N'Post')
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPointsDetails]([Id],[SecurityPrivilegeEndPointId],[SecurityPrivilegeId],[RequestTypeId]) VALUES (1667,1382,5064,NULL)
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPointsDetails]([Id],[SecurityPrivilegeEndPointId],[SecurityPrivilegeId],[RequestTypeId]) VALUES (1668,1383,5066,NULL)
GO
INSERT INTO [dbo].[SecurityPrivilegeEndPointsDetails]([Id],[SecurityPrivilegeEndPointId],[SecurityPrivilegeId],[RequestTypeId]) VALUES (1669,1384,5066,NULL)
GO
--------------------------------------- End AK 2024-06-12 ------------
---------------------------------------  mostafa 2024-06-13 ------------
ALTER TABLE dbo.WF_MonthlyEffectType ADD
	IsEdit bit NOT NULL CONSTRAINT DF_WF_MonthlyEffectType_IsEdit DEFAULT ((0))
GO
--------------------------------------- End mostafa 2024-06-13 ------------

---------------------------------------  M.Negm 2024-06-13 ------------
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1962,N'WorkFlow',N'OtherEmployeeTrackApi',N'Index',0,N'get',3164)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1963,N'WorkFlow',N'OtherEmployeeTrackApi',N'EmployeeTrack_Read',0,N'post',3165)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1964,N'WorkFlow',N'OtherEmployeeTrackApi',N'Save',1,N'get',3166)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1965,N'WorkFlow',N'OtherEmployeeTrackApi',N'Save',2,N'get',3167)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1966,N'WorkFlow',N'OtherEmployeeTrackApi',N'Delete',0,N'post',3168)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1967,N'WorkFlow',N'OtherEmployeeTrackApi',N'Save',0,N'post',3169)
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1385,NULL, NULL,N'WfOtherEmployeeTrack',N'GetWfEmployeeTrackSearch',N'post')
Go																									
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1386,NULL, NULL,N'WfOtherEmployeeTrack',N'post',N'post')
Go																													
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1387,NULL, NULL,N'WfOtherEmployeeTrack',N'Delete',N'Delete')
Go																													
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1388,NULL, NULL,N'WfOtherEmployeeTrack',N'GetForSave',N'get')
Go		
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1670,1385,3165, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1671,1386,3169, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1672,1387,3168, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1673,1388,3166, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1674,1388,3167, NULL)
Go
--------------------------------------- End M.Negm 2024-06-13 ------------

