﻿
--------------------------Ali 2022-09-22-----------------------------

 SET IDENTITY_INSERT [dbo].[EmailTemplateType] ON 
GO
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode], [RequestTypeCode], [HaveUserAccount]) 
VALUES (335, N'Opinion was expressed in the evaluation elements  ', N'  تم ابداء الرأى فى عناصر التقييم ', 0, 8, NULL, 1)
GO
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode], [RequestTypeCode], [HaveUserAccount]) 
VALUES (336, N'Evaluation elements have been approved', N'تمت الموافقه على عناصر التقييم', 0, 8, NULL, 1)
GO
SET IDENTITY_INSERT [dbo].[EmailTemplateType] OFF




INSERT [dbo].[EmailTemplate] ( [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode], [GeneralTypeCode], [JobTypeCode], [MessageTemplate])
 VALUES ( N'Opinion was expressed in the evaluation elements  ', N'   تم ابداء الرأى فى عناصر التقييم', 335, N'   تم ابداء الرأى فى عناصر التقييم', N'   تم ابداء الرأى فى عناصر التقييم', 1, NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[EmailTemplate] ([Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode], [GeneralTypeCode], [JobTypeCode], [MessageTemplate])
 VALUES (N'Evaluation elements have been approved', N'تمت الموافقه على عناصر التقييم', 336, N'تمت الموافقه على عناصر التقييم', N'تمت الموافقه على عناصر التقييم', 1, NULL, NULL, NULL, NULL)
GO
--------------------------End 2022-09-22-----------------------------
--------------------------Ali 2022-09-25-----------------------------

 update SystemMenu set Arabic_Name=N'تقييمي' where SystemMenuCode=649
 Go

 
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(651,N'Approval Evaluation Elements',N'اعتماد عناصر التقييم',161,N'',N'','fa fa-thumb-tack',N'',9,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(651,8)
Go



INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(652,N'Final Approval For Evaluation Elements',N'الاعتماد النهائى لعناصر التقييم',651,N'/Appraisal/ApprovalEvaluationElementFinal',N'Index','fa fa-thumb-tack',N'get',2,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(652,8)
Go

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(10144,N'الاعتماد النهائى لعناصر التقييم',N'Final Approval For Evaluation Elements',652,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(10145,N'عرض الاعتماد النهائى لعناصر التقييم',N'View Final Approval For Evaluation Elements',652,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(10146,N'إضافة الاعتماد النهائى لعناصر التقييم',N'Add Final Approval For Evaluation Elements',652,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(10147,N'تعديل الاعتماد النهائى لعناصر التقييم',N'Edit Final Approval For Evaluation Elements',652,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(10148,N'حذف الاعتماد النهائى لعناصر التقييم',N'Delete Final Approval For Evaluation Elements',652,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(10149,N'حفظ الاعتماد النهائى لعناصر التقييم',N'Save Final Approval For Evaluation Elements',652,2)
Go

Update [dbo].[SystemMenu] Set Sequence=2 where SystemMenuCode=244
Go
Update [dbo].[SystemMenu] Set Sequence=1 where SystemMenuCode=650
Go

Update [dbo].[SystemMenu] Set ParentID=651 ,Sequence=1 where SystemMenuCode=647
Go

--------------------------End 2022-09-25-----------------------------
--------------------------Hammad 2022-09-25-----------------------------
update ConfigParameter set Arabic_Name=N'امكانية التقييم اكثر من الدرجة القصوي' ,Name=N'Possibility to Evaluate More Than The Maximum Degree'
 where ConfigKey='PossibilityApplyingMoreThanTheMaximumDegree' 
 Go
Delete ConfigParameter where ConfigKey='Trgt_KPIItemsOnlyForManagerCategories'
Go
 --------------------------End 2022-09-25-----------------------------