﻿
------------------------------------ Ali 2024-08-04 -----------------------------

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (348, NULL, NULL, N'OverTimeRequest', N'SearchOverTimeRequest', N'Post')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (349, NULL, NULL, N'OverTimeRequest', N'GetDetails', N'Get')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (350, NULL, NULL, N'OverTimeRequest', N'GetWithOutSigById', N'Get')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (351, NULL, NULL, N'OverTimeRequest', N'Get', N'Get')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (352, NULL, NULL, N'OverTimeRequest', N'Delete', N'Delete')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (353, NULL, NULL, N'OverTimeRequest', N'Post', N'Post')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (354, NULL, NULL, N'OverTimeRequest', N'Put', N'Put')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (355, NULL, NULL, N'OverTimeRequest', N'CancelRequest', N'Post')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (356, NULL, NULL, N'OverTimeRequestSignature', N'GetSignatureById', N'Get')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (357, NULL, NULL, N'OverTimeRequestSignature', N'GetOverTimeRequestsSignatures', N'Get')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (358, NULL, NULL, N'OverTimeRequestSignature', N'GetRequestSignaturesByUser', N'Post')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (359, NULL, NULL, N'OverTimeRequestSignature', N'GetRequestHistory', N'Post')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (360, NULL, NULL, N'OverTimeRequestSignature', N'SaveSignature', N'Post')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (361, NULL, NULL, N'OverTimeRequestFinalSignature', N'GetFinalSignaturesByRequest', N'Get')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (362, NULL, NULL, N'OverTimeRequestFinalSignature', N'GetFinalSignatureById', N'Get')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (363, NULL, NULL, N'OverTimeRequestFinalSignature', N'GetOverTimeRequestFinalSigWithDetails', N'Get')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (364, NULL, NULL, N'OverTimeRequestFinalSignature', N'GetOverTimeRequestFinalSignaturesByUser', N'Post')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (365, NULL, NULL, N'OverTimeRequestFinalSignature', N'SaveOverTimeFinalSignature', N'Post')
Go

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (536, 348, 3053, NULL)
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (537, 349, 3053, NULL)
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (538, 350, 3055, NULL)
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (539, 351, 3055, NULL)
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (540, 352, 3056, NULL)
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (541, 353, 3058, NULL)
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (542, 354, 3058, NULL)
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (543, 355, 3057, NULL)
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (544, 356, 3061, NULL)
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (545, 357, 3060, NULL)
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (546, 358, 3060, NULL)
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (547, 359, 3395, NULL)
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (548, 360, 3062, NULL)
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (549, 361, 3387, NULL)
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (550, 362, 3388, NULL)
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (551, 363, 3387, NULL)
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (552, 364, 3387, NULL)
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (553, 365, 3389, NULL)
Go

 update SystemMenu set ControllerName =N'/WorkFlow/OverTimeRequestApi' where SystemMenuCode=64
 Go
 update SystemMenu set ControllerName =N'/WorkFlow/OverTimeRequestSignatureApi' where SystemMenuCode=65
 Go
 update SystemMenu set ControllerName =N'/WorkFlow/OverTimeRequestFinalSignatureApi' where SystemMenuCode=222
 Go

------------------------------------ End 2024-08-04 -----------------------------

---------------------------------------M.Negm 2024-08-05------------------------------
ALTER TABLE WF_OvertimeType
DROP CONSTRAINT DF_WF_OvertimeType_IsEdit;
Go 

ALTER TABLE WF_OvertimeType
DROP COLUMN IsEdit;
Go 

ALTER TABLE dbo.WF_OvertimeType ADD
	CanEditCostCenter bit NOT NULL CONSTRAINT DF_WF_OvertimeType_CanEditCostCenter DEFAULT ((1))
	Go
----------------------------------- End 2024-08-05 ----------------------------------------


---------------------------------------M.Negm 2024-08-06 -----------------------------
ALTER TABLE dbo.WF_MonthlyEffectType ADD
	CanEditCostCenter bit NOT NULL CONSTRAINT DF_WF_MonthlyEffectType_CanEditCostCenter DEFAULT ((1))
	Go

UPDATE WF_MonthlyEffectType
SET CanEditCostCenter = IsEdit;
Go 

ALTER TABLE WF_MonthlyEffectType
DROP CONSTRAINT DF_WF_MonthlyEffectType_IsEdit;
Go 

