﻿---------------------------- Hammad 2023-07-19 -----
ALTER TABLE dbo.Divisions ADD
	PayrollCode int NULL
GO
INSERT [dbo].[UserType] ([UserTypeCode], [Name], [Arabic_Name], [HaveEmployee], [OrganizationCategoryCode], [IsVisible]) 
VALUES (39, N'Payroll Division Manager', N'مسؤول المرتبات للقطاع ', 1, NULL, 1)
GO

update UserType set HaveEmployee=1 where UserTypeCode=38
Go
----------------------------End -----


---------------------------------------------mahmoud 12-7-2023
insert into SystemMenu (SystemMenuCode , Name , Arabic_Name , ParentID , ControllerName, ActionName , ImageURL , HTTPMethod , Sequence , IsVisible , ShowInPrivilegePage )
values ( 1008, N'Job Offer Request Signature ',N'إعتماد طلب العرض الوظيفى ' , 500,N'/WorkFlow/JobOfferRequestSignature' ,N'Index' , N'fa fa-thumb-tack',N'get' , 1, 1, 1    )

insert into SystemMenuModule( SystemMenuCode , AppModuleCode ) values  (1008 , 1)


insert into SecurityPrivilege (ID, DescriptionAR, DescriptionEN , SystemMenuCode , PrivilegeType )
values (5149, N'إعتماد طلب العرض الوظيفى ', N' JobOfferRequestSignature' , 1008, 1 )

insert into SecurityPrivilege (ID, DescriptionAR, DescriptionEN , SystemMenuCode , PrivilegeType )
values (5150, N'عرض إعتماد طلب العرض الوظيفى  ', N' JobOfferRequestSignatureView' , 1008, 2 )
insert into SecurityPrivilege (ID, DescriptionAR, DescriptionEN , SystemMenuCode , PrivilegeType )
values (5151, N' تعديل إعتماد طلب العرض الوظيفى  ', N' JobOfferRequestSignatureEdit ' , 1008, 2 )
insert into SecurityPrivilege (ID, DescriptionAR, DescriptionEN , SystemMenuCode , PrivilegeType )
values (5152, N'حفظ إعتماد طلب العرض الوظيفى   ', N' JobOfferRequestSignatureSave' , 1008, 2 )

insert into SecurityPrivilege (ID, DescriptionAR, DescriptionEN , SystemMenuCode , PrivilegeType )
values (5153, N'حفظ متعدد إعتماد طلب العرض الوظيفى', N'JobOfferRequestSignatureSaveMultiple' , 1008, 2 )


insert into SecurityPrivilegeActions (id , AreaName , ControllerName , ActionName , ActionType , HTTPMethod , SecurityPrivilegeID )
values (1088, N'WorkFlow' , N'JobOfferRequestSignature', N'Index', 0, N'get' ,5150  )
insert into SecurityPrivilegeActions (id , AreaName , ControllerName , ActionName , ActionType , HTTPMethod , SecurityPrivilegeID )
values (1089, N'WorkFlow' , N'JobOfferRequestSignature', N'JobOfferRequestSignature_Read', 0, N'post' ,5152  )
insert into SecurityPrivilegeActions (id , AreaName , ControllerName , ActionName , ActionType , HTTPMethod , SecurityPrivilegeID )
values (1090, N'WorkFlow' , N'JobOfferRequestSignature', N'Save', 2, N'get' ,5152  )
insert into SecurityPrivilegeActions (id , AreaName , ControllerName , ActionName , ActionType , HTTPMethod , SecurityPrivilegeID )
values (1092, N'WorkFlow' , N'JobOfferRequestSignature', N'Save', 0, N'post' ,5152  )
insert into SecurityPrivilegeActions (id , AreaName , ControllerName , ActionName , ActionType , HTTPMethod , SecurityPrivilegeID )
values (1091, N'WorkFlow' , N'JobOfferRequestSignature', N'SaveRequestSignatureLst', 0, N'Post' ,5152  )


insert into SecurityPrivilegeEndPointsDetails (id , SecurityPrivilegeEndPointId, SecurityPrivilegeId , RequestTypeId )
values (953, 9, 5150, 58)

insert into SecurityPrivilegeEndPointsDetails (id , SecurityPrivilegeEndPointId, SecurityPrivilegeId , RequestTypeId )
values (954, 10, 5151, 58)

insert into SecurityPrivilegeEndPointsDetails (id , SecurityPrivilegeEndPointId, SecurityPrivilegeId , RequestTypeId )
values (955, 13, 5153, 58)




-------------------------------------------------end 