﻿-------------------------------AK 2022-03-22---
ALTER TABLE [dbo].[WF_MonthlyEffectsRequest] ADD PYEAR smallint NULL;
ALTER TABLE [dbo].[WF_MonthlyEffectsRequest] ADD [Period] tinyint NULL;
-------------------------------End 2022-03-22---
-------------------------------Ali 2022-03-23---


ALTER TABLE dbo.Parameters ADD
	DataType int NULL
GO

  INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(599,N'Report Setting  Filters',N'اعداد فلاتر التقرير',208,N'/ReportSettingFilter',N'Index','fa fa-thumb-tack',N'get',9,1,0)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(599,6)
Go

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(1306,N'اعداد فلاتر التقرير',N'Report Setting  Filters',599,1)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(1307,N'عرض اعداد فلاتر التقرير',N'View Report Setting  Filters',599,2)

Go
-------------------------------End 2022-03-23---
-------------------------------Ali 2022-03-24---

update [SystemMenu] set Sequence=5 where [SystemMenuCode]=599
  update [SystemMenu] set Sequence=6 where [SystemMenuCode]=333
  update [SystemMenu] set Sequence=7 where [SystemMenuCode]=598
  update [SystemMenu] set Sequence=8 where [SystemMenuCode]=344
  update [SystemMenu] set Sequence=9 where [SystemMenuCode]=255
  Go
-------------------------------End 2022-03-24---