------------------------------- Ali 2020-11-10 --------------------------
  ALTER TABLE dbo.AC_TransactionEnquiry
 DROP COLUMN PenaltyAuthorityCode;
 Go
    ALTER TABLE dbo.AC_TransactionEnquiry ADD
	PenaltyDepartmentCode nvarchar(20) NOT NULL
	Go
	   update [SecurityPrivilege] 
  set [DescriptionAR] =N'ربط بمعاملات اخرى'
  where [ID]= 2133
  Go
------------------------------- End 2020-11-10 --------------------------
------------------------------- Hammad 2020-11-10 -----------------------
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
 VALUES (N'TheNoCharactersSearchEmployee', N'The No characters search for employee ', N'عدد حروف البحث للموظف', N' 3', 1, 11, 2, 0, NULL, NULL, NULL)
 Go

 INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) 
VALUES (N'TheNoCharactersSearchSection', N'The No characters search for section ', N'عدد حروف البحث للقسم', N' 3', 1, 11, 2, 0, NULL, NULL, NULL)
Go
------------------------------- End 2020-11-10 -----------------------
------------------------------- Ali 2020-11-11 -----------------------
CREATE VIEW [dbo].[SystemMenuView]
                    AS
                    SELECT * FROM [dbo].[SystemMenu]
GO

CREATE VIEW [dbo].[SecurityUserView]
                    AS
                    SELECT * FROM [dbo].[SecurityUser]
GO
------------------------------- End 2020-11-11-----------------------
------------------------------- A.Khaled 2020-11-12 -------------------------- 
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) 
VALUES (387, N'Reports', N'التقارير', 357, N'/Inventory/ReportSearch', N'Index', N'fa fa-thumb-tack', N'get', 7, 1, 1)
GO

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (14193, N'التقارير', N'Reports', 387, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (14194, N'عرض التقارير', N'View Reports', 387, 2)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (294, N'Inventory', N'ReportSearch', N'Index', 0, N'get', 14194)
GO

INSERT [dbo].[SystemMenuModule] ([SystemMenuCode], [AppModuleCode]) VALUES (387, 12)
Go
------------------------------- End 2020-11-12 --------------------------
