﻿--------------------------Hammad 2021-04-27----------------------
INSERT [dbo].[LabelsName] ([LabelKey], [Name], [Arabic_Name]) VALUES (N'SectionNameAr', N'Section Name Ar', N'اسم القسم بالعربى')
INSERT [dbo].[LabelsName] ([LabelKey], [Name], [Arabic_Name]) VALUES (N'SectionNameEn', N'Section Name En', N'اسم القسم بالانجليزى')
INSERT [dbo].[LabelsName] ([LabelKey], [Name], [Arabic_Name]) VALUES (N'DepartmentNameAr', N'Department Name Ar', N'اسم الادارة بالعربى')
INSERT [dbo].[LabelsName] ([LabelKey], [Name], [Arabic_Name]) VALUES (N'DepartmentNameEn', N'Department Name En', N'اسم الادارة بالانجليزى')
GO
INSERT [dbo].[LabelsName] ([LabelKey], [Name], [Arabic_Name]) VALUES (N'NewDivision', N'New Division', N'القطاع الجديد')
GO
INSERT [dbo].[LabelsName] ([LabelKey], [Name], [Arabic_Name]) VALUES (N'OldDepartment', N'Old Department', N'الادارة القديمة')
GO
INSERT [dbo].[LabelsName] ([LabelKey], [Name], [Arabic_Name]) VALUES (N'OldDivision', N'Old Division', N'القطاع القديم')
GO
DROP TABLE [dbo].[WF_NewEmployeesType]
GO

update SystemMenu set Name=N'Scholarship Type' , Arabic_Name=N'انوع المنح' ,ControllerName='/WorkFlow/ScholarshipType' where SystemMenuCode=491
GO
update SecurityPrivilege set DescriptionEN=N'Scholarship Type',DescriptionAR=N'انوع المنح'  where ID=15027
update SecurityPrivilege set DescriptionEN=N'View Scholarship Type',DescriptionAR=N'عرض انوع المنح'  where ID=15028
update SecurityPrivilege set DescriptionEN=N'Add Scholarship Type',DescriptionAR=N'إضافة انوع المنح'  where ID=15029
update SecurityPrivilege set DescriptionEN=N'Edit Scholarship Type',DescriptionAR=N'تعديل انوع المنح'  where ID=15030
update SecurityPrivilege set DescriptionEN=N'Delete Scholarship Type',DescriptionAR=N'حذف انوع المنح'  where ID=15031
update SecurityPrivilege set DescriptionEN=N'Save Scholarship Type',DescriptionAR=N'حفظ انوع المنح'  where ID=15032
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (698, N'WorkFlow', N'ScholarshipType', N'Index', 0, N'get', 15027)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (699, N'WorkFlow', N'ScholarshipType', N'ScholarshipType_Read', 0, N'post', 15028)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (700, N'WorkFlow', N'ScholarshipType', N'Save', 1, N'get', 15029)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (701, N'WorkFlow', N'ScholarshipType', N'Save', 2, N'get', 15030)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (702, N'WorkFlow', N'ScholarshipType', N'Delete', 0, N'post', 15031)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (703, N'WorkFlow', N'ScholarshipType', N'Save', 0, N'post', 15032)
Go
--------------------------End 2021-04-27----------------------
--------------------------Ali 2021-04-28----------------------

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(508,N'Edit Affiliation Department Or Section Request',N'طلب تعديل تبعية ادارة او قسم',496,N'/WorkFlow/ChangeSectionDepartRequest',N'Index','fa fa-thumb-tack',N'get',12,1,1)
Go


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

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15074,N'طلب تعديل تبعيةادارة او قسم',N'Edit Affiliation Dep Or Sec Request',508,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15075,N'عرض طلب تعديل تبعيةادارة او قسم',N'View Edit Affiliation Dep Or Sec Request',508,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15076,N'إضافة طلب تعديل تبعيةادارة او قسم',N'Add Edit Affiliation Dep Or Sec Request',508,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15077,N'تعديل طلب تعديل تبعيةادارة او قسم',N'Edit Edit Affiliation Dep Or Sec Request',508,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15078,N'حذف طلب تعديل تبعيةادارة او قسم',N'Delete Edit Affiliation Dep Or Sec Request',508,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15079,N'حفظ طلب تعديل تبعيةادارة او قسم',N'Save Edit Affiliation Dep Or Sec Request',508,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15080,N'الغاء طلب تعديل تبعيةادارة او قسم',N'Cancel Edit Affiliation Dep Or Sec Request',508,2)
Go


INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(686,N'WorkFlow',N'ChangeSectionDepartRequest',N'Index',0,N'get',15074)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(687,N'WorkFlow',N'ChangeSectionDepartRequest',N'ChangeSectionDepartRequest_Read',0,N'post',15075)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(688,N'WorkFlow',N'ChangeSectionDepartRequest',N'Save',1,N'get',15076)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(689,N'WorkFlow',N'ChangeSectionDepartRequest',N'Save',2,N'get',15077)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(690,N'WorkFlow',N'ChangeSectionDepartRequest',N'Delete',0,N'post',15078)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(691,N'WorkFlow',N'ChangeSectionDepartRequest',N'Save',0,N'post',15079)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (692, N'WorkFlow', N'ChangeSectionDepartRequest', N'Cancel', 0, N'get', 15080)

