﻿-----------------------------------------  Hammad 2025-02-09 --------------------- 
Update SystemMenu set ParentID=502 where SystemMenuCode= 1140
Go
-----------------------------------------  Hammad 2025-02-09 --------------------- 
------------------------Sayed 2025-02-11------------------------------


CREATE TABLE [dbo].[PositionsGroups](
	[PositionGroupCode] [int] NOT NULL,
	[Name] [nvarchar](150) NULL,
	[Arabic_Name] [nvarchar](150) NULL,
	[Closed] [bit] NULL,
	[MDT] [datetime] NULL,
 CONSTRAINT [PK_PositionsGroups_PositionGroupCode] PRIMARY KEY CLUSTERED 
(
	[PositionGroupCode] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[PositionsGroups] ADD  CONSTRAINT [DF_PositionsGroups_Closed]  DEFAULT ((0)) FOR [Closed]
GO
alter table Positions
add PositionGroupCode int null
Go
CREATE TABLE [dbo].[SectionsGroups](
	[SectionGroupCode] [int] NOT NULL,
	[Name] [nvarchar](150) NULL,
	[Arabic_Name] [nvarchar](150) NULL,
	[Closed] [bit] NULL,
	[MDT] [datetime] NULL,
 CONSTRAINT [PK_SectionsGroups_SectionGroupCode] PRIMARY KEY CLUSTERED 
(
	[SectionGroupCode] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[SectionsGroups] ADD  CONSTRAINT [DF_SectionsGroups_Closed]  DEFAULT ((0)) FOR [Closed]
GO
alter table Sections
add SectionGroupCode int null
Go

------------------------End 2025-02-11------------------------------

-----------------------------------------  Hammad 2025-02-11 -------- 
SET IDENTITY_INSERT [dbo].[EmailTemplateType] ON 
GO
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode], [RequestTypeCode], [HaveUserAccount]) VALUES (497, N' Send Follow Request Visa to Employee ', N' إرسال طلب متابعة التأشيرة إلى الموظف', 0, 1, NULL, 1)
GO
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode], [RequestTypeCode], [HaveUserAccount]) VALUES (498, N' Send Follow Request Air Ticket to Employee ', N' إرسال طلب متابعة تذكرة طيران إلى الموظف', 0, 1, NULL, 1)
GO
SET IDENTITY_INSERT [dbo].[EmailTemplateType] OFF

INSERT [dbo].[EmailTemplate] ([Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode], [GeneralTypeCode], [JobTypeCode], [MessageTemplate]) 
VALUES ( N'  Send Follow Request Visa to Employee  ', N'  إرسال طلب متابعة التأشيرة إلى الموظف', 497, N' إرسال طلب متابعة التأشيرة إلى الموظف', N'  إرسال طلب متابعة التأشيرة إلى الموظف', 1, NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[EmailTemplate] ([Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode], [GeneralTypeCode], [JobTypeCode], [MessageTemplate]) VALUES 
(N' Send Follow Request Air Ticket to Employee ', N' إرسال طلب متابعة تذكرة طيران إلى الموظف', 498, N' إرسال طلب متابعة تذكرة طيران إلى الموظف', N' إرسال طلب متابعة تذكرة طيران إلى الموظف', 1, NULL, NULL, NULL, NULL)
GO
------------------------End 2025-02-11------------------------------