﻿----------------------------------------- SHEHAB 2025-07-10 -----------------
GO
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], 
[RequestTypeId], [ConfigDescription]) VALUES (N'DisplayEmployeeShortName', N'Display Employee Short Name', N'عرض الاسم المختصر للموظف', N'false', 1, 67, 1, 1, NULL, NULL, NULL, N'عرض الاسم المختصر للموظف')

----------------------------------------- End 2025-07-10 -----------------
  ---------------------------------mostafa 2025-07-15--------------------------

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(1176,N'CV Bank',N'بنك السيرة الذاتية',47,N'/Recruitment/CVBank',N'Index','fa-solid fa-briefcase',N'get',12,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(1176,4)
Go

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(5157,N'بنك السيرة الذاتية',N'CV Bank',1176,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(5158,N'عرض بنك السيرة الذاتية',N'View CV Bank',1176,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(5159,N'إضافة بنك السيرة الذاتية',N'Add CV Bank',1176,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(5160,N'تعديل بنك السيرة الذاتية',N'Edit CV Bank',1176,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(5161,N'حذف بنك السيرة الذاتية',N'Delete CV Bank',1176,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(5162,N'حفظ بنك السيرة الذاتية',N'Save CV Bank',1176,2)
Go
  ---------------------------------End 2025-07-15--------------------------
----------------------------------------- SHEHAB 2025-07-14 -----------------
    GO
    update securityPrivilege
    set PrivilegeType=2
    where id=3592

----------------------------------------- End 2025-07-14 -----------------


  -----------------------------------------Ali 2025-07-15-----------------
  
    ALTER TABLE dbo.SecurityUserBranch ADD
	IsConsolidated bit NOT NULL CONSTRAINT DF_SecurityUserBranch_IsConsolidated DEFAULT ((0))
GO

  update SecurityUserBranch set  IsConsolidated=1
  Go

  INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId],[ConfigDescription])
VALUES(N'Rec_WorkByCentralRecruitment',N'Work By Central Recruitment',N'العمل بنظام التوظيف المركزي',N'false',4,6,1,1,Null,Null,Null,N'ربط التوظيف بطلب تعيين المرشحين وطلب موظفين جدد بنظام مركزى للتوظيف')
Go

ALTER TABLE WF_StaffReplacement
DROP CONSTRAINT FK_WF_StaffReplacement_Employees;
GO

  ALTER TABLE dbo.Sections ADD
	CentralCode nvarchar(20)  NULL
GO

  ALTER TABLE dbo.Positions ADD
	CentralCode nvarchar(20)  NULL
GO

  -----------------------------------------End 2025-07-15-----------------
   ----------------------------------------- AK 2025-07-16 --------------------

ALTER TABLE dbo.Divisions ADD
	AccountsPayable1Code int NULL,
	AccountsPayable2Code int NULL
GO
INSERT [dbo].[UserType] ([UserTypeCode], [Name], [Arabic_Name], [HaveEmployee], [OrganizationCategoryCode], [IsVisible]) VALUES (44, N'Accounts Payable1', N'الحسابات الدائنة1', 1, NULL, 1)
Go
INSERT [dbo].[UserType] ([UserTypeCode], [Name], [Arabic_Name], [HaveEmployee], [OrganizationCategoryCode], [IsVisible]) VALUES (45, N'Accounts Payable2', N'الحسابات الدائنة2', 1, NULL, 1)
Go
 -----------------------------------------END AK 2025-07-16 --------------------
 -----------------------------------------Hammad 2025-07-17 --------------------
 INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES (720, N'Business Trip Request', N' طلب مامورية', 498, N'/WorkFlow/MissionRequest', N'Index', N'fas fa-unlock-alt', N'get', 6, 1, 1)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15568, N'طلب مامورية', N'Business Trip Request', 720, 1)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15569, N'عرض طلب مامورية', N'View Business Trip Request', 720, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15570, N'اضافة طلب مامورية', N'Add Business Trip Request', 720, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15571, N'تعديل طلب مامورية', N'Edit Business Trip Request', 720, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15572, N'حذف طلب مامورية', N'Delete Business Trip Request', 720, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15574, N'الغاء طلب مامورية', N'Cancel Business Trip Request', 720, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15575, N'حفظ طلب مامورية', N'Save Business Trip Request', 720, 2)
GO

INSERT [dbo].[SystemMenuModule] ([SystemMenuCode], [AppModuleCode]) VALUES (720, 1)
GO
 -----------------------------------------End Hammad 2025-07-17 --------------------