﻿---------------------AK 2021-11-17---------
/* To prevent any potential data loss issues, you should review this script in detail before running it outside the context of the database designer.*/
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
GO
ALTER TABLE dbo.AC_TransactionTemplate ADD
	IsDefault bit NOT NULL CONSTRAINT DF_AC_TransactionTemplate_IsDefault DEFAULT 0
GO
ALTER TABLE dbo.AC_TransactionTemplate SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
---------------------End 2021-11-17---------
---------------------MOstafa 2021-11-28---------
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
GO
CREATE TABLE dbo.Tmp_WF_EmployeeDataType
	(
	EmployeeDataTypeCode int 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
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_WF_EmployeeDataType SET (LOCK_ESCALATION = TABLE)
GO
IF EXISTS(SELECT * FROM dbo.WF_EmployeeDataType)
	 EXEC('INSERT INTO dbo.Tmp_WF_EmployeeDataType (EmployeeDataTypeCode, Name, Arabic_Name, ColumnName, DataType, ControllerName, ActionName, IsFromEmployeeExtend, DataValueField, DataTextFieldEn, DataTextFieldAr)
		SELECT EmployeeDataTypeCode, Name, Arabic_Name, ColumnName, DataType, ControllerName, ActionName, IsFromEmployeeExtend, DataValueField, DataTextFieldEn, DataTextFieldAr FROM dbo.WF_EmployeeDataType WITH (HOLDLOCK TABLOCKX)')
GO
DROP TABLE dbo.WF_EmployeeDataType
GO
EXECUTE sp_rename N'dbo.Tmp_WF_EmployeeDataType', N'WF_EmployeeDataType', 'OBJECT' 
GO
ALTER TABLE dbo.WF_EmployeeDataType ADD CONSTRAINT
	PK_WF_EmployeeDataType PRIMARY KEY CLUSTERED 
	(
	EmployeeDataTypeCode
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
COMMIT

---------------------End 2021-11-28---------
---------------------Ali 2021-11-28---------


 INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'WFAddSplitDayOffAndHoliday',N'Add DayOff And Holiday When Split vacation',N'اضافة الاجازات الرسمية والعطلات عند تقسيم الاجازه',N'true',2,42,1,1,Null,Null,11)
Go
---------------------End 2021-11-28---------
---------------------Mostafa 2021-11-29---------

ALTER procedure [dbo].[Emp_GetEmployeeSalaryDetails] 
(
	@EmpCode	int=0
)
AS


SELECT 
	  [EmployeeCode]
      ,[dbo].Salary_Details.[BandCode]
      ,[Amount]
      ,[CurrencyCode]
      ,[CurrencyAmount]
      ,[AmountAcc]
      ,[CurrencyAmountAcc]
      ,[TempChangeValue]
      ,[ArabicAmount]
      ,[CalculateNumber]
      ,[EnglishAmount]
      ,[SerialAuto]
      ,[SpecialCostCenter]
	  ,[dbo].Basis.[Name] BasisNameEn
	  ,[dbo].Basis.[Arabic_Name] BasisNameAr

FROM [dbo].[Salary_Details]
inner join [dbo].[Basis] on [dbo].[Basis].[BandCode] = [dbo].Salary_Details.BandCode

where 
	( [dbo].Salary_Details.[EmployeeCode] = @EmpCode);

	Go
---------------------End 2021-11-29---------
---------------------Sayed 2021-11-29--------------
insert into LabelsName(LabelKey,Name,Arabic_Name) values('Location','Location',N'الموقع')
GO
insert into LabelsName(LabelKey,Name,Arabic_Name) values('NewLevel','New Level',N'المستوى الجديد')
GO
insert into LabelsName(LabelKey,Name,Arabic_Name) values('OldLevel','Old Level',N'المستوى القديم')
GO
----------------End 2021-11-29-------------------------
----------------Ali 2021-11-29-------------------------

ALTER TABLE dbo.WF_ChangeEmployeeDataRequest ADD
	OldValue nvarchar(100) NULL
GO
ALTER TABLE dbo.WF_MasterRequests ADD
	IsSynced bit NOT NULL CONSTRAINT DF_WF_MasterRequests_IsSynced DEFAULT ((0))
GO
----------------End 2021-11-29-------------------------
