﻿-------------------------------------- Ali 29-01-2023 ---------

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(1003,N'System Monitoring',N'مراقبة النظام',4,N'',N'','fa fa-thumb-tack',N'',4,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(1003,6)
Go
  INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(1360,N'مراقبة النظام',N'System Monitoring',1003,1)
  Go
  

Update [dbo].[SystemMenu] Set Name=N'Users Follow',Arabic_Name=N'تتبع المستخدمين',ParentID=1003,Sequence=1
 Where  SystemMenuCode= 102
Go

Update [dbo].[SystemMenu] Set ParentID=1003,Sequence=2
 Where  SystemMenuCode= 131
Go

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(1004,N'Register History',N'سجل الدخول',1003,N'/RegisterHistory',N'Index','fa fa-thumb-tack',N'get',3,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(1004,6)
Go

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(1358,N'سجل الدخول',N'Register History',1004,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(1359,N'عرض سجل الدخول',N'View Register History',1004,2)
Go

  
   INSERT INTO [dbo].[SecurityUserDetail] (SecurityUserID,PrivilegeID)
SELECT DISTINCT SecurityUserID, 1360 
FROM [dbo].[SecurityUserDetail] WHERE PrivilegeID in (1058,1059,1060,1087,1088)
Go

INSERT INTO [dbo].SecurityGroupDetail (SecurityGroupID,PrivilegeID)
SELECT DISTINCT SecurityGroupID, 1360 
FROM [dbo].SecurityGroupDetail WHERE PrivilegeID in (1058,1059,1060,1087,1088)
Go

--------------------------------------- End 29-01-2023 ---------
--------------------------------------- Ali 30-01-2023 ---------

ALTER TABLE dbo.WF_UserTrackNotification ADD
	RecieveMobileNotifications bit NOT NULL CONSTRAINT DF_WF_UserTrackNotification_RecieveMobileNotifications DEFAULT 1
GO
--------------------------------------- End 30-01-2023 ---------
--------------------------------------- Mostafa 30-01-2023 ---------


INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(1005,N'Users Online',N'المستخدمين (Online)',1003,N'/UsersOnline'',N'Index','fa fa-thumb-tack',N'get',4,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(1005,6)
Go

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(1361,N'المستخدمين (Online)',N'User Online',1005,1)
Go

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(1362,N'عرض المستخدمين (Online)',N'View User Online',1005,2)
Go

--------------------------------------- End 30-01-2023 ---------


