﻿-----------------------Hammad 2021-04-08---------------------------
 
CREATE TABLE [dbo].[LabelsName](
	[LabelKey] [nvarchar](150) NOT NULL,
	[Name] [nvarchar](150) NOT NULL,
	[Arabic_Name] [nvarchar](150) NOT NULL,
 CONSTRAINT [PK_LabelsName] PRIMARY KEY CLUSTERED 
(
	[LabelKey] 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
INSERT [dbo].[LabelsName] ([LabelKey], [Name], [Arabic_Name]) VALUES (N'Org4', N'Org4', N'هيكل 4')
INSERT [dbo].[LabelsName] ([LabelKey], [Name], [Arabic_Name]) VALUES (N'Org5', N'Org5', N'هيكل 5')
INSERT [dbo].[LabelsName] ([LabelKey], [Name], [Arabic_Name]) VALUES (N'Org6', N'Org6', N'هيكل 6')
GO


/****** Object:  StoredProcedure [dbo].[Emp_GetEmployeeProfile]    Script Date: 08/04/2021 2:19:05 PM ******/
DROP PROCEDURE [dbo].[Emp_GetEmployeeProfile]
GO

/****** Object:  StoredProcedure [dbo].[Emp_GetEmployeeProfile]    Script Date: 08/04/2021 2:19:05 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO




CREATE procedure [dbo].[Emp_GetEmployeeProfile] 
(
	@userCode	int
)
AS


SELECT  
	   e.[EmployeeCode]
      ,e.[Name]
      ,e.[Arabic_Name]
      ,[Sex]
      ,[BirthDate]
      ,[BirthCityCode]
      ,[BirthDestination]
      ,[BirthDestinationArabic]
          
      ,[LokerNumber]
      ,[IDTypeCode]
      ,[IdIssueFrom]
      ,[IdIssueFromArabic]
      ,[IdNumber]
      ,[IDpolice_station]
      ,[IdCityCode]
      ,[IdIssueDate]
      ,[IdExpireDate]
     
      ,[Children_Number]
     
      ,[HiringDate]
      ,[ContractDate]
      ,[ContractExpireDate]    
     
      ,[InsuranceNumber]
      ,e.[ReligionCode]      
    
      ,[ResignationCode]
      ,[ResignationDate]     
      ,[Active]
   
      ,[CityCode]
      ,[EngFullAddress]
      ,[ArabicFullAddress]
      ,[OldFullAddress]    
      ,[Police_Station]
      ,[EngArea]
      ,[EngPolice_Station]
     
      ,[MotherName]
      ,e.[Telephone]
      ,[Mobile]
      ,e.[EMail]
      ,[CurrPercent]
      ,[Hidden]
      ,[Transfer]
      ,[VacationCalcCode]
      ,[DayRate]
      ,[WorkHoures]     
      ,[RoomNumber]     
      ,[BasicSalary]
    
      ,[StopSalaryReason]
      ,[NotApplicableToTransportationAllowance]
      ,[StopSalary]
      ,[ResignationPostingDate]
       
      ,[EmployeeType]
      ,[BirthDateHijri]
      ,[ContractDateHijri]
      ,[ContractExpireDateHijri]
      ,[HiringDateHijri]
	  ,[ProbationDate]
      ,[ProbationDateHijri]
      ,[ExperienceDateHijri]
      ,[LastWageHijri]
      ,[InsureDateHijri]
      ,[ResignationDateHijri]
      ,[ResignationPostingDateHijri]
      
	  ,dbo.Location.[Name] LocationNameEn
	  ,dbo.Location.[Arabic_Name] LocationNameAr	
	  ,dbo.SocialInsurance.[BasicEmployeeShare]
	  ,dbo.SocialInsurance.[BasicCompanyShare]
	  ,dbo.SocialInsurance.[VariableEmployeeShare]
	  ,dbo.SocialInsurance.[VariableCompanyShare]
	  ,dbo.SocialInsurance.[InsuranceDate]
	  ,dbo.SocialInsurance.[InsuranceDateHijri]
	   ,dbo.SocialInsurance.MaxBasic

	  ,dbo.Insurer.[Name] as InsurerNameEn
	  ,dbo.Insurer.[Arabic_Name] as InsurerNameAr
	  ,dbo.InsuranceTypes.[Name] as InsuranceTypesNameEn
	  ,dbo.InsuranceTypes.[Arabic_Name] as InsuranceTypesNameAr
	  ,dbo.Sections.Name SectionsNameEn
	  ,dbo.Sections.Arabic_Name SectionsNameAr
	  ,dbo.Departments.Name DepartmentsNameEn
	  ,dbo.Departments.Arabic_Name DepartmentsNameAr
	  ,dbo.Divisions.Name DivisionsNameEn
	  ,dbo.Divisions.Arabic_Name DivisionsNameAr
	  ,dbo.Org4.Name Org4NameEn
	  ,dbo.Org4.Arabic_Name Org4NameAr
	  ,dbo.Org5.Name Org5NameEn
	  ,dbo.Org5.Arabic_Name Org5NameAr
	  ,dbo.Nationality.[Name] NationalityNameEn
	  ,dbo.Nationality.[Arabic_Name] NationalityNameAr
	  ,dbo.Nationality.[CountryName]
	  ,dbo.Nationality.[CountryArabic_Name]
	  ,dbo.MaritalStatus.[Name] MaritalStatusNameEn
	  ,dbo.MaritalStatus.[Arabic_Name] MaritalStatusNameAr
	  ,dbo.EmployeeEducationData.[EducationDescription]
	  ,dbo.[Contract].[Name] ContractNameEn
	  ,dbo.[Contract].[Arabic_Name] ContractNameAr
	  ,dbo.[Currencies].[Name] CurrenciesNameEn
	  ,dbo.[Currencies].[Arabic_Name] CurrenciesNameAr
	  ,dbo.Levels.Name LevelsNameEn
	  ,dbo.Levels.Arabic_Name LevelsNameAr
	  ,dbo.Positions.Name PositionsNameEn
	  ,dbo.Positions.Arabic_Name PositionsNameAr
	  ,dbo.[GeneralTypes].[Name] GeneralTypesNameEn
	  ,dbo.[GeneralTypes].[Arabic_Name] GeneralTypesNameAr
	  ,UserImage
	  ,RecieveEmailNotifications
	  ,UserName



	  ,dbo.EmployeesExtend.[IssuePlace] as EmpExtendIssuePlace
	  ,dbo.EmployeesExtend.[CardNumber] as  EmpExtendCardNumber
	  ,dbo.EmployeesExtend.[IssueDate] as EmpExtendIssueDate
	  ,dbo.EmployeesExtend.[IssueDateHijri] as EmpExtendIssueDateHijri
	  ,dbo.EmployeesExtend.[ExpireDate] as EmpExtendExpireDate
	  ,dbo.EmployeesExtend.[ExpireDateHijri] as EmpExtendExpireDateHijri
	  ,dbo.EmployeesExtend.ExtensionNumber
	  ,dbo.EmployeesExtend.EMail2 

	  ,dbo.[HealthInsuranceTypes].[Name] as MedicalInsuranceTypeNameEn
	  ,dbo.[HealthInsuranceTypes].[Arabic_Name] as MedicalInsuranceTypeNameAr
	

   
FROM [dbo].[SecurityUser]

left join [dbo].[Employees] e on [dbo].SecurityUser.[EmployeeCode] = e.EmployeeCode
left join [dbo].[Location] on [dbo].Location.[LocationCode] = e.LocationCode
left join [dbo].[SocialInsurance] on [dbo].SocialInsurance.[EmployeeCode] = e.EmployeeCode
left join [dbo].[Insurer] on [dbo].Insurer.[InsurerCode] = [dbo].SocialInsurance.[InsurerCode]
left join [dbo].[InsuranceTypes] on [dbo].InsuranceTypes.InsuranceCode = e.InsuranceCode
left join [dbo].[Sections] on [dbo].Sections.SectionCode = e.SectionCode
left join [dbo].[Departments] on [dbo].Departments.DepartmentCode = [dbo].Sections.DepartmentCode
left join [dbo].Divisions on [dbo].Divisions.DivisionCode = [dbo].Departments.DivisionCode
left join [dbo].Org4 on [dbo].Org4.Org4Code = [dbo].Divisions.FatherCode
left join [dbo].Org5 on [dbo].Org5.Org5Code = [dbo].Org4.FatherCode
left join [dbo].[Nationality] on [dbo].Nationality.[NationalityCode] = e.NationalityCode
left join [dbo].[MaritalStatus] on [dbo].MaritalStatus.[MaritalCode] = e.MaritalCode
left join [dbo].[EmployeeEducationData] on [dbo].EmployeeEducationData.[EmployeeCode] = e.EmployeeCode
left join [dbo].[Contract] on [dbo].[Contract].[ContractCode] = e.ContractCode
left join [dbo].[Currencies] on [dbo].[Currencies].CurrencyCode = e.CurrencyCode
left join [dbo].[Levels] on [dbo].Levels.LevelCode = e.LevelCode
left join [dbo].[GeneralTypes] on [dbo].GeneralTypes.[GeneralTypeCode] = e.GeneralTypeCode
left join [dbo].[Positions] on [dbo].Positions.PositionCode = e.PositionCode

left join [dbo].[EmployeesExtend] on [dbo].EmployeesExtend.[EmployeeExtendCode] = e.EmployeeCode
left join [dbo].[HealthInsuranceTypes] on [dbo].HealthInsuranceTypes.HealthInsuranceTypeCode = [dbo].[EmployeesExtend].HealthInsuranceTypeCode

where [dbo].[SecurityUser].[EmployeeCode] = @userCode;
GO

INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) 
VALUES (N'WFPermissionCalcMinute', N'Permission Calc Minute', N' طريقةإحتساب عدد دقائق الإذن', N'75', 2, 2, 6, 1, NULL, NULL, 2)
Go
INSERT [dbo].[ConfigLookup] ([ConfigLookupCode], [Name], [Arabic_Name], [ConfigKey]) VALUES (75, N'Fixed', N'Fixed', N'WFPermissionCalcMinute')
INSERT [dbo].[ConfigLookup] ([ConfigLookupCode], [Name], [Arabic_Name], [ConfigKey]) VALUES (76, N'Flexible', N'Flexible', N'WFPermissionCalcMinute')
Go

 -----------------------End 2021-04-08---------------------------
 -----------------------Ali 2021-04-08---------------------------

 INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'WFShowIsBridge',N' Show Is Bridge ?',N'اضهار  بريدج  ؟',N'false',2,38,1,1,Null,Null,11)
Go
 -----------------------End 2021-04-08---------------------------
  -----------------------Ali 2021-04-11---------------------------

ALTER TABLE dbo.WF_LoanTypeDetials ADD
	MaximumLoanpercent int NULL
GO

ALTER TABLE dbo.WF_NewJobRequest ADD
	LevelCode tinyint NULL,
	GradeCode int NULL,
	Responsibilitie nvarchar(250) NULL
GO
ALTER TABLE dbo.WF_NewJobRequest ADD CONSTRAINT
	FK_WF_NewJobRequest_Levels FOREIGN KEY
	(
	LevelCode
	) REFERENCES dbo.Levels
	(
	LevelCode
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
ALTER TABLE dbo.WF_NewJobRequest ADD CONSTRAINT
	FK_WF_NewJobRequest_Grade FOREIGN KEY
	(
	GradeCode
	) REFERENCES dbo.Grade
	(
	GradeCode
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
	Go


	ALTER TABLE dbo.WF_CompensationRequestForADayOfRest ADD
	CostCenter nvarchar(150) NULL
GO
ALTER TABLE dbo.WF_OverTimeRequest ADD
	CostCenter nvarchar(150) NULL
GO

 -----------------------End 2021-04-11---------------------------
 -----------------------Sayed 2021-04-11------------------------
   alter table TimePermissionsTypes
  add MaximumMinutesPerMonth int null,
   BonusEffect bit null
   GO
   ---------------------End 2021-04-11---------------------------
   ---------------------Hammad 2021-04-11------------------------

CREATE TABLE [dbo].[WF_MonthlyEffectType](
	[MonthlyEffectTypeCode] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](500) NOT NULL,
	[Arabic_Name] [nvarchar](500) NOT NULL,
	[BandCode] [int] NOT NULL,
	[MaxRequestCount] [int] NOT NULL,
	[MaxRequestCountType] [int] NOT NULL,
	[DaysCountAfterHiring] [int] NOT NULL,
	[IsFixed] [bit] NOT NULL,
	[CalculatedByCode] [int] NOT NULL,
 CONSTRAINT [PK_WF_MonthlyEffectType] PRIMARY KEY CLUSTERED 
(
	[MonthlyEffectTypeCode] 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_MonthlyEffectType] ADD  CONSTRAINT [DF_WF_MonthlyEffectType_IsFixed]  DEFAULT ((0)) FOR [IsFixed]
GO

ALTER TABLE dbo.WF_MonthlyEffectsRequest ADD
	CurrencyCode tinyint NOT NULL CONSTRAINT DF_WF_MonthlyEffectsRequest_CurrencyCode DEFAULT ((0))
GO

ALTER TABLE dbo.WF_MonthlyEffectsRequest ADD
	MonthlyEffectTypeCode int NULL
GO

ALTER TABLE [dbo].[WF_MonthlyEffectsRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_MonthlyEffectsRequest_WF_MonthlyEffectType] FOREIGN KEY([MonthlyEffectTypeCode])
REFERENCES [dbo].[WF_MonthlyEffectType] ([MonthlyEffectTypeCode])
GO

ALTER TABLE [dbo].[WF_MonthlyEffectsRequest] CHECK CONSTRAINT [FK_WF_MonthlyEffectsRequest_WF_MonthlyEffectType]
GO


INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(488,N'Monthly Effect Type',N'نوع الموثر الشهرى',28,N'/WorkFlow/MonthlyEffectType',N'Index','fa fa-thumb-tack',N'get',26,1,1)
Go

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

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15021,N'نوع الموثر الشهرى',N'Monthly Effect Type',488,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15022,N'عرض نوع الموثر الشهرى',N'View Monthly Effect Type',488,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15023,N'إضافة نوع الموثر الشهرى',N'Add Monthly Effect Type',488,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15024,N'تعديل نوع الموثر الشهرى',N'Edit Monthly Effect Type',488,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15025,N'حذف نوع الموثر الشهرى',N'Delete Monthly Effect Type',488,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15026,N'حفظ نوع الموثر الشهرى',N'Save Monthly Effect Type',488,2)
Go




   ---------------------End 2021-04-11------------------------


   ---------------------Ali 2021-04-12------------------------
   INSERT INTO [SST.ERP_Client]. [dbo].[APIs] ([ApiId], [ApiName]) VALUES (6, N'ArchiveApi')
   Go
   
  SET IDENTITY_INSERT [dbo].[AppModule] ON  
   INSERT [dbo].[AppModule] ([AppModuleCode], [Name], [Arabic_Name], [IsLicensed], [LicenseNumber]) VALUES (14, N'Employees Archive', N'ارشيف الموظفين', 1, NULL)
SET IDENTITY_INSERT [dbo].[AppModule] OFF
Go

 INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(489,N'Archive Basic Data',N'البيانات الاساسية للارشيف',133,N'',N'','fa fa-thumb-tack',N'',4,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(489,14)
Go


INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(490,N'Documents Types',N'أنواع الوثائق',489,N'/Archive/ArcEmpDocumentType',N'Index','fa fa-thumb-tack',N'get',1,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(490,14)
Go

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(9018,N'أنواع الوثائق',N'Documents Types',490,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(9019,N'عرض أنواع الوثائق',N'View Documents Types',490,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(9020,N'إضافة أنواع الوثائق',N'Add Documents Types',490,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(9021,N'تعديل أنواع الوثائق',N'Edit Documents Types',490,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(9022,N'حذف أنواع الوثائق',N'Delete Documents Types',490,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(9023,N'حفظ أنواع الوثائق',N'Save Documents Types',490,2)
Go



INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(662,N'Archive',N'ArcEmpDocumentType',N'Index',0,N'get',9018)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(663,N'Archive',N'ArcEmpDocumentType',N'ArcEmpDocumentType_Read',0,N'post',9019)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(664,N'Archive',N'ArcEmpDocumentType',N'Save',1,N'get',9020)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(665,N'Archive',N'ArcEmpDocumentType',N'Save',2,N'get',9021)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(666,N'Archive',N'ArcEmpDocumentType',N'Delete',0,N'post',9022)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(667,N'Archive',N'ArcEmpDocumentType',N'Save',0,N'post',9023)
Go


ALTER TABLE dbo.WF_PromotionRequest ADD
	CostCenter nvarchar(150) NULL
GO
ALTER TABLE dbo.WF_TransferRequest ADD
	CostCenter nvarchar(150) NULL
GO
   ---------------------End 2021-04-11----------------------

 ---------------------Hammad 2021-04-13---------------------
   INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
 VALUES (N'WFMonthOfEndYear', N'Month Of End Year', N'شهر  نهاية السنة   ', N'12', 1, 15, 2, 1, NULL, NULL, NULL)
 GO
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
 VALUES (N'WFVacationBalanceSource', N'Vacation Balance Source', N' مصدر رصيد الإجازات', N'77', 2, 39, 6, 1, NULL, NULL, 11)
 Go
INSERT [dbo].[ConfigLookup] ([ConfigLookupCode], [Name], [Arabic_Name], [ConfigKey]) VALUES (77, N'Vacation Due', N'Vacation Due', N'WFVacationBalanceSource')
INSERT [dbo].[ConfigLookup] ([ConfigLookupCode], [Name], [Arabic_Name], [ConfigKey]) VALUES (78, N'Vacations Balances', N'Vacations Balances', N'WFVacationBalanceSource')
Go
 ---------------------Hammad 2021-04-13---------------------
 ---------------------Ali 2021-04-13---------------------
CREATE TABLE [dbo].[WF_NewEmployeesType](
	[NewEmployeeTypeCode] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](150) NOT NULL,
	[Arabic_Name] [nvarchar](150) NOT NULL,
	[CreatedBy] [int] NOT NULL,
	[CreationDate] [datetime] NOT NULL,
	[ModifiedBy] [int] NULL,
	[ModificationDate] [datetime] NULL,
 CONSTRAINT [PK_WF_NewEmployeesType] PRIMARY KEY CLUSTERED 
(
	[NewEmployeeTypeCode] 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

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(491,N'New Employees Types',N'انواع التوظيف',28,N'/WorkFlow/NewEmployeeType',N'Index','fa fa-thumb-tack',N'get',27,1,1)
Go

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


INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15027,N'انواع التوظيف',N'New Employees Types',491,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15028,N'عرض انواع التوظيف',N'View New Employees Types',491,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15029,N'إضافة انواع التوظيف',N'Add New Employees Types',491,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15030,N'تعديل انواع التوظيف',N'Edit New Employees Types',491,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15031,N'حذف انواع التوظيف',N'Delete New Employees Types',491,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15032,N'حفظ انواع التوظيف',N'Save New Employees Types',491,2)
Go

 INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'WFShowDayRestShift',N'Day Rest Shift',N'وردية يوم الراحة',N'0',2,3,1,1,Null,Null,21)
Go
 ---------------------End 2021-04-13---------------------
 ---------------------Hammad 2021-04-14---------------------
 ALTER TABLE dbo.VacationType ADD
	HiringFromMonths float(53) NULL,
	GenderTypeCode int NULL,
	RepeatVacationTypeCode int NULL
GO

 ---------------------End 2021-04-14---------------------
 ---------------------Sayed 2021-04-14-------------------
  alter table VacationType
  add [TheMinimumNumberOfDaysAtATime] float null,
   [TheMaximumNumberOfDaysAtATime] float null,
   [BonusEffect] bit null
   GO
--------------------End 2021-04-14------------------------
--------------------------AK 2021-04-14--------------------------------
INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'AzureWorked',N'Azure Worked',N'يعمل بــ Azure',N'false',1,16,1,1,Null,Null,Null)
Go
 --------------------------End 2021-04-14--------------------------------
--------------------------Ali 2021-04-15--------------------------------
   update SystemMenu set 
  [Name]=N'Employees Archive',[Arabic_Name]=N'ارشيف الموظفين',
  [ParentID] = NULL,
  [Sequence]=20
  where [SystemMenuCode]=489
--------------------------Ali 2021-04-15--------------------------------
--------------------------Hammad 2021-04-18-----------------------------
ALTER TABLE dbo.WF_ChangeDayoffRequest ADD
	NewRestDate datetime NULL,
	NewRestDateHijri nvarchar(10) NULL
GO

delete ConfigParameter where ConfigKey='WFShowDayRestShift'
Go

update ConfigParameter set RequestTypeId=0 ,OrderNo=8   where ConfigKey='WFCheckDayOffDependOn'
GO
--------------------------End 2021-04-18-----------------------------
--------------------------AK 2021-04-18--------------------------------
INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'AppPath',N'App Path',N'مسار البرنامج',N'D:\_Code\SST.ERP\ERPMaster\ERPWeb',1,17,1,0,Null,Null,Null)
Go
 --------------------------End 2021-04-18--------------------------------


 --------------------------Ali 2021-04-18--------------------------------

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(494,N'Inventory Requests',N'طلبات المخازن',29,N'',N'','fa fa-thumb-tack',N'',45,1,1)
Go
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(494,1)
Go

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(495,N'Recruit Requests',N'طلبات التوظيف',29,N'',N'','fa fa-thumb-tack',N'',46,1,1)
Go
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(495,1)
Go

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(496,N'Administrative requests',N'الطلبات الادارية',29,N'',N'','fa fa-thumb-tack',N'',47,1,1)
Go
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(496,1)
Go

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(497,N'Financial requests',N'الطلبات المالية',29,N'',N'','fa fa-thumb-tack',N'',48,1,1)
Go
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(497,1)
Go

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(498,N'Attendance requests',N'طلبات الحضور والإنصراف',29,N'',N'','fa fa-thumb-tack',N'',49,1,1)
Go
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(498,1)
Go

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(499,N'Inventory Requests Signatures',N'اعتماد طلبات المخازن',108,N'',N'','fa fa-thumb-tack',N'',48,1,1)
Go
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(499,1)
Go

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(500,N'Recruit Requests Signatures',N'اعتماد طلبات التوظيف',108,N'',N'','fa fa-thumb-tack',N'',49,1,1)
Go
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(500,1)
Go

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(501,N'Administrative Requests Signatures',N'اعتماد الطلبات الادارية',108,N'',N'','fa fa-thumb-tack',N'',50,1,1)
Go
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(501,1)
Go

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(502,N'Financial Requests Signatures',N'اعتماد الطلبات المالية',108,N'',N'','fa fa-thumb-tack',N'',51,1,1)
Go
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(502,1)
Go

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(503,N'Attendance Requests Signatures',N'اعتماد طلبات الحضور والإنصراف',108,N'',N'','fa fa-thumb-tack',N'',52,1,1)
Go
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(503,1)
Go



   INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15048, N'طلبات المخازن', N'Inventory Requests', 494, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15049, N'طلبات التوظيف', N'Recruit Requests', 495, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15050, N'الطلبات الادارية', N'Administrative requests', 496, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15051, N'الطلبات المالية', N'Financial requests', 497, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15052, N'طلبات الحضور والإنصراف', N'Attendance requests', 498, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15053, N'اعتماد طلبات المخازن', N'Inventory Requests Signatures', 499, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15054, N'اعتماد طلبات التوظيف', N'Recruit Requests Signatures', 500, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15055, N'اعتماد الطلبات الادارية', N'Administrative Requests Signatures', 501, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15056, N'اعتماد الطلبات المالية', N'Financial Requests Signatures', 502, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15057, N'اعتماد طلبات الحضور والإنصراف', N'Attendance Requests Signatures', 503, 1)
Go

--Purchases Request
update SystemMenu 
  set ParentID =494 , Sequence =1
  where SystemMenuCode=226
  Go
  
    update SystemMenu 
  set ParentID =499 , Sequence =1
  where SystemMenuCode=227
   Go
--Requisition Form Request
  update SystemMenu 
  set ParentID =494 , Sequence =2
  where SystemMenuCode=330
  Go
  
    update SystemMenu 
  set ParentID =499 , Sequence =2
  where SystemMenuCode=331
   Go

   --Store Request
  update SystemMenu 
  set ParentID =494 , Sequence =3
  where SystemMenuCode=381
  Go
  
    update SystemMenu 
  set ParentID =499 , Sequence =3
  where SystemMenuCode=382
   Go

   --New Hire Request
   
  update SystemMenu 
  set ParentID =495 , Sequence =1
  where SystemMenuCode=71
  Go
  
    update SystemMenu 
  set ParentID =500 , Sequence =1
  where SystemMenuCode=72
   Go

   ----- Transfer Employee Request
     update SystemMenu 
  set ParentID =495 , Sequence =2
  where SystemMenuCode=335
  Go
  
    update SystemMenu 
  set ParentID =500 , Sequence =2
  where SystemMenuCode=336
   Go
   ---New Job Request
   
  update SystemMenu 
  set ParentID =495 , Sequence =3
  where SystemMenuCode=237
  Go
    update SystemMenu 
  set ParentID =500 , Sequence =3
  where SystemMenuCode=238
   Go

   ----New Employees Request
    update SystemMenu 
  set ParentID =495 , Sequence =4
  where SystemMenuCode=138
  Go
    update SystemMenu 
  set ParentID =500 , Sequence =4
  where SystemMenuCode=139
   Go

   ---Casual Request
     update SystemMenu 
  set ParentID =495 , Sequence =5
  where SystemMenuCode=82
  Go
    update SystemMenu 
  set ParentID =500 , Sequence =5
  where SystemMenuCode=83
   Go

   ----Air Ticket Request
    update SystemMenu 
  set ParentID =496 , Sequence =1
  where SystemMenuCode=66
  Go
    update SystemMenu 
  set ParentID =501 , Sequence =1
  where SystemMenuCode=67
   Go

   ---Resignation Request
    update SystemMenu 
  set ParentID =496 , Sequence =2
  where SystemMenuCode=80
  Go
    update SystemMenu 
  set ParentID =501 , Sequence =2
  where SystemMenuCode=81
   Go

   --- Over Time Symphony Request
    update SystemMenu 
  set ParentID =496 , Sequence =3
  where SystemMenuCode=140
  Go
    update SystemMenu 
  set ParentID =501 , Sequence =3
  where SystemMenuCode=141
   Go
   --Over Time Request
     update SystemMenu 
  set ParentID =496 , Sequence =4
  where SystemMenuCode=64
  Go
    update SystemMenu 
  set ParentID =501 , Sequence =4
  where SystemMenuCode=65
   Go
       update SystemMenu 
  set ParentID =501 , Sequence =5
  where SystemMenuCode=222
   Go

   --Maintenance Request
     update SystemMenu 
  set ParentID =496 , Sequence =5
  where SystemMenuCode=113
  Go
    update SystemMenu 
  set ParentID =501 , Sequence =6
  where SystemMenuCode=114
   Go

   -----Penalty Request
     update SystemMenu 
  set ParentID =496 , Sequence =6
  where SystemMenuCode=124
  Go
    update SystemMenu 
  set ParentID =501 , Sequence =7
  where SystemMenuCode=126
   Go
   -----Vehicle Request
     update SystemMenu 
  set ParentID =496 , Sequence =7
  where SystemMenuCode=146
  Go
    update SystemMenu 
  set ParentID =501 , Sequence =8
  where SystemMenuCode=147
   Go
-----General Request
update SystemMenu 
  set ParentID =496 , Sequence =8
  where SystemMenuCode=197
  Go
    update SystemMenu 
  set ParentID =501 , Sequence =9
  where SystemMenuCode=198
   Go
   ----Residence Request
    update SystemMenu 
  set ParentID =496 , Sequence =9
  where SystemMenuCode=392
  Go
    update SystemMenu 
  set ParentID =501 , Sequence =10
  where SystemMenuCode=393
   Go


   update SystemMenu 
  set ParentID =496 , Sequence =10
  where SystemMenuCode=394
  Go

  ----Loan Request
    update SystemMenu 
  set ParentID =497 , Sequence =1
  where SystemMenuCode=84
  Go
    update SystemMenu 
  set ParentID =502 , Sequence =1
  where SystemMenuCode=85
   Go
  --Promotion Request
    update SystemMenu 
  set ParentID =497 , Sequence =2
  where SystemMenuCode=89
  Go
    update SystemMenu 
  set ParentID =502 , Sequence =2
  where SystemMenuCode=90
   Go

   -----Bonus Request
  update SystemMenu 
  set ParentID =497 , Sequence =3
  where SystemMenuCode=144
  Go
    update SystemMenu 
  set ParentID =502 , Sequence =3
  where SystemMenuCode=145
   Go
   ----Monthly Effects Request
    
  update SystemMenu 
  set ParentID =497 , Sequence =4
  where SystemMenuCode=239
  Go
    update SystemMenu 
  set ParentID =502 , Sequence =4
  where SystemMenuCode=240
   Go
   ----- Financial Payment Employee Hr Request
     
  update SystemMenu 
  set ParentID =497 , Sequence =5
  where SystemMenuCode=399
  Go
    update SystemMenu 
  set ParentID =502 , Sequence =5
  where SystemMenuCode=400
   Go

   ----Financial Payment Employee  Request
  update SystemMenu 
  set ParentID =497 , Sequence =6
  where SystemMenuCode=396
  Go
    update SystemMenu 
  set ParentID =502 , Sequence =6
  where SystemMenuCode=397
   Go
   ---Vacation Request
     update SystemMenu 
  set ParentID =498 , Sequence =1
  where SystemMenuCode=91
  Go
    update SystemMenu 
  set ParentID =503 , Sequence =1
  where SystemMenuCode=45
   Go

    update SystemMenu 
  set ParentID =503 , Sequence =2
  where SystemMenuCode=92
   Go
   --Permission Request
   update SystemMenu 
  set ParentID =498 , Sequence =2
  where SystemMenuCode=36
  Go
    update SystemMenu 
  set ParentID =503 , Sequence =3
  where SystemMenuCode=37
   Go

   --Finger Print Request
    
  update SystemMenu 
  set ParentID =498 , Sequence =3
  where SystemMenuCode=69
  Go
    update SystemMenu 
  set ParentID =503 , Sequence =4
  where SystemMenuCode=70
   Go
   ---Change Dayoff Request
    update SystemMenu 
  set ParentID =498 , Sequence =4
  where SystemMenuCode=173
  Go
    update SystemMenu 
  set ParentID =503 , Sequence =5
  where SystemMenuCode=174
   Go
   
   ---Compensation Request For A Day Of Rest
     
  update SystemMenu 
  set ParentID =498 , Sequence =5
  where SystemMenuCode=220
  Go
    update SystemMenu 
  set ParentID =503 , Sequence =6
  where SystemMenuCode=221
   Go
   
      update SystemMenu 
  set ParentID =503 , Sequence =7
  where SystemMenuCode=223
   Go

---   Disclaimer Request Signature
update SystemMenu 
  set ParentID =501 , Sequence =11
  where SystemMenuCode=148
   Go


   

CREATE TABLE [dbo].[WF_EmployeeDataType](
	[EmployeeDataTypeCode] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](150) NOT NULL,
	[Arabic_Name] [nvarchar](150) NOT NULL,
	[ColumnName] [nvarchar](100) NOT NULL,
	[DataType] [tinyint] NOT NULL,
	[ControllerName] [nvarchar](100) NULL,
	[ActionName] [nvarchar](100) NULL,
	[IsFromEmployeeExtend] [bit] NOT NULL,
	[DataValueField] [nvarchar](50) NULL,
	[DataTextFieldEn] [nvarchar](50) NULL,
	[DataTextFieldAr] [nvarchar](50) NULL,
 CONSTRAINT [PK_WF_EmployeeDataType] PRIMARY KEY CLUSTERED 
(
	[EmployeeDataTypeCode] 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
SET IDENTITY_INSERT [dbo].[WF_EmployeeDataType] ON 

INSERT [dbo].[WF_EmployeeDataType] ([EmployeeDataTypeCode], [Name], [Arabic_Name], [ColumnName], [DataType], [ControllerName], [ActionName], [IsFromEmployeeExtend], [DataValueField], [DataTextFieldEn], [DataTextFieldAr]) VALUES (1, N'Birth Date', N'تاريخ الميلاد', N'BirthDate', 5, NULL, NULL, 0, NULL, NULL, NULL)
INSERT [dbo].[WF_EmployeeDataType] ([EmployeeDataTypeCode], [Name], [Arabic_Name], [ColumnName], [DataType], [ControllerName], [ActionName], [IsFromEmployeeExtend], [DataValueField], [DataTextFieldEn], [DataTextFieldAr]) VALUES (2, N'Bank Code', N'كود البنك', N'BankCode', 6, N'/Common', N'GetBank', 0, N'BankCode', N'Name', N'Arabic_Name')
INSERT [dbo].[WF_EmployeeDataType] ([EmployeeDataTypeCode], [Name], [Arabic_Name], [ColumnName], [DataType], [ControllerName], [ActionName], [IsFromEmployeeExtend], [DataValueField], [DataTextFieldEn], [DataTextFieldAr]) VALUES (3, N'Full Address  Ar', N'العنوان بالعربى', N'ArabicFullAddress', 4, NULL, NULL, 0, NULL, NULL, NULL)
INSERT [dbo].[WF_EmployeeDataType] ([EmployeeDataTypeCode], [Name], [Arabic_Name], [ColumnName], [DataType], [ControllerName], [ActionName], [IsFromEmployeeExtend], [DataValueField], [DataTextFieldEn], [DataTextFieldAr]) VALUES (4, N'Full Address En', N'العنوان بالانجليزى', N'EngFullAddress', 4, NULL, NULL, 0, NULL, NULL, NULL)
INSERT [dbo].[WF_EmployeeDataType] ([EmployeeDataTypeCode], [Name], [Arabic_Name], [ColumnName], [DataType], [ControllerName], [ActionName], [IsFromEmployeeExtend], [DataValueField], [DataTextFieldEn], [DataTextFieldAr]) VALUES (5, N'EMail', N'البريد الالكترونى', N'EMail', 4, NULL, NULL, 0, NULL, NULL, NULL)
INSERT [dbo].[WF_EmployeeDataType] ([EmployeeDataTypeCode], [Name], [Arabic_Name], [ColumnName], [DataType], [ControllerName], [ActionName], [IsFromEmployeeExtend], [DataValueField], [DataTextFieldEn], [DataTextFieldAr]) VALUES (6, N'Mobile ', N'رقم الموبايل', N'Mobile', 4, NULL, NULL, 0, NULL, NULL, NULL)
INSERT [dbo].[WF_EmployeeDataType] ([EmployeeDataTypeCode], [Name], [Arabic_Name], [ColumnName], [DataType], [ControllerName], [ActionName], [IsFromEmployeeExtend], [DataValueField], [DataTextFieldEn], [DataTextFieldAr]) VALUES (7, N'Marital Status', N'الحالة الاجتماعية', N'MaritalCode', 6, N'/Common', N'GetMaritalStatus', 0, N'MaritalCode', N'Name', N'Arabic_Name')
INSERT [dbo].[WF_EmployeeDataType] ([EmployeeDataTypeCode], [Name], [Arabic_Name], [ColumnName], [DataType], [ControllerName], [ActionName], [IsFromEmployeeExtend], [DataValueField], [DataTextFieldEn], [DataTextFieldAr]) VALUES (8, N'Extension ', N'رقم التحويلة', N'ExtensionNumber', 4, NULL, NULL, 1, NULL, NULL, NULL)
SET IDENTITY_INSERT [dbo].[WF_EmployeeDataType] OFF







CREATE TABLE [dbo].[WF_ChangeEmployeeDataRequest](
	[ChangeEmployeeDataCode] [int] IDENTITY(1,1) NOT NULL,
	[EmployeeDataTypeCode] [int] NOT NULL,
	[MasterRequestCode] [int] NOT NULL,
	[NewValue] [nvarchar](100) NULL,
 CONSTRAINT [PK_WF_ChangeEmployeeDataRequest] PRIMARY KEY CLUSTERED 
(
	[ChangeEmployeeDataCode] 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_ChangeEmployeeDataRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_ChangeEmployeeDataRequest_WF_ChangeEmployeeDataRequest] FOREIGN KEY([MasterRequestCode])
REFERENCES [dbo].[WF_MasterRequests] ([MasterRequestCode])
GO

ALTER TABLE [dbo].[WF_ChangeEmployeeDataRequest] CHECK CONSTRAINT [FK_WF_ChangeEmployeeDataRequest_WF_ChangeEmployeeDataRequest]
GO

ALTER TABLE [dbo].[WF_ChangeEmployeeDataRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_ChangeEmployeeDataRequest_WF_EmployeeDataType] FOREIGN KEY([EmployeeDataTypeCode])
REFERENCES [dbo].[WF_EmployeeDataType] ([EmployeeDataTypeCode])
GO

ALTER TABLE [dbo].[WF_ChangeEmployeeDataRequest] CHECK CONSTRAINT [FK_WF_ChangeEmployeeDataRequest_WF_EmployeeDataType]
GO




INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(492,N'Change Employee Data Request',N'طلب تغيير بيانات الموظف',496,N'/WorkFlow/ChangeEmployeeDataRequest',N'Index','fa fa-thumb-tack',N'get',11,1,1)
Go

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

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15033,N'طلب تغيير بيانات الموظف',N'Change Employee Data Request',492,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15034,N'عرض طلب تغيير بيانات الموظف',N'View Change Employee Data Request',492,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15035,N'إضافة طلب تغيير بيانات الموظف',N'Add Change Employee Data Request',492,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15036,N'تعديل طلب تغيير بيانات الموظف',N'Edit Change Employee Data Request',492,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15037,N'حذف طلب تغيير بيانات الموظف',N'Delete Change Employee Data Request',492,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15038,N'حفظ طلب تغيير بيانات الموظف',N'Save Change Employee Data Request',492,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15047,N'الغاء طلب تغيير بيانات الموظف',N'Cancel Change Employee Data Request',492,2)

Go

-- RequestType sqript run it if you want ( by default not Automatic run )

INSERT[dbo].[WF_RequestType]([RequestTypeId], [RequestTypeName], [RequestTypeNameEn], [IsEditable], [SenderUserName], [SenderFrom], [SenderPassword], [SenderHostName], [SenderPort], [SenderName], [SubmitBeforRequestDate], [SubmitAfterRequestDate], [IsUsed], [CanDelegation], [DisplayUserName], [HaveAttachment]) VALUES(42,N'طلب تغيير بيانات الموظف',N'Change Employee Data 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
-- EmailTemplateType sqript run it if you want ( by default not Automatic run )
SET IDENTITY_INSERT[dbo].[EmailTemplateType] ON
INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode]) VALUES(216,N'Change Employee Data Request Sending',N'ارسال طلب تغيير بيانات الموظف',0,1)

INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode]) VALUES(217,N'Change Employee Data Request Accept',N'الموافقة على طلب تغيير بيانات الموظف',0,1)

INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode]) VALUES(218,N'Change Employee Data Request Refuse',N'رفض طلب تغيير بيانات الموظف',0,1)

INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode]) VALUES(219,N'Change Employee Data Request Cancel',N'الغاء طلب تغيير بيانات الموظف',0,1)
SET IDENTITY_INSERT [dbo].[EmailTemplateType] OFF
-- EmailTemplate sqript run it if you want ( by default not Automatic run )
SET IDENTITY_INSERT [dbo].[EmailTemplate] ON 
INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(216,N'Change Employee Data Request Sending',N'ارسال طلب تغيير بيانات الموظف',216,N'ارسال',N'ارسال',1,NULL)

INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(217,N'Change Employee Data Request Accept',N'الموافقة على طلب تغيير بيانات الموظف',217,N'الموافقة على',N'الموافقة على',1,NULL)

INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(218,N'Change Employee Data Request Refuse',N'رفض طلب تغيير بيانات الموظف',218,N'رفض',N'رفض',1,NULL)

INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(219,N'Change Employee Data Request Cancel',N'الغاء طلب تغيير بيانات الموظف',219,N'الغاء',N'الغاء',1,NULL)
SET IDENTITY_INSERT [dbo].[EmailTemplate] OFF


---------------------
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(493,N'Change Employee Data Request Signature',N'اعتماد طلب تغيير بيانات الموظف',501,N'/WorkFlow/ChangeEmployeeDataRequestSignature',N'Index','fa fa-thumb-tack',N'get',12,1,1)
Go

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

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15039,N'اعتماد طلب تغيير بيانات الموظف',N'Change Employee Data Request Signature',493,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15040,N'عرض اعتماد طلب تغيير بيانات الموظف',N'View Change Employee Data Request Signature',493,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15041,N'تعديل اعتماد طلب تغيير بيانات الموظف',N'Edit Change Employee Data Request Signature',493,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15042,N'حفظ اعتماد طلب تغيير بيانات الموظف',N'Save Change Employee Data Request Signature',493,2)

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

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15044,N'عرض سجل الموظف',N'View Employee History',493,2)

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

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

Go
 --------------------------End 2021-04-18--------------------------------
 --------------------------Hammad 2021-04-18----------------------------

DECLARE @SecurityGroupCode int

DECLARE SecurityGroupCursor CURSOR FOR  
SELECT SecurityGroupCode  from SecurityGroup 

OPEN SecurityGroupCursor  

FETCH NEXT FROM SecurityGroupCursor INTO @SecurityGroupCode  
WHILE @@FETCH_STATUS = 0  
BEGIN    

insert into SecurityGroupDetail ([SecurityGroupID]  ,[PrivilegeID]) values(@SecurityGroupCode,15048)
insert into SecurityGroupDetail ([SecurityGroupID]  ,[PrivilegeID]) values(@SecurityGroupCode,15049)
insert into SecurityGroupDetail ([SecurityGroupID]  ,[PrivilegeID]) values(@SecurityGroupCode,15050)
insert into SecurityGroupDetail ([SecurityGroupID]  ,[PrivilegeID]) values(@SecurityGroupCode,15051)
insert into SecurityGroupDetail ([SecurityGroupID]  ,[PrivilegeID]) values(@SecurityGroupCode,15052)
insert into SecurityGroupDetail ([SecurityGroupID]  ,[PrivilegeID]) values(@SecurityGroupCode,15053)
insert into SecurityGroupDetail ([SecurityGroupID]  ,[PrivilegeID]) values(@SecurityGroupCode,15054)
insert into SecurityGroupDetail ([SecurityGroupID]  ,[PrivilegeID]) values(@SecurityGroupCode,15055)
insert into SecurityGroupDetail ([SecurityGroupID]  ,[PrivilegeID]) values(@SecurityGroupCode,15056)
insert into SecurityGroupDetail ([SecurityGroupID]  ,[PrivilegeID]) values(@SecurityGroupCode,15057)

   
FETCH NEXT FROM SecurityGroupCursor INTO @SecurityGroupCode 
END  
CLOSE SecurityGroupCursor   
DEALLOCATE SecurityGroupCursor 
go

 --------------------------End 2021-04-18----------------------------
 --------------------------Sayed 2021-04-19--------------------------
  INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'WFStopSalary',N'Stop Salary',N'ايقاف المرتب',N'true',2,5,1,1,Null,Null,7)
Go
---------------------------End 2021-04-18----------------------------
---------------------------Hammad 2021-04-18-------------------------
ALTER TABLE dbo.Org4 ADD
	ManagerCode int NULL
GO
ALTER TABLE dbo.Org5 ADD
	ManagerCode int NULL
GO
ALTER TABLE dbo.Org6 ADD
	ManagerCode int NULL
GO
ALTER TABLE dbo.Org7 ADD
	ManagerCode int NULL
GO
ALTER TABLE dbo.Org8 ADD
	ManagerCode int NULL
GO
ALTER TABLE dbo.Org9 ADD
	ManagerCode int NULL
GO

INSERT [dbo].[UserType] ([UserTypeCode], [Name], [Arabic_Name], [HaveEmployee], [OrganizationCategoryCode]) VALUES (30, N'Org4', N'هيكل 4', 1, NULL)
INSERT [dbo].[UserType] ([UserTypeCode], [Name], [Arabic_Name], [HaveEmployee], [OrganizationCategoryCode]) VALUES (31, N'Org5', N'هيكل 5', 1, NULL)
INSERT [dbo].[UserType] ([UserTypeCode], [Name], [Arabic_Name], [HaveEmployee], [OrganizationCategoryCode]) VALUES (32, N'Org6', N'هيكل6 ', 1, NULL)
INSERT [dbo].[UserType] ([UserTypeCode], [Name], [Arabic_Name], [HaveEmployee], [OrganizationCategoryCode]) VALUES (33, N'Org7', N'هيكل7 ', 1, NULL)
INSERT [dbo].[UserType] ([UserTypeCode], [Name], [Arabic_Name], [HaveEmployee], [OrganizationCategoryCode]) VALUES (34, N'Org8', N'هيكل8 ', 1, NULL)
INSERT [dbo].[UserType] ([UserTypeCode], [Name], [Arabic_Name], [HaveEmployee], [OrganizationCategoryCode]) VALUES (35, N'Org9', N'هيكل9 ', 1, NULL)
Go

---------------------------End 2021-04-18-------------------------