﻿  
    -----------------------AK 2021-09-28------------------------------------
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])VALUES(553,N'Program Title Type',N'نوع عنوان البرنامج',422,N'/WFAcademic/ProgramTitleType',N'Index',N'fa fa-thumb-tack',N'get',37,1,1)
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])VALUES(554,N'School Title Type',N'نوع عنوان المدرسة',422,N'/WFAcademic/SchoolTitleType',N'Index',N'fa fa-thumb-tack',N'get',38,1,1)

INSERT[dbo].[SystemMenuModule]([SystemMenuCode], [AppModuleCode]) VALUES(553,16)
INSERT[dbo].[SystemMenuModule]([SystemMenuCode], [AppModuleCode]) VALUES(554,16)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15216,N'نوع عنوان البرنامج الأكاديمي',N'Academic Program Title Type',553,1)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15217,N'عرض نوع عنوان البرنامج الأكاديمي',N'View Academic Program Title Type',553,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15218,N'إضافة نوع عنوان البرنامج الأكاديمي',N'Add Academic Program Title Type',553,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15219,N'تعديل نوع عنوان البرنامج الأكاديمي',N'Edit Academic Program Title Type',553,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15220,N'حذف نوع عنوان البرنامج الأكاديمي',N'Delete Academic Program Title Type',553,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15221,N'حفظ نوع عنوان البرنامج الأكاديمي',N'Save Academic Program Title Type',553,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15222,N'نوع عنوان المدرسة الأكاديمية',N'Academic School Title Type',554,1)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15223,N'عرض نوع عنوان المدرسة الأكاديمية',N'View Academic School Title Type',554,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15224,N'إضافة نوع عنوان المدرسة الأكاديمية',N'Add Academic School Title Type',554,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15225,N'تعديل نوع عنوان المدرسة الأكاديمية',N'Edit Academic School Title Type',554,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15226,N'حذف نوع عنوان المدرسة الأكاديمية',N'Delete Academic School Title Type',554,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15227,N'حفظ نوع عنوان المدرسة الأكاديمية',N'Save Academic School Title Type',554,2)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(824,N'WFAcademic',N'ProgramTitleType',N'Index',N'0',N'get',15216)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(825,N'WFAcademic',N'ProgramTitleType',N'AcademicProgramTitleType_Read',N'0',N'post',15217)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(826,N'WFAcademic',N'ProgramTitleType',N'Save',N'1',N'get',15218)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(827,N'WFAcademic',N'ProgramTitleType',N'Save',N'2',N'post',15219)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(828,N'WFAcademic',N'ProgramTitleType',N'Delete',N'0',N'post',15220)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(829,N'WFAcademic',N'ProgramTitleType',N'Save',N'0',N'post',15221)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(830,N'WFAcademic',N'SchoolTitleType',N'Index',N'0',N'get',15222)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(831,N'WFAcademic',N'SchoolTitleType',N'GetAcademicSchoolTitleType_Read',N'0',N'post',15223)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(832,N'WFAcademic',N'SchoolTitleType',N'Save',N'1',N'get',15224)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(833,N'WFAcademic',N'SchoolTitleType',N'Save',N'2',N'post',15225)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(834,N'WFAcademic',N'SchoolTitleType',N'Delete',N'0',N'post',15226)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(835,N'WFAcademic',N'SchoolTitleType',N'Save',N'0',N'post',15227)

Go
  -----------------------End 2021-09-28------------------------------------

  --------------------------Hammad 2021-09-29-------------------------

ALTER TABLE dbo.WF_EmployeeTrack ADD
	UserId int NULL
GO
ALTER TABLE WF_EmployeeTrack
ALTER COLUMN EmployeeId int  NULL
GO
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
 VALUES (563, N'User Request Track  ', N'مسارات المستخدمين', 28, N'/WorkFlow/UserRequestTrack', N'Index', N'fa fa-thumb-tack', N'get', 28, 1, 1)
 Go
 INSERT [dbo].[SystemMenuModule] ([SystemMenuCode], [AppModuleCode]) VALUES (563, 1)
 Go
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15243, N'مسارات المستخدمين', N'User Request Track', 563, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15244, N'عرض مسارات المستخدمين ', N'View User Request Track', 563, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15245, N'حفظ مسارات المستخدمين', N'Save User Request Track', 563, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15246, N'إضافة مسارات المستخدمين', N'Add User Request Track', 563, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15247, N'تعديل مسارات المستخدمين', N'Edit User Request Track', 563, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15248, N'حذف مسارات المستخدمين', N'Delete User Request Track', 563, 2)

Go
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
 VALUES (N'StoreRequestTrackByUser', N' Store Request Track By User', N'مسار طلب المخزن بواسطه المستخدم', N'true', 2, 1, 1, 1, NULL, NULL, 28)
 --------------------------Hammad 2021-09-29-------------------------