﻿---------------------------- AK 2023-06-26 ----- 
CREATE TABLE [dbo].[WhatsAppNotificationLog](
	[WhatsAppNotificationLogId] [int] IDENTITY(1,1) NOT NULL,
	[TransactionCode] [bigint] NOT NULL,
	[Mobile] [nvarchar](50) NOT NULL,
	[Status] [bit] NOT NULL,
	[ResponseMessage] [nvarchar](1000) NOT NULL,
	[AppModuleCode] [int] NOT NULL,
	[RequestTypeId] [int] NULL,
	[CreationDate] [datetime] NOT NULL,
	[CreatedBy] [int] NOT NULL,
 CONSTRAINT [PK_WhatsAppNotificationLog] PRIMARY KEY CLUSTERED 
(
	[WhatsAppNotificationLogId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
---------------------------- End 2023-06-26 -----
---------------------------- Ali 2023-07-03 -----

SET IDENTITY_INSERT [dbo].[MobileNotificationTypes] ON 

INSERT [dbo].[MobileNotificationTypes] ([MobileNotificationTypeCode], [Name], [Arabic_Name]) VALUES (181, N'Sending Change Employee Data Request', N'ارسال طلب تغيير بيانات موظف ')
INSERT [dbo].[MobileNotificationTypes] ([MobileNotificationTypeCode], [Name], [Arabic_Name]) VALUES (182, N'Accept Change Employee Data Request', N'الموافقه على  طلب تغيير بيانات موظف ')
INSERT [dbo].[MobileNotificationTypes] ([MobileNotificationTypeCode], [Name], [Arabic_Name]) VALUES (183, N'Refuse Change Employee Data Request', N'رفض  طلب تغيير بيانات موظف  ')
INSERT [dbo].[MobileNotificationTypes] ([MobileNotificationTypeCode], [Name], [Arabic_Name]) VALUES (184, N'Cancellation Change Employee Data Request', N'الغاء طلب تغيير بيانات موظف ')

SET IDENTITY_INSERT [dbo].[MobileNotificationTypes] OFF
Go

SET IDENTITY_INSERT [dbo].[MobileNotificationTemplates] ON 
INSERT [dbo].[MobileNotificationTemplates] ([MobileNotificationTemplateCode], [Title], [Arabic_Title], [Body], [Arabic_Body], [RequestTypeCode], [MobileNotificationTypeCode], [ModifiedBy], [ModificationDate])
VALUES (181, N'sending Change Employee Data', N'ارسال تغيير بيانات الموظف ', N'sending Change Employee Data', N'ارسال تغيير بيانات الموظف', 42, 181, NULL, NULL)
INSERT [dbo].[MobileNotificationTemplates] ([MobileNotificationTemplateCode], [Title], [Arabic_Title], [Body], [Arabic_Body], [RequestTypeCode], [MobileNotificationTypeCode], [ModifiedBy], [ModificationDate])
VALUES (182, N'Accept Change Employee Data ', N'الموافقه على   تغيير بيانات الموظف', N'Accept Change Employee Data ', N'الموافقه على   تغيير بيانات الموظف', 42, 182, NULL, NULL)
INSERT [dbo].[MobileNotificationTemplates] ([MobileNotificationTemplateCode], [Title], [Arabic_Title], [Body], [Arabic_Body], [RequestTypeCode], [MobileNotificationTypeCode], [ModifiedBy], [ModificationDate])
VALUES (183, N'Refuse Change Employee Data', N'رفض   تغيير بيانات الموظف', N'Refuse Change Employee Data', N'رفض   تغيير بيانات الموظف', 42, 183, NULL, NULL)
INSERT [dbo].[MobileNotificationTemplates] ([MobileNotificationTemplateCode], [Title], [Arabic_Title], [Body], [Arabic_Body], [RequestTypeCode], [MobileNotificationTypeCode], [ModifiedBy], [ModificationDate])
VALUES (184, N'Cancellation Change Employee Data', N'الغاء  تغيير بيانات الموظف', N'Cancellation Change Employee Data', N'الغاء  تغيير بيانات الموظف', 42, 184, NULL, NULL)
SET IDENTITY_INSERT [dbo].[MobileNotificationTemplates] OFF
Go
---------------------------- End 2023-07-03 -----
----------------------------------------mahmoud 4-7-2023----------------------------
ALTER TABLE Rec_PersonalInterviewStages 
ADD NeedCandidateOpinion bit not null default 0 ;

ALTER TABLE Rec_JobApplyingStages
ADD CandidateOpinion nvarchar(Max) ;


-------------------------------------------------------- end 4-7-2023----------------------------
---------------------------- Ali 2023-07-06 -----
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) 
VALUES (15337, N'ارسال ايميل بعد الموافقه على الطلب', N'Send Email After Approving Request', 522, 2)
GO

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (1087, N'WorkFlow', N'IntroductionLetterRequest', N'SendEmailAfterApprovingRequest', 0, N'get', 15337)
GO

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (686, NULL, NULL, N'IntroductionLetterRequest', N'SendEmailAfterApprovingRequest', N'get')
GO

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (863, 686, 15337, 50)
GO

 INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId],[ConfigDescription])
VALUES(N'RecUploadCvMandatory',N'Upload Cv Mandatory',N'تحميل السيرة الذاتية إلزامي',N'false',14,27,1,1,Null,Null,Null,N'تحميل السيرة الذاتية إلزامي عند ادخال البيانات فى التوظيف عبر الانترنت')
Go

---------------------------- End 2023-07-06 -----
------------------------------mahmoud 6-7-2023 -------------


INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId], [ConfigDescription])
 VALUES (N'AddingJobOfferRequest', N'Adding JobOffer Request', N'أضافة طلب العرض الوظيفى ', N'false', 2, 1, 1, 1, NULL, NULL, 58, N'أضافة طلب العرض الوظيفى ')
GO

-----------------------------------------6-7-2023 -----------------