﻿----------------------------Hammad 2021-05-26------------------------
Go
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) 
VALUES (5134, N'حفظ عناصر الشاشة لإعلان اونلاين', N'Save Fields Online', 59, 2)
Go
----------------------------End 2021-05-26------------------------
---------------------------- Sayed 2021-05-27---------------------
update ConfigParameter set ConfigValue='true' where ConfigKey='WFCompensationReducedBalance'
GO
---------------------------End 2021-05-27------------------------
---------------------------Ali 2021-05-27------------------------

 INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES
   (1277,N'اظهار كل الموظفين',N'Display all employees',25,2)
   Go

   INSERT INTO [SST.ERP_Client]. [dbo].[APIs] ([ApiId], [ApiName]) VALUES (7, N'MeetingApi')
   Go
   
  SET IDENTITY_INSERT [dbo].[AppModule] ON  
   INSERT [dbo].[AppModule] ([AppModuleCode], [Name], [Arabic_Name], [IsLicensed], [LicenseNumber]) VALUES (15, N'Meetings', N'الاجتماعات', 1, NULL)
SET IDENTITY_INSERT [dbo].[AppModule] OFF
Go

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(531,N'Meetings',N'الاجتماعات',NULL,NULL,NULL,'fa fa-thumb-tack',NULL,21,1,1)
Go
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(531,15)
Go

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(532,N'Basic Data Meeting',N'البيانات الاساسية للاجتماعات',531,NULL,NULL,'fa fa-thumb-tack',NULL,1,1,1)
Go
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(532,15)
Go

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(533,N'Meeting Topics',N'مواضيع الاجتماع',532,N'/Meeting/MeetingTopic',N'Index','fa fa-thumb-tack',N'get',1,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(533,15)
Go

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(17006,N'مواضيع الاجتماع',N'Meeting Topics',533,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(17007,N'عرض مواضيع الاجتماع',N'View Meeting Topics',533,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(17008,N'إضافة مواضيع الاجتماع',N'Add Meeting Topics',533,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(17009,N'تعديل مواضيع الاجتماع',N'Edit Meeting Topics',533,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(17010,N'حذف مواضيع الاجتماع',N'Delete Meeting Topics',533,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(17011,N'حفظ مواضيع الاجتماع',N'Save Meeting Topics',533,2)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(800,N'Meeting',N'MeetingTopic',N'Index',0,N'get',17006)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(801,N'Meeting',N'MeetingTopic',N'MeetingTopic_Read',0,N'post',17007)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(802,N'Meeting',N'MeetingTopic',N'Save',1,N'get',17008)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(803,N'Meeting',N'MeetingTopic',N'Save',2,N'get',17009)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(804,N'Meeting',N'MeetingTopic',N'Delete',0,N'post',17010)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(805,N'Meeting',N'MeetingTopic',N'Save',0,N'post',17011)
Go

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(534,N'Meeting Type',N'نوع الاجتماع',532,N'/Meeting/MeetingType',N'Index','fa fa-thumb-tack',N'get',2,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(534,15)
Go

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(17012,N'نوع الاجتماع',N'Meeting Type',534,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(17013,N'عرض نوع الاجتماع',N'View Meeting Type',534,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(17014,N'إضافة نوع الاجتماع',N'Add Meeting Type',534,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(17015,N'تعديل نوع الاجتماع',N'Edit Meeting Type',534,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(17016,N'حذف نوع الاجتماع',N'Delete Meeting Type',534,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(17017,N'حفظ نوع الاجتماع',N'Save Meeting Type',534,2)
Go


INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(806,N'Meeting',N'MeetingType',N'Index',0,N'get',17012)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(807,N'Meeting',N'MeetingType',N'MeetingType_Read',0,N'post',17013)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(808,N'Meeting',N'MeetingType',N'Save',1,N'get',17014)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(809,N'Meeting',N'MeetingType',N'Save',2,N'get',17015)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(810,N'Meeting',N'MeetingType',N'Delete',0,N'post',17016)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(811,N'Meeting',N'MeetingType',N'Save',0,N'post',17017)
Go



INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(535,N'Meeting Place',N'مكان الاجتماع',532,N'/Meeting/MeetingPlace',N'Index','fa fa-thumb-tack',N'get',3,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(535,15)
Go

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(17018,N'مكان الاجتماع',N'Meeting Place',535,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(17019,N'عرض مكان الاجتماع',N'View Meeting Place',535,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(17020,N'إضافة مكان الاجتماع',N'Add Meeting Place',535,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(17021,N'تعديل مكان الاجتماع',N'Edit Meeting Place',535,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(17022,N'حذف مكان الاجتماع',N'Delete Meeting Place',535,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(17023,N'حفظ مكان الاجتماع',N'Save Meeting Place',535,2)
Go


INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(812,N'Meeting',N'MeetingPlace',N'Index',0,N'get',17018)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(813,N'Meeting',N'MeetingPlace',N'MeetingPlace_Read',0,N'post',17019)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(814,N'Meeting',N'MeetingPlace',N'Save',1,N'get',17020)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(815,N'Meeting',N'MeetingPlace',N'Save',2,N'get',17021)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(816,N'Meeting',N'MeetingPlace',N'Delete',0,N'post',17022)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(817,N'Meeting',N'MeetingPlace',N'Save',0,N'post',17023)
Go
---------------------------End 2021-05-27------------------------
---------------------------Hammad 2021-05-27------------------------
ALTER TABLE dbo.WF_CompensationAllowanceTypes ADD
	DeserveOverTime bit NOT NULL CONSTRAINT DF_WF_CompensationAllowanceTypes_DeserveOverTime DEFAULT 0,
	OverTimeBandCode int NULL
GO
ALTER TABLE dbo.WF_CompensationRequestFinalDayRestSignature ADD
	CompensationBalanceAfterFactor float(53) NULL,
	CompensationMoneyAfterFactor float(53) NULL,
	CompensationOverTimeAfterFactor float(53) NULL
GO

---------------------------End 2021-05-27------------------------