﻿---------------------------Hammad 2022-07-17------------------------
Alter table VacationType add 
FixedNumberOfDays float null
Go
Alter table WF_VacationRequest add 
EffectDaysCount float null
Go
Update WF_VacationRequest set EffectDaysCount=DaysCount
Go
---------------------------End 2022-07-17------------------------
---------------------------Ali 2022-07-17------------------------
   INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'Trgt_MaxContributionRateForEachElement',N'Max Contribution Rate For Each Element',N'الحد الاقصى للوزن النسبى لكل عنصر',N'3',10,21,2,1,Null,Null,Null)
Go

 INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'Trgt_MaxTotalContributionRate',N'Max Total Contribution Rate',N'الحد الاقصى لاجمالى الوزن النسبى',N'9',10,22,2,1,Null,Null,Null)
Go

Insert into LabelsName(LabelKey,Name,Arabic_Name) values('position','position',N'الوظيفة')
GO

  INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(10127,N'تخصيص موظفين ',N'Assign Employees',637,2)
Go
---------------------------End 2022-07-17------------------------
---------------------------Mostafa 2022-07-18------------------------

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(639,N'PaySlip Privilege',N'صلاحيات سجل المرتب',7,N'/PaySlipPrivilege',N'Index','fa fa-refresh',N'get',7,1,1)
Go

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

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15304,N'صلاحيات سجل المرتب',N'PaySlip Privilege',639,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15305,N'عرض صلاحيات سجل المرتب',N'View PaySlip Privilege',639,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15309,N'حفظ صلاحيات سجل المرتب',N'Save PaySlip Privilege',639,2)
Go





CREATE TABLE [dbo].[PaySlipPrivilege](
	[PaySlipPrivilegeId] [int] IDENTITY(1,1) NOT NULL,
	[SecurityUserCode] [int] NOT NULL,
	[SalaryTypeCode] [int] NOT NULL,
	[CreatedBy] [int] NOT NULL,
	[CreationDate] [datetime] NOT NULL,
	[ModifyBy] [int] NULL,
	[ModifyDate] [datetime] NULL,
 CONSTRAINT [PK_PaySlipPrivilege] PRIMARY KEY CLUSTERED 
(
	[PaySlipPrivilegeId] 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].[PaySlipPrivilege]  WITH CHECK ADD  CONSTRAINT [FK_PaySlipPrivilege_SecurityUserCode] FOREIGN KEY([SecurityUserCode])
REFERENCES [dbo].[SecurityUser] ([SecurityUserCode])
GO

ALTER TABLE [dbo].[PaySlipPrivilege] CHECK CONSTRAINT [FK_PaySlipPrivilege_SecurityUserCode]
GO

CREATE TABLE [dbo].[PaySlipPrivilegeLevels](
	[PaySlipPrivilegeLevelsId] [int] IDENTITY(1,1) NOT NULL,
	[LevelCode] [tinyint] NOT NULL,
	[PaySlipPrivilegeId] [int] NOT NULL,
 CONSTRAINT [PK_PaySlipPrivilegeLevels] PRIMARY KEY CLUSTERED 
(
	[PaySlipPrivilegeLevelsId] 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].[PaySlipPrivilegeLevels]  WITH CHECK ADD  CONSTRAINT [FK_PaySlipPrivilegeLevels_LevelCode] FOREIGN KEY([LevelCode])
REFERENCES [dbo].[Levels] ([LevelCode])
GO

ALTER TABLE [dbo].[PaySlipPrivilegeLevels] CHECK CONSTRAINT [FK_PaySlipPrivilegeLevels_LevelCode]
GO

ALTER TABLE [dbo].[PaySlipPrivilegeLevels]  WITH CHECK ADD  CONSTRAINT [FK_PaySlipPrivilegeLevels_PaySlipPrivilege] FOREIGN KEY([PaySlipPrivilegeId])
REFERENCES [dbo].[PaySlipPrivilege] ([PaySlipPrivilegeId])
GO

ALTER TABLE [dbo].[PaySlipPrivilegeLevels] CHECK CONSTRAINT [FK_PaySlipPrivilegeLevels_PaySlipPrivilege]
GO


---------------------------End 2022-07-18------------------------
