﻿--------------------------Ali 2025-02-25-----------------------------
 


 INSERT INTO SecurityGroupDetail( SecurityGroupID,PrivilegeID, CreationDate, CreatedBy)
    SELECT gr.SecurityGroupID,9055, GETDATE(), 1
    FROM SecurityGroupDetail gr 
	WHERE  gr.PrivilegeID in
	(1125,9001,9011,9032,9038);
Go



INSERT INTO SecurityUserDetail ( SecurityUserID,PrivilegeID, CreationDate, CreatedBy)
	  SELECT sec.SecurityUserID,9055, GETDATE(), 1
	  FROM SecurityUserDetail sec 
	WHERE  sec.PrivilegeID in
	(1125,9001,9011,9032,9038);
Go




 update [SystemMenu] set ParentID=1155 where [SystemMenuCode] in(490,504,505)
  Go

  INSERT INTO SecurityUserDetail ( SecurityUserID,PrivilegeID, CreationDate, CreatedBy)
	  SELECT sec.SecurityUserID,9056, GETDATE(), 1
	  FROM SecurityUserDetail sec 
	WHERE  sec.PrivilegeID in
	(25063,25062);
Go

INSERT INTO SecurityGroupDetail( SecurityGroupID,PrivilegeID, CreationDate, CreatedBy)
    SELECT gr.SecurityGroupID,9056, GETDATE(), 1
    FROM SecurityGroupDetail gr 
	WHERE  gr.PrivilegeID in
	(25063,25062);
Go


 INSERT INTO SecurityUserDetail ( SecurityUserID,PrivilegeID, CreationDate, CreatedBy)
	  SELECT sec.SecurityUserID,9000, GETDATE(), 1
	  FROM SecurityUserDetail sec 
	WHERE  sec.PrivilegeID in
	(25063,25062);
Go

INSERT INTO SecurityGroupDetail( SecurityGroupID,PrivilegeID, CreationDate, CreatedBy)
    SELECT gr.SecurityGroupID,9000, GETDATE(), 1
    FROM SecurityGroupDetail gr 
	WHERE  gr.PrivilegeID in
	(25063,25062);
Go
--------------------------End 2025-02-25-----------------------------
--------------------------Ali 2025-02-26-----------------------------

 IF EXISTS (
    SELECT 1 FROM SecurityUserDetail WHERE PrivilegeID IN (25063, 25062)
) OR EXISTS (
    SELECT 1 FROM SecurityGroupDetail WHERE PrivilegeID IN (25063, 25062)
)
BEGIN
    UPDATE AppModule  SET IsLicensed = 1  WHERE AppModuleCode = 3;
END
Go
--------------------------End 2025-02-26-----------------------------
--------------------------Hammad 2025-02-26--------------------------

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) 
VALUES (714, N'Circulars and Decisions', N'التعاميم و القرارات', 115, NULL, NULL, N'fa fa-thumb-tack', N'get', 13, 1, 1)
GO
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) 
VALUES (715, N'Circulars and Decisions Type', N'أنواع التعاميم و القرارات', 714, N'/CircularsDecisionType', N'Index', N'fa fa-thumb-tack', N'get', 1, 1, 1)
GO
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES (716, N'Circulars and Decisions', N' التعاميم و القرارات', 714, N'/CircularsDecision', N'Index', N'fa fa-thumb-tack', N'get', 2, 1, 1)
GO

INSERT [dbo].[SystemMenuModule] ([SystemMenuCode], [AppModuleCode]) VALUES (714, 6)
GO
INSERT [dbo].[SystemMenuModule] ([SystemMenuCode], [AppModuleCode]) VALUES (715, 6)
GO
INSERT [dbo].[SystemMenuModule] ([SystemMenuCode], [AppModuleCode]) VALUES (716, 6)
GO

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1425, N'التعاميم و القرارات ', N' Circulars and Decisions', 714, 1)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1426, N'أنواع التعاميم و القرارات ', N' Circulars and Decisions Types', 715, 1)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1427, N'إضافة نوع تعميم وقرار', N' Add Circulars and Decision Type', 715, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1428, N'تعديل نوع تعميم وقرار ', N'Edit Circulars and Decision Type', 715, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1429, N'حذف نوع تعميم وقرار', N' Delete Circulars and Decision Type', 715, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1430, N'حفظ نوع تعميم وقرار', N' Save Circulars and Decision Type', 715, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1431, N' التعاميم و القرارات ', N' Circulars and Decisions', 716, 1)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1432, N'إضافة تعميم وقرار', N' Add Circulars and Decision', 716, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1433, N'تعديل تعميم وقرار ', N'Edit Circulars and Decision', 716, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1434, N'حذف تعميم وقرار', N' Delete Circulars and Decision', 716, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1435, N'حفظ تعميم وقرار', N' Save Circulars and Decision', 716, 2)
GO

--------------------------End 2025-02-26--------------------------