﻿
-------------------------------------Negm 2024-04-02 --------------------


INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) 
VALUES(1768,N'WorkFlow',N'PermissionRequestApi',N'Index',0,N'get',3032)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) 
VALUES(1769,N'WorkFlow',N'PermissionRequestApi',N'PermissionRequest_Read',0,N'post',3038)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1770,N'WorkFlow',N'PermissionRequestApi',N'Save',1,N'get',3033)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1771,N'WorkFlow',N'PermissionRequestApi',N'Save',2,N'get',3034)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1772,N'WorkFlow',N'PermissionRequestApi',N'Delete',0,N'post',3035)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) 
VALUES(1773,N'WorkFlow',N'PermissionRequestApi',N'Save',0,N'post',3037)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1774,N'WorkFlow',N'PermissionRequestApi',N'Cancel',0,N'post',3036)
Go


INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1775,N'WorkFlow',N'PermissionRequestSignatureApi',N'Index',0,N'get',3039)
GO

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) 
VALUES(1776,N'WorkFlow',N'PermissionRequestSignatureApi',N'PermissionRequest_Read',0,N'post',3040)
GO

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) 
VALUES(1777,N'WorkFlow',N'PermissionRequestSignatureApi',N'Save',2,N'get',3041)
GO

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1778,N'WorkFlow',N'PermissionRequestSignatureApi',N'Save',0,N'post',3042)
GO

-------------------------------End 2024-04-02 -----------------------------------------

----------------------------------------M.Negm 2024-04-03 ------------------------------

   INSERT INTO LabelsName  (LabelKey, Name, Arabic_Name ) values( N'Projects' ,N'Projects', N'المشروعات ')
   GO
  Alter Table Wf_NewHireRequest add  ProjectCode int null 
  GO
  --------------------------------------END 2024-04-03 -------------------------------------
  --------------------------------------Hammad 2024-04-04 -----------------------------------
  INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType])
VALUES (15467, N'تقديم طلب عقد مؤقت لكل الموظفين', N'Add Assignment Request For All Employee', 1009, 2)
GO
  --------------------------------------End 2024-04-04 -----------------------------------

  ----------------------------------------M.Negm 2024-04-04 ------------------------------

 INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId], [ConfigDescription]) 
VALUES (N'WfNewHireCanViewLocalAmount', N' Can View Local Amount', N'إظهار العملة المحلية', N'true', 2, 34, 1, 1, NULL, NULL, 5, N'إظهار العملة المحلية ')
Go

  --------------------------------------END 2024-04-04 -------------------------------------

    ----------------------------------------M.Negm 2024-04-04 ------------------------------

update LabelsName set Name=N'Project'   where LabelKey =N'Projects'
Go
update LabelsName set Arabic_Name=N'المشروع'   where LabelKey =N'Projects'
Go

INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId], [ConfigDescription]) 
VALUES (N'WfNewHireCanViewProject', N' Can View Project', N'إظهار المشروع ', N'false', 2, 35, 1, 1, NULL, NULL, 5, N'إظهار المشروع ')
Go
  --------------------------------------END 2024-04-04 -------------------------------------
  --------------------------------------Motafa 2024-04-04 -------------------------------------

   INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId],[ConfigDescription])
VALUES(N'Wf_FingerprintMaximumRequestPeDay',N'Maximum Request Per day',N'الحد الاقصي لتقديم طلب بصمة في اليوم',N'0',2,2,2,1,Null,Null,6,N'عدد طلبات نسيان بصمة في اليوم')
Go
  --------------------------------------END 2024-04-04 -------------------------------------
  --------------------------------------Hammad 2024-04-07 -------------------------------------
ALTER TABLE dbo.WF_NewHireRequest ADD
	HomeInstitution nvarchar(100) NULL,
	DeanName nvarchar(100) NULL,
	NumberOfMandateDays int NULL,
	FacultyName nvarchar(100) NULL,
	FacultyNameAr nvarchar(100) NULL
GO

--------------------------------------End 2024-04-07 -------------------------------------
--------------------------------------Hammad 2024-04-08 -------------------------------------

BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION

ALTER TABLE dbo.Contract
	DROP CONSTRAINT DF_Contract_ContractCode

