﻿-------------------------MOstafa  2022-09-11--------
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (568, NULL, NULL, N'ArcEmpDocument', N'Get', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (569, NULL, NULL, N'ArcEmpDocument', N'GetById', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (570, NULL, NULL, N'ArcEmpDocument', N'Put', N'Put')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (571, NULL, NULL, N'ArcEmpDocument', N'Post', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (572, NULL, NULL, N'ArcEmpDocument', N'Delete', N'Delete')
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (766, 568, 9025, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (767, 569, 9027, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (768, 570, 9027, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (769, 571, 9029, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (770, 572, 9028, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (574, NULL, NULL, N'ArcEmpDocumentType', N'GetArcEmpDocumentType', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (575, NULL, NULL, N'ArcEmpDocumentType', N'Get', N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (576, NULL, NULL, N'ArcEmpDocumentType', N'Put', N'Put')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (577, NULL, NULL, N'ArcEmpDocumentType', N'Post', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (578, NULL, NULL, N'ArcEmpDocumentType', N'Delete', N'Delete')
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (772, 574, 9019, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (773, 575, 9021, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (774, 576, 9021, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (775, 577, 9023, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (776, 578, 9022, NULL)
GO
-------------------------End  2022-09-11--------
-------------------------Mostafa  2022-09-13--------

 INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'Trgt_KPIItemsOnlyForManagerCategories',N'KPI Items Only For Manager Categories',N'عناصر مؤشر اداء فقط لفئات المدير',N'True',10,23,1,1,Null,Null,Null)
Go
-------------------------end  2022-09-13--------
-------------------------Mostafa  2022-09-14--------
CREATE TABLE [dbo].[WF_TrackLevels](
	[TrackLevelId] [int] IDENTITY(1,1) NOT NULL,
	[TrackId] [int] NOT NULL,
	[LevelCode] [tinyint] NOT NULL,
 CONSTRAINT [PK_WF_TrackLevels] PRIMARY KEY CLUSTERED 
(
	[TrackLevelId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[WF_TrackLevels]  WITH CHECK ADD  CONSTRAINT [FK_WF_TrackLevels_Levels] FOREIGN KEY([LevelCode])
REFERENCES [dbo].[Levels] ([LevelCode])
GO
ALTER TABLE [dbo].[WF_TrackLevels] CHECK CONSTRAINT [FK_WF_TrackLevels_Levels]
GO
ALTER TABLE [dbo].[WF_TrackLevels]  WITH CHECK ADD  CONSTRAINT [FK_WF_TrackLevels_WF_Track] FOREIGN KEY([TrackId])
REFERENCES [dbo].[WF_Track] ([TrackId])
GO
ALTER TABLE [dbo].[WF_TrackLevels] CHECK CONSTRAINT [FK_WF_TrackLevels_WF_Track]
GO
-------------------------End  2022-09-13--------
-------------------------Ali  2022-09-13--------

 INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'AppWorkingWithNotifEvaluationElements',N'Working with Notification For Evaluation Elements',N'العمل بنظام التنبيهات لعناصر التقييم',N'false',10,24,1,1,Null,Null,Null)
Go
-------------------------End  2022-09-13--------
--------------------------Mostafa 2022-09-15-----------------------------
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(648,N'Employee Evaluation',N'تقييم الموظفين',161,N'',N'','fa fa-thumb-tack',N'',24,1,1)
Go
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(648,8)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(10136,N'تقييم الموظفين',N'Employee Evaluation',648,1)
Go
Update [dbo].[SystemMenu] Set ParentID=648,ControllerName=N'/Appraisal/EmployeeEvaluationItem',ActionName=N'Index',ImageURL='',HTTPMethod=N'get',Sequence=1,IsVisible=1,ShowInPrivilegePage=1
 Where  SystemMenuCode= 191
Go
delete from [dbo].[SystemMenuModule]
 Where  SystemMenuCode =191
Go
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(191,8)
Update [dbo].[SystemMenu] Set ParentID=648,ControllerName=N'/Appraisal/EmployeeEvaluationStatus',ActionName=N'Index',ImageURL='',HTTPMethod=N'get',Sequence=2,IsVisible=1,ShowInPrivilegePage=1
 Where  SystemMenuCode= 192
Go
delete from [dbo].[SystemMenuModule]
 Where  SystemMenuCode =192
Go
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(192,8)

Update [dbo].[SystemMenu] Set ParentID=648,ControllerName=N'/Appraisal/EvaluationComment',ActionName=N'Index',ImageURL='',HTTPMethod=N'get',Sequence=3,IsVisible=1,ShowInPrivilegePage=1
 Where  SystemMenuCode= 243
Go
delete from [dbo].[SystemMenuModule]
 Where  SystemMenuCode =243
Go
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(243,8)

Update [dbo].[SystemMenu] Set ParentID=648,ControllerName=N'/Appraisal/CalculationAnnualWorkIncentive',ActionName=N'Index',ImageURL='fa fa-thumb-tack',HTTPMethod=N'get',Sequence=4,IsVisible=1,ShowInPrivilegePage=1
 Where  SystemMenuCode= 566
Go
delete from [dbo].[SystemMenuModule]
 Where  SystemMenuCode =566
Go
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(566,8)

Update [dbo].[SystemMenu] Set ParentID=648,ControllerName=N'/Appraisal/AttendanceEvaluation',ActionName=N'Index',ImageURL='',HTTPMethod=N'get',Sequence=5,IsVisible=1,ShowInPrivilegePage=1
 Where  SystemMenuCode= 245
Go
delete from [dbo].[SystemMenuModule]
 Where  SystemMenuCode =245
Go
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(245,8)

Update [dbo].[SystemMenu] Set ParentID=648,ControllerName=N'/Appraisal/CalculatingAnnualIncrease',ActionName=N'Index',ImageURL='fa fa-thumb-tack',HTTPMethod=N'get',Sequence=6,IsVisible=1,ShowInPrivilegePage=1
 Where  SystemMenuCode= 567
Go
delete from [dbo].[SystemMenuModule]
 Where  SystemMenuCode =567
Go
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(567,8)
--------------------------End 2022-09-15-----------------------------
--------------------------Hammad 2022-09-18-----------------------------
update ConfigParameter set ConfigKey='APPKPIItemsOnlyForManagerCategories' where ConfigKey='Trgt_KPIItemsOnlyForManagerCategories'
--------------------------End 2022-09-18-----------------------------

--------------------------Mostafa 2022-09-18-----------------------------

 INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'WFTrackAdministrativeStructureRequest',N'Use Track administrative structure of request',N'توجيه مسار الإعتماد طبقاً للهيكل الإداري الخاص للطلب',N'False',2,33,1,1,Null,Null,5)
Go
--------------------------End 2022-09-18-----------------------------
--------------------------Hammad 2022-09-18-----------------------------

SET IDENTITY_INSERT [dbo].[EmailTemplateType] ON 
GO
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode], [RequestTypeCode], [HaveUserAccount]) 
VALUES (333, N'Send Notification To Manger For Create Appraisal Element  ', N'  إرسال التنبيه الى الادارات لانشاء العناصر', 0, 8, NULL, 1)
GO
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode], [RequestTypeCode], [HaveUserAccount]) 
VALUES (334, N'Send Notification To Employees To See Appraisal Element', 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'Send Notification To Manger For Create Appraisal Element  ', N'  إرسال التنبيه الى الادارات لانشاء العناصر', 333, N'  إرسال التنبيه الى الادارات لانشاء العناصر', N'  إرسال التنبيه الى الادارات لانشاء العناصر', 1, NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[EmailTemplate] ([Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode], [GeneralTypeCode], [JobTypeCode], [MessageTemplate])
 VALUES (N'Send Notification To Employees To See Appraisal Element', N'ارسال تنبية  الى الموظفين للاطلاع على العناصر', 334, N'ارسال تنبية  الى الموظفين للاطلاع على العناصر', N'ارسال تنبية  الى الموظفين للاطلاع على العناصر', 1, NULL, NULL, NULL, NULL)
GO
--------------------------End 2022-09-18-----------------------------
--------------------------Ali 2022-09-19-----------------------------

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(647,N'Approval Evaluation elements for employee',N'إعتماد عناصر التقيم للموظف',161,N'/Appraisal/ApprovalEvaluationElementsEmployee',N'Index','fa fa-thumb-tack',N'get',23,1,1)
Go

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

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(10130,N'إعتماد عناصر التقيم للموظف',N'Approval Evaluation elements for employee',647,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(10131,N'عرض إعتماد عناصر التقيم للموظف',N'View Approval Evaluation elements for employee',647,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(10132,N'إضافة إعتماد عناصر التقيم للموظف',N'Add Approval Evaluation elements for employee',647,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(10133,N'تعديل إعتماد عناصر التقيم للموظف',N'Edit Approval Evaluation elements for employee',647,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(10134,N'حذف إعتماد عناصر التقيم للموظف',N'Delete Approval Evaluation elements for employee',647,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(10135,N'حفظ إعتماد عناصر التقيم للموظف',N'Save Approval Evaluation elements for employee',647,2)
Go
--------------------------End 2022-09-19-----------------------------
--------------------------MOstafa 2022-09-19-----------------------------
update  [SystemMenu] set Sequence=7 where SystemMenuCode=648
Go
--------------------------End 2022-09-19-----------------------------