﻿ ---------------------AK 2022-03-02---------------------------

INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
 VALUES (N'MailIsEnableSSL', N'Is enable SSL', N'تفعيل التشفير SSL', N'true', 1, 6, 1, 1, NULL, NULL, NULL)
GO

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (588, N'Save Other Tracks', N'حفظ مسارات أخرى', 28, N'/WorkFlow/OtherEmployeeTrack', N'Save', N'fa fa-thumb-tack', N'get', 5, 0, 0)
GO
 ---------------------End 2022-03-02---------------------------

 ---------------------Mostafa 2022-03-02---------------------------
 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.TempPaySlip
	DROP COLUMN Effect
GO
ALTER TABLE dbo.TempPaySlip SET (LOCK_ESCALATION = TABLE)
GO
COMMIT

GO  
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.Basis
	DROP COLUMN Effect
GO
ALTER TABLE dbo.Basis SET (LOCK_ESCALATION = TABLE)
GO
COMMIT


/****** Object:  StoredProcedure [dbo].[Emp_GetPaySlip]    Script Date: 02/03/2022 1:26:44 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER procedure [dbo].[Emp_GetPaySlip] 
(
	@EmpCpde		nvarchar(50),
	@TemTable		nvarchar(100),
	@CalculateNo	nvarchar(10)
)
as


--Create  table TempPaySlip(EmployeeCode int,LineValue float,BandCode int,LE_Share float,CurrencyCode tinyint,Effect bit,Hide bit,CollectIn int,CollectInEx int );
declare @query nvarchar(2000);

set @query=' insert into TempPaySlip
SELECT 
      [EmployeeCode]     
      ,[LineValue]    
      ,Basis.[BandCode]    
      ,[LE_Share]    
      ,[CurrencyCode]
	  ,[Hide]
	  ,[CollectIn]
	  ,[CollectInEx]
     
  FROM '+@TemTable +' as result inner join [dbo].[Basis] on Basis.BandCode=result.BandCode

  where [EmployeeCode]='+@EmpCpde
  if(@CalculateNo!='0')
  begin
 set @query=@query +'and CalculateNumber='+@CalculateNo;
   end 

exec(@query);

--SELECT * from paySlip
--INSERT into @tempPaySlip SELECT * from paySlip;

SELECT * from  TempPaySlip
delete  from   TempPaySlip

 ---------------------End 2022-03-02---------------------------