------------------------------- A.Khaled 2020-07-12 --------------------------
  UPDATE [dbo].[FieldsDataSource] SET [FieldName]=N'Sex' WHERE [FieldDataSourceCode]=11
  INSERT [dbo].[FieldsDataSource] ([FieldDataSourceCode], [FieldName], [DescriptionAr], [DescriptionEn], [FieldDataType], [Area], [Controller], [Action]) VALUES (12, N'EmployeeCode', N'كود الموظف', N'Employee Code', 3, NULL, N'Common', N'GetAllEmployees')
  ------------------------------- End 2020-07-12 --------------------------
   ------------------------------Ali 2020-07-12-----------

  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 (346, N'Holidays Map', N'خطة الاجازات', 345, N'/Attendance/HolidaysMap', N'Index', NULL, N'get', 1, 1, 1)
Go


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

INSERT [dbo].[SystemMenuModule] ( [SystemMenuCode], [AppModuleCode]) VALUES ( 345, 11)
INSERT [dbo].[SystemMenuModule] ( [SystemMenuCode], [AppModuleCode]) VALUES ( 346, 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)
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)
Go
   ------------------------------End 2020-07-12-----------
