﻿ ----------------------------Sayed 2025-04-07-------------------------
 CREATE TABLE [dbo].[PrefixTypes](
	[PrefixTypeCode] [int] NOT NULL,
	[Name] [nvarchar](255) NULL,
	[Arabic_Name] [nvarchar](255) NULL,
	[ShortName] [nvarchar](255) NULL,
	[ShortArabicName] [nvarchar](255) NULL,
	[OnlyFor] [tinyint] NULL,
	[Closed] [bit] NULL,
	[MDT] [datetime] NULL,
 CONSTRAINT [PK_PrefixTypes_PrefixTypeCode] PRIMARY KEY CLUSTERED 
(
	[PrefixTypeCode] 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

ALTER TABLE [dbo].[PrefixTypes] ADD  CONSTRAINT [DF_PrefixTypes_Closed]  DEFAULT ((0)) FOR [Closed]
GO

CREATE TABLE [dbo].[EmployeesData](
	[EmployeeCode] [int] NOT NULL,
	[AgeYear] [int] NULL,
	[AgeMonth] [int] NULL,
	[AgeDay] [int] NULL,
	[AgeText] [nvarchar](10) NULL,
	[AgeNumber] [float] NULL,
	[MDT] [datetime] NULL,
	[OfficePlace] [nvarchar](100) NULL,
	[EstimatedEndDateOfService] [datetime] NULL,
	[PrefixTypeCode] [smallint] NULL,
 CONSTRAINT [PK_EmployeesData] PRIMARY KEY CLUSTERED 
(
	[EmployeeCode] 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
 -----------------------------------------End 2025-04-07 --------------------
 -----------------------------------------Ali 2025-04-08 --------------------

 Update [dbo].[SystemMenu] Set ParentID=350,Sequence=6
 Where  SystemMenuCode= 1168
Go
 -----------------------------------------End 2025-04-08 --------------------

 -----------------------------------------Mostafa 2025-04-08 --------------------
 
    INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId],[ConfigDescription])
VALUES(N'DisplayEmployeeTitle',N'Display Employee Title',N'عرض لقب الموظف',N'false',1,50,1,1,Null,Null,Null,N'عرض لقب الموظف')
Go
 -----------------------------------------Mostafa 2025-04-09 --------------------
 -----------------------------------------Hammad 2025-04-10 --------------------

 INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) 
VALUES (718, N'Branches Transfer Request Signature', N'اعتماد طلب نقل الفروع  ', 500, N'/WorkFlow/BranchTransferRequestSignature', N'Index', N'fa fa-thumb-tack', N'get', 10, 1, 1)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15560, N'اعتماد طلب نقل الفروع', N'Branches Transfer Request Signature', 718, 1)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15561, N'عرض اعتماد طلب نقل الفروع', N'View Branches Transfer Request Signature', 718, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15562, N'تعديل اعتماد طلب نقل الفروع', N'Edit Branches Transfer Request Signature', 718, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15563, N'حفظ اعتماد طلب نقل الفروع', N'Save Branches Transfer Request Signature', 718, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15564, N'حفظ متعدد  طلب نقل الفروع', N'Save Multiple Branches Transfer Request Signature', 718, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15565, N'سجل طلبات  نقل للموظف', N'Transfers Request Employee History', 718, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15566, N'ارجاع طلب نقل الفروع', N'Inverse Branches Transfer Request Signature', 718, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15567, N'اختيار كل الطلبات', N'Choose All Requests', 718, 2)
GO

INSERT [dbo].[SystemMenuModule] ([SystemMenuCode], [AppModuleCode]) VALUES (718, 1)
GO
 -----------------------------------------End 2025-04-10 --------------------
