﻿
   -----------------------------------------Mostafa 2025-10-07 ------------------

   
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES 
(2230, N'Recruitment', N'QuestionTemplate', N'SaveRatingQuestion', 0, N'post', 5040)

select * from Rec_QuestionType

SET IDENTITY_INSERT Rec_QuestionType ON 
GO
INSERT Rec_QuestionType (QuestionTypeCode,Name,Arabic_Name) VALUES (6,N'Rating Questions ',N'أسئلة التقييم')
GO
SET IDENTITY_INSERT Rec_QuestionType OFF
GO

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES 
(2230, N'Recruitment', N'QuestionTemplate', N'SaveRatingQuestion', 0, N'post', 5040)
Go
SET IDENTITY_INSERT Rec_QuestionType ON 
GO
INSERT Rec_QuestionType (QuestionTypeCode,Name,Arabic_Name) VALUES (6,N'Rating Questions ',N'أسئلة التقييم')
GO
SET IDENTITY_INSERT Rec_QuestionType OFF
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES 
(2231, N'Recruitment', N'QuestionTemplate', N'SaveRankingQuestion', 0, N'post', 5040)
GO
SET IDENTITY_INSERT Rec_QuestionType ON 
GO
INSERT Rec_QuestionType (QuestionTypeCode,Name,Arabic_Name) VALUES (7,N'Ranking Questions ',N'أسئلة تصنيف')
GO
SET IDENTITY_INSERT Rec_QuestionType OFF
GO
   -----------------------------------------End 2025-10-07 ------------------
   -----------------------------------------Hammad 2025-10-08 ---------------
ALTER TABLE dbo.SecurityGroup ADD
	EmployeeRuleFilterId int NULL
GO
ALTER TABLE [dbo].[SecurityGroup]  WITH CHECK ADD  CONSTRAINT [FK_SecurityGroup_EmployeeRuleFilter] FOREIGN KEY([EmployeeRuleFilterId])
REFERENCES [dbo].[EmployeeRuleFilter] ([EmployeeRuleFilterId])
GO

ALTER TABLE [dbo].[SecurityGroup] CHECK CONSTRAINT [FK_SecurityGroup_EmployeeRuleFilter]
GO
   -----------------------------------------End 2025-10-08 ---------------