﻿ ----------------------------------------- AK 2025-10-12 --------------------
UPDATE SystemMenu SET ActionName=NULL, HTTPMethod=NULL WHERE SystemMenuCode=1196
GO
UPDATE SystemMenu SET Arabic_Name=N'تكويدات', Name='Basic data', ControllerName='/', ActionName=NULL, HTTPMethod=NULL WHERE SystemMenuCode=1197
GO
INSERT INTO [SystemMenu](SystemMenuCode,Name,Arabic_Name,ParentID,ControllerName,ActionName,ImageURL,HTTPMethod,Sequence,IsVisible,ShowInPrivilegePage) VALUES (1199,N'Discount types',N'أنواع الخصم',1197,N'/SAL/DiscountType',N'Index',N'fa fa-thumb-tack',N'get',1,1,1)
GO
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(1199,21)
GO
DELETE SecurityPrivilege WHERE ID BETWEEN 22067 AND 22072
GO
INSERT INTO [SecurityPrivilege](ID,DescriptionAR,DescriptionEN,SystemMenuCode,PrivilegeType) VALUES (22066,N'تكويدات',N'Basic data',1197,1)
GO
INSERT INTO [SecurityPrivilege](ID,DescriptionAR,DescriptionEN,SystemMenuCode,PrivilegeType) VALUES (22067,N'أنواع الخصم',N'Discount types',1199,1)
GO
INSERT INTO [SecurityPrivilege](ID,DescriptionAR,DescriptionEN,SystemMenuCode,PrivilegeType) VALUES (22068,N'عرض أنواع الخصم',N'View Discount types',1199,2)
GO
INSERT INTO [SecurityPrivilege](ID,DescriptionAR,DescriptionEN,SystemMenuCode,PrivilegeType) VALUES (22069,N'إضافة أنواع الخصم',N'Add Discount types',1199,2)
GO
INSERT INTO [SecurityPrivilege](ID,DescriptionAR,DescriptionEN,SystemMenuCode,PrivilegeType) VALUES (22070,N'تعديل أنواع الخصم',N'Edit Discount types',1199,2)
GO
INSERT INTO [SecurityPrivilege](ID,DescriptionAR,DescriptionEN,SystemMenuCode,PrivilegeType) VALUES (22071,N'حذف أنواع الخصم',N'Delete Discount types',1199,2)
GO
INSERT INTO [SecurityPrivilege](ID,DescriptionAR,DescriptionEN,SystemMenuCode,PrivilegeType) VALUES (22072,N'حفظ أنواع الخصم',N'Save Discount types',1199,2)
GO
INSERT INTO [SystemMenu](SystemMenuCode,Name,Arabic_Name,ParentID,ControllerName,ActionName,ImageURL,HTTPMethod,Sequence,IsVisible,ShowInPrivilegePage) VALUES (1200,N'Price lists',N'قوائم الأسعار',1197,N'/SAL/PriceList',N'Index',N'fa fa-thumb-tack',N'get',1,1,1)
GO
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(1200,21)
GO
INSERT INTO [SecurityPrivilege](ID,DescriptionAR,DescriptionEN,SystemMenuCode,PrivilegeType) VALUES (22073,N'قوائم الأسعار',N'Price lists',1200,1)
GO
INSERT INTO [SecurityPrivilege](ID,DescriptionAR,DescriptionEN,SystemMenuCode,PrivilegeType) VALUES (22074,N'عرض قوائم الأسعار',N'View Price lists',1200,2)
GO
INSERT INTO [SecurityPrivilege](ID,DescriptionAR,DescriptionEN,SystemMenuCode,PrivilegeType) VALUES (22075,N'إضافة قوائم الأسعار',N'Add Price lists',1200,2)
GO
INSERT INTO [SecurityPrivilege](ID,DescriptionAR,DescriptionEN,SystemMenuCode,PrivilegeType) VALUES (22076,N'تعديل قوائم الأسعار',N'Edit Price lists',1200,2)
GO
INSERT INTO [SecurityPrivilege](ID,DescriptionAR,DescriptionEN,SystemMenuCode,PrivilegeType) VALUES (22077,N'حذف قوائم الأسعار',N'Delete Price lists',1200,2)
GO
INSERT INTO [SecurityPrivilege](ID,DescriptionAR,DescriptionEN,SystemMenuCode,PrivilegeType) VALUES (22078,N'حفظ قوائم الأسعار',N'Save Price lists',1200,2)
GO
 -----------------------------------------END AK 2025-10-12 --------------------

 ----------------------------------------- SHEHAB 2025-10-15 --------------------
GO
SET IDENTITY_INSERT [dbo].[AppModule] ON 
GO
INSERT [dbo].[AppModule] ([AppModuleCode], [Name], [Arabic_Name], [IsLicensed], [IntegrateWithLedger], [LicenseNumber]) VALUES (24, N'Survey', N'الاستطلاع', 0, 0, NULL)
GO
SET IDENTITY_INSERT [dbo].[AppModule] OFF
GO

