﻿---------------------Hammad 2022-05-16---------
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES 
(1323, N'عرض الوقت الإضافى فى الحضور والانصراف', N'View Over time in Attandance', 3, 2)
GO
---------------------End 2022-05-16---------


---------------------Ali 2022-05-16---------

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(613,N'My Employees',N'موظفينى',null,N'',N'','fa fa-thumb-tack',N'',16,0,1)
Go

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

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(1316,N'موظفينى',N'My Employees',613,1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1317, N'عرض موظفينى', N'View My Employees', 613, 2)
Go

   INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(614,N'My Employees Vacations',N'اجازات موظفينى',613,N'',N'','fa fa-thumb-tack',N'',2,0,1)
Go

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

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(1324,N'اجازات موظفينى',N'My Employees Vacations',614,1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1318, N'عرض الاجازات', N'View Vacations', 614, 2)
Go

   INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(615,N'Send salary notification For My Employees',N'إرسال الإشعار بالراتب لموظفينى',613,N'',N'','fa fa-thumb-tack',N'',1,0,1)
Go

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

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(1325,N'إرسال الإشعار بالراتب لموظفينى',N'Send salary notification For My Employees',615,1)
Go

 update [SecurityPrivilege] set [SystemMenuCode]= 615
   where [ID]=1314
   Go

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(616,N'View My Employees Attendance',N'عرض حضور وانصراف موظفينى',613,N'',N'','fa fa-thumb-tack',N'',3,0,1)
Go

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

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(1326,N'عرض حضور وانصراف موظفينى',N'View My Employees Attendance',616,1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1319, N'عرض الحضور والانصراف', N'View Attendance', 616, 2)
Go


INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(617,N'View My Employees Permissions',N'عرض اذونات موظفينى',613,N'',N'','fa fa-thumb-tack',N'',4,0,1)
Go

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

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(1327,N'عرض اذونات موظفينى',N'View My Employees Permissions',617,1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1320, N'عرض الاذونات', N'View Permissions', 617, 2)

Go

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(618,N'View My Employees Tasks',N'عرض مهام موظفينى',613,N'',N'','fa fa-thumb-tack',N'',5,0,1)
Go

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

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(1328,N'عرض مهام موظفينى',N'View My Employees Tasks',618,1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1321, N'عرض مهام الموظفين', N'View Employee Tasks', 618, 2)
Go


INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(619,N'View My Employees Balance Check',N'عرض متابعة ارصدة موظفينى',613,N'',N'','fa fa-thumb-tack',N'',6,0,1)
Go

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

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(1329,N'عرض متابعة ارصدة موظفينى',N'View My Employees Balance Check',619,1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1322, N'عرض متابعة الارصدة ', N'View Balance Check', 619, 2)
Go

  Alter table [Basis] ADD
	AllocationByLocation bit  NULL
Go
---------------------End 2022-05-16---------