INSERT[dbo].[WF_RequestType]([RequestTypeId], [RequestTypeName], [RequestTypeNameEn], [IsEditable], [SenderUserName], [SenderFrom], [SenderPassword], [SenderHostName], [SenderPort], [SenderName], [SubmitBeforRequestDate], [SubmitAfterRequestDate], [IsUsed], [CanDelegation], [DisplayUserName], [HaveAttachment]) VALUES(44,N'طلب تعديل تبعية ادارة او قسم',N'Edit Affiliation Department Or Section Request',0,N'sayedmustafa84@yahoo.com',N'sayedmustafa84@yahoo.com',N'1',N'smtp.sendgrid.net',587,N'SST',NULL,NULL,1,1,0,0)
Go
SET IDENTITY_INSERT[dbo].[EmailTemplateType] ON
INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode]) VALUES(224,N'Edit Affiliation Department Or Section Request Sending',N'ارسال طلب تعديل تبعية ادارة او قسم',0,1)

INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode]) VALUES(225,N'Edit Affiliation Department Or Section Request Accept',N'الموافقة على طلب تعديل تبعية ادارة او قسم',0,1)

INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode]) VALUES(226,N'Edit Affiliation Department Or Section Request Refuse',N'رفض طلب تعديل تبعية ادارة او قسم',0,1)

INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode]) VALUES(227,N'Edit Affiliation Department Or Section Request Cancel',N'الغاء طلب تعديل تبعية ادارة او قسم',0,1)
SET IDENTITY_INSERT [dbo].[EmailTemplateType] OFF
SET IDENTITY_INSERT [dbo].[EmailTemplate] ON 
INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(224,N'Edit Affiliation Department Or Section Request Sending',N'ارسال طلب تعديل تبعية ادارة او قسم',224,N'ارسال',N'ارسال',1,NULL)

INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(225,N'Edit Affiliation Department Or Section Request Accept',N'الموافقة على طلب تعديل تبعية ادارة او قسم',225,N'الموافقة على',N'الموافقة على',1,NULL)

INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(226,N'Edit Affiliation Department Or Section Request Refuse',N'رفض طلب تعديل تبعية ادارة او قسم',226,N'رفض',N'رفض',1,NULL)

INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(227,N'Edit Affiliation Department Or Section Request Cancel',N'الغاء طلب تعديل تبعية ادارة او قسم',227,N'الغاء',N'الغاء',1,NULL)
SET IDENTITY_INSERT [dbo].[EmailTemplate] OFF
Go

-----------------------


INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(509,N'Edit Affiliation Department Or Section Request Signature',N'اعتماد طلب تعديل تبعية ادارة او قسم',501,N'/WorkFlow/ChangeSectionDepartRequestSignature',N'Index','fa fa-thumb-tack',N'get',14,1,1)
Go

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

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15081,N'اعتماد طلب تعديل تبعية ادارة او قسم',N'Edit Affiliation Dep Or Sec Request Signature',509,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15082,N'عرض اعتماد طلب تعديل تبعية ادارة او قسم',N'View Edit Affiliation Dep Or Sec Request Signature',509,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15083,N'تعديل اعتماد طلب تعديل تبعية ادارة او قسم',N'Edit Edit Affiliation Dep Or Sec Request Signature',509,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15084,N'حفظ اعتماد طلب تعديل تبعية ادارة او قسم',N'Save Edit Affiliation Dep Or Sec Request Signature',509,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15085,N'حفظ متعدد للاعتماد',N'Multiple Save',509,2)


INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15087,N'ارجاع الطلب',N'Inverse Request',509,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15088,N'اختيار كل الطلبات',N'Choose All Requests',509,2)

Go


INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(693,N'WorkFlow',N'ChangeSectionDepartRequestSignature',N'Index',0,N'get',15081)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(694,N'WorkFlow',N'ChangeSectionDepartRequestSignature',N'ChangeSectionDepartRequestSignature_Read',0,N'post',15082)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(695,N'WorkFlow',N'ChangeSectionDepartRequestSignature',N'Save',2,N'get',15083)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(696,N'WorkFlow',N'ChangeSectionDepartRequestSignature',N'Save',0,N'post',15084)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(697,N'WorkFlow',N'ChangeSectionDepartRequestSignature',N'SaveRequestSignatureLst',0,N'post',15085)
Go
--------------------------End 2021-04-28----------------------
--------------------------Sayed 2021-04-28--------------------
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) VALUES (N'SyncEmployeeNow', N'Sync All Employee Again ', N'مزامنة كل الموظفين مرة اخرى ', N'false', 3, 14, 1, 1, NULL, NULL, NULL)
GO
--------------------------End 2021-04-28----------------------
--------------------------Hammad 2021-04-28-------------------



INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(512,N'Scholarship Request',N'طلب المنحة دراسية',496,N'/WorkFlow/ScholarshipRequest',N'Index','fa fa-thumb-tack',N'get',14,1,1)
Go

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

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15104,N'طلب المنحة دراسية',N'Scholarship Request',512,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15105,N'عرض طلب المنحة دراسية',N'View Scholarship Request',512,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15106,N'إضافة طلب المنحة دراسية',N'Add Scholarship Request',512,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15107,N'تعديل طلب المنحة دراسية',N'Edit Scholarship Request',512,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15108,N'حذف طلب المنحة دراسية',N'Delete Scholarship Request',512,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15109,N'حفظ طلب المنحة دراسية',N'Save Scholarship Request',512,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15110,N'إلغاء طلب المنحة دراسية',N'Cancel Scholarship Request',512,2)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(716,N'WorkFlow',N'ScholarshipRequest',N'Index',0,N'get',15104)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(717,N'WorkFlow',N'ScholarshipRequest',N'ScholarshipRequest_Read',0,N'post',15105)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(718,N'WorkFlow',N'ScholarshipRequest',N'Save',1,N'get',15106)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(719,N'WorkFlow',N'ScholarshipRequest',N'Save',2,N'get',15107)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(720,N'WorkFlow',N'ScholarshipRequest',N'Delete',0,N'post',15108)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(721,N'WorkFlow',N'ScholarshipRequest',N'Save',0,N'post',15109)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(722,N'WorkFlow',N'ScholarshipRequest',N'Cancel',0,N'post',15110)

Go

INSERT[dbo].[WF_RequestType]([RequestTypeId], [RequestTypeName], [RequestTypeNameEn], [IsEditable], [SenderUserName], [SenderFrom], [SenderPassword], [SenderHostName], [SenderPort], [SenderName], [SubmitBeforRequestDate], [SubmitAfterRequestDate], [IsUsed], [CanDelegation], [DisplayUserName], [HaveAttachment]) VALUES(46,N'طلب المنحة دراسية',N'Scholarship Request',0,N'sayedmustafa84@yahoo.com',N'sayedmustafa84@yahoo.com',N'1',N'smtp.sendgrid.net',587,N'SST',NULL,NULL,1,1,0,0)
Go

SET IDENTITY_INSERT[dbo].[EmailTemplateType] ON
INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode]) VALUES(232,N'Scholarship Request Sending',N'ارسال طلب المنحة دراسية',0,1)

INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode]) VALUES(233,N'Scholarship Request Accept',N'الموافقة على طلب المنحة دراسية',0,1)

INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode]) VALUES(234,N'Scholarship Request Refuse',N'رفض طلب المنحة دراسية',0,1)

INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode]) VALUES(235,N'Scholarship Request Cancel',N'الغاء طلب المنحة دراسية',0,1)
SET IDENTITY_INSERT [dbo].[EmailTemplateType] OFF

SET IDENTITY_INSERT [dbo].[EmailTemplate] ON 
INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(232,N'Scholarship Request Sending',N'ارسال طلب المنحة دراسية',232,N'ارسال',N'ارسال',1,NULL)

INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(233,N'Scholarship Request Accept',N'الموافقة على طلب المنحة دراسية',233,N'الموافقة على',N'الموافقة على',1,NULL)

INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(234,N'Scholarship Request Refuse',N'رفض طلب المنحة دراسية',234,N'رفض',N'رفض',1,NULL)

INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(235,N'Scholarship Request Cancel',N'الغاء طلب المنحة دراسية',235,N'الغاء',N'الغاء',1,NULL)
SET IDENTITY_INSERT [dbo].[EmailTemplate] OFF






INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(513,N'Scholarship Request Signature',N'إعتماد طلب المنحة الدراسية',501,N'/WorkFlow/ScholarshipRequestSignature',N'Index','fa fa-thumb-tack',N'get',16,1,1)
Go

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

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15111,N'إعتماد طلب المنحة الدراسية',N'Scholarship Request Signature',513,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15112,N'عرض إعتماد طلب المنحة الدراسية',N'View Scholarship Request Signature',513,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15113,N'تعديل إعتماد طلب المنحة الدراسية',N'Edit Scholarship Request Signature',513,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15114,N'حفظ إعتماد طلب المنحة الدراسية',N'Save Scholarship Request Signature',513,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15115,N'حفظ متعدد للاعتماد',N'Multiple Save',513,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15116,N'عرض سجل الموظف',N'View Employee History',513,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15117,N'ارجاع الطلب',N'Inverse Request',513,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15118,N'اختيار كل الطلبات',N'Choose All Requests',513,2)
Go




INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(723,N'WorkFlow',N'ScholarshipRequestSignature',N'Index',0,N'get',15111)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(724,N'WorkFlow',N'ScholarshipRequestSignature',N'ScholarshipRequestSignature_Read',0,N'post',15112)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(725,N'WorkFlow',N'ScholarshipRequestSignature',N'Save',2,N'get',15113)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(726,N'WorkFlow',N'ScholarshipRequestSignature',N'Save',0,N'post',15114)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(727,N'WorkFlow',N'ScholarshipRequestSignature',N'SaveRequestSignatureLst',0,N'post',15115)
Go

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(510,N'Medical Insurance Register Request',N'طلب الاشتراك فى التامين الطبى',496,N'/WorkFlow/MedicalInsuranceRegisterRequest',N'Index','fa fa-thumb-tack',N'get',13,1,1)
Go

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

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15089,N'طلب الاشتراك فى التامين الطبى',N'Medical Insurance Register Request',510,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15090,N'عرض طلب الاشتراك فى التامين الطبى',N'View Medical Insurance Register Request',510,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15091,N'إضافة طلب الاشتراك فى التامين الطبى',N'Add Medical Insurance Register Request',510,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15092,N'تعديل طلب الاشتراك فى التامين الطبى',N'Edit Medical Insurance Register Request',510,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15093,N'حذف طلب الاشتراك فى التامين الطبى',N'Delete Medical Insurance Register Request',510,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15094,N'حفظ طلب الاشتراك فى التامين الطبى',N'Save Medical Insurance Register Request',510,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15095,N'الغاء طلب الاشتراك فى التامين الطبى',N'Cancel Medical Insurance Register Request',510,2)
Go
-- SSTAuthorizationActionFilterBefore (script only not added in db Check it and run if you want) 

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(704,N'WorkFlow',N'MedicalInsuranceRegisterRequest',N'Index',0,N'get',15089)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(705,N'WorkFlow',N'MedicalInsuranceRegisterRequest',N'MedicalInsuranceRegisterRequest_Read',0,N'post',15090)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(706,N'WorkFlow',N'MedicalInsuranceRegisterRequest',N'Save',1,N'get',15091)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(707,N'WorkFlow',N'MedicalInsuranceRegisterRequest',N'Save',2,N'get',15092)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(708,N'WorkFlow',N'MedicalInsuranceRegisterRequest',N'Delete',0,N'post',15093)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(709,N'WorkFlow',N'MedicalInsuranceRegisterRequest',N'Save',0,N'post',15094)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (710, N'WorkFlow', N'MedicalInsuranceRegisterRequest', N'Cancel', 0, N'get', 15095)
Go


