
    UPDATE [SecurityPrivilege]
SET [SystemMenuCode]=335
WHERE ID = 3449;
GO

    UPDATE [SecurityPrivilege]
SET [DescriptionAR] = N'عرض سجل الموظف', [DescriptionEN]= 'View Employee History'
WHERE [ID] = 3450;
GO

SET IDENTITY_INSERT [dbo].[EmailTemplateType] ON 
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode]) VALUES (142, N'Transfer Request Sending', N'ارسال طلب تحويل', 0, 1)
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode]) VALUES (143, N'Transfer Request Accept', N'الموافقة على طلب تحويل ', 0, 1)
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode]) VALUES (144, N'Transfer Request Refuse', N'رفض طلب تحويل', 0, 1)
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode]) VALUES (145, N'Transfer Request Cancellation', N'الغاء طلب تحويل', 0, 1)
GO
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 (142, N'Transfer Request Sending', N'ارسال طلب تحويل', 142, N'ارسال طلب تحويل', N'نرجو الموافقة على طلب التحويل', 1, NULL)
INSERT [dbo].[EmailTemplate] ([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES (143, N'Transfer Request Accept', N'الموافقة على طلب تحويل', 143, N'اعتماد طلب تحويل', N'<p>تمت الموافقة</p>', 1, NULL)
INSERT [dbo].[EmailTemplate] ([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES (144, N'Transfer Request Refuse', N'رفض طلب تحويل', 144, N'رفض طلب تحويل', N'تم رفض الطلب', 1, NULL)
INSERT [dbo].[EmailTemplate] ([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES (145, N'Transfer Request Cancellation', N' إلغاء طلب تحويل', 145, N'إلغاء طلب تحويل', N'تم إلغاء الطلب', 1, NULL)
GO
SET IDENTITY_INSERT [dbo].[EmailTemplateType] OFF
GO


INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3453, N'ارجاع طلب  تحويل موظف', N'Inverse  Transfer Employee Request', 336, 2)
GO
INSERT [dbo].[WF_Track] ([TrackId], [TrackName], [TrackNameEn], [RequestTypeId], [IsOrdered], [IsBridge], [IsDefault], [VacationCode], [IsOverloadBudget]) VALUES (2047, N'طلب تحويل من قسم', N'Transfer request from department', 25, 0, 0, 0, NULL, 0)
GO

   --------------------------------End 2019-11-11----------------------------

   --------------------------------Ali 2019-11-12----------------------------
   INSERT [dbo].[WF_RequestType] ([RequestTypeId], [RequestTypeName], [RequestTypeNameEn], [IsEditable], [SenderUserName], [SenderFrom], [SenderPassword], [SenderHostName], [SenderPort], [SenderName], [SubmitBeforRequestDate], [SubmitAfterRequestDate]) VALUES (25, N'طلب نقل موظف', N'TransferEmployeeRequest', 0, N'sayedmustafa1984@gmail.com', N'sayedmustafa1984@gmail.com', N'123', N'smtp.sendgrid.net', 587, N'Sayed', NULL, NULL)
Go
       UPDATE [SystemMenu]
SET [Name] = 'Transfer Employee Request', [Arabic_Name]= N'طلب نقل موظف'
WHERE [SystemMenuCode] = 335;
Go

    UPDATE [SystemMenu]
SET [Name] = 'Transfer Employee Request Signature', [Arabic_Name]= N'اعتماد طلب نقل موظف'
WHERE [SystemMenuCode] = 336;
Go


      UPDATE [SecurityPrivilege]
SET [DescriptionEN] = 'Transfer Employee Request', [DescriptionAR]= N'طلب نقل موظف'
WHERE [ID] = 3438;
Go

      UPDATE [SecurityPrivilege]
SET [DescriptionEN] = 'View Transfer Employee Request', [DescriptionAR]= N'عرض طلب نقل موظف'
WHERE [ID] = 3439;
Go

      UPDATE [SecurityPrivilege]
SET [DescriptionEN] = 'Add Transfer Employee Request', [DescriptionAR]= N'اضافة طلب نقل موظف'
WHERE [ID] = 3440;
Go
      UPDATE [SecurityPrivilege]
SET [DescriptionEN] = 'Edit Transfer Employee Request', [DescriptionAR]= N'تعديل طلب نقل موظف'
WHERE [ID] = 3441;
Go
      UPDATE [SecurityPrivilege]
SET [DescriptionEN] = 'Save Transfer Employee Request', [DescriptionAR]= N'حفظ طلب نقل موظف'
WHERE [ID] = 3442;
Go
      UPDATE [SecurityPrivilege]
SET [DescriptionEN] = 'Delete Transfer Employee Request', [DescriptionAR]= N'حذف طلب نقل موظف'
WHERE [ID] = 3443;
Go

      UPDATE [SecurityPrivilege]
SET [DescriptionEN] = 'Transfer Employee Request Signature', [DescriptionAR]= N'اعتماد طلب نقل موظف'
WHERE [ID] = 3444;
Go
      UPDATE [SecurityPrivilege]
SET [DescriptionEN] = 'View Transfer Employee Request Signature', [DescriptionAR]= N'عرض اعتماد طلب نقل موظف'
WHERE [ID] = 3445;
Go
      UPDATE [SecurityPrivilege]
SET [DescriptionEN] = 'Edit Transfer Employee Request Signature', [DescriptionAR]= N'تعديل اعتماد طلب نقل موظف'
WHERE [ID] = 3446;
Go
      UPDATE [SecurityPrivilege]
SET [DescriptionEN] = 'Save Transfer Employee Request Signature', [DescriptionAR]= N'حفظ اعتماد طلب نقل موظف'
WHERE [ID] = 3447;
Go
      UPDATE [SecurityPrivilege]
SET [DescriptionEN] = 'Multiple Save Transfer Employee Request Signature', [DescriptionAR]= N'حفظ متعدد اعتماد طلب نقل موظف'
WHERE [ID] = 3448;
Go
      UPDATE [SecurityPrivilege]
SET [DescriptionEN] = 'Cancel Transfer Employee Request', [DescriptionAR]= N'الغاء طلب نقل موظف'
WHERE [ID] = 3449;
Go
      UPDATE [SecurityPrivilege]
SET [DescriptionEN] = 'Inverse Transfer Employee Request', [DescriptionAR]= N'ارجاع طلب نقل موظف'
WHERE [ID] = 3453;
Go
   --------------------------------End 2019-11-12----------------------------
    --------------------------------Hammad 2019-11-17-------------------------
   
CREATE procedure [dbo].[GetPendingTransaction] 
(
    @AuthorityExportCode int
)
AS
with TBLHistory as(select max(ChangeDate) as LastChangeDate,TransactionCode from AC_TransactionHistory 

group by TransactionCode)

select TransactionCode from  AC_TransactionHistory
where AC_TransactionHistory.ChangeDate in (select LastChangeDate from TBLHistory)
and AuthorityExportCode=@AuthorityExportCode


GO
   --------------------------------End 2019-11-17-------------------------

--------------------------------Ali 2019-11-17-------------------------
   ALTER TABLE WF_TransferRequest  
DROP CONSTRAINT FK_WF_TransferRequest_Location_New ,FK_WF_TransferRequest_Location_Old   
GO  


ALTER TABLE WF_TransferRequest
DROP COLUMN NewLocationCode ,OldLocationCode;
Go

 ALTER TABLE WF_TransferRequest
ADD OldDivisionCode nvarchar(2) NOT NULL , NewDivisionCode nvarchar(2) NOT NULL
Go

ALTER TABLE [dbo].[WF_TransferRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_TransferRequest_Division_New] FOREIGN KEY([NewDivisionCode])
REFERENCES [dbo].[Divisions] ([DivisionCode])
GO

ALTER TABLE [dbo].[WF_TransferRequest] CHECK CONSTRAINT [FK_WF_TransferRequest_Division_New]
GO

ALTER TABLE [dbo].[WF_TransferRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_TransferRequest_Division_Old] FOREIGN KEY([OldDivisionCode])
REFERENCES [dbo].[Divisions] ([DivisionCode])
GO

ALTER TABLE [dbo].[WF_TransferRequest] CHECK CONSTRAINT [FK_WF_TransferRequest_Division_Old]
GO

 --------------------------------End 2019-11-17-------------------------