﻿---------------------------------------------------- Ali  14-01-2024 --------------------------------------------------------------------------


ALTER TABLE dbo.Basis ADD
	ShowInMonthlyEffectRequest bit NOT NULL CONSTRAINT DF_Basis_ShowInMonthlyEffectRequest DEFAULT ((1))
GO

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES (1037, N'Band Salary Configurations', N'إعدادات بنود المرتب', 52, N'/BandSalaryConfiguration', N'Index', N'fa fa-thumb-tack', N'get', 10, 1, 1)
GO

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

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1381, N'إعدادات بنود المرتب', N'Band Salary Configurations', 1037, 1)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1382, N'عرض إعدادات بنود المرتب ', N'View Band Salary Configurations', 1037, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1383, N'حفظ إعدادات بنود المرتب ', N'Save Band Salary Configurations', 1037, 2)
GO

---------------------------------------------------- End  14-01-2024 --------------------------------------------------------------------------
---------------------------------------------------- Ali  15-01-2024 --------------------------------------------------------------------------

 ALTER TABLE dbo.Basis ADD
	ShowInAssignmentRequest bit NOT NULL CONSTRAINT DF_Basis_ShowInAssignmentRequest DEFAULT ((0))
GO
ALTER TABLE dbo.Basis
	DROP CONSTRAINT DF_Basis_ShowInMonthlyEffectRequest
GO

ALTER TABLE dbo.Contract ADD
	ShowInAssignmentRequest bit NOT NULL CONSTRAINT DF_Contract_ShowInAssignmentRequest DEFAULT ((0))
GO

INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId], [ConfigDescription]) VALUES (N'Wf_RecJobStatus', N'? Job Status Mandatory', N'حالة الوظيفة اجبارى ؟', N'false', 2, 6, 1, 1, NULL, NULL, 14, N'اخفاء مرتبط بوحده توظيف ؟ =1 واظهار  حالة الوظيفة')
---------------------------------------------------- End  15-01-2024 --------------------------------------------------------------------------

--------------------------------------------------------Negm 15-01-2024 -----------------------------------------------------------------------

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES (1038, N'Contract Configurations', N'إعدادات العقود', 52, N'/BasicData/ContractShowConfiguration', N'Index', N'fa fa-thumb-tack', N'get', 11, 1, 1)
GO

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


INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1384, N'إعدادات العقود', N'Contract Show Configurations ', 1038, 1)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1385, N'عرض إعدادات العقود ', N' View Contract Show Configurations', 1038, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1386, N'حفظ إعدادات العقود ', N'Save Contract Show Configurations', 1038, 2)
GO
---------------------------------------------------------- End  15-01-2024---------------------------------------------------------------------------------------------------------

---------------------------------------------------- Ali  15-01-2024 --------------------------------------------------------------------------

INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId], [ConfigDescription]) VALUES (N'Wf_RecJobStatus', N'? Job Status Mandatory', N'حالة الوظيفة اجبارى ؟', N'false', 2, 6, 1, 1, NULL, NULL, 14, N'اخفاء مرتبط بوحده توظيف ؟ =1 واظهار  حالة الوظيفة')
Go
---------------------------------------------------- End  15-01-2024 --------------------------------------------------------------------------