INSERT[dbo].[WF_RequestType]([RequestTypeId], [RequestTypeName], [RequestTypeNameEn], [IsEditable], [SenderUserName], [SenderFrom], [SenderPassword], [SenderHostName], [SenderPort], [SenderName], [SubmitBeforRequestDate], [SubmitAfterRequestDate], [IsUsed], [CanDelegation], [DisplayUserName], [HaveAttachment]) VALUES(45,N'طلب الاشتراك فى التامين الطبى',N'Medical Insurance Register Request',0,N'sayedmustafa84@yahoo.com',N'sayedmustafa84@yahoo.com',N'1',N'smtp.sendgrid.net',587,N'SST',NULL,NULL,1,1,0,0)
Go

-- EmailTemplateType sqript run it if you want ( by default not Automatic run )
SET IDENTITY_INSERT[dbo].[EmailTemplateType] ON
INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode]) VALUES(228,N'Medical Insurance Register Request Sending',N'ارسال طلب الاشتراك فى التامين الطبى',0,1)

INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode]) VALUES(229,N'Medical Insurance Register Request Accept',N'الموافقة على طلب الاشتراك فى التامين الطبى',0,1)

INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode]) VALUES(230,N'Medical Insurance Register Request Refuse',N'رفض طلب الاشتراك فى التامين الطبى',0,1)

INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode]) VALUES(231,N'Medical Insurance Register Request Cancel',N'الغاء طلب الاشتراك فى التامين الطبى',0,1)
SET IDENTITY_INSERT [dbo].[EmailTemplateType] OFF


-- EmailTemplate sqript run it if you want ( by default not Automatic run )
SET IDENTITY_INSERT [dbo].[EmailTemplate] ON 
INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(228,N'Medical Insurance Register Request Sending',N'ارسال طلب الاشتراك فى التامين الطبى',228,N'ارسال',N'ارسال',1,NULL)

INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(229,N'Medical Insurance Register Request Accept',N'الموافقة على طلب الاشتراك فى التامين الطبى',229,N'الموافقة على',N'الموافقة على',1,NULL)

INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(230,N'Medical Insurance Register Request Refuse',N'رفض طلب الاشتراك فى التامين الطبى',230,N'رفض',N'رفض',1,NULL)

INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(231,N'Medical Insurance Register Request Cancel',N'الغاء طلب الاشتراك فى التامين الطبى',231,N'الغاء',N'الغاء',1,NULL)
SET IDENTITY_INSERT [dbo].[EmailTemplate] OFF


INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(511,N'Medical Insurance Register Request Signature',N'اعتماد طلب الاشتراك فى التامين الطبى',501,N'/WorkFlow/MedicalInsuranceRegisterRequestSignature',N'Index','fa fa-thumb-tack',N'get',15,1,1)
Go

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

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15096,N'اعتماد طلب الاشتراك فى التامين الطبى',N'Medical Insurance Register Request Signature',511,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15097,N'عرض اعتماد طلب الاشتراك فى التامين الطبى',N'View Medical Insurance Register Request Signature',511,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15098,N'تعديل اعتماد طلب الاشتراك فى التامين الطبى',N'Edit Medical Insurance Register Request Signature',511,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15099,N'حفظ اعتماد طلب الاشتراك فى التامين الطبى',N'Save Medical Insurance Register Request Signature',511,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15100,N'حفظ متعدد للاعتماد',N'Multiple Save',511,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15101,N'عرض سجل الموظف',N'View Employee History',511,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15102,N'ارجاع الطلب',N'Inverse Request',511,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15103,N'اختيار كل الطلبات',N'Choose All Requests',511,2)

Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(711,N'WorkFlow',N'MedicalInsuranceRegisterRequestSignature',N'Index',0,N'get',15096)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(712,N'WorkFlow',N'MedicalInsuranceRegisterRequestSignature',N'MedicalInsuranceRegisterRequestSignature_Read',0,N'post',15097)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(713,N'WorkFlow',N'MedicalInsuranceRegisterRequestSignature',N'Save',2,N'get',15098)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(714,N'WorkFlow',N'MedicalInsuranceRegisterRequestSignature',N'Save',0,N'post',15099)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(715,N'WorkFlow',N'MedicalInsuranceRegisterRequestSignature',N'SaveRequestSignatureLst',0,N'post',15100)
Go
--------------------------End 2021-04-28----------------------
--------------------------Hammad 2021-05-04-------------------

