﻿


CREATE TABLE [dbo].[WF_HireCandidateRequest](
	[MasterRequestCode] [int] NOT NULL,
	[ForeignerUserCode] [int] NOT NULL,
	[SectionCode] [nvarchar](20) NOT NULL,
	[PositionCode] [nvarchar](30) NOT NULL,
	[ApplyForJobCode] [int] NOT NULL,
 CONSTRAINT [PK_WF_HireCandidateRequest] PRIMARY KEY CLUSTERED 
(
	[MasterRequestCode] 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].[WF_HireCandidateRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_HireCandidateRequest_WF_MasterRequests] FOREIGN KEY([MasterRequestCode])
REFERENCES [dbo].[WF_MasterRequests] ([MasterRequestCode])
GO

ALTER TABLE [dbo].[WF_HireCandidateRequest] CHECK CONSTRAINT [FK_WF_HireCandidateRequest_WF_MasterRequests]
GO




INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(540,N'Hire Candidates Signature',N'اعتماد تعيين المرشحين',500,N'/WorkFlow/HireCandidateRequestSignature',N'Index','fa fa-thumb-tack',N'get',6,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(540,1)
Go

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15209,N'اعتماد تعيين المرشحين',N'Hire Candidates Signature',540,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15210,N'عرض اعتماد تعيين المرشحين',N'View Hire Candidates Signature',540,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15211,N'تعديل اعتماد تعيين المرشحين',N'Edit Hire Candidates Signature',540,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15212,N'حفظ اعتماد تعيين المرشحين',N'Save Hire Candidates Signature',540,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15213,N'حفظ متعدد للاعتماد',N'Multiple Save',540,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15214,N'ارجاع الطلب',N'Inverse Request',540,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15215,N'اختيار كل الطلبات',N'Choose All Requests',540,2)

Go



INSERT[dbo].[WF_RequestType]([RequestTypeId], [RequestTypeName], [RequestTypeNameEn], [IsEditable], [SenderUserName], [SenderFrom], [SenderPassword], [SenderHostName], [SenderPort], [SenderName], [SubmitBeforRequestDate], [SubmitAfterRequestDate], [IsUsed], [CanDelegation], [DisplayUserName], [HaveAttachment])
 VALUES(53,N'طلب تعيين المرشحين',N'Hire Candidate Request',0,N'sayedmustafa84@yahoo.com',N'sayedmustafa84@yahoo.com',N'1',N'smtp.sendgrid.net',587,N'SST',NULL,NULL,1,1,0,0)
Go


SET IDENTITY_INSERT[dbo].[EmailTemplateType] ON
INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode]) VALUES(261,N'Hire Candidate Request Sending',N'ارسال طلب تعيين المرشحين',0,1)

INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode]) VALUES(262,N'Hire Candidate Request Accept',N'الموافقة على طلب تعيين المرشحين',0,1)

INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode]) VALUES(263,N'Hire Candidate Request Refuse',N'رفض طلب تعيين المرشحين',0,1)

INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode]) VALUES(264,N'Hire Candidate Request Cancel',N'الغاء طلب تعيين المرشحين',0,1)
SET IDENTITY_INSERT [dbo].[EmailTemplateType] OFF
SET IDENTITY_INSERT [dbo].[EmailTemplate] ON 
INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(261,N'Hire Candidate Request Sending',N'ارسال طلب تعيين المرشحين',261,N'ارسال',N'ارسال',1,NULL)

INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(262,N'Hire Candidate Request Accept',N'الموافقة على طلب تعيين المرشحين',262,N'الموافقة على',N'الموافقة على',1,NULL)

INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(263,N'Hire Candidate Request Refuse',N'رفض طلب تعيين المرشحين',263,N'رفض',N'رفض',1,NULL)

INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(264,N'Hire Candidate Request Cancel',N'الغاء طلب تعيين المرشحين',264,N'الغاء',N'الغاء',1,NULL)
SET IDENTITY_INSERT [dbo].[EmailTemplate] OFF
Go
 --------------------------End 2021-06-09--------------------------------
 --------------------------Hammad 2021-06-09-----------------------------
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) 
VALUES (N'ShowEmployeesSubContracts', N'Show Employees Sub Contracts', N'  عرض العقود الفرعية للموظف', N'true', 7, 11, 1, 1, NULL, NULL, NULL)
 
 Go
 INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
 VALUES (N'RecHireCandidateRequest', N'Add Hire Candidate Request', N'اضافة طلب لتعين المرشح', N'false', 4, 3, 1, 1, NULL, NULL, NULL)
 Go

 INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
 VALUES (541, N'Consolidated Report', N'  تقارير مجمعة', 182, N'/ConsolidatedDashboard/ConsolidatedReport', N'Index', N'fa fa-thumb-tack', N'get', 6, 1, 1)
 Go
 INSERT [dbo].[SystemMenuModule] ( [SystemMenuCode], [AppModuleCode]) VALUES (541, 9)
 Go

 INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (11040, N'  تقارير مجمعة ', N'Consolidated Report', 541, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (11041, N'عرض   تقارير مجمعة ', N'View Consolidated Report', 541, 2)
Go
 --------------------------End 2021-06-09-----------------------------
 --------------------------Ali 2021-06-13-----------------------------
 update [WF_RequestType]
set  [CategoryCode]=1,[RequestTypeGroupCode]=4
	 where  [RequestTypeId]=53
	 Go
	 update [SystemMenu]
set
 [Name]=N'Hire Candidates Request Signature', [Arabic_Name]=N'اعتماد  طلب تعيين المرشحين'
	 where  [SystemMenuCode]=540
	 Go

	 update [SecurityPrivilege] set  [DescriptionAR]=N'اعتماد طلب تعيين المرشحين' ,[DescriptionEN]=N'Hire Candidates Request Signature' where [ID]=15209
update [SecurityPrivilege] set  [DescriptionAR]=N'عرض اعتماد طلب تعيين المرشحين'   ,[DescriptionEN]=N'View Hire Candidates Request Signature' where [ID]=15210 
update [SecurityPrivilege] set  [DescriptionAR]=N'تعديل اعتماد طلب تعيين المرشحين' ,[DescriptionEN]=N'Edit Hire Candidates Request Signature' where [ID]=15211
update [SecurityPrivilege] set  [DescriptionAR]=N'حفظ اعتماد طلب تعيين المرشحين'   ,[DescriptionEN]=N'Save Hire Candidates Request Signature' where [ID]=15212
Go
 --------------------------End 2021-06-13-----------------------------
  --------------------------Ali 2021-10-06-------------------------

  INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'WFMustAddPreviousExperiences',N'Must Add Previous Experiences',N'الزامية اضافة الخبرات السابقة',N'false',2,10,1,1,Null,Null,5)
Go


  CREATE TABLE [dbo].[WF_EmployeesExperiences](
	[EmployeesExperienceCode] [int] IDENTITY(1,1) NOT NULL,
	[NewHireRequestCode] [int] NOT NULL,
	[Position] [nvarchar](150) NOT NULL,
	[Salary] [float] NULL,
	[PreviousCurrencyCode] [tinyint] NOT NULL,
	[DateFrom] [datetime] NULL,
	[DateTo] [datetime] NULL,
	[ReasonLeave] [nvarchar](200) NULL,
	[PlaceName] [nvarchar](150) NULL,
 CONSTRAINT [PK_WF_PreviousExperiences] PRIMARY KEY CLUSTERED 
(
	[EmployeesExperienceCode] 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].[WF_EmployeesExperiences]  WITH CHECK ADD  CONSTRAINT [FK_WF_PreviousExperiences_WF_NewHireRequest] FOREIGN KEY([NewHireRequestCode])
REFERENCES [dbo].[WF_NewHireRequest] ([NewHireRequestCode])
GO

ALTER TABLE [dbo].[WF_EmployeesExperiences] CHECK CONSTRAINT [FK_WF_PreviousExperiences_WF_NewHireRequest]
GO
  --------------------------End 2021-10-06-------------------------
  --------------------------Hammad 2021-10-09----------------------
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
 VALUES (N'WFDisplayEmployeeFinancialPrivilege', N'DisplayEmployeeFinancialPrivilege', N'   عرض موظفين صلاحيات المالية', N'false', 2, 5, 1, 1, NULL, NULL, 9)
 Go
   --------------------------End 2021-10-09----------------------
