  ------------------------------Ali 2020-07-12-----------
   

SET IDENTITY_INSERT [dbo].[AppModule] ON 
INSERT [dbo].[AppModule] ([AppModuleCode], [Name], [Arabic_Name], [IsLicensed]) VALUES (11, N'Attendance', N'الحضور والانصراف', 1)
SET IDENTITY_INSERT [dbo].[AppModule] OFF
Go


   ------------------------------End 2020-07-12-----------
    ------------------------------Ali 2020-07-13-----------
   ALTER TABLE dbo.WF_MissionPlace ADD
	BandCode int NULL
GO
   ------------------------------End 2020-07-13-----------
  ------------------------------- A.Khaled 2020-07-19 --------------------------  

update  [dbo].[SystemMenu] set ParentID=345 where SystemMenuCode=212
GO
INSERT [dbo].[SystemMenuModule] ( [SystemMenuCode], [AppModuleCode]) VALUES ( 212, 11)
GO
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
 VALUES (345, N'Attendance', N'الحضور والانصراف', NULL, NULL, NULL, NULL, NULL, 16, 1, 1)

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (347, N'Come Early  Policy', N'سياسة الحضور المبكر', 348, N'/Attendance/PolicyComeEarly', N'Index', NULL, N'get', 2, 1, 1)
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (348, N'Policies', N'السياسات', 345, NULL, NULL, NULL, NULL, 2, 1, 1)
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (349, N'Come late policy', N'سياسة الحضور المتأخر', 348, N'/Attendance/PolicyComeLate', N'Index', NULL, N'GET', 1, 1, 1)
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (350, N'Basic Data', N'البيانات الاساسية', 345, NULL, NULL, NULL, NULL, 1, 1, 1)
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (346, N'Holidays Map', N'الاجازات الرسمية', 350, N'/Attendance/HolidaysMap', N'Index', NULL, N'get', 1, 1, 1)
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (351, N'Working Out Work Time Policy', N'سياسة العمل خارج الدوام', 348, N'/Attendance/PolicyWorkingOutWorkTime', N'Index', NULL, N'get', 3, 1, 1)
GO

INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (345, 11)
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (346, 11)
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (347, 11)
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (348, 11)
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (349, 11)
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (350, 11)
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (351, 11)
GO

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13012, N'الاجازات الرسمية', N'Holidays Map', 346, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13013, N'عرض الاجازات الرسمية', N'view Holidays Map', 346, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13014, N'إضافة الاجازات الرسمية', N'Add Holidays Map', 346, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13015, N'تعديل الاجازات الرسمية', N'Edit Holidays Map', 346, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13016, N'حذف الاجازات الرسمية', N'Delete Holidays Map', 346, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13017, N'حفظ الاجازات الرسمية', N'Save Holidays Map', 346, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13018, N'الحضور والانصراف', N'Attendance', 345, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13019, N'الحضور والانصراف', N'Attendance', 345, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13020, N'سياسة الحضور المبكر', N'Come Early Policy', 347, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13021, N'عرض سياسة الحضور المبكر', N'view Come Early Policy', 347, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13022, N'إضافة سياسة الحضور المبكر', N'Add Come Early Policy', 347, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13023, N'تعديل سياسة الحضور المبكر', N'Edit Come Early Policy', 347, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13024, N'حذف سياسة الحضور المبكر', N'Delete Come Early Policy', 347, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13025, N'حفظ سياسة الحضور المبكر', N'Save Come Early Policy', 347, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13026, N'سياسة الحضور المتأخر', N'Come Late Policy', 349, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13027, N'عرض سياسة الحضور المتأخر', N'View Come Late Policy', 349, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13028, N'إضافة سياسة الحضور المتأخر', N'Add Come Late Policy', 349, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13029, N'تعديل سياسة الحضور المتأخر', N'Edit Come Late Policy', 349, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13030, N'حذف سياسة الحضور المتأخر', N'Delete Come Late Policy', 349, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13031, N'حفظ سياسة الحضور المتأخر', N'Save Come Late Policy', 349, 2)

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13032, N'السياسات', N'Policies', 348, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13033, N'البيانات الاساسية', N'Basic Data', 350, 1)

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13034, N'السياسات', N'Policies', 348, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13035, N'البيانات الاساسية', N'Basic Data', 350, 1)

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13036, N'سياسة العمل خارج الدوام', N'Working Out Work Time Policy', 351, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13037, N'عرض سياسة العمل خارج الدوام', N'View Working Out Work Time Policy', 351, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13038, N'إضافة سياسة العمل خارج الدوام', N'Add Working Out Work Time Policy', 351, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13039, N'تعديل سياسة العمل خارج الدوام', N'Edit Working Out Work Time Policy', 351, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13040, N'حذف سياسة العمل خارج الدوام', N'Delete Working Out Work Time Policy', 351, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13041, N'حفظ سياسة العمل خارج الدوام', N'Save Working Out Work Time Policy', 351, 2)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (167, N'Attendance', N'HolidaysMap', N'Index', 0, N'get', 13012)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (168, N'Attendance', N'HolidaysMap', N'HolidaysMap_Read', 0, N'post', 13013)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (169, N'Attendance', N'HolidaysMap', N'Save', 1, N'get', 13014)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (170, N'Attendance', N'HolidaysMap', N'Save', 2, N'get', 13015)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (171, N'Attendance', N'HolidaysMap', N'Delete', 0, N'post', 13016)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (172, N'Attendance', N'HolidaysMap', N'Save', 0, N'post', 13017)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (173, N'Attendance', N'PolicyComeEarly', N'Index', 0, N'get', 13020)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (174, N'Attendance', N'PolicyComeEarly', N'PolicyComeEarly_Read', 0, N'post', 13021)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (175, N'Attendance', N'PolicyComeEarly', N'Save', 1, N'get', 13022)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (176, N'Attendance', N'PolicyComeEarly', N'Save', 2, N'get', 13023)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (177, N'Attendance', N'PolicyComeEarly', N'Delete', 0, N'post', 13024)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (178, N'Attendance', N'PolicyComeEarly', N'Save', 0, N'post', 13025)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (179, N'Attendance', N'PolicyComeLate', N'Index', 0, N'get', 13020)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (180, N'Attendance', N'PolicyComeLate', N'PolicyComeLate_Read', 0, N'post', 13021)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (181, N'Attendance', N'PolicyComeLate', N'Save', 1, N'get', 13022)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (182, N'Attendance', N'PolicyComeLate', N'Save', 2, N'get', 13023)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (183, N'Attendance', N'PolicyComeLate', N'Delete', 0, N'post', 13024)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (184, N'Attendance', N'PolicyComeLate', N'Save', 0, N'post', 13025)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (185, N'Attendance', N'PolicyWorkingOutWorkTime', N'Index', 0, N'get', 13036)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (186, N'Attendance', N'PolicyWorkingOutWorkTime', N'PolicyWorkingOutWork_Read', 0, N'post', 13037)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (187, N'Attendance', N'PolicyWorkingOutWorkTime', N'Save', 1, N'get', 13038)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (188, N'Attendance', N'PolicyWorkingOutWorkTime', N'Save', 2, N'get', 13039)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (189, N'Attendance', N'PolicyWorkingOutWorkTime', N'Delete', 0, N'post', 13040)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (190, N'Attendance', N'PolicyWorkingOutWorkTime', N'Save', 0, N'post', 13041)

Go
  ------------------------------- End 2020-07-19 --------------------------
  
  ------------------------------- Ali 2020-07-21 --------------------------

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (351, N'Working Out Work Time Policy', N'سياسة العمل خارج الدوام', 348, N'/Attendance/PolicyWorkingOutWorkTime', N'Index', NULL, N'get', 3, 1, 1)
GO

INSERT [dbo].[SystemMenuModule] ( [SystemMenuCode], [AppModuleCode]) VALUES ( 351, 11)
GO


INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13036, N'سياسة العمل خارج الدوام', N'Working Out Work Time Policy', 351, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13037, N'عرض سياسة العمل خارج الدوام', N'View Working Out Work Time Policy', 351, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13038, N'إضافة سياسة العمل خارج الدوام', N'Add Working Out Work Time Policy', 351, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13039, N'تعديل سياسة العمل خارج الدوام', N'Edit Working Out Work Time Policy', 351, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13040, N'حذف سياسة العمل خارج الدوام', N'Delete Working Out Work Time Policy', 351, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13041, N'حفظ سياسة العمل خارج الدوام', N'Save Working Out Work Time Policy', 351, 2)
GO

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (185, N'Attendance', N'PolicyWorkingOutWorkTime', N'Index', 0, N'get', 13036)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (186, N'Attendance', N'PolicyWorkingOutWorkTime', N'PolicyWorkingOutWork_Read', 0, N'post', 13037)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (187, N'Attendance', N'PolicyWorkingOutWorkTime', N'Save', 1, N'get', 13038)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (188, N'Attendance', N'PolicyWorkingOutWorkTime', N'Save', 2, N'get', 13039)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (189, N'Attendance', N'PolicyWorkingOutWorkTime', N'Delete', 0, N'post', 13040)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (190, N'Attendance', N'PolicyWorkingOutWorkTime', N'Save', 0, N'post', 13041)
GO


INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (352, N' Leave Early Policy', N'سياسة الانصراف المبكر', 348, N'/Attendance/PolicyLeaveEarly', N'Index', NULL, N'get', 4, 1, 1)
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (353, N'Over Time  Policy ', N'سياسة الوقت الإضافى', 348, N'/Attendance/PolicyOverTime', N'Index', NULL, N'get', 5, 1, 1)
GO

INSERT [dbo].[SystemMenuModule] ( [SystemMenuCode], [AppModuleCode]) VALUES ( 352, 11)
INSERT [dbo].[SystemMenuModule] ( [SystemMenuCode], [AppModuleCode]) VALUES ( 353, 11)
GO

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13042, N'سياسة الانصراف المبكر', N' Leave Early Policy', 352, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13043, N'عرض سياسة الانصراف المبكر', N'View Leave Early Policy', 352, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13044, N'إضافة سياسة الانصراف المبكر', N'Add Leave Early Policy', 352, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13045, N'تعديل سياسة الانصراف المبكر', N'Edit Leave Early Policy', 352, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13046, N'حذف سياسة الانصراف المبكر', N'Delete Leave Early Policy', 352, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13047, N'حفظ سياسة الانصراف المبكر', N'Save Leave Early Policy', 352, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13048, N'سياسة الوقت الإضافى', N'Over Time  Policy ', 353, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13049, N'عرض سياسة الوقت الإضافى', N'View Over Time Policy ', 353, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13050, N'إضافة سياسة الوقت الإضافى', N'Add Over Time Policy ', 353, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13051, N'تعديل سياسة الوقت الإضافى', N'Edit Over Time Policy ', 353, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13052, N'حذف سياسة الوقت الإضافى', N'Delete Over Time Policy ', 353, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13053, N'حفظ سياسة الوقت الإضافى', N'Save Over Time Policy ', 353, 2)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (191, N'Attendance', N'PolicyLeaveEarly', N'Index', 0, N'get', 13042)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (192, N'Attendance', N'PolicyLeaveEarly', N'PolicyLeaveEarly_Read', 0, N'post', 13043)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (193, N'Attendance', N'PolicyLeaveEarly', N'Save', 1, N'get', 13044)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (194, N'Attendance', N'PolicyLeaveEarly', N'Save', 2, N'get', 13045)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (195, N'Attendance', N'PolicyLeaveEarly', N'Delete', 0, N'post', 13046)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (196, N'Attendance', N'PolicyLeaveEarly', N'Save', 0, N'post', 13047)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (197, N'Attendance', N'PolicyOverTime', N'Index', 0, N'get', 13048)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (198, N'Attendance', N'PolicyOverTime', N'PolicyOverTime_Read', 0, N'post', 13049)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (199, N'Attendance', N'PolicyOverTime', N'Save', 1, N'get', 13050)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (200, N'Attendance', N'PolicyOverTime', N'Save', 2, N'get', 13051)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (201, N'Attendance', N'PolicyOverTime', N'Delete', 0, N'post', 13052)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (202, N'Attendance', N'PolicyOverTime', N'Save', 0, N'post', 13053)
GO

  ------------------------------- End 2020-07-21 --------------------------
  ------------------------------- Ali 2020-07-26 --------------------------
 INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (354, N'Group Policy  ', N'مجموعة السياسات', 348, N'/Attendance/GroupPolicy', N'Index', NULL, N'get', 6, 1, 1)
