﻿
  -----------------------------------------SHEHAB 2025-07-2--------------------   
USE [SST.ERP_Client]
GO
INSERT [dbo].[APIs] ([ApiId], [ApiName], [PortNo]) VALUES (15, N'AdminCommh', NULL)
GO
SET IDENTITY_INSERT [dbo].[ClientsApis] ON 
GO
INSERT [dbo].[ClientsApis] ([ClientApiId], [ApiId], [ClientCode], [ApiUrl], [PublishUrl]) VALUES (33, 14, 1, N'https://localhost:7208/', NULL)
GO
SET IDENTITY_INSERT [dbo].[ClientsApis] OFF
GO
  -----------------------------------------End 2025-07-2--------------------

  -----------------------------------------’Mostafa 2025-07-2--------------------
  
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(1175,N'Employee Rule Filter',N'ترشحات الموظفين',1039,N'/EmployeeRuleFilter',N'Index','fa-solid fa-users',N'get',20,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(1175,6)
Go

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(1438,N'ترشحات الموظفين',N'Employee Rule Filter',1175,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(1439,N'عرض ترشحات الموظفين',N'View Employee Rule Filter',1175,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(1440,N'إضافة ترشحات الموظفين',N'Add Employee Rule Filter',1175,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(1441,N'تعديل ترشحات الموظفين',N'Edit Employee Rule Filter',1175,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(1442,N'حذف ترشحات الموظفين',N'Delete Employee Rule Filter',1175,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(1443,N'حفظ ترشحات الموظفين',N'Save Employee Rule Filter',1175,2)
Go



  -----------------------------------------End 2025-07-2--------------------
  -----------------------------------------Ali 2025-07-7--------------------

   INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId],[ConfigDescription])
VALUES(N'Wf_HideReplacementEmployee',N'Hide replacement employee',N'اخفاء الموظف البديل',N'false',2,53,1,1,Null,Null,11,N'اخفاء الموظف البديل بحيث يكون لها اولويه عن الموظف البديل اجبارى فى نوع الاجازه')
Go
  -----------------------------------------End 2025-07-7--------------------
  -----------------------------------------Ali 2025-07-8--------------------
  
   ALTER TABLE dbo.Rec_RecruitEmployeeExperiance ADD
	IsHotel bit NOT NULL CONSTRAINT DF_Rec_RecruitEmployeeExperiance_IsHotel DEFAULT ((0)),
	Area nvarchar(150) NULL,
	AverageServiceAllowance float(53) NULL,
	PreviousSalary float(53) NULL,
	RoomNumber int NULL
GO
  -----------------------------------------End 2025-07-8--------------------
  -----------------------------------------Hammad 2025-07-8-----------------

INSERT [dbo].[NotificationTemplateType] ([NotificationTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [NotificationTiming], [IsNotificationTimingEnabled], [DurationType], [Duration], [IsDurationEnabled], [SenderUserName], [SenderFrom], [SenderPassword], [SenderHostName], [SenderPort], [SenderName], [IsActive], [MinVacationBalance], [IsSendToOldManager], [MDT], [EnableSsl], [EnableAttachment], [HaveUserAccount], [IsSendWhatsAppNotifications], [IsSendRealTimeMobileNotifications], [IsSendEmailNotifications], [NotificationTypeCondition]) 
VALUES (28, N'Salary Approval', N'إعتماد المرتبات', 0, 6, 1, 1, 1, 0, N'sstdev65@gmail.com', N'sstdev65@gmail.com', N'Oxe5A5B94hEAX71eHkljEg==', N'smtp.gmail.com', 587, N'SST System', 1, NULL, 0, NULL, 1, 0, 1, 0, 0, 1, NULL)
GO

INSERT [dbo].[NotificationTemplate] ([Name], [Arabic_Name], [NotificationTemplateTypeCode], [Subject], [Body], [IsDefault], [MDT], [NotificationBody], [NotificationBody_Arabic]) 
VALUES ( N'Salary Approval', N'إعتماد المرتبات', 28, N'إعتماد المرتبات', N'تم&nbsp;إعتماد المرتبات', 1, NULL, NULL, NULL)
GO
  -----------------------------------------End 2025-07-8-----------------
 -----------------------------------------Hammad 2025-07-9--------------
  ALTER TABLE dbo.Closing ADD
	NotifIsSent bit NOT NULL CONSTRAINT DF_Closing_NotifIsSent DEFAULT 0
GO

update Closing set NotifIsSent=1
Go
-----------------------------------------End 2025-07-9--------------

  -----------------------------------------Ali 2025-07-9-----------------
   ALTER TABLE dbo.Rec_RecruitEmployeeExperiance ADD
	RecruitJobCode int NULL
GO
  -----------------------------------------End 2025-07-9-----------------

   
  ---------------------------------Sayed 2025-07-09--------------------------
  INSERT [dbo].[LabelsName] ([LabelKey], [Name], [Arabic_Name]) VALUES (N'VacationRemark', N'Comment', N'التعليق')
GO
-------------------------------End----------------------------------------------