ALTER TABLE WF_MonthlyEffectType
DROP COLUMN IsEdit;
Go 
----------------------------------- End 2024-08-06 ----------------------------------------
----------------------------------- MOstafa 2024-08-07 ----------------------------------------
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(1089,N'Manpower Budget Request',N'طلب موازنة قوى عاملة',495,N'/WorkFlow/ManpowerBudgetRequest',N'Index','fa fa-briefcase',N'get',9,1,1)
GO
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(1089,1)
GO
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15480,N' طلب موازنة قوى عاملة',N' Manpower Budget Request',1089,1)
GO
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15481,N'عرض طلب موازنة قوى عاملة ',N'View Manpower Budget Request',1089,2)
GO
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15482,N'إضافة طلب موازنة قوى عاملة ',N'Add Manpower Budget Request',1089,2)
GO
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15483,N'تعديل طلب موازنة قوى عاملة ',N'Edit Manpower Budget Request',1089,2)
GO
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15484,N'حذف طلب موازنة قوى عاملة ',N'Delete Manpower Budget Request',1089,2)
GO
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15485,N'حفظ طلب موازنة قوى عاملة ',N'Save Manpower Budget Request',1089,2)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(2019,N'WorkFlow',N'ManpowerBudgetRequest',N'Index',0,N'get',15480)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(2020,N'WorkFlow',N'ManpowerBudgetRequest',N'ManpowerBudgetRequest_Read',0,N'post',15481)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(2021,N'WorkFlow',N'ManpowerBudgetRequest',N'Save',1,N'get',15482)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(2022,N'WorkFlow',N'ManpowerBudgetRequest',N'Save',2,N'get',15483)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(2023,N'WorkFlow',N'ManpowerBudgetRequest',N'Delete',0,N'post',15484)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(2024,N'WorkFlow',N'ManpowerBudgetRequest',N'Save',0,N'post',15485)
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1450,NULL, NULL,N'ManpowerBudgetRequest',N'GetManpowerBudgetRequestSearch',N'post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1451,NULL, NULL,N'ManpowerBudgetRequest',N'GetDetails',N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (1456, NULL, NULL, N'ManpowerBudgetRequest', N'GetWithOutSigById', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1452,NULL, NULL,N'ManpowerBudgetRequest',N'Put',N'Put')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1453,NULL, NULL,N'ManpowerBudgetRequest',N'post',N'post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1454,NULL, NULL,N'ManpowerBudgetRequest',N'Delete',N'Delete')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1455,NULL, NULL,N'ManpowerBudgetRequest',N'Get',N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1745,1450,15481, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1746,1451,15481, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1747,1452,15485, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1748,1453,15485, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1749,1454,15484, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1750,1455,15483, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (1757, 1456, 15483, NULL)
GO
INSERT [dbo].[WF_RequestType] ([RequestTypeId], [RequestTypeName], [RequestTypeNameEn], [IsEditable], [SenderUserName], [SenderFrom], [SenderPassword], [SenderHostName], [SenderPort], [SenderName], [SubmitBeforRequestDate], [SubmitAfterRequestDate], [IsUsed], [CanDelegation], [DisplayUserName], [HaveAttachment], [WorkedByDefaultContract], [CategoryCode], [RequestTypeGroupCode], [SendEmailNotification], [AsyncWhatsAppMessage], [RequsetPrint], [SignatureRefusedComentMandatory], [IsApi], [IsMasterRequest], [NotifSignCountAction], [NotifSignCountController], [NotifSignCountArea], [IsEnableSSL], [WorkedByAssignmentContract], [IsMobile], [SignatureApprovedCommentMandatory])
VALUES (66,N'طلب موازنة قوى عاملة',N'Manpower Budget Request', 0, N'sst.sentmail@gmail.com', N'sst.sentmail@gmail.com', N'mwtjgyjxrrgczlfr', N'smtp.gmail.com', 587, N'SST System', NULL, NULL, 1, 1, 0, 0, 0, 1, 2, 1, 0, 1, 0, 1, 1, N'index', N'ManpowerBudgetRequestSignature', N'WorkFlow', 1, 1, 0, 0)
GO
SET IDENTITY_INSERT[dbo].[EmailTemplateType] ON
INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode],[RequestTypeCode],[HaveUserAccount]) VALUES(416,N'Manpower Budget Request Sending',N'ارسال طلب موازنة قوى عاملة',0,1,66, 1 )
INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode],[RequestTypeCode],[HaveUserAccount]) VALUES(417,N'Manpower Budget Request Accept',N'الموافقة على طلب موازنة قوى عاملة',0,1,66, 1 )
INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode],[RequestTypeCode],[HaveUserAccount]) VALUES(418,N'Manpower Budget Request Refuse',N'رفض طلب موازنة قوى عاملة',0,1,66, 1 )
INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode],[RequestTypeCode],[HaveUserAccount]) VALUES(419,N'Manpower Budget Request Cancel',N'الغاء طلب موازنة قوى عاملة',0,1,66, 1 )
INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode],[RequestTypeCode],[HaveUserAccount]) VALUES(420,N'Send Notification AFter Track',N'ارسال اشعار بعد نهاية المسار',0,1,66, 1 )
SET IDENTITY_INSERT [dbo].[EmailTemplateType] OFF
GO
SET IDENTITY_INSERT [dbo].[EmailTemplate] ON 
INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(4342,N'Manpower Budget Request Sending',N'ارسال طلب موازنة قوى عاملة',416,N'ارسال',N'ارسال',1,NULL)
INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(4343,N'Manpower Budget Request Accept',N'الموافقة على طلب موازنة قوى عاملة',417,N'الموافقة على',N'الموافقة على',1,NULL)
INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(4344,N'Manpower Budget Request Refuse',N'رفض طلب موازنة قوى عاملة',418,N'رفض',N'رفض',1,NULL)
INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(4345,N'Manpower Budget Request Cancel',N'الغاء طلب موازنة قوى عاملة',419,N'الغاء',N'الغاء',1,NULL)
INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(4346,N'Send Notification AFter Track',N'ارسال اشعار بعد نهاية المسار',420,N'ارسال اشعار بعد نهاية المسار',N'ارسال اشعار بعد نهاية المسار',1,NULL)
SET IDENTITY_INSERT [dbo].[EmailTemplate] OFF
GO
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(1090,N'Manpower Budget Request Signature',N'اعتماد طلب موازنة قوى عاملة',500,N'/WorkFlow/ManpowerBudgetRequestSignature',N'Index','fa fa-thumb-tack',N'get',9,1,1)
Go
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(1090,1)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15486,N'اعتماد طلب موازنة قوى عاملة',N'Manpower Budget Request Signature',1090,1)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15487,N'عرض اعتماد طلب موازنة قوى عاملة',N'View Manpower Budget Request Signature',1090,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15488,N'تعديل اعتماد طلب موازنة قوى عاملة',N'Edit Manpower Budget Request Signature',1090,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15489,N'حفظ اعتماد طلب موازنة قوى عاملة',N'Save Manpower Budget Request Signature',1090,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15490,N'حفظ متعدد للاعتماد',N'Multiple Save',1090,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15491,N'عرض سجل الموظف',N'View Employee History',1090,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15492,N'ارجاع الطلب',N'Inverse Request',1090,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15493,N'اختيار كل الطلبات',N'Choose All Requests',1090,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15494,N'الغاء طلب موازنة قوى عاملة',N'Manpower Budget Request',1089,2)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(2025,N'WorkFlow',N'ManpowerBudgetRequestSignature',N'Index',0,N'get',15486)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(2026,N'WorkFlow',N'ManpowerBudgetRequestSignature',N'ManpowerBudgetRequestSignature_Read',0,N'post',15487)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(2027,N'WorkFlow',N'ManpowerBudgetRequestSignature',N'Save',2,N'get',15488)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(2028,N'WorkFlow',N'ManpowerBudgetRequestSignature',N'Save',0,N'post',15489)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1751, 12, 15494, 66)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (1752, 9, 15487, 66)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (1753, 10, 15487, 66)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (1754, 8, 15488, 66)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (1755, 13, 15489, 66)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (1756, 11, 15491, 66)
Go
----------------------------------- End 2024-08-07 ----------------------------------------

----------------------------------- M.Negm 2024-08-08 ----------------------------------------
  ALTER TABLE dbo.SecurityUser ADD
	MobileSkin nvarchar(50) Null 
GO
update SecurityUser set MobileSkin='skin-1'
Go
------------------------------------- End 2024-08-08 -----------------------------------------