﻿ 
  -------------------------------------- M.Negm  2024-10-10 ------------------------
CREATE TABLE [dbo].[FingerAreaRegion](
[FingerAreaRegionCode] [int] IDENTITY(1,1) NOT NULL,
[Arabic_Name] [nvarchar](150) NOT NULL,
[Name] [nvarchar](150) NOT NULL,
[CreatedBy] [int] NOT NULL,
[CreationDate] [datetime] NOT NULL,
[ModifiedBy] [int] NULL,
[ModificationDate] [datetime] NULL,
CONSTRAINT [PK_FingerAreaRegion] PRIMARY KEY CLUSTERED 
(
[FingerAreaRegionCode] 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

CREATE TABLE [dbo].[FingerAreaRegionPoint](
[FingerAreaRegionPointCode] [int] IDENTITY(1,1) NOT NULL,
[FingerAreaRegionCode] [int] NOT NULL,
[Latitude] [float] NOT NULL,
[Longitude] [float] NOT NULL,
CONSTRAINT [PK_FingerAreaRegionPoint] PRIMARY KEY CLUSTERED 
(
[FingerAreaRegionPointCode] 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].[FingerAreaRegionPoint]  WITH CHECK ADD  CONSTRAINT [FK_FingerAreaRegionPoint_FingerAreaRegion] FOREIGN KEY([FingerAreaRegionCode])
REFERENCES [dbo].[FingerAreaRegion] ([FingerAreaRegionCode])
GO

ALTER TABLE [dbo].[FingerAreaRegionPoint] CHECK CONSTRAINT [FK_FingerAreaRegionPoint_FingerAreaRegion]
GO


INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(709,N'Finger Area Region ',N'مناطق مساحة البصمة ',1028,N'/Attendance/FingerAreaRegion',N'Index','fas fa-fingerprint',N'get',11,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(709,11)
Go

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(13150,N'مناطق مساحةالبصمة ',N'Finger Area Region ',709,1)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(13151,N'عرض مناطق مساحة البصمة',N'View Finger Area Region',709,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(13152,N'إضافة مناطق مساحة البصمة',N'Add Finger Area Region ',709,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(13153,N'تعديل مناطق مساحة البصمة',N'Edit Finger Area Region ',709,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(13154,N'حذف مناطق مساحة البصمة',N'Delete Finger Area Region ',709,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(13155,N'حفظ مناطق مساحة البصمة',N'Save Finger Area Region ',709,2)
Go


INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(2037,N'Attendance',N'FingerAreaRegion',N'Index',0,N'get',13150)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(2038,N'Attendance',N'FingerAreaRegion',N'FingerAreaRegion_Read',0,N'post',13151)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(2039,N'Attendance',N'FingerAreaRegion',N'Save',1,N'get',13152)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(2040,N'Attendance',N'FingerAreaRegion',N'Save',2,N'get',13153)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(2041,N'Attendance',N'FingerAreaRegion',N'Delete',0,N'post',13154)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(2042,N'Attendance',N'FingerAreaRegion',N'Save',0,N'post',13155)
GO


ALTER TABLE dbo.FingerArea ADD FingerAreaRegionCode int  NULL

ALTER TABLE [dbo].[FingerArea]  WITH CHECK ADD  CONSTRAINT [FK_FingerArea_FingerAreaRegion] FOREIGN KEY([FingerAreaRegionCode])
REFERENCES [dbo].[FingerAreaRegion] ([FingerAreaRegionCode])
GO


 -------------------------------------- End 2024-10-10 ------------------------
 -------------------------------------- Ali 2024-10-10 ------------------------ 
 ALTER TABLE dbo.VacationType ADD
	IsMissionPlace bit NOT NULL CONSTRAINT DF_VacationType_IsMissionPlace DEFAULT ((0))
GO
 -------------------------------------- End 2024-10-10 ------------------------
 -------------------------------------- Hammad 2024-10-13 ------------------------
 INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId], [ConfigDescription]) 
VALUES (N'Wf_TimeSheetMonthlyEffectHaveSameCalculatedBy', N'Add Monthly effect Type with same Calculated by', N' اضافة أنواع مؤثرات للطلب لها نفس نوع الاحتساب ', N'false', 2, 1, 1, 1, NULL, NULL, 55, N' اضافة أنواع مؤثرات للطلب لها نفس نوع الاحتساب')
GO
 -------------------------------------- End 2024-10-13 ------------------------

  -------------------------------------- M.Negm 2024-10-13 ------------------------ 

ALTER TABLE EmployeeFiltering
ADD [SalaryPayWayCode] INT NULL;
GO

 -------------------------------------- End 2024-10-13 ------------------------