﻿
 -------------------------------------- M.Negm 2024-10-13 ------------------------ 

 
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 (67,N'طلب تسكين موظف على مساحة بصمة ',N'Finger Area Employee 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'FingerAreaEmployeeRequestSignature', 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(478,N'Finger Area Employee Request Sending',N'ارسال طلب تسكين موظف على مساحة بصمة',0,1,67, 1 )
INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode],[RequestTypeCode],[HaveUserAccount])
VALUES(479,N'Finger Area Employee Request Accept',N'الموافقة على طلب تسكين موظف على مساحة بصمة',0,1,67, 1 )
INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode],[RequestTypeCode],[HaveUserAccount])
VALUES(480,N'Finger Area Employee Request Refuse',N'رفض طلب تسكين موظف على مساحة بصمة',0,1,67, 1 )
INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode],[RequestTypeCode],[HaveUserAccount])
VALUES(481,N'Finger Area Employee Request Cancel',N'الغاء طلب تسكين موظف على مساحة بصمة',0,1,67, 1 )
INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode],[RequestTypeCode],[HaveUserAccount])
VALUES(482,N'Send Notification AFter Track',N' ارسال اشعار بعد نهاية المسار',0,1,67, 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(4389,N'Finger Area Employee Request Sending',N'ارسال طلب تسكين موظف على مساحة بصمة',478,N'ارسال',N'ارسال',1,NULL)
INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode])
VALUES(4390,N'Finger Area Employee Request Accept',N'الموافقة على طلب تسكين موظف على مساحة بصمة',479,N'الموافقة على',N'الموافقة على',1,NULL)
INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode])
VALUES(4391,N'Finger Area Employee Request Refuse',N'رفض طلب تسكين موظف على مساحة بصمة',480,N'رفض',N'رفض',1,NULL)
INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode])
VALUES(4392,N'Finger Area Employee Request Cancel',N'الغاء طلب تسكين موظف على مساحة بصمة',481,N'الغاء',N'الغاء',1,NULL)
INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode])
VALUES(4393,N'Send Notification AFter Track',N'ارسال اشعار بعد نهاية المسار',482,N'ارسال اشعار بعد نهاية المسار',N'ارسال اشعار بعد نهاية المسار',1,NULL)
SET IDENTITY_INSERT [dbo].[EmailTemplate] OFF
GO

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1491,N'WorkFlow', NULL,N'FingerAreaEmployeeRequest',N'Post',N'Post')
Go

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1840,1491,13149 ,67)
Go
 -------------------------------------- End 2024-10-13 ------------------------
 -------------------------------------- Hammad 2024-10-21 ---------------------
 INSERT INTO SecurityUserDetail (SecurityUserID,PrivilegeID)
SELECT su.SecurityUserCode, 13149
FROM SecurityUser su
where AttendByMobile=1 
and (select count(*)from SecurityUserDetail as detail where detail.SecurityUserID=su.SecurityUserCode and detail.PrivilegeID=13149) =0
Go
 -------------------------------------- End 2024-10-21 ------------------------

  -------------------------------------- M.Negm 2024-10-22 ---------------------
 update [SecurityPrivilegeEndPoints] set  [ApiName] = Null where [Id]=1491
Go
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(1098,N'FingerArea Employee Request Signature',N'اعتماد طلب تسكين موظف على مساحة بصمة ',503,N'/WorkFlow/FingerAreaEmployeeRequestSignature',N'Index','fa fa-thumb-tack',N'get',8,1,1)
Go
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(1098,1)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType])
VALUES(15496,N'اعتماد طلب تسكين موظف على مساحة بصمة',N'FingerArea Employee Request Signature',1098,1)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) 
VALUES(15497,N'عرض اعتماد تسكين موظف على مساحة بصمة',N'View FingerArea Employee Request Signature',1098,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType])
VALUES(15498,N'تعديل اعتماد تسكين موظف على مساحة بصمة',N'Edit FingerArea Employee Request Signature',1098,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) 
VALUES(15499,N'حفظ اعتماد تسكين موظف على مساحة بصمة',N'Save FingerArea Employee Request Signature',1098,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType])
VALUES(15500,N'حفظ متعدد للاعتماد',N'Multiple Save',1098,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType])
VALUES(15501,N'عرض سجل الموظف',N'View Employee History',1098,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType])
VALUES(15502,N'ارجاع الطلب',N'Inverse Request',1098,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType])
VALUES(15503,N'اختيار كل الطلبات',N'Choose All Requests',1098,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType])
VALUES(15504,N'الغاء طلب تسكين موظف على مساحة بصمة',N'FingerArea Employee Request',1098,2)
GO

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(2049,N'WorkFlow',N'FingerAreaEmployeeRequestSignature',N'Index',0,N'get',15496)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(2050,N'WorkFlow',N'FingerAreaEmployeeRequestSignature',N'FingerAreaEmployeeRequestSignature_Read',0,N'post',15497)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(2051,N'WorkFlow',N'FingerAreaEmployeeRequestSignature',N'Save',2,N'get',15498)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(2052,N'WorkFlow',N'FingerAreaEmployeeRequestSignature',N'Save',0,N'post',15499)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1847, 12, 15504, 67)
GO

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (1848, 9, 15497, 67)
GO

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (1849, 10, 15497, 67)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (1850, 13, 15499, 67)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (1851, 11, 15501, 67)
Go
 -------------------------------------- End 2024-10-22 ------------------------
  -------------------------------------- Hammad 2024-10-22 ---------------------
 delete ConfigParameter where ConfigKey='VacCheckEmpHaveFingerprint'
 Go
  -------------------------------------- End 2024-10-22 ------------------------

    -------------------------------------- M.Negm 2024-10-23 ---------------------

SET IDENTITY_INSERT[dbo].[EmailTemplateType] ON
INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode],[RequestTypeCode],[HaveUserAccount])
VALUES(483,N'Penalty Request Delete',N'حذف طلب الجزاء ',0,1,13, 1 )
go
INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode],[RequestTypeCode],[HaveUserAccount])
VALUES(484,N'vacation  Request Delete',N'حذف طلب الاجازة  ',0,1,11, 1 )
go 
INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode],[RequestTypeCode],[HaveUserAccount])
VALUES(485,N'Permission Request Delete',N'حذف طلب الاذن   ',0,1,2, 1 )
go 
SET IDENTITY_INSERT[dbo].[EmailTemplateType] OFF

SET IDENTITY_INSERT [dbo].[EmailTemplate] ON 
INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode])
VALUES(4394,N'Penalty Request Delete',N'حذف طلب الجزاء ',483,N' حذذذذذذذذذف ',N'حذذذذذف',1,NULL)
go 
INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode])
VALUES(4395,N'vacation Request Delete',N'حذف طلب الاجازة ',484,N' حذذذذذذذذذف ',N'حذذذذذف',1,NULL)
go 
INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode])
VALUES(4396,N'Permission Request Delete',N'حذف طلب الاذن ',485,N' حذذذذذذذذذف طلب الاذن ',N' حذذذذذف طلب الاذن ',1,NULL) 
 go 
SET IDENTITY_INSERT [dbo].[EmailTemplate] OFF 
  -------------------------------------- End 2024-10-22 ------------------------

