﻿--------------------------Mostafa 2022-10-31-----------------
ALTER TABLE Rec_QuestionTemplate
ADD    QuestionDescription_Arabic Nvarchar(250)  NULL
GO
ALTER TABLE Rec_MultiChoiceAnswer
ADD    AnswerDescription_Arabic Nvarchar(250)  NULL
GO
UPDATE Rec_QuestionTemplate SET QuestionDescription_Arabic = QuestionDescription;
GO
UPDATE Rec_MultiChoiceAnswer SET AnswerDescription_Arabic = AnswerDescription;
GO
--------------------------End 2022-10-31-----------------
--------------------------Hammad 2022-10-31--------------
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) 
VALUES (2237, N'تغير درجة الاهمية', N'Change Priority Degree', 16, 2)
GO
--------------------------End 2022-10-31--------------
--------------------------Hammad 2022-11-01-----------
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) 
VALUES (584, NULL, NULL, N'JournalType', N'Post', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
 VALUES (782, 584, 23018, NULL)
GO


/****** Object:  StoredProcedure [dbo].[Emp_GetEmployeeSalaryDetails]    Script Date: 01/11/2022 11:31:33 ******/
DROP PROCEDURE [dbo].[Emp_GetEmployeeSalaryDetails]
GO

/****** Object:  StoredProcedure [dbo].[Emp_GetEmployeeSalaryDetails]    Script Date: 01/11/2022 11:31:33 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE procedure [dbo].[Emp_GetEmployeeSalaryDetails] 
(
	@EmpCode	int=0
)
AS


SELECT 
	  [EmployeeCode]
      ,[dbo].Salary_Details.[BandCode]
      ,[Amount]
      ,[CurrencyCode]
      ,[CurrencyAmount]
      ,[AmountAcc]
      ,[CurrencyAmountAcc]
      ,[TempChangeValue]
      ,[ArabicAmount]
      ,[CalculateNumber]
      ,[EnglishAmount]
      ,[SerialAuto]
      ,[SpecialCostCenter]
	  ,[dbo].Basis.[Name] BasisNameEn
	  ,[dbo].Basis.[Arabic_Name] BasisNameAr

FROM [dbo].[Salary_Details]
inner join [dbo].[Basis] on [dbo].[Basis].[BandCode] = [dbo].Salary_Details.BandCode

where 
	( [dbo].[Basis].OutofTotal=0 and [dbo].Salary_Details.[EmployeeCode] = @EmpCode);

GO

--------------------------End 2022-11-01-----------
--------------------------Ali 2022-11-02-----------


CREATE TABLE [dbo].[Rec_RecruitJobEducations](
	[RecruitJobEducationCode] [int] IDENTITY(1,1) NOT NULL,
	[RecruitJobCode] [int] NOT NULL,
	[EducationStatusCode] [int] NOT NULL,
 CONSTRAINT [PK_Rec_RecruitJobEducations] PRIMARY KEY CLUSTERED 
(
	[RecruitJobEducationCode] 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

ALTER TABLE [dbo].[Rec_RecruitJobEducations]  WITH CHECK ADD  CONSTRAINT [FK_Rec_RecruitJobEducations_EducationStatus] FOREIGN KEY([EducationStatusCode])
REFERENCES [dbo].[EducationStatus] ([EducationStatusCode])
GO

ALTER TABLE [dbo].[Rec_RecruitJobEducations] CHECK CONSTRAINT [FK_Rec_RecruitJobEducations_EducationStatus]
GO

ALTER TABLE [dbo].[Rec_RecruitJobEducations]  WITH CHECK ADD  CONSTRAINT [FK_Rec_RecruitJobEducations_Rec_RecruitJob] FOREIGN KEY([RecruitJobCode])
REFERENCES [dbo].[Rec_RecruitJob] ([RecruitJobCode])
GO

ALTER TABLE [dbo].[Rec_RecruitJobEducations] CHECK CONSTRAINT [FK_Rec_RecruitJobEducations_Rec_RecruitJob]
GO


CREATE TABLE [dbo].[Rec_RecruitJobNationalities](
	[RecruitJobNationalityCode] [int] IDENTITY(1,1) NOT NULL,
	[RecruitJobCode] [int] NOT NULL,
	[NationalityCode] [tinyint] NOT NULL,
 CONSTRAINT [PK_Rec_RecruitJobNationalities] PRIMARY KEY CLUSTERED 
(
	[RecruitJobNationalityCode] 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

ALTER TABLE [dbo].[Rec_RecruitJobNationalities]  WITH CHECK ADD  CONSTRAINT [FK_Rec_RecruitJobNationalities_Nationality] FOREIGN KEY([NationalityCode])
REFERENCES [dbo].[Nationality] ([NationalityCode])
GO

ALTER TABLE [dbo].[Rec_RecruitJobNationalities] CHECK CONSTRAINT [FK_Rec_RecruitJobNationalities_Nationality]
GO

ALTER TABLE [dbo].[Rec_RecruitJobNationalities]  WITH CHECK ADD  CONSTRAINT [FK_Rec_RecruitJobNationalities_Rec_RecruitJob] FOREIGN KEY([RecruitJobCode])
REFERENCES [dbo].[Rec_RecruitJob] ([RecruitJobCode])
GO

ALTER TABLE [dbo].[Rec_RecruitJobNationalities] CHECK CONSTRAINT [FK_Rec_RecruitJobNationalities_Rec_RecruitJob]
GO


insert into Rec_RecruitJobEducations (RecruitJobCode,EducationStatusCode) (select EducationStatusCode,EducationStatusCode from Rec_RecruitJob)
Go



ALTER TABLE Rec_RecruitJob
DROP COLUMN EducationStatusCode
GO



INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(657,N'Recruit Files',N'مرفقات التوظيف',48,N'/Recruitment/RecruitRequiredFile',N'Index','fa fa-thumb-tack',N'get',16,1,1)
Go

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

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(5136,N'مرفقات التوظيف',N'Recruit Files',657,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(5137,N'عرض مرفقات التوظيف',N'View Recruit Files',657,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(5138,N'إضافة مرفقات التوظيف',N'Add Recruit Files',657,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(5139,N'تعديل مرفقات التوظيف',N'Edit Recruit Files',657,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(5140,N'حذف مرفقات التوظيف',N'Delete Recruit Files',657,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(5141,N'حفظ مرفقات التوظيف',N'Save Recruit Files',657,2)
Go


--------------------------End 2022-11-02-----------
--------------------------Hammad 2022-11-02-----------
SET IDENTITY_INSERT [dbo].[EmailTemplateType] ON 
GO
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode], [RequestTypeCode], [HaveUserAccount]) 
VALUES (342, N'Reset Password', N'إعادة تعيين كلمة المرور ', 0, 4, NULL, 1)
GO
SET IDENTITY_INSERT [dbo].[EmailTemplateType] OFF
GO

INSERT [dbo].[EmailTemplate] ([Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode], [GeneralTypeCode], [JobTypeCode], [MessageTemplate]) 
VALUES ( N'Reset Password', N'إعادة تعيين كلمة المرور', 342, N'Reset Password', N'<div style="text-align:left;">Hello @Raw(Model.CandidateName),<br /><br />We wanted to let you know that your password was reset.<br />new password :&nbsp; @Raw(Model.Password)<br /><br />Please do not reply to this email with your password<br />and we strongly discourage you from sharing it with anyone.<br /><br />Thank You.</div>', 1, NULL, NULL, NULL, NULL)
GO
--------------------------End 2022-11-02-----------