﻿ ---------------------Mostafa 2022-03-07---------------------------
 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---------------------------
   ---------------------AK 2022-03-03---------------------------
 INSERT INTO [SST.ERP_Client]. [dbo].[APIs] ([ApiId], [ApiName]) VALUES (8, N'GenerlLedger')
Go
 ---------------------End 2022-03-03---------------------------
 -------------------------------Sayed 2022-03-07---------
ALTER TABLE WF_OverTimeRequest 
Alter COLUMN SectionCode nvarchar(20)  null;
Go
-------------------------------End 2022-03-07------------