﻿-----------------------Hammad 2021-03-30---------------------------------------

 INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13070, N'  إغلاق  الحضور والانصراف', N'  Close Attendance ', 449, 2)
 Go
 -----------------------eND 2021-03-30---------------------------------------
 

-----------------------------Ali 2021-03-18-----------------------------


INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1254, N'عرض تفاصيل طلب الملف البحثى', N'Research Profile Request View Details', 3, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1255, N'عرض تفاصيل طلب المنشور', N'Publication Request View Details', 3, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1256, N'عرض تفاصيل طلب النشاط العلمى', N'Scientific Activity Request View Details', 3, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1257, N'عرض تفاصيل طلب اللجنة', N'Committee Request View Details', 3, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1258, N'عرض تفاصيل طلب التطوير المهني وخدمات المجتمع', N'Prof Dev Community Service Request View Details', 3, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1259, N'عرض تفاصيل طلب لجائزة', N'Award Request View Details', 3, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1260, N'عرض تفاصيل طلب المنح', N'Sponser Request View Details', 3, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1261, N'عرض تفاصيل طلب الإشراف على الانشطة المشتركة', N'Co-Extra Curricular Activity Request View Details', 3, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1262, N'عرض تفاصيل طلب الإشراف على الدرسات العليا', N'PG Supervision Request View Details', 3, 2)
Go

-----------------------------End 2021-03-18-----------------------------
-----------------------------Ali 2021-03-28-----------------------------

INSERT [dbo].[Academic_Institutes] ([InstituteCode], [Name], [Arabic_Name], [Audit_CreatedBy], [Audit_CreationDate], [Audit_ModifiedBy], [Audit_ModificationDate]) VALUES (1, N'NU', N'NU', 1025, CAST(N'2021-01-13T08:38:30.480' AS DateTime), NULL, NULL)
Go




INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(473,N'Scopus Category',N'Scopus Category',422,N'/WFAcademic/ScopusCategory',N'Index','fa fa-thumb-tack',N'get',35,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(473,1)
Go

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(3975,N'Scopus Category',N'Scopus Category',473,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(3976,N'عرض Scopus Category',N'View Scopus Category',473,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(3977,N'إضافة Scopus Category',N'Add Scopus Category',473,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(3978,N'تعديل Scopus Category',N'Edit Scopus Category',473,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(3979,N'حذف Scopus Category',N'Delete Scopus Category',473,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(3980,N'حفظ Scopus Category',N'Save Scopus Category',473,2)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(609,N'WFAcademic',N'ScopusCategory',N'Index',0,N'get',3975)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(610,N'WFAcademic',N'ScopusCategory',N'ScopusCategory_Read',0,N'post',3976)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(611,N'WFAcademic',N'ScopusCategory',N'Save',1,N'get',3977)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(612,N'WFAcademic',N'ScopusCategory',N'Save',2,N'get',3978)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(613,N'WFAcademic',N'ScopusCategory',N'Delete',0,N'post',3979)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(614,N'WFAcademic',N'ScopusCategory',N'Save',0,N'post',3980)
Go



-----------------------------End 2021-03-28-----------------------------
  -----------------------Hammad 2021-03-28------------------------------------
  
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(474,N'Relevance Type',N'نوع الصلة',422,N'/WFAcademic/RelevanceType',N'Index','fa fa-thumb-tack',N'get',36,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(474,1)
Go

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(3981,N'نوع الصلة',N'Relevance Type',474,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(3982,N'عرض نوع الصلة',N'View Relevance Type',474,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(3983,N'إضافة نوع الصلة',N'Add Relevance Type',474,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(3984,N'تعديل نوع الصلة',N'Edit Relevance Type',474,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(3985,N'حذف نوع الصلة',N'Delete Relevance Type',474,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(3986,N'حفظ نوع الصلة',N'Save Relevance Type',474,2)
Go



INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(615,N'WFAcademic',N'RelevanceType',N'Index',0,N'get',3981)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(616,N'WFAcademic',N'RelevanceType',N'RelevanceType_Read',0,N'post',3982)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(617,N'WFAcademic',N'RelevanceType',N'Save',1,N'get',3983)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(618,N'WFAcademic',N'RelevanceType',N'Save',2,N'get',3984)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(619,N'WFAcademic',N'RelevanceType',N'Delete',0,N'post',3985)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(620,N'WFAcademic',N'RelevanceType',N'Save',0,N'post',3986)
Go
  -----------------------End 2021-03-28------------------------------------
  -----------------------Ali 2021-03-29------------------------------------

  SET IDENTITY_INSERT [dbo].[Academic_ScopusCategories] ON 

INSERT [dbo].[Academic_ScopusCategories] ([ScopusCategoryCode], [Name], [Arabic_Name], [Audit_CreatedBy], [Audit_CreationDate], [Audit_ModifiedBy], [Audit_ModificationDate]) VALUES (1, N'Scopus Q1 Category', N'Scopus Q1 Category', 1, CAST(N'2021-03-29T12:30:49.137' AS DateTime), NULL, NULL)
INSERT [dbo].[Academic_ScopusCategories] ([ScopusCategoryCode], [Name], [Arabic_Name], [Audit_CreatedBy], [Audit_CreationDate], [Audit_ModifiedBy], [Audit_ModificationDate]) VALUES (2, N'Scopus Q2 Category', N'Scopus Q2 Category', 1, CAST(N'2021-03-29T12:38:44.690' AS DateTime), NULL, NULL)
INSERT [dbo].[Academic_ScopusCategories] ([ScopusCategoryCode], [Name], [Arabic_Name], [Audit_CreatedBy], [Audit_CreationDate], [Audit_ModifiedBy], [Audit_ModificationDate]) VALUES (3, N'Scopus Category (not Q1, Q2)', N'Scopus Category (not Q1, Q2)', 1, CAST(N'2021-03-29T12:39:46.083' AS DateTime), NULL, NULL)
INSERT [dbo].[Academic_ScopusCategories] ([ScopusCategoryCode], [Name], [Arabic_Name], [Audit_CreatedBy], [Audit_CreationDate], [Audit_ModifiedBy], [Audit_ModificationDate]) VALUES (4, N'Journals (Scholar but not-Scopus)', N'Journals (Scholar but not-Scopus)', 1, CAST(N'2021-03-29T12:40:15.143' AS DateTime), NULL, NULL)

SET IDENTITY_INSERT [dbo].[Academic_ScopusCategories] OFF
Go
  -----------------------End 2021-03-29------------------------------------