﻿----------------------------------------- Hammad 2025-02-17 -------------------
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId], [ConfigDescription]) 
VALUES (N'VacationDueViewNewFormat', N'View Employee Vacation Due In Table', N'عرض رصيد الموظف  فى جدول    ', N'false', 1, 62, 1, 1, NULL, NULL, NULL, N'عرض رصيد الموظف  بالتنسيق الجديد')
GO
UPDATE WF_RequestType set NotifSignCountController='OverTimeRequestSignatureApi' where RequestTypeId=3  
 Go
  UPDATE WF_RequestType set NotifSignCountController='OverTimeRequestFinalSignatureApi' where RequestTypeId=20
 Go
  ----------------------------------------- End 2025-02-16 -------------------

  -------------------------- Ali 2025-02-18-----------------------------

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(1154,N'Users Archive',N'أرشيف المستخدمين',133,N'',N'','fa fa-thumb-tack',N'',1,1,1)
Go
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(1154,3)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(9055,N'أرشيف المستخدمين',N'Users Archive',1154,1)
Go

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(1155,N'Employees Archive',N'أرشيف الموظفين',133,N'',N'','fa fa-thumb-tack',N'',2,1,1)
Go
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(1155,3)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(9056,N'أرشيف الموظفين',N'Employees Archive',1155,1)
Go

update [SystemMenu] set ParentID=1154 where [SystemMenuCode] in(134,137,181,561,1002)
 Go
  INSERT INTO SecurityUserDetail ( SecurityUserID,PrivilegeID, CreationDate, CreatedBy)
	  SELECT sec.SecurityUserID,9055, GETDATE(), 1
	  FROM SecurityUserDetail sec 
	WHERE  sec.PrivilegeID in
	(13071,13074,13098,23107,23108);
Go

INSERT INTO SecurityGroupDetail( SecurityGroupID,PrivilegeID, CreationDate, CreatedBy)
    SELECT gr.SecurityGroupID,9055, GETDATE(), 1
    FROM SecurityGroupDetail gr 
	WHERE  gr.PrivilegeID in
	(13071,13074,13098,23107,23108);
Go


  update [SystemMenu] set ParentID=1155 where [SystemMenuCode] in(490,504,505)
  Go
  INSERT INTO SecurityUserDetail ( SecurityUserID,PrivilegeID, CreationDate, CreatedBy)
	  SELECT sec.SecurityUserID,1155, GETDATE(), 1
	  FROM SecurityUserDetail sec 
	WHERE  sec.PrivilegeID in
	(9018,9024,9047);
Go

INSERT INTO SecurityGroupDetail( SecurityGroupID,PrivilegeID, CreationDate, CreatedBy)
    SELECT gr.SecurityGroupID,1155, GETDATE(), 1
    FROM SecurityGroupDetail gr 
	WHERE  gr.PrivilegeID in
	(9018,9024,9047);
Go

  update [SystemMenu] set IsVisible=0  where [SystemMenuCode] =489
 Go

  update SystemMenuModule set AppModuleCode=3 where [SystemMenuCode] in(490,504,505)
  Go
--------------------------End 2025-02-18-----------------------------