------------------------------- Hammad 2020-11-02 -----------------------
SET IDENTITY_INSERT [dbo].[EmailTemplateType] ON 
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode]) VALUES (161, N'Employee Delegation', 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 (161, N'Employee Delegation', N'تفويض الموظفيين', 161, N'تفويض الموظفيين', N'<p>تفويض الموظفيين</p>', 1, NULL)
SET IDENTITY_INSERT [dbo].[EmailTemplate] OFF

INSERT [dbo].[UserType] ([UserTypeCode], [Name], [Arabic_Name], [HaveEmployee], [OrganizationCategoryCode]) VALUES (23, N'Division Personal Manger', N' مدير شئون العاملين للقطاع', 1, NULL)
INSERT [dbo].[UserType] ([UserTypeCode], [Name], [Arabic_Name], [HaveEmployee], [OrganizationCategoryCode]) VALUES (24, N'Division HR Manager', N'مدير الموارد البشرية للقطاع', 1, NULL)
Go


------------------------------- End 2020-11-02 -----------------------
-------------------------------Sayed 2020-11-03-----------------------
alter table Divisions
add PersonalManagerCode int null
GO
alter table Divisions
add HRManagerCode int null
GO
-----------------------------End 2020-11-03---------------------------
-----------------------------Hammad 2020-11-03------------------------
ALTER TABLE dbo.WF_Track ADD
	GeneralRequestTypeCode int NULL
GO
-----------------------------End 2020-11-03------------------------
------------------------------- A.Khaled 2020-11-03 -------------------------- 
--===================================================================================
--===================================================================================
--===================================================================================
--===================================================================================
--THIS IS FOR ALTER SectionCode, DepartmentCode & DivisionCode LENGTH TO 20 CHARACTER
--===================================================================================
--===================================================================================
--===================================================================================
--===================================================================================


ALTER TABLE [dbo].[WF_OverTimeSymphonyRequest] DROP CONSTRAINT [FK_WF_OverTimeSymphonyRequest_Sections]
GO
ALTER TABLE [dbo].[WF_PromotionRequest] DROP CONSTRAINT [FK_WF_PromotionRequest_Departments]
go
ALTER TABLE [dbo].[WF_PromotionRequest] DROP CONSTRAINT [FK_WF_PromotionRequest_Divisions]
go
ALTER TABLE [dbo].[WF_PromotionRequest] DROP CONSTRAINT [FK_WF_PromotionRequest_Sections]
go
ALTER TABLE [dbo].[WF_TransferRequest] DROP CONSTRAINT [FK_WF_TransferRequest_Departments_New]
go
ALTER TABLE [dbo].[WF_TransferRequest] DROP CONSTRAINT [FK_WF_TransferRequest_Departments_Old]
go
ALTER TABLE [dbo].[WF_TransferRequest] DROP CONSTRAINT [FK_WF_TransferRequest_Division_New]
go
ALTER TABLE [dbo].[WF_TransferRequest] DROP CONSTRAINT [FK_WF_TransferRequest_Division_Old]
go
ALTER TABLE [dbo].[WF_TransferRequest] DROP CONSTRAINT [FK_WF_TransferRequest_Sections_New]
go
ALTER TABLE [dbo].[WF_TransferRequest] DROP CONSTRAINT [FK_WF_TransferRequest_Sections_Old]
go
ALTER TABLE [dbo].[WF_CasualRequestSection] DROP CONSTRAINT [FK_WF_CasualRequestSection_Sections]
go
ALTER TABLE [dbo].[SecurityUserSection] DROP CONSTRAINT [FK_SecurityUserSection_Sections]
go
ALTER TABLE [dbo].[Employees] DROP CONSTRAINT [FK_Employees_Sections]
go
ALTER TABLE [dbo].[EmployeeCandidacy] DROP CONSTRAINT [FK_EmployeeCandidacy_Sections]
go
ALTER TABLE [dbo].[EmployeeCandidacy] DROP CONSTRAINT [FK_EmployeeCandidacy_Departments]
go
ALTER TABLE [dbo].[Sections] DROP CONSTRAINT [FK_Sections_Departments]
go
ALTER TABLE [dbo].[Departments] DROP CONSTRAINT [FK_Departments_Divisions]
GO
ALTER TABLE dbo.AC_Authority ALTER COLUMN DepartmentCode NVARCHAR(20) NULL
GO
ALTER TABLE dbo.Budget ALTER COLUMN SectionCode NVARCHAR(20) NOT NULL
GO
ALTER TABLE dbo.CentralDepartments ALTER COLUMN DepartmentCode NVARCHAR(20) NOT NULL
GO
ALTER TABLE dbo.CentralDivisions ALTER COLUMN DivisionCode NVARCHAR(20) NOT NULL
GO
ALTER TABLE dbo.CentralSections ALTER COLUMN SectionCode NVARCHAR(20) NOT NULL
go
ALTER TABLE dbo.CostCenter ALTER COLUMN CostCenterDepartmentCode NVARCHAR(20) NULL
go
ALTER TABLE dbo.Departments ALTER COLUMN DepartmentCode NVARCHAR(20) NOT NULL
go
ALTER TABLE dbo.Departments ALTER COLUMN DivisionCode NVARCHAR(20) NULL
go
ALTER TABLE dbo.Divisions ALTER COLUMN DivisionCode NVARCHAR(20) NOT NULL
go
ALTER TABLE dbo.EmployeeCandidacy ALTER COLUMN DepartmentCode NVARCHAR(20) NOT NULL
go
ALTER TABLE dbo.EmployeeCandidacy ALTER COLUMN SectionCode NVARCHAR(20) NOT NULL
go
ALTER TABLE dbo.Employees ALTER COLUMN DivisionCode NVARCHAR(20) NULL
go
ALTER TABLE dbo.Employees ALTER COLUMN DepartmentCode NVARCHAR(20) NULL
go
ALTER TABLE dbo.Employees ALTER COLUMN SectionCode NVARCHAR(20) NULL
go
ALTER TABLE dbo.EventSection ALTER COLUMN SectionCode NVARCHAR(20) NOT NULL
go
ALTER TABLE dbo.ReplacementEmployee ALTER COLUMN ReplacementSectionCode NVARCHAR(20) NOT NULL
go
ALTER TABLE dbo.Sections ALTER COLUMN SectionCode NVARCHAR(20) NOT NULL
go
ALTER TABLE dbo.Sections ALTER COLUMN DepartmentCode NVARCHAR(20) NULL
go
ALTER TABLE dbo.SectionsClose ALTER COLUMN SectionCode NVARCHAR(20) NULL
go
ALTER TABLE dbo.SecurityUserSection ALTER COLUMN SectionCode NVARCHAR(20) NOT NULL
go
ALTER TABLE dbo.StaffRooms ALTER COLUMN DepartmentCode NVARCHAR(20) NULL
go
ALTER TABLE dbo.WF_CasualRequestSection ALTER COLUMN SectionCode NVARCHAR(20) NOT NULL
go
ALTER TABLE dbo.WF_NewHireRequest ALTER COLUMN DivisionCode NVARCHAR(20) NOT NULL
go
ALTER TABLE dbo.WF_NewHireRequest ALTER COLUMN DepartmentCode NVARCHAR(20) NOT NULL
go
ALTER TABLE dbo.WF_NewHireRequest ALTER COLUMN SectionCode NVARCHAR(20) NOT NULL
go
ALTER TABLE dbo.WF_OverTimeRequest ALTER COLUMN SectionCode NVARCHAR(20) NULL
go
ALTER TABLE dbo.WF_PromotionRequest ALTER COLUMN SectionCode NVARCHAR(20) NOT NULL
go
ALTER TABLE dbo.WF_PromotionRequest ALTER COLUMN DivisionCode NVARCHAR(20) NOT NULL
go
ALTER TABLE dbo.WF_PromotionRequest ALTER COLUMN DepartmentCode NVARCHAR(20) NOT NULL
go
ALTER TABLE dbo.WF_PromotionRequest ALTER COLUMN OldSectionCode NVARCHAR(20) NOT NULL
go
ALTER TABLE dbo.WF_PromotionRequest ALTER COLUMN OldDivisionCode NVARCHAR(20) NOT NULL
go
ALTER TABLE dbo.WF_PromotionRequest ALTER COLUMN OldDepartmentCode NVARCHAR(20) NOT NULL
go
ALTER TABLE dbo.WF_TransferRequest ALTER COLUMN OldDepartmentCode NVARCHAR(20) NOT NULL
go
ALTER TABLE dbo.WF_TransferRequest ALTER COLUMN OldSectionCode NVARCHAR(20) NOT NULL
go
ALTER TABLE dbo.WF_TransferRequest ALTER COLUMN NewSectionCode NVARCHAR(20) NOT NULL
go
ALTER TABLE dbo.WF_TransferRequest ALTER COLUMN NewDepartmentCode NVARCHAR(20) NOT NULL
go
ALTER TABLE dbo.WF_TransferRequest ALTER COLUMN OldDivisionCode NVARCHAR(20) NOT NULL
go
ALTER TABLE dbo.WF_TransferRequest ALTER COLUMN NewDivisionCode NVARCHAR(20) NOT NULL
GO
ALTER TABLE [dbo].[WF_PromotionRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_PromotionRequest_Departments] FOREIGN KEY([DepartmentCode])
REFERENCES [dbo].[Departments] ([DepartmentCode])
ALTER TABLE [dbo].[WF_PromotionRequest] CHECK CONSTRAINT [FK_WF_PromotionRequest_Departments]
go
ALTER TABLE [dbo].[WF_PromotionRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_PromotionRequest_Divisions] FOREIGN KEY([DivisionCode])
REFERENCES [dbo].[Divisions] ([DivisionCode])
ALTER TABLE [dbo].[WF_PromotionRequest] CHECK CONSTRAINT [FK_WF_PromotionRequest_Divisions]
go
ALTER TABLE [dbo].[WF_PromotionRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_PromotionRequest_Sections] FOREIGN KEY([SectionCode])
REFERENCES [dbo].[Sections] ([SectionCode])
ALTER TABLE [dbo].[WF_PromotionRequest] CHECK CONSTRAINT [FK_WF_PromotionRequest_Sections]
go

ALTER TABLE [dbo].[WF_TransferRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_TransferRequest_Departments_New] FOREIGN KEY([NewDepartmentCode])
REFERENCES [dbo].[Departments] ([DepartmentCode])
ALTER TABLE [dbo].[WF_TransferRequest] CHECK CONSTRAINT [FK_WF_TransferRequest_Departments_New]
go
ALTER TABLE [dbo].[WF_TransferRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_TransferRequest_Departments_Old] FOREIGN KEY([OldDepartmentCode])
REFERENCES [dbo].[Departments] ([DepartmentCode])
ALTER TABLE [dbo].[WF_TransferRequest] CHECK CONSTRAINT [FK_WF_TransferRequest_Departments_Old]
go
ALTER TABLE [dbo].[WF_TransferRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_TransferRequest_Division_New] FOREIGN KEY([NewDivisionCode])
REFERENCES [dbo].[Divisions] ([DivisionCode])
ALTER TABLE [dbo].[WF_TransferRequest] CHECK CONSTRAINT [FK_WF_TransferRequest_Division_New]
go
ALTER TABLE [dbo].[WF_TransferRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_TransferRequest_Division_Old] FOREIGN KEY([OldDivisionCode])
REFERENCES [dbo].[Divisions] ([DivisionCode])
ALTER TABLE [dbo].[WF_TransferRequest] CHECK CONSTRAINT [FK_WF_TransferRequest_Division_Old]
go

ALTER TABLE [dbo].[WF_TransferRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_TransferRequest_Sections_New] FOREIGN KEY([NewSectionCode])
REFERENCES [dbo].[Sections] ([SectionCode])
ALTER TABLE [dbo].[WF_TransferRequest] CHECK CONSTRAINT [FK_WF_TransferRequest_Sections_New]
go
ALTER TABLE [dbo].[WF_TransferRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_TransferRequest_Sections_Old] FOREIGN KEY([OldSectionCode])
REFERENCES [dbo].[Sections] ([SectionCode])
ALTER TABLE [dbo].[WF_TransferRequest] CHECK CONSTRAINT [FK_WF_TransferRequest_Sections_Old]
go

ALTER TABLE [dbo].[WF_CasualRequestSection]  WITH CHECK ADD  CONSTRAINT [FK_WF_CasualRequestSection_Sections] FOREIGN KEY([SectionCode])
REFERENCES [dbo].[Sections] ([SectionCode])
ALTER TABLE [dbo].[WF_CasualRequestSection] CHECK CONSTRAINT [FK_WF_CasualRequestSection_Sections]
go

ALTER TABLE [dbo].[SecurityUserSection]  WITH CHECK ADD  CONSTRAINT [FK_SecurityUserSection_Sections] FOREIGN KEY([SectionCode])
REFERENCES [dbo].[Sections] ([SectionCode])
ALTER TABLE [dbo].[SecurityUserSection] CHECK CONSTRAINT [FK_SecurityUserSection_Sections]
go

ALTER TABLE [dbo].[Employees]  WITH CHECK ADD  CONSTRAINT [FK_Employees_Sections] FOREIGN KEY([SectionCode])
REFERENCES [dbo].[Sections] ([SectionCode])
ALTER TABLE [dbo].[Employees] CHECK CONSTRAINT [FK_Employees_Sections]
go

ALTER TABLE [dbo].[EmployeeCandidacy]  WITH CHECK ADD  CONSTRAINT [FK_EmployeeCandidacy_Sections] FOREIGN KEY([SectionCode])
REFERENCES [dbo].[Sections] ([SectionCode])
ALTER TABLE [dbo].[EmployeeCandidacy] CHECK CONSTRAINT [FK_EmployeeCandidacy_Sections]
go
ALTER TABLE [dbo].[EmployeeCandidacy]  WITH CHECK ADD  CONSTRAINT [FK_EmployeeCandidacy_Departments] FOREIGN KEY([DepartmentCode])
REFERENCES [dbo].[Departments] ([DepartmentCode])
ALTER TABLE [dbo].[EmployeeCandidacy] CHECK CONSTRAINT [FK_EmployeeCandidacy_Departments]
go

ALTER TABLE [dbo].[Sections]  WITH CHECK ADD  CONSTRAINT [FK_Sections_Departments] FOREIGN KEY([DepartmentCode])
REFERENCES [dbo].[Departments] ([DepartmentCode])
ALTER TABLE [dbo].[Sections] CHECK CONSTRAINT [FK_Sections_Departments]
go

ALTER TABLE [dbo].[Departments]  WITH CHECK ADD  CONSTRAINT [FK_Departments_Divisions] FOREIGN KEY([DivisionCode])
REFERENCES [dbo].[Divisions] ([DivisionCode])
ALTER TABLE [dbo].[Departments] CHECK CONSTRAINT [FK_Departments_Divisions]
GO
ALTER TABLE dbo.WF_OverTimeSymphonyRequest ALTER COLUMN SectionCode NVARCHAR(20) NULL
ALTER TABLE dbo.WF_OverTimeSymphonyRequest ALTER COLUMN SectionCodeRequest NVARCHAR(20) NOT NULL
go
ALTER TABLE [dbo].[WF_OverTimeSymphonyRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_OverTimeSymphonyRequest_Sections] FOREIGN KEY([SectionCodeRequest])
REFERENCES [dbo].[Sections] ([SectionCode])
GO
ALTER TABLE [dbo].[WF_OverTimeSymphonyRequest] CHECK CONSTRAINT [FK_WF_OverTimeSymphonyRequest_Sections]
GO
---------------------------------------------------------------------------
------------------------------- End 2020-11-03 --------------------------
------------------------------- Hammad 2020-11-03 -----------------------
ALTER TABLE dbo.WF_OtherEmployeeTrack ALTER COLUMN OtherCode int NULL
Go
------------------------------- End 2020-11-03 -----------------------
------------------------------- Ali 2020-11-03 -----------------------


  INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(386,N'Transaction Enquiry Reply',N'الرد على استفسار المعامله',9,N'/AdminComm/TransactionEnquiryReply',N'Index','fa fa-thumb-tack',N'get',51,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(386,2)
Go

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(2135,N'الرد على استفسار المعامله',N'Transaction Enquiry Reply',386,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(2136,N'عرض الرد على استفسار المعامله',N'View Transaction Enquiry Reply',386,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(2137,N'إضافة الرد على استفسار المعامله',N'Add Transaction Enquiry Reply',386,2)

Go


CREATE TABLE [dbo].[AC_TransactionEnquiryReply](
	[TransEnquiryReplyId] [int] IDENTITY(1,1) NOT NULL,
	[TransactionEnquiryId] [int] NOT NULL,
	[ReplyContent] [nvarchar](max) NULL,
	[UserCode] [int] NOT NULL,
	[CreatedBy] [int] NOT NULL,
	[CreationDate] [datetime] NOT NULL,
	[CreationDateHijri] [nvarchar](10) NOT NULL,
	[ModifiedBy] [int] NULL,
	[ModificationDate] [datetime] NULL,
	[ModificationDateHijri] [nvarchar](10) NULL,
 CONSTRAINT [PK_AC_TransactionEnquiryReply] PRIMARY KEY CLUSTERED 
(
	[TransEnquiryReplyId] 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

ALTER TABLE [dbo].[AC_TransactionEnquiryReply]  WITH CHECK ADD  CONSTRAINT [FK_AC_TransactionEnquiryReply_AC_TransactionEnquiry] FOREIGN KEY([TransactionEnquiryId])
REFERENCES [dbo].[AC_TransactionEnquiry] ([TransactionEnquiryId])
GO

ALTER TABLE [dbo].[AC_TransactionEnquiryReply] CHECK CONSTRAINT [FK_AC_TransactionEnquiryReply_AC_TransactionEnquiry]
GO



ALTER TABLE dbo.AC_TransactionEnquiry ADD
	ReplyContent nvarchar(MAX) NULL
GO
ALTER TABLE dbo.AC_TransactionEnquiry SET (LOCK_ESCALATION = TABLE)
GO

------------------------------- End 2020-11-03 -----------------------
------------------------------- Hammad 2020-11-03 --------------------
ALTER TABLE dbo.WF_GeneralRequestType ADD
	HaveDifferentTrack bit NOT NULL CONSTRAINT DF_WF_GeneralRequestType_HaveDifferentTrack DEFAULT 0
GO
------------------------------- End 2020-11-03 --------------------

-------------------------------Sayed 2020-11-05---------------------
alter table Divisions
add ChiefAccountantCode int null
GO
alter table Divisions
add FinancialControlerCode int null
GO
alter table Divisions
add GeneralManagerCode int null
GO
INSERT [dbo].[UserType] ([UserTypeCode], [Name], [Arabic_Name], [HaveEmployee], [OrganizationCategoryCode]) VALUES (25, N'Division Chief Accountant', N' رئيس الحسابات للقطاع', 1, NULL)
INSERT [dbo].[UserType] ([UserTypeCode], [Name], [Arabic_Name], [HaveEmployee], [OrganizationCategoryCode]) VALUES (26, N'Division Financial Controler', N'المراقب المالي للقطاع', 1, NULL)
INSERT [dbo].[UserType] ([UserTypeCode], [Name], [Arabic_Name], [HaveEmployee], [OrganizationCategoryCode]) VALUES (27, N'Division General Manager', N'المدير العام للقطاع', 1, NULL)
Go
----------------------------End 2020-11-05-------------------------