GO
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (1185, N'Survey', N'الاستطلاع', NULL, NULL, NULL, N'fa-solid fa-square-poll-vertical', N'get', 17, 1, 1)
GO
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (1186, N'BasicData', N'بيانات اساسية', 1185, NULL, NULL, N'fas fa-database', N'get', 1, 1, 1)
GO
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (1187, N'SurveyType', N'انواع الاستطلاع', 1186, N'/Survey/SurveyType', N'Index', N'fa-solid fa-clipboard-list', N'get', 2, 1, 1)
GO

GO
SET IDENTITY_INSERT [dbo].[SystemMenuModule] ON 
GO
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (72881, 1185, 24)
GO
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (72882, 1186, 24)
GO
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (72883, 1187, 24)
GO
SET IDENTITY_INSERT [dbo].[SystemMenuModule] OFF
GO


GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (27000, N'نوع الاستطلاع', N'SurveyType', 1187, 1)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (27001, N'اضافة نوع استطلاع', N'Add SurveyType', 1187, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (27002, N'تعديل نوع استطلاع', N'Edit SurveyType', 1187, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (27003, N'حذف نوع استطلاع', N'Delete SurveyType', 1187, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (27004, N'عرض نوع الاستطلاع', N'SurveyType View', 1187, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (27005, N'حفظ نوع الاستطلاع', N'SaveSurveyType', 1187, 2)
GO

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (1189, N'Survey Category', N'فئات الاستطلاع', 1186, N'/Survey/SurveyCategory', N'Index', N'fas fa-list', N'get', 1, 1, 1)
GO
SET IDENTITY_INSERT [dbo].[SystemMenuModule] ON 
Go
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (72885, 1189, 24)
GO
SET IDENTITY_INSERT [dbo].[SystemMenuModule] OFF
GO


GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (27008, N'فئة الاستطلاع', N'Survey Category', 1189, 1)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (27009, N'حفظ فئة الاستطلاع', N'Save Survey Category', 1189, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (27010, N'حذف فئة الاستطلاع', N'Delete Survey Category', 1189, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (27011, N'اضافة فئة الاستطلاع', N'Add Survey Category', 1189, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (27012, N'عرض فئة الاستطلاع', N'View Survey Category', 1189, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (27013, N'تعديل فئة الاستطلاع', N'Edit Survey Category', 1189, 2)
GO


GO
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (1190, N'Survey', N'استطلاع', 1186, N'/Survey/Survey', N'Index', N'fa-solid fa-square-poll-vertical', N'get', 3, 1, 1)


Go
SET IDENTITY_INSERT [dbo].[SystemMenuModule] ON 
GO
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (74885, 1190, 24)
GO
SET IDENTITY_INSERT [dbo].[SystemMenuModule] OFF
GO


GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (27014, N'استطلاع', N'Survey', 1190, 1)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (27015, N'حفظ استطلاع', N'Save Survey', 1190, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (27016, N'اضافة استطلاع', N'Add Survey', 1190, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (27017, N'تعديل استطلاع ', N'Edit Survey', 1190, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (27018, N'حذف استطلاع', N'Delete Survey', 1190, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (27019, N'عرض استطلاع', N'View Survey', 1190, 2)

SET IDENTITY_INSERT [dbo].[EmailTemplateType] On
GO
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode], [RequestTypeCode], [HaveUserAccount]) VALUES (505, N'Send Employee Survey', N'ارسال استطلاع الي موظفين', 0, 24, NULL, 1)
GO
SET IDENTITY_INSERT [dbo].[EmailTemplateType] OFF
Go

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) 
VALUES (1198, N'Employee Survey', N'استطلاع الموظفين', 1185, N'/Survey/EmployeeSurvey', N'Index', N'fas fa-users', N'get', 4, 1, 1)
GO

GO
SET IDENTITY_INSERT [dbo].[SystemMenuModule] ON
GO
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (74908, 1198, 24)
GO
SET IDENTITY_INSERT [dbo].[SystemMenuModule] OFF
GO




GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (27020, N'استطلاع الموظفين', N'Employee Survey', 1198, 1)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (27021, N'عرض استطلاع الموظفين', N'View Employee Survey', 1198, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (27022, N'اضافة استطلاع الموظفين ', N'Add Employee Survey', 1198, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (27023, N'حفظ استطلاع الموظفين', N'Save Employee Survey', 1198, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (27024, N'حذف استطلاع الموظفين', N'Delete Employee Survey', 1198, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (27025, N'تعديل استطلاع الموظفين', N'Edit Employee Survey', 1198, 2)
GO


 -----------------------------------------END SHEHAB 2025-10-15 --------------------
 -----------------------------------------Hammad 2025-10-16 --------------------
  update [SST.ERP_Client].[dbo].[APIs] set ApiName='AdditionalHRAPI' where ApiId=10
  Go

   -----------------------------------------End 2025-10-16 --------------------