﻿--------------------------------- Ali 2024-05-21 ------------

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1310,NULL, NULL,N'Home',N'GetHealthCard',N'Get')
Go

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1311,NULL, NULL,N'Home',N'GetComprehensiveHealthInsurance',N'Get')
Go

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1585,1310,1419, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1586,1311,1420, NULL)
Go


INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1900,N'WorkFlow',N'PermissionsTypeConfig',N'Index',0,N'get',3360)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1901,N'WorkFlow',N'PermissionsTypeConfig',N'EditTimePermissionsType',0,N'post',3361)
Go

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1312,NULL, NULL,N'PermissionsTypeConfig',N'Get',N'Get')
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1313,NULL, NULL,N'PermissionsTypeConfig',N'Put',N'Put')
Go


INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1587,1312,3361, NULL)
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1588,1313,3361, NULL)
Go

--------------------------------- End 2024-05-21 ------------
--------------------------------- Hammad 2024-05-22 ---------
ALTER TABLE dbo.WF_Track ADD
	IgnoreDuplicateUser bit NOT NULL CONSTRAINT DF_WF_Track_IGnoreDuplicateUser DEFAULT ((0))
GO
Update WF_Track set SkippSendEmailAfterTrack=1
Go
--------------------------------- End 2024-05-22 ---------
--------------------------------- Ali 2024-05-22 ---------
ALTER TABLE dbo.WF_LoanType ADD
	[CreatedBy] [int] NOT NULL DEFAULT ((1)) ,
	[CreationDate] [datetime] NOT NULL  DEFAULT (getdate()),
	[ModificationDate] [datetime] NULL,
	[ModifiedBy] [int] NULL
GO
ALTER TABLE dbo.[WF_BonusType] ADD
	[CreatedBy] [int] NOT NULL DEFAULT ((1)) ,
	[CreationDate] [datetime] NOT NULL  DEFAULT (getdate()),
	[ModificationDate] [datetime] NULL,
	[ModifiedBy] [int] NULL
GO
ALTER TABLE dbo.[WF_FingerPrintType] ADD
	[CreatedBy] [int] NOT NULL DEFAULT ((1)) ,
	[CreationDate] [datetime] NOT NULL  DEFAULT (getdate()),
	[ModificationDate] [datetime] NULL,
	[ModifiedBy] [int] NULL
GO

ALTER TABLE dbo.VacationType ADD
	MaxDaysPerMonth int NULL
GO
--------------------------------- End 2024-05-22 ---------
--------------------------------- Mostafa 2024-05-22 ---------
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1902,N'WorkFlow',N'PenaltyType',N'Index',0,N'get',3965)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1903,N'WorkFlow',N'PenaltyType',N'PenaltyType_Read',0,N'post',3966)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1904,N'WorkFlow',N'PenaltyType',N'Save',0,N'post',3967)
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1316,NULL, NULL,N'PenaltyType',N'GetPenaltyTypeSearch',N'post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1317,NULL, NULL,N'PenaltyType',N'Put',N'Put')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1318,NULL, NULL,N'PenaltyType',N'Get',N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1590,1316,3966, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1591,1317,3967, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1592,1318,3308, NULL)
GO
UPDATE PenaltiesList SET CreatedBy = 1 WHERE CreatedBy IS NULL OR CreatedBy = 0;
GO
UPDATE PenaltiesList SET CreationDate = GETDATE() WHERE CreationDate IS NULL;
GO
--------------------------------- End 2024-05-22 ---------

--------------------------------M.Negm 2024-05-22 ---------------
CREATE TABLE [dbo].[EmployeeMobileAppData](
	[EmployeeCode] [int] NOT NULL,
	[WhatsappNumber] [nvarchar](20) NULL,
	[MDT] [datetime] NULL,
	[WhatsappNumberKey] [nvarchar](10) NULL,
 CONSTRAINT [PK_EmployeeMobileAppData] 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 2024-05-22 --------------------------------
------------------------------ Mostafa 2024-05-22 --------------------------------
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
 VALUES (256, N'Performance Evaluation Details Reports', N'تفاصيل تقييم الأداء', 224, N'/Appraisal/PerformanceEvaluationDetailsReports', N'Index', NULL, N'get', 5, 1, 1)
 Go

 INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10157, N'تفاصيل تقييم الأداء ', N'Performance Evaluation Details Reports ', 256, 1)
 Go
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10158, N'عرض تفاصيل تقييم الأداء', N'View Performance Evaluation Details Reports', 256, 2)
Go

INSERT [dbo].[SystemMenuModule] ([SystemMenuCode], [AppModuleCode]) VALUES (256, 8)
Go
------------------------------ End 2024-05-22 --------------------------------