ALTER TABLE dbo.Contract
	DROP CONSTRAINT DF_Contract_ShowInAssignmentRequest

ALTER TABLE dbo.Contract
	DROP CONSTRAINT DF_Contract_Period

CREATE TABLE dbo.Tmp_Contract
	(
	ContractCode tinyint NOT NULL IDENTITY (0, 1),
	Name nvarchar(1000) NULL,
	Arabic_Name nvarchar(1000) NULL,
	Period tinyint NULL,
	Probation float(53) NULL,
	ProbationDurationByDays int NULL,
	WDName nvarchar(200) NULL,
	FixedTerm bit NULL,
	Closed bit NULL,
	ContractGroupCode int NULL,
	MappingCode int NULL,
	ShowInAssignmentRequest bit NOT NULL,
	PeriodDurationByDays int NULL,
	ManualExpireDate bit NULL,
	CentralCode int NULL,
	DropDayoffAndHolidays bit NULL,
	SalaryPayWayCode int NULL,
	DropDayoff bit NULL,
	DropHolidays bit NULL,
	CreationDate datetime NULL,
	CreatedBy int NULL,
	ModifiedBy int NULL,
	ModificationDate datetime NULL,
	Serial tinyint NULL
	)  ON [PRIMARY]

ALTER TABLE dbo.Tmp_Contract SET (LOCK_ESCALATION = TABLE)

ALTER TABLE dbo.Tmp_Contract ADD CONSTRAINT
	DF_Contract_Period DEFAULT ((0)) FOR Period

ALTER TABLE dbo.Tmp_Contract ADD CONSTRAINT
	DF_Contract_FixedTerm DEFAULT ((0)) FOR FixedTerm

ALTER TABLE dbo.Tmp_Contract ADD CONSTRAINT
	DF_Contract_Closed DEFAULT ((0)) FOR Closed

ALTER TABLE dbo.Tmp_Contract ADD CONSTRAINT
	DF_Contract_ShowInAssignmentRequest DEFAULT ((0)) FOR ShowInAssignmentRequest

ALTER TABLE dbo.Tmp_Contract ADD CONSTRAINT
	DF_Contract_ManualExpireDate DEFAULT ((0)) FOR ManualExpireDate

ALTER TABLE dbo.Tmp_Contract ADD CONSTRAINT
	DF_Contract_DropDayoffAndHolidays DEFAULT ((0)) FOR DropDayoffAndHolidays

ALTER TABLE dbo.Tmp_Contract ADD CONSTRAINT
	DF_Contract_DropDayoff DEFAULT ((0)) FOR DropDayoff

ALTER TABLE dbo.Tmp_Contract ADD CONSTRAINT
	DF_Contract_DropHolidays DEFAULT ((0)) FOR DropHolidays

SET IDENTITY_INSERT dbo.Tmp_Contract ON

