﻿-----------------------------------------Ali 2025-06-18------------------

  update [SystemMenu] set Sequence=1 ,ParentID=1117  where SystemMenuCode=1113   
  update [SystemMenu] set Sequence=2 where SystemMenuCode=1143   
  update [SystemMenu] set Sequence=3 where SystemMenuCode=1141   
  Go
 -----------------------------------------END  2025-06-18 --------------------
  -----------------------------------------Hammad 2025-06-22------------------
 ALTER TABLE [dbo].[NotificationRecieverDetail] DROP CONSTRAINT [FK_EmailRecieverDetail_EmailTemplateType]
GO
  -----------------------------------------End 2025-06-22--------------------

  -----------------------------------------Mostafa 2025-06-24------------------

update AppModule set IsLicensed=0  where AppModuleCode =20
GO
  -----------------------------------------End 2025-06-24--------------------
  -----------------------------------------Ali 2025-06-25--------------------

 INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId],[ConfigDescription])
VALUES(N'EvaluatorNumStartCompetencySignature',N'Evaluator Number to start competency signature',N'عدد المقيمين اللازم لبدء اعتماد عناصر الكفاءة',N'2',10,26,2,0,Null,Null,Null,N'عدد المقيمين اللازم لبدء اعتماد عناصر الكفاءة عند الوصول للعدد يتم فتح مسار اعتماد الكفاءه للمعتمدين')
Go

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(1174,N'Competency Approval Signature',N'اعتماد تقييم الكفاءة',1135,N'/PMS/CompetencyApprovalSignature',N'index','fa fa-thumb-tack',N'Get',3,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(1174,8)
Go

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(26133,N'اعتماد تقييم الكفاءة',N'Competency Approval Signature',1174,1)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(26134,N'عرض اعتماد تقييم الكفاءة',N'View Competency Approval Signature',1174,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(26135,N'حفظ اعتماد تقييم الكفاءة',N'Save Competency Approval Signature',1174,2)
Go
  -----------------------------------------End 2025-06-25--------------------

