﻿---------------------------Hammad 2021-04-20----------------------


ALTER TABLE dbo.Employees ADD
	Org4Code nvarchar(20) NULL,
	Org5Code nvarchar(20) NULL,
	Org6Code nvarchar(20) NULL,
	Org7Code nvarchar(20) NULL,
	Org8Code nvarchar(20) NULL,
	Org9Code nvarchar(20) NULL
GO


ALTER TABLE dbo.WF_NewJobRequest ADD
	SectionCode nvarchar(20) NULL
GO

ALTER TABLE [dbo].[WF_NewJobRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_NewJobRequest_Sections] FOREIGN KEY([SectionCode])
REFERENCES [dbo].[Sections] ([SectionCode])
GO

ALTER TABLE [dbo].[WF_NewJobRequest] CHECK CONSTRAINT [FK_WF_NewJobRequest_Sections]
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType])
 VALUES (15058, N'ربط الوظيفة بالقسم  ', N'Add section to new job', 238, 2)
 Go
---------------------------End 2021-04-20----------------------
---------------------------Hammad 2021-04-21-------------------
ALTER TABLE dbo.WF_PenaltyRequest ADD
	InvestigationRequired bit NOT NULL CONSTRAINT DF_WF_PenaltyRequest_InvestigationRequired DEFAULT 0
GO

ALTER TABLE dbo.WF_NewEmployeesRequest ADD
	SectionCode nvarchar(20) NULL,
	VacanciesCount int null,
	JobTypeCode int null

GO

ALTER TABLE [dbo].[WF_NewEmployeesRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_NewEmployeesRequest_Sections] FOREIGN KEY([SectionCode])
REFERENCES [dbo].[Sections] ([SectionCode])
GO

ALTER TABLE [dbo].[WF_NewEmployeesRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_NewEmployeesRequest_NewEmployeesType] FOREIGN KEY([JobTypeCode])
REFERENCES [dbo].[Rec_JobType] ([JobTypeCode])
GO


update SystemMenu set Name=N'Employeement Types' ,Arabic_Name=N'أنواع التوظيف'    where SystemMenuCode=106
update SecurityPrivilege set DescriptionEN=N'Employeement Types' ,DescriptionAR=N'أنواع التوظيف'  where ID=5093
update SecurityPrivilege set DescriptionEN=N'View Employeement Types' ,DescriptionAR=N'عرض أنواع التوظيف'  where ID=5094
update SecurityPrivilege set DescriptionEN=N'Add Employeement Types' ,DescriptionAR=N'إضافة أنواع التوظيف'  where ID=5095
update SecurityPrivilege set DescriptionEN=N'Edit Employeement Types' ,DescriptionAR=N'تعديل أنواع التوظيف'  where ID=5096
update SecurityPrivilege set DescriptionEN=N'Save Employeement Types' ,DescriptionAR=N'حفظ أنواع التوظيف'  where ID=5097
update SecurityPrivilege set DescriptionEN=N'Delete Employeement Types' ,DescriptionAR=N'حذف أنواع التوظيف'  where ID=5098
Go

---------------------------End 2021-04-21-------------------
---------------------------Hammad 2021-04-22---------------