IF EXISTS(SELECT * FROM dbo.Contract)
	 EXEC('INSERT INTO dbo.Tmp_Contract (ContractCode, Name, Arabic_Name, Period, Probation, ProbationDurationByDays, WDName, FixedTerm, Closed, ContractGroupCode, MappingCode, ShowInAssignmentRequest)
		SELECT ContractCode, Name, Arabic_Name, Period, Probation, ProbationDurationByDays, WDName, FixedTerm, Closed, ContractGroupCode, MappingCode, ShowInAssignmentRequest FROM dbo.Contract WITH (HOLDLOCK TABLOCKX)')

SET IDENTITY_INSERT dbo.Tmp_Contract OFF

ALTER TABLE dbo.Rec_RecruitJob
	DROP CONSTRAINT FK_Rec_RecruitJob_Contract

ALTER TABLE dbo.WF_AssignmentRequests
	DROP CONSTRAINT FK_AssignmentRequest_Contract

ALTER TABLE dbo.WF_RenewContractRequests
	DROP CONSTRAINT FK_RenewContractRequest_Contract

DROP TABLE dbo.Contract

EXECUTE sp_rename N'dbo.Tmp_Contract', N'Contract', 'OBJECT' 

ALTER TABLE dbo.Contract ADD CONSTRAINT
	PK_Contract PRIMARY KEY CLUSTERED 
	(
	ContractCode
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]


COMMIT
BEGIN TRANSACTION

ALTER TABLE dbo.WF_RenewContractRequests ADD CONSTRAINT
	FK_RenewContractRequest_Contract FOREIGN KEY
	(
	ContractCode
	) REFERENCES dbo.Contract
	(
	ContractCode
	) ON UPDATE  NO ACTION 
	 ON DELETE  CASCADE 
	

ALTER TABLE dbo.WF_RenewContractRequests SET (LOCK_ESCALATION = TABLE)

COMMIT
BEGIN TRANSACTION

ALTER TABLE dbo.WF_AssignmentRequests ADD CONSTRAINT
	FK_AssignmentRequest_Contract FOREIGN KEY
	(
	SubContractCode
	) REFERENCES dbo.Contract
	(
	ContractCode
	) ON UPDATE  NO ACTION 
	 ON DELETE  CASCADE 
	

ALTER TABLE dbo.WF_AssignmentRequests SET (LOCK_ESCALATION = TABLE)

COMMIT
BEGIN TRANSACTION

ALTER TABLE dbo.Rec_RecruitJob ADD CONSTRAINT
	FK_Rec_RecruitJob_Contract FOREIGN KEY
	(
	ContractCode
	) REFERENCES dbo.Contract
	(
	ContractCode
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	

ALTER TABLE dbo.Rec_RecruitJob SET (LOCK_ESCALATION = TABLE)

COMMIT

go
update Contract set Serial=ContractCode
GO
  --------------------------------------End 2024-04-08 -------------------------------------

    --------------------------------------Ali 2024-04-08 -------------------------------------

ALTER TABLE dbo.Contract ADD
	ShowHomeInstitutionInNewHire bit NOT NULL CONSTRAINT DF_Contract_ShowHomeInstitutionInNewHire DEFAULT ((0)),
	ShowDeanNameInNewHire bit NOT NULL CONSTRAINT DF_Contract_ShowDeanNameInNewHire DEFAULT ((0)),
	ShowNumberOfMandateDayInNewHire bit NOT NULL CONSTRAINT DF_Contract_ShowNumberOfMandateDayInNewHire DEFAULT ((0)),
	ShowFacultyInNewHire bit NOT NULL CONSTRAINT DF_Contract_ShowFacultyInNewHire DEFAULT ((0))
GO
  --------------------------------------End 2024-04-08 -------------------------------------
  --------------------------------------Hammad 2024-04-08 -----------------------------------
   
CREATE TABLE [dbo].[ProjectContracts](
	[ProjectContractCode] [int] IDENTITY(1,1) NOT NULL,
	[ProjectCode] [int] NOT NULL,
	[ContractCode] [tinyint] NOT NULL,
 CONSTRAINT [PK__ProjectContracts] PRIMARY KEY CLUSTERED 
(
	[ProjectContractCode] 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].[ProjectContracts]  WITH CHECK ADD  CONSTRAINT [FK_ProjectContracts_Contract] FOREIGN KEY([ContractCode])
REFERENCES [dbo].[Contract] ([ContractCode])
GO

ALTER TABLE [dbo].[ProjectContracts] CHECK CONSTRAINT [FK_ProjectContracts_Contract]
GO

ALTER TABLE [dbo].[ProjectContracts]  WITH CHECK ADD  CONSTRAINT [FK_ProjectContracts_Projects] FOREIGN KEY([ProjectCode])
REFERENCES [dbo].[Projects] ([ProjectCode])
GO

ALTER TABLE [dbo].[ProjectContracts] CHECK CONSTRAINT [FK_ProjectContracts_Projects]
GO

  --------------------------------------End 2024-04-08 -----------------------------------

  --------------------------------------Negm 2024-04-08 -----------------------------------
   INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15474,N'إضافة أنواع عقود المشروع',N'Add Project Contracts',1038,2)
   Go
  --------------------------------------End 2024-04-08 -----------------------------------
 --------------------------------------Hammad 2024-04-08 -----------------------------------
    update contract set CreationDate=GETDATE(),CreatedBy=1
  Go
    --------------------------------------End 2024-04-08 -----------------------------------


