﻿ ----------------------------------------- Hammad 2025-05-21 --------------------
update SystemMenu set ControllerName='/WorkFlow/RequestTypeAPI' where ControllerName='/WorkFlow/RequestType'
Go
 ----------------------------------------- End 2025-05-21 --------------------
 ----------------------------------------- Ali 2025-05-26 --------------------

 INSERT INTO [SecurityPrivilege](ID,DescriptionAR,DescriptionEN,SystemMenuCode,PrivilegeType) VALUES (15573,N'تعديل الطلب من الاعتماد',N'Edit Request From Signature',198,2)
GO

 ----------------------------------------- End 2025-05-26 --------------------
 ----------------------------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) 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) ON [PRIMARY]
) ON [PRIMARY]
GO
 -----------------------------------------End 2025-04-07 --------------------
 -----------------------------------------Ali 2025-05-27 --------------------

   ALTER TABLE dbo.Divisions ADD
	InformationTechnologyCode int NULL
GO

INSERT [dbo].[UserType] ([UserTypeCode], [Name], [Arabic_Name], [HaveEmployee], [OrganizationCategoryCode], [IsVisible]) VALUES (43, N'Information Technology', N'النظم والمعلومات ', 1, NULL, 1)
Go
 -----------------------------------------Ali 2025-05-27 --------------------

 update SystemMenu set  ControllerName='/WorkFlow/VacationTypeApi' where ControllerName='/WorkFlow/VacationType'
GO
update SystemMenu set ControllerName='/WorkFlow/RequestTypeAPI' where ControllerName='/WorkFlow/RequestType'
Go
UPDATE WF_RequestType set NotifSignCountController='OverTimeRequestSignatureApi' where RequestTypeId=3  
 Go
 UPDATE WF_RequestType set NotifSignCountController='OverTimeRequestFinalSignatureApi' where RequestTypeId=20
 Go
 Update SystemMenu set ControllerName='/WorkFlow/TrackApi' where SystemMenuCode=31
Go
Update SystemMenu set ControllerName='/WorkFlow/EmployeeTrackApi' where SystemMenuCode=32
Go
Update SystemMenu set ControllerName='/WorkFlow/OtherEmployeeTrackApi' where SystemMenuCode in (98,588)
Go
update WF_RequestType set NotifSignCountController='NewHireRequestSignatureAPi' where RequestTypeId=5
Go
update SystemMenu set ControllerName='/WorkFlow/NewHireRequestAPI' where SystemMenuCode=71
Go
update SystemMenu set ControllerName='/WorkFlow/NewHireRequestSignatureAPI' where SystemMenuCode=72
Go
update WF_RequestType set NotifSignCountController= N'PermissionRequestSignatureApi' where RequestTypeId=2
Go
update WF_RequestType set NotifSignCountController= N'FingerPrintRequestSignatureApi' where RequestTypeId=6
Go
update WF_RequestType set NotifSignCountController= N'CompensationDayOfRestRequestSignatureApi' where RequestTypeId=21
Go
update WF_RequestType set NotifSignCountController= N'CompensationReqFinalDayRestSignatureApi' where RequestTypeId=22
Go
update WF_RequestType set NotifSignCountController= N'LoanRequestSignatureApi' where RequestTypeId=9
Go
update WF_RequestType set NotifSignCountController= N'MonthlyEffectsRequestSignatureApi' where RequestTypeId=27
Go
update WF_RequestType set NotifSignCountController= N'OverTimeRequestSignatureApi' where RequestTypeId=3
Go
update WF_RequestType set NotifSignCountController= N'PenaltyRequestSignatureApi' where RequestTypeId=13
Go
update WF_RequestType set NotifSignCountController= N'PromotionRequestSignatureApi' where RequestTypeId=10
Go
update WF_RequestType set NotifSignCountController= N'ReimbursementRequestSignatureApi' where RequestTypeId=52
Go
update WF_RequestType set NotifSignCountController= N'ResignationRequestSignatureApi' where RequestTypeId=7
Go
update WF_RequestType set NotifSignCountController= N'DisclaimerRequestSignatureApi' where RequestTypeId=17
  Go 
update SystemMenu set ControllerName =N'/WorkFlow/PromotionRequestApi' where SystemMenuCode=89
 Go
update SystemMenu set ControllerName =N'/WorkFlow/PromotionRequestSignatureApi' where SystemMenuCode=90
 Go
update SystemMenu set ControllerName =N'/WorkFlow/PenaltyRequestApi' where SystemMenuCode=124
 Go
update SystemMenu set ControllerName =N'/WorkFlow/PenaltyRequestSignatureApi' where SystemMenuCode=126
 Go
update SystemMenu set ControllerName =N'/WorkFlow/FingerPrintRequestApi' where SystemMenuCode=69
 Go
update SystemMenu set ControllerName =N'/WorkFlow/FingerPrintRequestSignatureApi' where SystemMenuCode=70
 Go
update SystemMenu set ControllerName =N'/WorkFlow/CompensationRequestForADayOfRestApi' where SystemMenuCode=220
 Go
 update SystemMenu set ControllerName =N'/WorkFlow/CompensationDayOfRestRequestSignatureApi' where SystemMenuCode=221
 Go
 update SystemMenu set ControllerName =N'/WorkFlow/CompensationReqFinalDayRestSignatureApi' where SystemMenuCode=223
 Go
update SystemMenu set ControllerName =N'/WorkFlow/PermissionRequestApi' where SystemMenuCode=36
 Go
update SystemMenu set ControllerName =N'/WorkFlow/PermissionRequestSignatureApi' where SystemMenuCode=37
 Go
 update SystemMenu set ControllerName =N'/WorkFlow/ResignationRequestApi' where SystemMenuCode=80
 Go
 update SystemMenu set ControllerName =N'/WorkFlow/ResignationRequestSignatureApi' where SystemMenuCode=81
 Go
  update SystemMenu set ControllerName =N'/WorkFlow/DisclaimerRequestSignatureApi' where SystemMenuCode=148
 Go
 update SystemMenu set ControllerName =N'/WorkFlow/LoanRequestApi' where SystemMenuCode=84
 Go
 update SystemMenu set ControllerName =N'/WorkFlow/LoanRequestSignatureApi' where SystemMenuCode=85
 Go
 update SystemMenu set ControllerName =N'/WorkFlow/MonthlyEffectsRequestApi' where SystemMenuCode=239
 Go
 update SystemMenu set ControllerName =N'/WorkFlow/MonthlyEffectsRequestSignatureApi' where SystemMenuCode=240
 Go
   update SystemMenu set ControllerName =N'/WorkFlow/CombinedVacationsRequestApi' where ControllerName =N'/WorkFlow/CombinedVacationsRequest'
 Go
 update WF_RequestType set NotifSignCountController =N'CombinedVacationsRequestSignatureApi' where NotifSignCountController =N'CombinedVacationsRequestSignature'
 Go





