﻿
 -----------------------------------------Hammad 2025-04-17 -----------------
 ALTER TABLE dbo.FingerAreaCheckPointLogs ADD
	TimeCheckInOutPureDataId int NULL
GO
 -----------------------------------------End 2025-04-17 -----------------
 -----------------------------------------Hammad 2025-04-23 --------------
 INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) 
VALUES (719, N'Fingerprint in and out For Project', N'  بصمات الدخول والخروج للمشروع ', 1028, N'/Attendance/FingerPrintInOutProject', N'Index', N'fa fa-thumb-tack', N'get', 12, 1, 1)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13156, N'بصمات الدخول والخروج للمشروع', N'Fingerprint in and out For Project', 719, 1)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13157, N'عرض بصمات الدخول والخروج للمشروع', N'View Fingerprint in and out For Project', 719, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13158, N'إضافة بصمات الدخول والخروج للمشروع', N'Add Fingerprint in and out For Project', 719, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13159, N'حذف بصمة الدخول والخروج للمشروع', N'Delete Fingerprint in and out For Project', 719, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13160, N'حفظ بصمة الدخول والخروج للمشروع', N'Save Fingerprint in and out For Project', 719, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13161, N'تعديل بصمة الدخول والخروج للمشروع', N'Edit Fingerprint in and out For Project', 719, 2)
GO
INSERT [dbo].[SystemMenuModule] ([SystemMenuCode], [AppModuleCode]) VALUES (719, 1)
GO
 -----------------------------------------End 2025-04-23 --------------
 -----------------------------------------Ali 2025-04-27 --------------

 ALTER TABLE dbo.EmployeeFiltering ADD
	FromContractDate datetime NULL,
	ToContractDate datetime NULL,
	FromProbationDate datetime NULL,
	ToProbationDate datetime NULL,
	FromContractExpireDate datetime NULL,
	ToContractExpireDate datetime NULL,
	FromHiringDate datetime NULL,
	ToHiringDate datetime NULL,
	IsActive bit NOT NULL CONSTRAINT DF_EmployeeFiltering_IsActive_1 DEFAULT ((0))
GO

update dbo.EmployeeFiltering set IsActive=1
Go


  ALTER TABLE [Contract]
    ALTER COLUMN  ShowFacultyInNewHire bit NOT NULL;
    Go
 -----------------------------------------End 2025-04-27 --------------

