﻿ --------------------------------------Ali 2024-04-14 -----------------------------------
	update SystemMenu set ControllerName =N'/WorkFlow/PermissionRequestApi' where SystemMenuCode=36
 Go

   UPDATE SecurityPrivilegeActions SET ControllerName = N'PermissionRequestApi'
where  id in(1768,1769,1770,1771,1772,1773,1774)
 Go

 update SystemMenu set ControllerName =N'/WorkFlow/PermissionRequestSignatureApi' where SystemMenuCode=37
 Go

 UPDATE SecurityPrivilegeActions SET ControllerName = N'PermissionRequestSignatureApi'
where  id in(1775,1776,1777, 1778)
 Go

update SystemMenu set ControllerName =N'/WorkFlow/ResignationRequestApi' where SystemMenuCode=80
 Go

     UPDATE SecurityPrivilegeActions SET ControllerName = N'ResignationRequestApi'
where  id in(1714, 1715,1716, 1717,1718, 1719, 1720)
 Go

 update SystemMenu set ControllerName =N'/WorkFlow/ResignationRequestSignatureApi' where SystemMenuCode=81
 Go

      UPDATE SecurityPrivilegeActions SET ControllerName = N'ResignationRequestSignatureApi'
where  id in(1721, 1722, 1723,1724)
 Go

 update SystemMenu set ControllerName =N'/WorkFlow/DisclaimerRequestSignatureApi' where SystemMenuCode=148
 Go

  UPDATE SecurityPrivilegeActions SET ControllerName = N'DisclaimerRequestSignatureApi'
where  id in(1764,1765,1766,1767)
Go

 update SystemMenu set ControllerName =N'/WorkFlow/LoanRequestApi' where SystemMenuCode=84
 Go

  UPDATE SecurityPrivilegeActions SET ControllerName = N'LoanRequestApi'
where  id in(1739,1740,1741,1742,1743,1744,1745)

 update SystemMenu set ControllerName =N'/WorkFlow/LoanRequestSignatureApi' where SystemMenuCode=85
 Go

  UPDATE SecurityPrivilegeActions SET ControllerName = N'LoanRequestSignatureApi'
where  id in(1731,1732,1733,1734)
Go
    --------------------------------------End 2024-04-14 -----------------------------------



  --------------------------------------Negm 2024-04-15 -----------------------------------
ALTER TABLE WF_MonthlyEffectType ADD
	IsClosed bit NOT NULL CONSTRAINT DF_WF_MonthlyEffectType_IsClosed DEFAULT ((0))
GO

 ALTER TABLE WF_MonthlyEffectType ADD
	CurrencyCode tinyint  NULL
GO


ALTER TABLE dbo.WF_MonthlyEffectType ADD CONSTRAINT
	FK_WF_MonthlyEffectType_Currencies FOREIGN KEY
	(
	CurrencyCode
	) REFERENCES dbo.Currencies
	(
	CurrencyCode
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO

ALTER TABLE [dbo].WF_MonthlyEffectType CHECK CONSTRAINT FK_WF_MonthlyEffectType_Currencies
GO

  --------------------------------------End 2024-04-15 -----------------------------------
  --------------------------------------MOstafa 2024-04-16 -----------------------------------
ALTER TABLE WF_Track
DROP COLUMN IsIndoor;
GO
  --------------------------------------End 2024-04-16 -----------------------------------
    --------------------------------------Ali 2024-04-16 -----------------------------------

   update SystemMenu set ControllerName =N'/WorkFlow/MonthlyEffectsRequestApi' where SystemMenuCode=239
 Go
 update SystemMenu set ControllerName =N'/WorkFlow/MonthlyEffectsRequestSignatureApi' where SystemMenuCode=240
 Go


UPDATE SecurityPrivilegeActions SET ControllerName = N'MonthlyEffectsRequestApi'
where  id between 1455 and 1461
Go
UPDATE SecurityPrivilegeActions SET ControllerName = N'MonthlyEffectsRequestSignatureApi'
where  id between 1462 and 1465
Go
  --------------------------------------End 2024-04-16 -----------------------------------