﻿----------------------------------------- Sheahb 2026-05-11 -----------------

INSERT [dbo].[NotificationTemplateType] ([NotificationTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [NotificationTiming], [IsNotificationTimingEnabled], [DurationType], [Duration], [IsDurationEnabled], [SenderUserName], [SenderFrom], [SenderPassword], [SenderHostName], [SenderPort], [SenderName], [IsActive], [MinVacationBalance], [IsSendToOldManager], [MDT], [EnableSsl], [EnableAttachment], [HaveUserAccount], [IsSendWhatsAppNotifications], [IsSendRealTimeMobileNotifications], [IsSendEmailNotifications], [NotificationTypeCondition], [ReminderDuration]) 
VALUES (29, N'Rejected Vacation Requests', N'  طلبات الاجازة المرفوضة', 0, 6, 1, 1, 1, 0, N'789789', N'123', N'8tCWsaMkm/xvVDyAbcC+qg==', N'smtp.sendgrid.net', 587, N'SST', 0, NULL, 0, NULL, 1, 1, 1, 0, 0, 1, NULL, NULL)
GO
INSERT [dbo].[NotificationTemplate] ([Name], [Arabic_Name], [NotificationTemplateTypeCode], [Subject], [Body], [IsDefault], [MDT], [NotificationBody], [NotificationBody_Arabic]) 
VALUES (N'Rejected Vacation Requests', N'طلبات الاجازة المرفوضة', 29, N'  طلبات الاجازة المرفوضة', N'', 1, NULL, NULL, NULL)
GO
----------------------------------------- End 2026-05-11 -----------------
----------------------------------------- Ali 2026-05-13 -----------------

IF NOT EXISTS(SELECT 1 FROM sys.columns WHERE name = 'AbilityWorkInCountry' AND object_id = OBJECT_ID('dbo.Rec_RecruitEmployee'))
                   ALTER TABLE [dbo].[Rec_RecruitEmployee] ADD [AbilityWorkInCountry] tinyint  NULL
Go

insert into LabelsName(LabelKey,Name,Arabic_Name)VALUES(N'RecAbilityWorkInCountry',N'Ability To Work her',N'امكانية العمل هنا ')
GO

DECLARE @ConstraintName NVARCHAR(200);
                        
    SELECT @ConstraintName = dc.name
    FROM sys.default_constraints dc
    INNER JOIN sys.columns c
        ON dc.parent_object_id = c.object_id
        AND dc.parent_column_id = c.column_id
    WHERE dc.parent_object_id = OBJECT_ID('dbo.Rec_RecruitEmployee')
    AND c.name = 'HaveValidVisa';
    
    IF @ConstraintName IS NOT NULL
    BEGIN
        EXEC('ALTER TABLE [dbo].[Rec_RecruitEmployee] DROP CONSTRAINT [' + @ConstraintName + ']');
    END
    
    
    	 ALTER TABLE [dbo].[Rec_RecruitEmployee]
    ALTER COLUMN [HaveValidVisa] BIT NULL;
    Go

----------------------------------------- End 2026-05-13 -----------------
----------------------------------------- Hammad 2026-05-14 --------------
update  WF_RequestType set IsMasterRequest=0 where RequestTypeId=14
Go
----------------------------------------- End 2026-05-14 -----------------

----------------------------------------- Ali 2026-05-18 -----------------

 INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId],[ConfigDescription])
VALUES(N'Rec_DisplayRecruitJobJobRole',N'Display Job Role in Recruit Job',N'عرض الدور الوظيفي بشاشة الوظائف الشاغره',N'true',14,45,1,1,Null,Null,Null,N'عرض الدور الوظيفي بشاشة الوظائف الشاغره')
Go

IF NOT EXISTS(SELECT 1 FROM sys.columns WHERE name = 'OfferFileName' AND object_id = OBJECT_ID('dbo.Rec_JobOffer'))
          ALTER TABLE [dbo].[Rec_JobOffer] ADD [OfferFileName] nvarchar(250)  NULL;

		  Go
IF NOT EXISTS(SELECT 1 FROM sys.columns WHERE name = 'OfferSignatureFileName' AND object_id = OBJECT_ID('dbo.Rec_JobOffer'))
          ALTER TABLE [dbo].[Rec_JobOffer] ADD [OfferSignatureFileName] nvarchar(250)  NULL;
		  Go


 INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId],[ConfigDescription])
VALUES(N'Rec_MandatoryUploadOfferSignatureFile',N'Mandatory Upload Offer Signature File',N'رفع ملف العرض موقع الزامى',N'false',14,46,1,1,Null,Null,Null,N'رفع ملف العرض موقع الزامى عند الموافقه على العرض من خلال المتقدم للوظيفه')
Go
----------------------------------------- End 2026-05-18 -----------------
----------------------------------------- Shehab 2026-05-19 -----------------


INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) 
VALUES (1262, N'Blocked Passwords', N'كلمات المرور المحظورة', 4, N'/BlockedPasswords', N'Index', N'fa-solid fa-ban', N'get', 16, 1, 1)
Go
INSERT [dbo].[SystemMenuModule] ([SystemMenuCode], [AppModuleCode]) VALUES (1262, 6)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15697, N'كلمات المرور المحظورة', N'Blocked Passwords', 1262, 1)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15698, N'عرض كلمات المرور المحظورة', N'View Blocked Passwords', 1262, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15699, N'إضافة كلمات المرور المحظورة', N'Add Blocked Passwords', 1262, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15700, N'تعديل كلمات المرور المحظورة', N'Edit Blocked Passwords', 1262, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15701, N'حذف كلمات المرور المحظورة', N'Delete Blocked Passwords', 1262, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15702, N'حفظ كلمات المرور المحظورة', N'Save Blocked Passwords', 1262, 2)
GO
----------------------------------------- End 2026-05-19 -----------------
----------------------------------------- Ali 2026-05-19 -----------------
 INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId],[ConfigDescription])
VALUES(N'WF_DisplayLoanMaxAllowAmount',N'Display Loan Max Allow Amount',N'عرض الحد الأقصى المسموح به للسلفه',N'false',2,9,1,1,Null,Null,9,N'عرض الحد الأقصى المسموح به للسلفه')
Go
----------------------------------------- End 2026-05-19 -----------------
----------------------------------------- SHEHAB 2026-05-20 -----------------

INSERT [dbo].[EmailTemplate] ([Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode], [GeneralTypeCode], 
[JobTypeCode], [MessageTemplate]) VALUES (N'Send Employee Survey', N'ارسال استطلاع الي موظفين', 505, N'ارسال استطلاع الي موظفين', N'ارسال استطلاع الي موظفين', 1, NULL, NULL, NULL, NULL)
GO

----------------------------------------- End 2026-05-20 -----------------


