﻿
-----------------------------------------Ali 2026-1-13  add to fix not if exist in db --------------------

ALTER TABLE dbo.VacationCalculationWays ADD
	[DropDayoffBalanceDueInCaseOfCameDuringAnotherVacation] [bit] NULL DEFAULT ((0))
GO

ALTER TABLE dbo.VacationCalculationWays ADD
    [IgnoreAnyAnnualConsumption] [bit] NULL DEFAULT ((0))
GO

ALTER TABLE dbo.VacationCalculationWays ADD
    [IgnoreAnyDayoffConsumption] [bit] NULL DEFAULT ((0))
GO

ALTER TABLE dbo.VacationCalculationWays ADD
    [IgnoreAnyHolidaysConsumption] [bit] NULL DEFAULT ((0))
GO

ALTER TABLE dbo.VacationCalculationWays ADD
    [FourthPostingTo] [int] NULL DEFAULT ((0))
GO

ALTER TABLE dbo.VacationCalculationWays ADD
    [PostingBalanceToNextYearFourth] [bit] NULL DEFAULT ((0))
GO

ALTER TABLE dbo.VacationCalculationWays ADD
    [SickBalanceDue] [float] NULL DEFAULT ((0))
GO

ALTER TABLE dbo.VacationCalculationWays ADD
    [NoBalnceAtAll] [bit] NULL DEFAULT ((0))
GO

ALTER TABLE dbo.VacationCalculationWays ADD
    [Closed] [bit] NULL DEFAULT ((0))
GO

ALTER TABLE dbo.VacationCalculationWays ADD
    [CalculateAccordCode] [tinyint] NULL DEFAULT ((0))
GO

ALTER TABLE dbo.VacationCalculationWays ADD
    [RemoveAnyDayoffBalanceAfterCloseMonthAccordingToLevel] [bit] NULL DEFAULT ((0))
GO

ALTER TABLE dbo.VacationCalculationWays ADD
    [ZeroDayoff] [bit] NULL DEFAULT ((0))
GO

ALTER TABLE dbo.VacationCalculationWays ADD
    [ZeroHoliday] [bit] NULL DEFAULT ((0))
GO

ALTER TABLE dbo.VacationCalculationWays ADD
    [SettlementOfDayOffBalancesAndHolidaysBeforeContract] [bit] NULL DEFAULT ((0))
GO

ALTER TABLE dbo.VacationCalculationWays ADD
    [RemoveAnyHolidayBalanceAfterCloseMonthAccordingToLevel] [bit] NULL DEFAULT ((0))
GO

ALTER TABLE dbo.VacationCalculationWays ADD
    [ShowMovementInScreenWithinTheYearOnly] [bit] NULL DEFAULT ((0))
GO

ALTER TABLE dbo.VacationCalculationWays ADD
    [DefaultTimeScheduleTypeCode] [int] NULL DEFAULT ((0))
GO

ALTER TABLE dbo.VacationCalculationWays ADD
    [NoEffectWithAnyLessenDueOfVacationsTypes] [bit] NULL DEFAULT ((0))
GO

ALTER TABLE dbo.VacationCalculationWays ADD
    [DayoffMinimumConsumesPerMonth] [float] NULL DEFAULT ((0))
GO

ALTER TABLE dbo.VacationCalculationWays ADD
    [DayoffExceptPreviousBalance] [bit] NULL DEFAULT ((0))
GO

ALTER TABLE dbo.VacationCalculationWays ADD
    [ConvertAllDayOffConsumptionAsAnnual] [bit] NULL DEFAULT ((0))
GO

ALTER TABLE dbo.VacationCalculationWays ADD
    [ConvertAllHolidayConsumptionAsAnnual] [bit] NULL DEFAULT ((0))
GO

ALTER TABLE dbo.VacationCalculationWays ADD
    [MinimumDaysToDroppingdayOffInVacationType] [float] NULL DEFAULT ((0))
GO

ALTER TABLE dbo.VacationCalculationWays ADD
    [DropSecondDayOfWeekendIfVacationConsumedSameWeek] [bit] NULL DEFAULT ((0))
GO

ALTER TABLE dbo.VacationCalculationWays ADD
    [DoNotDeductingDayFromHolidayEventDoubleWages] [bit] NULL DEFAULT ((0))
GO

ALTER TABLE dbo.VacationCalculationWays ADD
    [CentralCode] [int] NULL DEFAULT ((0))
GO

ALTER TABLE dbo.VacationCalculationWays ADD
    [DayoffAccordToTimeScheduleType] [bit] NULL DEFAULT ((0))
GO

ALTER TABLE dbo.VacationCalculationWays ADD
    [NotApplicableToVacationAccrual] [bit] NULL DEFAULT ((0))
GO

ALTER TABLE dbo.VacationCalculationWays ADD
 [Serial] [nvarchar](250) NULL
GO

ALTER TABLE dbo.VacationCalculationWays ADD
    [CreationDate] [datetime] NOT NULL DEFAULT (getdate())
GO

ALTER TABLE dbo.VacationCalculationWays ADD
    [CreatedBy] [int] NOT NULL DEFAULT ((1))
GO

ALTER TABLE dbo.VacationCalculationWays ADD
    [ModifiedBy] [int] NULL 
GO

ALTER TABLE dbo.VacationCalculationWays ADD
    [ModificationDate] [datetime] NULL 
GO

ALTER TABLE dbo.VacationCalculationWays ADD
    [IsDeleteAnnualLessThan6Months] [bit] NOT NULL DEFAULT ((0))
GO

-----------------------------------------End 2026-1-13 --------------------
-----------------------------------------Hammad 2026-1-14 -----------------

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) 
VALUES (15606, N'عرض كل انواع الطب العام', N'Display All General Request Type', 197, 2)
GO

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES 
(722, N'General Request Type Category', N'فئة نوع الطلب العام', 28, N'/WorkFlow/GeneralRequestTypeCategory', N'Index', N'fas fa-list-check', N'get', 14, 1, 1)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15607, N'فئة نوع الطلب العام', N'General Request Type Category ', 722, 1)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15608, N'عرض فئة نوع الطلب العام', N'View General Request Type Category', 722, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15609, N'إضافة فئة نوع الطلب العام', N'Add General Request Type Category', 722, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15610, N'تعديل فئة نوع الطلب العام', N'Edit General Request Type Category', 722, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15611, N'حذف فئة نوع الطلب العام', N'Delete General Request Type Category', 722, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15612, N'حفظ فئة نوع الطلب العام', N'Save General Request Type Category', 722, 2)
GO
INSERT [dbo].[SystemMenuModule] ([SystemMenuCode], [AppModuleCode]) VALUES (722, 1)
GO
-----------------------------------------End 2026-1-14 -----------------

-----------------------------------------Ali 2026-1-14 عشان يحل مشكله الترتيب مع workflow Api--------------------

  IF NOT EXISTS (SELECT 1 FROM sys.columns WHERE Name='HideFromRequest' AND Object_ID=Object_ID('ResignationReasons'))
BEGIN
ALTER TABLE ResignationReasons ADD HideFromRequest BIT Not NULL  DEFAULT ((0));
END
GO
-----------------------------------------End 2026-1-14 --------------------