CREATE TABLE [dbo].[Faculties](
	[FacultyCode] [smallint] NOT NULL,
	[Name] [nvarchar](150) NULL,
	[Arabic_Name] [nvarchar](150) NULL,
	[MDT] [datetime] NULL,
 CONSTRAINT [PK_Faculties] PRIMARY KEY CLUSTERED 
(
	[FacultyCode] 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
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (1, N'ARTS', N'اداب', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (2, N'ALSUN', N'السن', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (3, N'LAW', N'حقوق', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (4, N'COMMERCE', N'تجارة', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (5, N'SOCIAL SERVICE', N'خدمة اجتماعية', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (6, N'APPLIED ARTS', N'الفنون التطبيقية', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (7, N'FINE ARTS', N'الفنون الجميلة', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (8, N'COMMERCE &BUSINESS ADMIST.', N'التجارة الخارجية', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (9, N'AGRICULTURE', N'زراعة', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (10, N'AMERICAN', N'امريكية', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (11, N'SCIENCE', N'علوم', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (12, N'MASS COMMUNICATION', N'تكنولوجيا', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (13, N'ECONOMIC & POLITICAL', N'سياسة و اقتصاد', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (14, N'COOPERATION HIGH INST.', N'معهد العالى للتعاون', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (15, N'ENGINEERING', N'الهندسة', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (16, N'ENG, & TECHNOLEGI', N'هندسة و تكنولوجيا', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (17, N'MEDICINE', N'طب', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (18, N'EDUCATION', N'التربية', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (19, N'PETROLEUM & MINING INST.', N'معهد البترول و التعدين', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (20, N'SECRETARIAL INST.', N'معهد السكرتارية', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (21, N'COMMERTIAL TECH. INST.', N'معهد الفنى التجارى', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (22, N'HIGH THEATORICAL INST.', N'معهد فنى مسرحى', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (23, N'EFFICIENT PRODUCTIVITY', N'معهد الكفاية الانتاجية', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (24, N'POLICE', N'الشرطة', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (25, N'DONBOSCO INST.', N'معهد دنبوسكو', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (26, N'TOURISM & HOTELS', N'سياحة و فنادق', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (27, N'MILITARY ACADAMY', N'الكلية الحربية', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (28, N'VETERINARY', N'طب بيطرى', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (29, N'LANGUAGE & TRANSLATION', N'اللغات و الترجمة', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (30, N'PHYSICAL EDUCATION', N'التربية الرياضية', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (31, N'DENTITRY', N'أسنان', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (32, N'RELIGION', N'أصول الدين', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (33, N'HIGH SCHOOL', N'دبلوم', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (34, N'TOURISM INSTITUTE', N'معهد السياحة', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (35, N'INDUSTRIAL INSTITUTE', N'معهد صناعى', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (36, N'GIRLS', N'كلية البنات', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (37, N'ARCHAEOLOGY', N'اثار', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (38, N'RELIGION', N'معهد أزهرى', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (39, N'HOME ECONOMIC', N'إقتصاد منزلى', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (41, N'SOCIAL SERVICE INS.', N'المعهد العالى للخدمة الإجتماعي', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (42, N'TECH. MEDICAL INST.', N'معهد فنى صحى', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (43, N'PRODUCTIVE EFFICIENCY', N'معهد الكفاية الإنتاجية', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (44, N'TECH.TNSTITUTE FOR HOTELS', N'معهد فنى للفنادق', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (45, N'HOTEL MANEGEMENT', N'', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (46, N'IHTTI SCHOOL OF HOTEL MGT.', N'', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (47, N'INT-L HOTEL&TOURISM TRAIN INST', N'', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (48, N'BUSINESS COLLEDGE', N'', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (49, N'SADAT ACADEMY', N'اكادمية السادات', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (50, N'VARIOUS STUDIES INSTITUTE', N'معهد دراسات نوعية', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (51, N'EGOTH', N'إيجوث', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (52, N'VETERINARY', N'طب بيطرى', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (53, N'ZAITON INST.FOR STUDIES', N'مركز الزيتون لدراسات', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (54, N'ARAB AFRO INSTITUTE', N'المركز العربى الأفريقى', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (55, N'AZHAR SECONDARY', N'ثانوى ازهرى', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (56, N'LANGUAGEINSTITUTE', N'مركز لغات', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (57, N'ADMIN.&COMPUTER INSTIT.', N'معهد الادارة و الكومبيوتر', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (58, N'NATIONAL TELEGRAM & WIRELESS', N'الاهلية للتلغراف و اللاسلكى', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (59, N'AGRI.COOPERATION INST.', N'معهد تعاون زراعى', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (60, N'COMPUTER & COMMERCIAL SC. INST', N'معهد حاسبات و علوم تجارية', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (61, N'TECHNOLOGICAL DEVELOPMENT', N'تنمبة تكولوجية', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (62, N'VARIOUS STUDIES', N'تربية نوعية', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (91, N'SCONDRY SCH.', N'', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (99, N'OTHER', N'أخرى', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (100, N'Modern Academy Maadi', N'الاكاديمية الحديثة بالمعادى', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (101, N'Faculty of Workers', N'الجامعة العمالية', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (102, N'Institute of Police', N'معهد امناء الشرطه', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (103, N'المعهد العالي للحاسب والمعلومات والادارة', N'المعهد العالي للحاسب والمعلومات والادارة', NULL)
INSERT [dbo].[Faculties] ([FacultyCode], [Name], [Arabic_Name], [MDT]) VALUES (104, N'Bachelor of Science in Management', N'بكارليوس علوم الأدارة', NULL)
ALTER TABLE [dbo].[Faculties] ADD  CONSTRAINT [DF_Faculties_FacultyCode]  DEFAULT ((0)) FOR [FacultyCode]
GO
--------------------------End 2021-05-04-------------------
--------------------------Ali 2021-05-04-------------------

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(514,N'Medical Insurance Cancel Request',N'طلب الغاء الاشتراك فى التامين الطبى',496,N'/WorkFlow/MedicalInsuranceCancelRequest',N'Index','fa fa-thumb-tack',N'get',15,1,1)
Go

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

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15119,N'طلب الغاء الاشتراك فى التامين الطبى',N'Medical Insurance Cancel Request',514,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15120,N'عرض طلب الغاء الاشتراك فى التامين الطبى',N'View Medical Insurance Cancel Request',514,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15121,N'إضافة طلب الغاء الاشتراك فى التامين الطبى',N'Add Medical Insurance Cancel Request',514,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15122,N'تعديل طلب الغاء الاشتراك فى التامين الطبى',N'Edit Medical Insurance Cancel Request',514,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15123,N'حذف طلب الغاء الاشتراك فى التامين الطبى',N'Delete Medical Insurance Cancel Request',514,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15124,N'حفظ طلب الغاء الاشتراك فى التامين الطبى',N'Save Medical Insurance Cancel Request',514,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15125,N'الغاء طلب الغاء الاشتراك فى التامين الطبى',N'Cancel Medical Insurance Cancel Request',514,2)
Go


INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(728,N'WorkFlow',N'MedicalInsuranceCancelRequest',N'Index',0,N'get',15119)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(729,N'WorkFlow',N'MedicalInsuranceCancelRequest',N'MedicalInsuranceCancelRequest_Read',0,N'post',15120)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(730,N'WorkFlow',N'MedicalInsuranceCancelRequest',N'Save',1,N'get',15121)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(731,N'WorkFlow',N'MedicalInsuranceCancelRequest',N'Save',2,N'get',15122)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(732,N'WorkFlow',N'MedicalInsuranceCancelRequest',N'Delete',0,N'post',15123)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(733,N'WorkFlow',N'MedicalInsuranceCancelRequest',N'Save',0,N'post',15124)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (734, N'WorkFlow', N'MedicalInsuranceCancelRequest', N'Cancel', 0, N'get', 15125)
Go

INSERT[dbo].[WF_RequestType]([RequestTypeId], [RequestTypeName], [RequestTypeNameEn], [IsEditable], [SenderUserName], [SenderFrom], [SenderPassword], [SenderHostName], [SenderPort], [SenderName], [SubmitBeforRequestDate], [SubmitAfterRequestDate], [IsUsed], [CanDelegation], [DisplayUserName], [HaveAttachment]) VALUES(47,N'طلب الغاء الاشتراك فى التامين الطبى',N'Medical Insurance Cancel Request',0,N'sayedmustafa84@yahoo.com',N'sayedmustafa84@yahoo.com',N'1',N'smtp.sendgrid.net',587,N'SST',NULL,NULL,1,1,0,0)
Go
SET IDENTITY_INSERT[dbo].[EmailTemplateType] ON
INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode]) VALUES(236,N'Medical Insurance Cancel Request Sending',N'ارسال طلب الغاء الاشتراك فى التامين الطبى',0,1)

INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode]) VALUES(237,N'Medical Insurance Cancel Request Accept',N'الموافقة على طلب الغاء الاشتراك فى التامين الطبى',0,1)

INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode]) VALUES(238,N'Medical Insurance Cancel Request Refuse',N'رفض طلب الغاء الاشتراك فى التامين الطبى',0,1)

INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode]) VALUES(239,N'Medical Insurance Cancel Request Cancel',N'الغاء طلب الغاء الاشتراك فى التامين الطبى',0,1)
SET IDENTITY_INSERT [dbo].[EmailTemplateType] OFF
SET IDENTITY_INSERT [dbo].[EmailTemplate] ON 
INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(236,N'Medical Insurance Cancel Request Sending',N'ارسال طلب الغاء الاشتراك فى التامين الطبى',236,N'ارسال',N'ارسال',1,NULL)

INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(237,N'Medical Insurance Cancel Request Accept',N'الموافقة على طلب الغاء الاشتراك فى التامين الطبى',237,N'الموافقة على',N'الموافقة على',1,NULL)

INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(238,N'Medical Insurance Cancel Request Refuse',N'رفض طلب الغاء الاشتراك فى التامين الطبى',238,N'رفض',N'رفض',1,NULL)

INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(239,N'Medical Insurance Cancel Request Cancel',N'الغاء طلب الغاء الاشتراك فى التامين الطبى',239,N'الغاء',N'الغاء',1,NULL)
SET IDENTITY_INSERT [dbo].[EmailTemplate] OFF

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(515,N'Medical Insurance Cancel Request Signature',N'اعتماد طلب الغاء الاشتراك فى التامين الطبى',501,N'/WorkFlow/MedicalInsuranceCancelRequestSignature',N'Index','fa fa-thumb-tack',N'get',17,1,1)
Go

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

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15126,N'اعتماد طلب الغاء الاشتراك فى التامين الطبى',N'Medical Insurance Cancel Request Signature',515,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15127,N'عرض اعتماد طلب الغاء الاشتراك فى التامين الطبى',N'View Medical Insurance Cancel Request Signature',515,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15128,N'تعديل اعتماد طلب الغاء الاشتراك فى التامين الطبى',N'Edit Medical Insurance Cancel Request Signature',515,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15129,N'حفظ اعتماد طلب الغاء الاشتراك فى التامين الطبى',N'Save Medical Insurance Cancel Request Signature',515,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15130,N'حفظ متعدد للاعتماد',N'Multiple Save',515,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15131,N'عرض سجل الموظف',N'View Employee History',515,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15132,N'ارجاع الطلب',N'Inverse Request',515,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15133,N'اختيار كل الطلبات',N'Choose All Requests',515,2)

Go


INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(735,N'WorkFlow',N'MedicalInsuranceCancelRequestSignature',N'Index',0,N'get',15126)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(736,N'WorkFlow',N'MedicalInsuranceCancelRequestSignature',N'MedicalInsuranceCancelRequestSignature_Read',0,N'post',15127)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(737,N'WorkFlow',N'MedicalInsuranceCancelRequestSignature',N'Save',2,N'get',15128)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(738,N'WorkFlow',N'MedicalInsuranceCancelRequestSignature',N'Save',0,N'post',15129)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(739,N'WorkFlow',N'MedicalInsuranceCancelRequestSignature',N'SaveRequestSignatureLst',0,N'post',15130)
Go
--------------------------End 2021-05-04-------------------
--------------------------Hammad 2021-05-05----------------

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(517,N'Print Business Card Request',N'طلب طباعة كرت عمل',496,N'/WorkFlow/PrintBusinessCardRequest',N'Index','fa fa-thumb-tack',N'get',16,1,1)
Go

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

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15134,N'طلب طباعة كرت عمل',N'Print Business Card Request',517,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15135,N'عرض طلب طباعة كرت عمل',N'View Print Business Card Request',517,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15136,N'إضافة طلب طباعة كرت عمل',N'Add Print Business Card Request',517,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15137,N'تعديل طلب طباعة كرت عمل',N'Edit Print Business Card Request',517,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15138,N'حذف طلب طباعة كرت عمل',N'Delete Print Business Card Request',517,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15139,N'حفظ طلب طباعة كرت عمل',N'Save Print Business Card Request',517,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15140,N'الغاء طلب طباعة كرت عمل',N'Cancel Print Business Card Request',517,2)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(740,N'WorkFlow',N'PrintBusinessCardRequest',N'Index',0,N'get',15134)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(741,N'WorkFlow',N'PrintBusinessCardRequest',N'PrintBusinessCardRequest_Read',0,N'post',15135)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(742,N'WorkFlow',N'PrintBusinessCardRequest',N'Save',1,N'get',15136)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(743,N'WorkFlow',N'PrintBusinessCardRequest',N'Save',2,N'get',15137)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(744,N'WorkFlow',N'PrintBusinessCardRequest',N'Delete',0,N'post',15138)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(745,N'WorkFlow',N'PrintBusinessCardRequest',N'Save',0,N'post',15139)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(746,N'WorkFlow',N'PrintBusinessCardRequest',N'Cancel',0,N'get',15140)

GO


INSERT[dbo].[WF_RequestType]([RequestTypeId], [RequestTypeName], [RequestTypeNameEn], [IsEditable], [SenderUserName], [SenderFrom], [SenderPassword], [SenderHostName], [SenderPort], [SenderName], [SubmitBeforRequestDate], [SubmitAfterRequestDate], [IsUsed], [CanDelegation], [DisplayUserName], [HaveAttachment]) VALUES(48,N'طلب طباعة كرت عمل',N'Print Business Card Request',0,N'sayedmustafa84@yahoo.com',N'sayedmustafa84@yahoo.com',N'1',N'smtp.sendgrid.net',587,N'SST',NULL,NULL,1,1,0,0)
Go

SET IDENTITY_INSERT[dbo].[EmailTemplateType] ON
INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode]) VALUES(240,N'Print Business Card Request Sending',N'ارسال طلب طباعة كرت عمل',0,1)

INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode]) VALUES(241,N'Print Business Card Request Accept',N'الموافقة على طلب طباعة كرت عمل',0,1)

INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode]) VALUES(242,N'Print Business Card Request Refuse',N'رفض طلب طباعة كرت عمل',0,1)

INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode]) VALUES(243,N'Print Business Card Request Cancel',N'الغاء طلب طباعة كرت عمل',0,1)
SET IDENTITY_INSERT [dbo].[EmailTemplateType] OFF

SET IDENTITY_INSERT [dbo].[EmailTemplate] ON 
INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(240,N'Print Business Card Request Sending',N'ارسال طلب طباعة كرت عمل',240,N'ارسال',N'ارسال',1,NULL)

INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(241,N'Print Business Card Request Accept',N'الموافقة على طلب طباعة كرت عمل',241,N'الموافقة على',N'الموافقة على',1,NULL)

INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(242,N'Print Business Card Request Refuse',N'رفض طلب طباعة كرت عمل',242,N'رفض',N'رفض',1,NULL)

INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(243,N'Print Business Card Request Cancel',N'الغاء طلب طباعة كرت عمل',243,N'الغاء',N'الغاء',1,NULL)
SET IDENTITY_INSERT [dbo].[EmailTemplate] OFF

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(518,N'Print Business Card Request Signature',N'إعتماد طلب طباعة كرت عمل',501,N'/WorkFlow/PrintBusinessCardRequestSignature',N'Index','fa fa-thumb-tack',N'get',18,1,1)
Go

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

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15141,N'إعتماد طلب طباعة كرت عمل',N'Print Business Card Request Signature',518,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15142,N'عرض إعتماد طلب طباعة كرت عمل',N'View Print Business Card Request Signature',518,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15143,N'تعديل إعتماد طلب طباعة كرت عمل',N'Edit Print Business Card Request Signature',518,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15144,N'حفظ إعتماد طلب طباعة كرت عمل',N'Save Print Business Card Request Signature',518,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15145,N'حفظ متعدد للاعتماد',N'Multiple Save',518,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15146,N'عرض سجل الموظف',N'View Employee History',518,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15147,N'ارجاع الطلب',N'Inverse Request',518,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15148,N'اختيار كل الطلبات',N'Choose All Requests',518,2)

Go



INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(747,N'WorkFlow',N'PrintBusinessCardRequestSignature',N'Index',0,N'get',15141)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(748,N'WorkFlow',N'PrintBusinessCardRequestSignature',N'PrintBusinessCardRequestSignature_Read',0,N'post',15142)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(749,N'WorkFlow',N'PrintBusinessCardRequestSignature',N'Save',2,N'get',15143)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(750,N'WorkFlow',N'PrintBusinessCardRequestSignature',N'Save',0,N'post',15144)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(751,N'WorkFlow',N'PrintBusinessCardRequestSignature',N'SaveRequestSignatureLst',0,N'post',15145)
GO
--------------------------End 2021-05-05----------------
--------------------------Ali 2021-05-05----------------


CREATE TABLE [dbo].[Rec_Endorsement](
	[EndorsementCode] [int] IDENTITY(1,1) NOT NULL,
	[Endorsement] [nvarchar](max) NOT NULL,
	[Arabic_Endorsement] [nvarchar](max) NOT NULL,
	[CreatedBy] [int] NOT NULL,
	[CreationDate] [datetime] NOT NULL,
	[ModifiedBy] [int] NULL,
	[ModificationDate] [datetime] NULL,
	[DisplayArabicAndEnglishEndorsement] [bit] NOT NULL,
 CONSTRAINT [PK_Rec_Endorsement] PRIMARY KEY CLUSTERED 
(
	[EndorsementCode] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO


INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(516,N'Endorsement',N'الاقرار',48,N'/Recruitment/Endorsement',N'Index','fa fa-thumb-tack',N'get',15,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(516,4)
Go

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(5130,N'الاقرار',N'Endorsement',516,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(5131,N'عرض الاقرار',N'View Endorsement',516,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(5132,N'حفظ الاقرار',N'Save Endorsement',516,2)
Go


INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(752,N'Recruitment',N'Endorsement',N'Index',0,N'get',5130)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(753,N'Recruitment',N'Endorsement',N'Save',0,N'post',5132)
Go




--------------------------End 2021-05-05----------------
--------------------------Ali 2021-05-06----------------
SET IDENTITY_INSERT [dbo].[Rec_Endorsement] ON 

INSERT [dbo].[Rec_Endorsement] ([EndorsementCode], [Endorsement], [Arabic_Endorsement], [CreatedBy], [CreationDate], [ModifiedBy], [ModificationDate], [DisplayArabicAndEnglishEndorsement]) VALUES (1, N'Are you sure you want to Submit your answers, you can not modify the Answers after this action?', N'هل أنت متأكد أنك تريد إرسال إجاباتك ، لا يمكنك تعديل الإجابات بعد هذا الإجراء؟', 1, CAST(N'2021-05-06T10:44:03.000' AS DateTime), NULL, NULL, 0)
SET IDENTITY_INSERT [dbo].[Rec_Endorsement] OFF
Go
--------------------------End 2021-05-06----------------
--------------------------Hammad 2021-05-06-------------
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) 
VALUES(9031,N'اظهار انواع الوثائق الغير متاحه للعرض',N'Show Document Type Not Available',504,2)
Go
--------------------------End 2021-05-06----------------
--------------------------Hammad 2021-05-09----------
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) 
VALUES (N'ShowUserType', N'Show User Type', N'إظهار نوع المستخدم', N'true', 7, 10, 1, 1, NULL, NULL, NULL)
GO
ALTER TABLE dbo.EmployeesExtend ADD
	OutOfTimePenaltiesActions bit NULL
GO
ALTER TABLE dbo.EmployeesExtend ADD
	HeHasNoRightToReceiveTheSalaryReceipt bit NULL
GO

ALTER TABLE dbo.WF_NewEmployeesRequest ADD
	CostCenter nvarchar(50) NULL,
	EmploymentPeriodDateFrom datetime NULL,
	EmploymentPeriodDateTo datetime NULL,
	GeneralTypeCode tinyint NULL,
	RelatedToRecJob bit NOT NULL CONSTRAINT DF_WF_NewEmployeesRequest_RelatedToRecJob DEFAULT 0,
	RecJobStatusCode int NULL
GO
--------------------------End 2021-05-09-------------