--select jobtitle from employee where position=75048
--Si falla, dehabilitar los triggers /Tables/dbo.Employee/Triggers/Trigger_EmployeeUserInfoSync y trSA_EmployeeUserSync_Ins
--DISABLE TRIGGER [dbo].[trSA_EmployeeUserSync_Del] ON dbo.employee
--DISABLE TRIGGER [dbo].[trSA_EmployeeUserSync_Ins] ON dbo.employee
--DISABLE TRIGGER [dbo].[trSA_EmployeeUserSync_Upd] ON dbo.employee --Si falla el alta, se deshabilita este trigger
--DISABLE TRIGGER [dbo].[tRIGGER_EmployeeUserInfoSync] ON dbo.employee --Si falla el alta, se deshabilita este trigger
--ENABLE TRIGGER [dbo].[trSA_EmployeeUserSync_Del] ON dbo.employee
--ENABLE trigger [dbo].[trSA_EmployeeUserSync_Ins] ON dbo.employee
--ENABLE trigger [dbo].[trSA_EmployeeUserSync_Upd] ON dbo.employee --Posterior a deshabilitarlo, se habilita
--ENABLE TRIGGER [dbo].[tRIGGER_EmployeeUserInfoSync] ON dbo.employee ----Posterior a deshabilitarlo, se habilita
--select * from hm_employee where payrollid=1041291
--select * from employee where employeeno=277
--select * from hm_employee where employeeno=277
-------------------------------------
--delete from hm_employee where employeeno = 277 --si marca error de duplicado, se busca cual es el empleado y se elimina de hm_employee
--select * from employee where employeeno = 277
--- por si marca error al dar de alta, buscarlos y luego borrarlos
select * from HM_Employee where PayrollID = 1053593
select * from AspNetUsers where UserName = 1053593
select * from mobile.NotificationUser
where UserId = 'E24839E9-2E8A-4055-8852-72963ED6B8B0'
select * from employee where payrollid=1053593
----------------
DECLARE
@payrollID NVARCHAR(20) = 1053593 --Aqui va el # de empleado
, @firstName VARCHAR(20) = 'SOFIA' --Nombre
, @lastName VARCHAR(15) = 'JUAREZ' --Apellido
, @position NVARCHAR(7) = 75043 --Posición
, @posAuth TINYINT = 0
, @employeeNo INT
, @employeeNoNext INT
--, @jobTitle NVARCHAR(40) = 'SYSTEMADMIN'
--, @empLocation SMALLINT = 1
declare @tmpEmployeeNumbersTable Table(id int,employeeNo int)
insert into @tmpEmployeeNumbersTable
select ROW_NUMBER() OVER (ORDER BY EmployeeNo), EmployeeNo from employee
SELECT TOP 1 @employeeNo = EmployeeNo FROM Employee WITH (NOLOCK) WHERE PayrollID = @payrollID
IF(@employeeNo IS NULL)
BEGIN
---print 'entra'
set @employeeNoNext = (select top 1 id from @tmpEmployeeNumbersTable where id != employeeNo)
---print @employeeNoNext
SET IDENTITY_INSERT employee ON;
INSERT INTO Employee ([EmployeeNo],[FirstName],[MiddleInit],[LastName],[PayrollID],[Zip],[HomePhone],[Addr1],[Addr2],[City],[State],[EmergPhone],[EmergContact],[Dependents],[WageType],[OnCommission],[CommissType],[PartOrFull],[Initials],[BirthDate],[HireDate],[TermDate],[TermCode],[TaxStatus],[InitialPay],[AuthLevel__1],[AuthLevel__2],[AuthLevel__3],[AuthLevel__4],[AuthLevel__5],[AuthLevel__6],[AuthLevel__7],[AuthLevel__8],[AuthLevel__9],[AuthLevel__10],[Password],[TransToday],[NetMerchSls],[VoidsToday],[CostOfSales],[OverShort],[PosAuth],[CashSales],[ChargeSales],[CustCount],[CashTender],[OtherTender],[Deposits],[Payments],[LastTran__1],[LastTran__2],[LastTran__3],[LastRegID__1],[LastRegID__2],[LastRegID__3],[PrevTran__1],[PrevTran__2],[PrevTran__3],[PrevRegID__1],[PrevRegID__2],[PrevRegID__3],[DrawerOpen__1],[DrawerOpen__2],[DrawerOpen__3],[CurrentCash__1],[CurrentCash__2],[CurrentCash__3],[DatePswdChng],[Discount],[PriceCode],[EmpLocation],[JobTitle],[CostOrMargin],[EmailAddr],[Addr3],[RightHanded],[MiddleName],[SocialSec],[TABadge],[NewHire],[Sex],[CashInDrawer],[EmpStatus],[JobCode],[Security],[Register],[JobClass],[DataSource],[MLastName],[Position])
VALUES (@employeeNoNext, @firstName, N'', @lastName, @payrollID, N'66267', N'81557000', N'RICARDO MARGAIN ZOZAYA #605', N'', N'SAN PEDRO GARZA GARCIA', N'NL', N'81557000', N'0',
0, 0, 0, 0, 0, @payrollID, NULL, CAST(GetDate() AS Date), NULL, N'', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
N'', 0, 0, 0, 0, 0, @posAuth, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, CAST(0.00 AS Decimal(8, 2)), CAST(0.00 AS Decimal(8, 2)), CAST(0.00 AS Decimal(8, 2)),
CAST(GetDate() AS Date), CAST(0.00 AS Decimal(4, 2)), 0, NULL, N'ASOCIADO_OAT_SMS', 0, N'', N'', 1, N'', N'', N'',
1, 0, CAST(0.00 AS Decimal(7, 2)),
3, 0, 1, 0, 0, N'', N'', @position)
END
SET IDENTITY_INSERT employee OFF
select * from employee where payrollid=@payrollID 