﻿ ---------------------------------------- AK 2025-11-16 ---------------------------------
CREATE TABLE [dbo].[CentralVacationTypes](
	[VacationCode] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](150) NULL,
	[Arabic_Name] [nvarchar](150) NULL,
	[Closed] [bit] NULL,
	[MDT] [datetime] NULL,
	[CreatedBy] [int] NOT NULL,
	[CreationDate] [datetime] NOT NULL,
	[ModifiedBy] [int] NULL,
	[ModificationDate] [datetime] NULL,
	[Serial] [nvarchar](150) NULL,
 CONSTRAINT [PK_CentralVacationTypes_VacationCode] PRIMARY KEY CLUSTERED 
(
	[VacationCode] 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].[CentralVacationTypes] ADD  CONSTRAINT [DF_CentralVacationTypes_Closed]  DEFAULT ((0)) FOR [Closed]
GO

ALTER TABLE [dbo].[CentralVacationTypes] ADD  CONSTRAINT [DF_CentralVacationTypes_MDT]  DEFAULT (getdate()) FOR [MDT]
GO

ALTER TABLE [dbo].[CentralVacationTypes] ADD  DEFAULT ((1)) FOR [CreatedBy]
GO

ALTER TABLE [dbo].[CentralVacationTypes] ADD  DEFAULT (getdate()) FOR [CreationDate]
GO

CREATE TABLE [dbo].[VacationCalculationWaysAnnualDiscount](
	[AnnualVacationDiscountCode] [int] IDENTITY(1,1) NOT NULL,
	[VacationCalcCode] [tinyint] NOT NULL,
	[AnnualDiscountCalculate] [float] NULL,
PRIMARY KEY CLUSTERED 
(
	[AnnualVacationDiscountCode] 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 AK 2025-11-16 -----------------------------
  ----------------------------------------End  2025-11-13 --------------

  ----------------------------------------Mostafa  2025-11-18 --------------

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES
(26147, N'عرض استطلاع تقييم الموظف', N'Employee Evaluation Survey View', 1138, 2),
(26148, N'حفظ استطلاع تقييم الموظف', N'Employee Evaluation Survey Save', 1138, 2)
Go

  ----------------------------------------End  2025-11-18 --------------شيي 
  ----------------------------------------Hammad  2025-11-19 --------------
INSERT [dbo].[LookupTables] ([TableName], [ControllerName], [ActionName], [DataValueField], [DataTextFieldEn], [DataTextFieldAr])
VALUES (N'FingerArea', N'Attendance/FingerArea', N'GetAllActiveAreaWithCode', N'FingerAreaCode', N'Name', N'Arabic_Name')
GO

ALTER TABLE LookupTables ALTER COLUMN ControllerName nvarchar(100) NULL;
ALTER TABLE LookupTables ALTER COLUMN ActionName nvarchar(100) NULL;
ALTER TABLE LookupTables ALTER COLUMN DataValueField nvarchar(50) NULL;
ALTER TABLE LookupTables ALTER COLUMN DataTextFieldEn nvarchar(50) NULL;
ALTER TABLE LookupTables ALTER COLUMN DataTextFieldAr nvarchar(50) NULL;
Go
ALTER TABLE LookupTables
ADD CategoryCode INT NULL;
Go
update LookupTables set CategoryCode=1
Go
 INSERT [dbo].[LookupTables] ([TableName],[CategoryCode])
VALUES (N'FingerAreaCheckPointLogs',3)
GO
 INSERT [dbo].[LookupTables] ([TableName],[CategoryCode])
VALUES (N'FingerAreaEmployee',3)
GO

  ----------------------------------------End  2025-11-19 --------------