﻿
  ----------------------------------------Mostafa  2025-11-12 -----------------
delete SecurityGroupDetail  where PrivilegeID in(27026,27027,27028,27029,27030,27031)
GO
delete SecurityUserDetail where PrivilegeID in(27026,27027,27028,27029,27030,27031)
GO
delete SecurityPrivilege where ID in(27026,27027,27028,27029,27030,27031)
go
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES
(26141, N'عرض أسئلة إعداد التقييم', N'Appraisal Setting Questions View', 1113, 2),
(26142, N'إضافة أسئلة إعداد التقييم', N'Appraisal Setting Questions Add', 1113, 2),
(26143, N'تعديل أسئلة إعداد التقييم', N'Appraisal Setting Questions Edit', 1113, 2),
(26144, N'حذف أسئلة إعداد التقييم', N'Appraisal Setting Questions Delete', 1113, 2),
(26145, N'حفظ أسئلة إعداد التقييم', N'Appraisal Setting Questions Save', 1113, 2),
(26146, N'تحديث سؤال وجواب إعداد التقييم', N'Appraisal Setting Questions Answer Update', 1113, 2);
GO
  ----------------------------------------End  2025-11-12 -----------------
  ----------------------------------------Hammad  2025-11-12 --------------
  ALTER TABLE dbo.SecurityUser ADD
	AllLocations bit NOT NULL CONSTRAINT DF_SecurityUser_AllLocations DEFAULT ((0))
GO

UPDATE SecurityUser
SET AllLocations = 1 
WHERE SecurityUserCode IN (
    SELECT userLoc.SecurityUserCode
    FROM (  SELECT SecurityUserCode, COUNT(*) as UserLocationCount FROM SecurityUserLocation  GROUP BY SecurityUserCode) userLoc
    CROSS JOIN ( SELECT COUNT(*) as TotalLocationCount  FROM Location WHERE Closed = 0 ) loc
    WHERE userLoc.UserLocationCount = loc.TotalLocationCount )

Go

  ----------------------------------------End  2025-11-12 --------------
  ----------------------------------------Hammad  2025-11-13 -----------
  INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId], [ConfigDescription]) 
VALUES (N'WFResignationAddDisclaimerRequest', N'Add Disclaimer Request ', N'إضافة طلب إخلاء طرف من الاستقالة', N'102', 2, 10, 6, 1, NULL, NULL, 7, N'إضافة طلب إخلاء طرف من الاستقالة')
GO

INSERT [dbo].[ConfigLookup] ([ConfigLookupCode], [Name], [Arabic_Name], [ConfigKey]) VALUES (101, N'Ignoare Add  Disclaimer request', N'تجاهل إضافة طلب اخلاء طرف ', N'WFResignationAddDisclaimerRequest')
GO
INSERT [dbo].[ConfigLookup] ([ConfigLookupCode], [Name], [Arabic_Name], [ConfigKey]) VALUES (102, N'After Resignation approval', N'بعد الموافقة على طلب الاستقالة ', N'WFResignationAddDisclaimerRequest')
GO
INSERT [dbo].[ConfigLookup] ([ConfigLookupCode], [Name], [Arabic_Name], [ConfigKey]) VALUES (103, N'Befor Resignation approval', N'قبل الموافقة على طلب الاستقالة ', N'WFResignationAddDisclaimerRequest')
GO

update ConfigParameter set ConfigValue=102 where ConfigKey='WFResignationAddDisclaimerRequest' and (selecT ConfigValue from ConfigParameter where ConfigKey='WFAddDisclaimerRequestAfterResignationApproval')='true'
Go

Delete ConfigParameter where ConfigKey='WFAddDisclaimerRequestAfterResignationApproval'
Go

  ----------------------------------------End  2025-11-13 --------------