﻿----------------------------Ali 2022-05-23----------------

ALTER TABLE dbo.EmployeesSkills
	DROP CONSTRAINT FK_EmployeesSkills_SkillsTypes
GO

ALTER TABLE dbo.EmployeesSkills ADD CONSTRAINT
	FK_EmployeesSkills_SkillsTypes FOREIGN KEY
	(
	SkillTypeCode
	) REFERENCES dbo.SkillsTypes
	(
	SkillTypeCode
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO
----------------------------End 2022-05-23----------------
----------------------------Hammad 2022-05-24----------------
update SecurityPrivilegeActions set HTTPMethod='get' where SecurityPrivilegeID=23001
Go
update SecurityPrivilegeActions set HTTPMethod='get' where SecurityPrivilegeID=23009
GO
----------------------------End 2022-05-24----------------
----------------------------Hammad 2022-05-25----------------
update SystemMenu set IsVisible=1 , ShowInPrivilegePage=1 where SystemMenuCode=94
Go
----------------------------End 2022-05-25----------------
----------------------------Ali 2022-05-25----------------

 INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'WF_SaveChangeMonthlyEffectsRequest',N'Save Change Monthly Effects Request',N'الاحنفاظ بتغيير بيانات طلب المؤثرات الشهريه',N'false',2,1,1,1,Null,Null,27)
Go
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3994, N'تغيير بيانات طلب مؤثرات شهرية', N'Change Monthly Effects Request Data', 240, 2)
Go


CREATE TABLE [dbo].[WF_MonthlyEffectsHistory](
	[MonthlyEffectsHistoryId] [int] IDENTITY(1,1) NOT NULL,
	[MasterRequestCode] [int] NOT NULL,
	[Amount] [float] NOT NULL,
	[PYEAR] [smallint] NULL,
	[Period] [tinyint] NULL,
	[CostCenter] [nvarchar](150) NULL,
	[ClosingNumber] [tinyint] NULL,
	[CreatedBy] [int] NOT NULL,
	[CreationDate] [datetime] NOT NULL,
 CONSTRAINT [PK_WF_MonthlyEffectsHistory] PRIMARY KEY CLUSTERED 
(
	[MonthlyEffectsHistoryId] 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 2022-05-25----------------
----------------------------Mostafa 2022-05-26----------------
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(626,N'Compensation Allowance Report',N'تقرير بدل التعويض',94,N'/WorkFlow/CompensationAllowanceReport',N'Index','fa fa-thumb-tack',N'get',3,1,1)
Go

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

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15299,N'تقرير بدل التعويض',N'Compensation Allowance Report',626,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15300,N'عرض تقرير بدل التعويض',N'View Compensation Allowance Report',626,2)

----------------------------End 2022-05-26----------------

