﻿
--------------------------Ali 2023-10-24-----------------------
ALTER TABLE dbo.Emp_Delegation ADD
	IsAddRequest bit NOT NULL CONSTRAINT DF_Emp_Delegation_AddRequest DEFAULT (0)
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 (64, N'طلب تفويض موظف', N'Employee Delegation 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, 4, 1, 0, 1, 0, 1, 1, N'index', N'EmployeeDelegationRequestSignature', 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(375,N'Employee Delegation Sending',N'ارسال تفويض موظف',0,1,64, 1 )

INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode],[RequestTypeCode],[HaveUserAccount]) VALUES(376,N'Employee Delegation Accept',N'الموافقة على تفويض موظف',0,1,64, 1 )

INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode],[RequestTypeCode],[HaveUserAccount]) VALUES(377,N'Employee Delegation Refuse',N'رفض تفويض موظف',0,1,64, 1 )

INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode],[RequestTypeCode],[HaveUserAccount]) VALUES(378,N'Send Notification AFter Track',N'ارسال اشعار بعد نهاية المسار',0,1,64, 1 )
SET IDENTITY_INSERT [dbo].[EmailTemplateType] OFF
Go

INSERT[dbo].[EmailTemplate]([Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(N'Employee Delegation Sending',N'ارسال تفويض موظف',375,N'ارسال',N'ارسال',1,NULL)

INSERT[dbo].[EmailTemplate]([Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(N'Employee Delegation Accept',N'الموافقة على تفويض موظف',376,N'الموافقة على',N'الموافقة على',1,NULL)

INSERT[dbo].[EmailTemplate]([Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(N'Employee Delegation Refuse',N'رفض تفويض موظف',377,N'رفض',N'رفض',1,NULL)

INSERT[dbo].[EmailTemplate]([Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(N'Send Notification AFter Track',N'ارسال اشعار بعد نهاية المسار',378,N'ارسال اشعار بعد نهاية المسار',N'ارسال اشعار بعد نهاية المسار',1,NULL)
Go

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(1022,N'Employee Delegation Request signature',N'اعتماد طلب تفويض موظف',501,N'/WorkFlow/EmployeeDelegationRequestsignature',N'Index','fa fa-thumb-tack',N'get',29,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(1022,1)
Go

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15422,N'اعتماد طلب تفويض موظف',N'Employee Delegation Request signature',1022,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15423,N'عرض اعتماد طلب تفويض موظف',N'View Employee Delegation Request signature',1022,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15424,N'تعديل اعتماد طلب تفويض موظف',N'Edit Employee Delegation Request signature',1022,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15425,N'حفظ اعتماد طلب تفويض موظف',N'Save Employee Delegation Request signature',1022,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15426,N'حفظ متعدد للاعتماد',N'Multiple Save',1022,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15427,N'ارجاع الطلب',N'Inverse Request',1022,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15428,N'اختيار كل الطلبات',N'Choose All Requests',1022,2)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1284,N'WorkFlow',N'EmployeeDelegationRequestsignature',N'Index',0,N'get',15422)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1285,N'WorkFlow',N'EmployeeDelegationRequestsignature',N'EmployeeDelegationRequestsignature_Read',0,N'post',15423)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1286,N'WorkFlow',N'EmployeeDelegationRequestsignature',N'Save',2,N'get',15424)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1287,N'WorkFlow',N'EmployeeDelegationRequestsignature',N'Save',0,N'post',15425)
Go

INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId], [ConfigDescription]) VALUES (N'WfAddRequestToWorkWithEmployeeDelegation', N'Add Request To Work With Employee Delegation', N'إضافة طلب للعمل مع تفويض الموظفين', N'false', 15, 2, 1, 1, NULL, NULL, NULL, N'اضافة طلب بحيث لا يعمل بالتفويض الا بعد الموافقه على الطلب')
Go
--------------------------End 2023-10-24-----------------------