Go
INSERT [dbo].[SystemMenuModule] ([SystemMenuCode], [AppModuleCode]) VALUES ( 354, 11)
Go

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13054, N'مجموعة السياسات', N'Group Policy  ', 354, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13055, N'عرض مجموعة السياسات', N'View Group Policy  ', 354, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13056, N'إضافة مجموعة السياسات', N'Add Group Policy  ', 354, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13057, N'تعديل مجموعة السياسات', N'Edit Group Policy  ', 354, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13058, N'حذف مجموعة السياسات', N'Delete Group Policy  ', 354, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13059, N'حفظ  مجموعة السياسات', N'Save Group Policy  ', 354, 2)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (203, N'Attendance', N'GroupPolicy', N'Index', 0, N'get', 13054)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (204, N'Attendance', N'GroupPolicy', N'GroupPolicy_Read', 0, N'post', 13055)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (205, N'Attendance', N'GroupPolicy', N'Save', 1, N'get', 13056)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (206, N'Attendance', N'GroupPolicy', N'Save', 2, N'get', 13057)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (207, N'Attendance', N'GroupPolicy', N'Delete', 0, N'post', 13058)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (208, N'Attendance', N'GroupPolicy', N'Save', 0, N'post', 13059)
Go
  ------------------------------- End 2020-07-26 --------------------------
  ------------------------------- Ali 2020-08-4 --------------------------
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (355, N'Shifts', N'الدوام', 345, NULL, NULL, N'fa fa-thumb-tack', NULL, 4, 1, 1)
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (356, N'ShiftTypes', N'أنواع الدوام', 355, N'/Attendance/ShiftType', N'Index', N'fa fa-thumb-tack', N'get', 1, 1, 1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(355,11)
Go
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(356,11)
Go


INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13060, N'الدوام', N'Shifts', 355, 1)
Go
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13061, N'أنواع الدوام', N'ShiftTypes', 356, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13062, N'عرض أنواع الدوام' , N'View ShiftTypes', 356, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13063, N' إضافة أنواع الدوام', N'Add ShiftType', 356, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13064, N'تعديل أنواع الدوام ', N'Edit ShiftType', 356, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13065, N'حذف أنواع الدوام', N'Delete ShiftType', 356, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13066, N'حفظ أنواع الدوام', N'Save ShiftType', 356, 2)
Go


INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (209, N'Attendance', N'ShiftType', N'Index', 0, N'get', 13061)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (210, N'Attendance', N'ShiftType', N'ShiftTypes_Read', 0, N'post', 13062)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (211, N'Attendance', N'ShiftType', N'Save', 1, N'get', 13063)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (212, N'Attendance', N'ShiftType', N'Save', 2, N'get', 13064)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (213, N'Attendance', N'ShiftType', N'Delete', 0, N'post', 13065)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (214, N'Attendance', N'ShiftType', N'Save', 0, N'post', 13066)
Go
  ------------------------------- End 2020-08-4 --------------------------
    ------------------------------- Ali 2020-08-10 --------------------------
  ALTER TABLE dbo.[Employees] ADD
	OrganizationStructureCode int NULL
GO
  ------------------------------- End 2020-08-10 --------------------------
    ------------------------------- Hammad 2020-08-11 --------------------------
  INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3541, N'حفظ متعدد  اعتماد نهائى للوقت الإضافى', N'Save Multiple OverTime Request Final Signature ', 222, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3542, N'اختيار كل الطلبات', N'Choose All Requests', 222, 2)
Go
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3543, N'حفظ متعدد  اعتماد نهائى لطلب التعويض', N'Save Multiple Compensation Request Final Signature', 223, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3544, N'اختيار كل الطلبات', N'Choose All Requests', 223, 2)
Go
  ------------------------------- End 2020-08-11 --------------------------
  -------------------------------Sayed 2020-08-12--------------------------
  INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (179, N'Attendance', N'PolicyComeLate', N'Index', 0, N'get', 13020)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (180, N'Attendance', N'PolicyComeLate', N'PolicyComeLate_Read', 0, N'post', 13021)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (181, N'Attendance', N'PolicyComeLate', N'Save', 1, N'get', 13022)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (182, N'Attendance', N'PolicyComeLate', N'Save', 2, N'get', 13023)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (183, N'Attendance', N'PolicyComeLate', N'Delete', 0, N'post', 13024)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (184, N'Attendance', N'PolicyComeLate', N'Save', 0, N'post', 13025)
Go
------------------------------ End 2020-08-12 --------------------------