﻿
--------------------------Ali 2025-03-04--------------------------

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(1159,N'Documents',N'الوثائق',1151,N'',N'','fa fa-thumb-tack',N'',2,1,1)
Go
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(1159,3)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(9075,N'الوثائق',N'Documents',1159,1)
Go


INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(1158,N'Project Documents',N'وثائق المشروع',1159,N'/Archive/ProjectDocument',N'Index','fa fa-thumb-tack',N'get',4,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(1158,3)
Go

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(9069,N'وثائق المشروع',N'Project Documents',1158,1)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(9070,N'عرض وثائق المشروع',N'View Project Documents',1158,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(9071,N'إضافة وثائق المشروع',N'Add Project Documents',1158,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(9072,N'تعديل وثائق المشروع',N'Edit Project Documents',1158,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(9073,N'حذف وثائق المشروع',N'Delete Project Documents',1158,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(9074,N'حفظ وثائق المشروع',N'Save Project Documents',1158,2)
Go

--------------------------End 2025-03-02--------------------------
--------------------------Modtafa 2025-03-05--------------------------
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 FK_Contract_MappingContract

ALTER TABLE dbo.MappingResources SET (LOCK_ESCALATION = TABLE)

COMMIT
BEGIN TRANSACTION

ALTER TABLE dbo.Contract
	DROP CONSTRAINT DF_Contract_ContractCode

ALTER TABLE dbo.Contract
	DROP CONSTRAINT DF_Contract_Period

ALTER TABLE dbo.Contract
	DROP CONSTRAINT DF_Contract_Probation

ALTER TABLE dbo.Contract
	DROP CONSTRAINT DF_Contract_ShowInAssignmentRequest

ALTER TABLE dbo.Contract
	DROP CONSTRAINT DF_Contract_ShowHomeInstitutionInNewHire

ALTER TABLE dbo.Contract
	DROP CONSTRAINT DF_Contract_ShowDeanNameInNewHire

ALTER TABLE dbo.Contract
	DROP CONSTRAINT DF_Contract_ShowNumberOfMandateDayInNewHire

ALTER TABLE dbo.Contract
	DROP CONSTRAINT DF_Contract_ShowFacultyInNewHire

CREATE TABLE dbo.Tmp_Contract
	(
	ContractCode tinyint NOT NULL IDENTITY (1, 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,
	ShowHomeInstitutionInNewHire bit NOT NULL,
	ShowDeanNameInNewHire bit NOT NULL,
	ShowNumberOfMandateDayInNewHire bit NOT NULL,
	ShowFacultyInNewHire bit NULL,
	PeriodDurationByDays int NULL,
	ManualExpireDate bit NULL,
	CentralCode int NULL,
	DropDayoffAndHolidays bit NULL,
	SalaryPayWayCode int NULL,
	DropDayoff bit NULL,
	CreationDate datetime NULL,
	CreatedBy int NULL,
	ModifiedBy int NULL,
	ModificationDate datetime NULL,
	Serial tinyint NULL,
	DropHolidays bit 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_Probation DEFAULT ((0)) FOR Probation

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

ALTER TABLE dbo.Tmp_Contract ADD CONSTRAINT
	DF_Contract_ShowHomeInstitutionInNewHire DEFAULT ((0)) FOR ShowHomeInstitutionInNewHire

ALTER TABLE dbo.Tmp_Contract ADD CONSTRAINT
	DF_Contract_ShowDeanNameInNewHire DEFAULT ((0)) FOR ShowDeanNameInNewHire

ALTER TABLE dbo.Tmp_Contract ADD CONSTRAINT
	DF_Contract_ShowNumberOfMandateDayInNewHire DEFAULT ((0)) FOR ShowNumberOfMandateDayInNewHire

ALTER TABLE dbo.Tmp_Contract ADD CONSTRAINT
	DF_Contract_ShowFacultyInNewHire DEFAULT ((0)) FOR ShowFacultyInNewHire

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_CreationDate DEFAULT (getdate()) FOR CreationDate

ALTER TABLE dbo.Tmp_Contract ADD CONSTRAINT
	DF_Contract_CreatedBy DEFAULT ((1)) FOR CreatedBy

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, ShowHomeInstitutionInNewHire, ShowDeanNameInNewHire, ShowNumberOfMandateDayInNewHire, ShowFacultyInNewHire)
		SELECT ContractCode, Name, Arabic_Name, Period, Probation, ProbationDurationByDays, WDName, FixedTerm, Closed, ContractGroupCode, MappingCode, ShowInAssignmentRequest, ShowHomeInstitutionInNewHire, ShowDeanNameInNewHire, ShowNumberOfMandateDayInNewHire, ShowFacultyInNewHire FROM dbo.Contract WITH (HOLDLOCK TABLOCKX)')

SET IDENTITY_INSERT dbo.Tmp_Contract OFF

ALTER TABLE dbo.ProjectContracts
	DROP CONSTRAINT FK_ProjectContracts_Contract

ALTER TABLE dbo.WF_AssignmentRequests
	DROP CONSTRAINT FK_AssignmentRequest_Contract

ALTER TABLE dbo.Rec_RecruitJob
	DROP CONSTRAINT FK_Rec_RecruitJob_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]


ALTER TABLE dbo.Contract ADD CONSTRAINT
	FK_Contract_MappingContract FOREIGN KEY
	(
	MappingCode
	) REFERENCES dbo.MappingResources
	(
	MappingResourceCode
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	

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.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
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.ProjectContracts ADD CONSTRAINT
	FK_ProjectContracts_Contract FOREIGN KEY
	(
	ContractCode
	) REFERENCES dbo.Contract
	(
	ContractCode
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	

ALTER TABLE dbo.ProjectContracts SET (LOCK_ESCALATION = TABLE)
COMMIT
GO
update Contract set Serial=ContractCode
GO
--------------------------End 2025-03-05--------------------------

--------------------------Mostafa 2025-03-06--------------------------
insert into LabelsName(LabelKey,Name,Arabic_Name)VALUES(N'Due',N'Due',N'المستحقات')
insert into LabelsName(LabelKey,Name,Arabic_Name)VALUES(N'Consumption',N'Consumption',N'المستهلك')
insert into LabelsName(LabelKey,Name,Arabic_Name)VALUES(N'DisCount',N'DisCount',N'المخصوم')
insert into LabelsName(LabelKey,Name,Arabic_Name)VALUES(N'NetClosingMonth',N'Net Closing Month',N'الصافى لنهاية الشهر')
insert into LabelsName(LabelKey,Name,Arabic_Name)VALUES(N'NetEndYear',N'Net End Year',N'الصافى لنهاية العام')
insert into LabelsName(LabelKey,Name,Arabic_Name)VALUES(N'NetEndContract',N'Net End Contract',N'الصافى لنهاية العقد')
GO
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId], [ConfigDescription]) 
VALUES (N'HideFinalConsumptionAndSettlementBalance', N'Hide Final Consumption And Settlement Balance', N'إخفاء رصيد الاستهلاك النهائي والتسوية', N'false', 1, 63, 1, 1, NULL, NULL, NULL, N'إخفاء رصيد الاستهلاك النهائي والتسوية')
GO
--------------------------End 2025-03-06--------------------------