INSERT [dbo].[LabelsName] ([LabelKey], [Name], [Arabic_Name]) VALUES (N'Department', N'Department', N'الإدارة')
INSERT [dbo].[LabelsName] ([LabelKey], [Name], [Arabic_Name]) VALUES (N'Division', N'Division', N'القطاع')
INSERT [dbo].[LabelsName] ([LabelKey], [Name], [Arabic_Name]) VALUES (N'GeneralType', N'General Type', N'النوع العام')
INSERT [dbo].[LabelsName] ([LabelKey], [Name], [Arabic_Name]) VALUES (N'Section', N'Section', N'القسم ')
Go
---------------------------End 2021-04-22---------------
---------------------------Ali 2021-04-25---------------
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(504,N'Employee Documents',N'وثائق الموظف',489,N'/Archive/ArcEmpDocument',N'Index','fa fa-thumb-tack',N'get',2,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(504,14)
Go

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(505,N'Import Employees  files',N'استيراد ملفات الموظفين',489,N'/Archive/ArcEmpDocument',N'SaveImportEmployeefile','fa fa-thumb-tack',N'get',3,0,0)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(505,14)
Go


INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(9024,N'وثائق الموظف',N'Employee Documents',504,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(9025,N'عرض وثائق الموظف',N'View Employee Documents',504,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(9026,N'إضافة وثائق الموظف',N'Add Employee Documents',504,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(9027,N'تعديل وثائق الموظف',N'Edit Employee Documents',504,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(9028,N'حذف وثائق الموظف',N'Delete Employee Documents',504,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(9029,N'حفظ وثائق الموظف',N'Save Employee Documents',504,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(9030,N'استيراد ملفات الموظفين',N'Import Employees files',505,2)
Go



INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(668,N'Archive',N'ArcEmpDocument',N'Index',0,N'get',9024)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(669,N'Archive',N'ArcEmpDocument',N'EmployeeDocument_Read',0,N'post',9025)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(670,N'Archive',N'ArcEmpDocument',N'Save',1,N'get',9026)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(671,N'Archive',N'ArcEmpDocument',N'Save',2,N'get',9027)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(672,N'Archive',N'ArcEmpDocument',N'Delete',0,N'post',9028)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(673,N'Archive',N'ArcEmpDocument',N'Save',0,N'post',9029)
Go


  INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1270, N'عرض وثائق الموظف', N'View Employee Decuments', 3, 2)
Go

---------------------------End 2021-04-25---------------

--------------------------Hammad 2021-04-25-----------------------------


INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(506,N'New Section Department Request',N'طلب بفتح قسم أو إدارة جديد',496,N'/WorkFlow/NewSectionDepartRequest',N'Index','fa fa-thumb-tack',N'get',11,1,1)
Go

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

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15059,N'طلب بفتح قسم أو إدارة جديد',N'New Section Department Request',506,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15060,N'عرض طلب بفتح قسم أو إدارة جديد',N'View New Section Department Request',506,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15061,N'إضافة طلب بفتح قسم أو إدارة جديد',N'Add New Section Department Request',506,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15062,N'تعديل طلب بفتح قسم أو إدارة جديد',N'Edit New Section Department Request',506,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15063,N'حذف طلب بفتح قسم أو إدارة جديد',N'Delete New Section Department Request',506,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15064,N'حفظ طلب بفتح قسم أو إدارة جديد',N'Save New Section Department Request',506,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) 
VALUES(15073,N'الغاء طلب بفتح قسم أو إدارة جديد',N'Cancel New Section Department Request',506,2)
Go



INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(674,N'WorkFlow',N'NewSectionDepartRequest',N'Index',0,N'get',15059)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(675,N'WorkFlow',N'NewSectionDepartRequest',N'NewSectionDepartRequest_Read',0,N'post',15060)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(676,N'WorkFlow',N'NewSectionDepartRequest',N'Save',1,N'get',15061)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(677,N'WorkFlow',N'NewSectionDepartRequest',N'Save',2,N'get',15062)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(678,N'WorkFlow',N'NewSectionDepartRequest',N'Delete',0,N'post',15063)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(679,N'WorkFlow',N'NewSectionDepartRequest',N'Save',0,N'post',15064)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(685,N'WorkFlow',N'NewSectionDepartRequest',N'Cancel',0,N'post',15073)
Go


INSERT[dbo].[WF_RequestType]([RequestTypeId], [RequestTypeName], [RequestTypeNameEn], [IsEditable], [SenderUserName], [SenderFrom], [SenderPassword], [SenderHostName], [SenderPort], [SenderName], [SubmitBeforRequestDate], [SubmitAfterRequestDate], [IsUsed], [CanDelegation], [DisplayUserName], [HaveAttachment]) VALUES(43,N'طلب بفتح قسم أو إدارة جديد',N'New Section Department 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(220,N'New Section Department Request Sending',N'ارسال طلب بفتح قسم أو إدارة جديد',0,1)

INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode]) VALUES(221,N'New Section Department Request Accept',N'الموافقة على طلب بفتح قسم أو إدارة جديد',0,1)

INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode]) VALUES(222,N'New Section Department Request Refuse',N'رفض طلب بفتح قسم أو إدارة جديد',0,1)

INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode]) VALUES(223,N'New Section Department 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(220,N'New Section Department Request Sending',N'ارسال طلب بفتح قسم أو إدارة جديد',220,N'ارسال',N'ارسال',1,NULL)

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

INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(222,N'New Section Department Request Refuse',N'رفض طلب بفتح قسم أو إدارة جديد',222,N'رفض',N'رفض',1,NULL)

INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(223,N'New Section Department Request Cancel',N'الغاء طلب بفتح قسم أو إدارة جديد',223,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(507,N'New Section Department Request Signature',N'اعتماد طلب بفتح قسم أو إدارة جديد',501,N'/WorkFlow/NewSectionDepartRequestSignature',N'Index','fa fa-thumb-tack',N'get',13,1,1)
Go

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

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15065,N'اعتماد طلب بفتح قسم أو إدارة جديد',N'New Section Department Request Signature',507,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15066,N'عرض اعتماد طلب بفتح قسم أو إدارة جديد',N'View New Section Department Request Signature',507,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15067,N'تعديل اعتماد طلب بفتح قسم أو إدارة جديد',N'Edit New Section Department Request Signature',507,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15068,N'حفظ اعتماد طلب بفتح قسم أو إدارة جديد',N'Save New Section Department Request Signature',507,2)

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

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

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

Go


INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(680,N'WorkFlow',N'NewSectionDepartRequestSignature',N'Index',0,N'get',15065)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(681,N'WorkFlow',N'NewSectionDepartRequestSignature',N'NewSectionDepartRequestSignature_Read',0,N'post',15066)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(682,N'WorkFlow',N'NewSectionDepartRequestSignature',N'Save',2,N'get',15067)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(683,N'WorkFlow',N'NewSectionDepartRequestSignature',N'Save',0,N'post',15068)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(684,N'WorkFlow',N'NewSectionDepartRequestSignature',N'SaveRequestSignatureLst',0,N'post',15069)
Go
--------------------------End 2021-04-25-------------------------
