﻿

--------------------------------------- Negm  2024-05-12 ---------


INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1819,N'WorkFlow',N'MaintenanceType',N'Index',0,N'get',3188)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1820,N'WorkFlow',N'MaintenanceType',N'MaintenanceType_Read',0,N'post',3189)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1821,N'WorkFlow',N'MaintenanceType',N'Save',1,N'get',3190)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1822,N'WorkFlow',N'MaintenanceType',N'Save',2,N'get',3191)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1823,N'WorkFlow',N'MaintenanceType',N'Delete',0,N'post',3192)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1824,N'WorkFlow',N'MaintenanceType',N'Save',0,N'post',3193)
Go




INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1232,NULL, NULL,N'MaintenanceType',N'GetMaintenanceTypeSearch',N'post')
Go

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1233,NULL, NULL,N'MaintenanceType',N'GetMaintenanceType',N'Get')
Go																													

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1234,NULL, NULL,N'MaintenanceType',N'Put',N'Put')
Go																													

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1235,NULL, NULL,N'MaintenanceType',N'post',N'post')
Go																													

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1236,NULL, NULL,N'MaintenanceType',N'Delete',N'Delete')
Go																													

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1237,NULL, NULL,N'MaintenanceType',N'Get',N'Get')
Go


INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1514,1232,3189, NULL)
Go

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1515,1234,3193, NULL)
Go

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1516,1235,3193, NULL)
Go

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1517,1236,3192, NULL)
Go

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1518,1237,3191, NULL)
Go


--------------------------------------- End  2024-05-12 ------------

----------------------------------M.Negm 2024-05-13 ------------------ 
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1831,N'WorkFlow',N'GeneralRequestType',N'Index',0,N'get',3335)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1832,N'WorkFlow',N'GeneralRequestType',N'GeneralRequestType_Read',0,N'post',3336)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1833,N'WorkFlow',N'GeneralRequestType',N'Save',1,N'get',3337)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1834,N'WorkFlow',N'GeneralRequestType',N'Save',2,N'get',3338)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1835,N'WorkFlow',N'GeneralRequestType',N'Delete',0,N'post',3339)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1836,N'WorkFlow',N'GeneralRequestType',N'Save',0,N'post',3340)
Go




INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1244,NULL, NULL,N'GeneralRequestType',N'GetGeneralRequestTypeSearch',N'post')
Go

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1245,NULL, NULL,N'GeneralRequestType',N'GetGeneralRequestType',N'Get')
Go																													

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1246,NULL, NULL,N'GeneralRequestType',N'Put',N'Put')
Go																													

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1247,NULL, NULL,N'GeneralRequestType',N'post',N'post')
Go																													

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1248,NULL, NULL,N'GeneralRequestType',N'Delete',N'Delete')
Go																													

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1249,NULL, NULL,N'GeneralRequestType',N'Get',N'Get')
Go


INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1525,1244,3336, NULL)
Go

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1526,1246,3340, NULL)
Go

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1527,1247,3340, NULL)
Go

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1528,1248,3339, NULL)
Go

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1529,1249,3338, NULL)
Go

--------------------------------- End 2024-05-13 ---------------------

--------------------------------- Negm 2024-05-13 ---------------------

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1837,N'WorkFlow',N'MonthlyEffectType',N'Index',0,N'get',15021)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1838,N'WorkFlow',N'MonthlyEffectType',N'MonthlyEffectType_Read',0,N'post',15022)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1839,N'WorkFlow',N'MonthlyEffectType',N'Save',1,N'get',15023)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1840,N'WorkFlow',N'MonthlyEffectType',N'Save',2,N'get',15024)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1841,N'WorkFlow',N'MonthlyEffectType',N'Delete',0,N'post',15025)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1842,N'WorkFlow',N'MonthlyEffectType',N'Save',0,N'post',15026)
Go

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1250,NULL, NULL,N'MonthlyEffectType',N'GetMonthlyEffectTypeSearch',N'post')
Go

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1251,NULL, NULL,N'MonthlyEffectType',N'GetMonthlyEffectType',N'Get')
Go																													

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1252,NULL, NULL,N'MonthlyEffectType',N'Put',N'Put')
Go																													

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1253,NULL, NULL,N'MonthlyEffectType',N'post',N'post')
Go																													

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1254,NULL, NULL,N'MonthlyEffectType',N'Delete',N'Delete')
Go																													

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1255,NULL, NULL,N'MonthlyEffectType',N'Get',N'Get')
Go


INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1530,1250,15022, NULL)
Go

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1531,1252,15026, NULL)
Go

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1532,1253,15026, NULL)
Go

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1533,1254,15025, NULL)
Go

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1534,1255,15024, NULL)
Go

--------------------------------- End 2024-05-13 ---------------------
---------------------------------M.Negm 2024-05-13 -----------------------

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1843,N'WorkFlow',N'LetterTypes',N'Index',0,N'get',15261)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1844,N'WorkFlow',N'LetterTypes',N'letterTypes_Read',0,N'post',15262)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1845,N'WorkFlow',N'LetterTypes',N'Save',1,N'get',15263)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1846,N'WorkFlow',N'LetterTypes',N'Save',2,N'get',15264)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1847,N'WorkFlow',N'LetterTypes',N'Delete',0,N'post',15265)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1848,N'WorkFlow',N'LetterTypes',N'Save',0,N'post',15266)
Go



INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1256,NULL, NULL,N'LetterTypes',N'GetLetterTypeSearch',N'post')
Go

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1257,NULL, NULL,N'LetterType',N'GetLetterType',N'Get')
Go																													

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1258,NULL, NULL,N'LetterType',N'Put',N'Put')
Go																													

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1259,NULL, NULL,N'LetterType',N'post',N'post')
Go																													

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1260,NULL, NULL,N'LetterType',N'Delete',N'Delete')
Go																													

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1261,NULL, NULL,N'LetterType',N'Get',N'Get')
Go

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1535,1256,15262, NULL)
Go

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1536,1258,15266, NULL)
Go

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1537,1259,15266, NULL)
Go

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1538,1260,15265, NULL)
Go

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1539,1261,15264, NULL)
Go

-----------------------------End 2024-05-13 ------------------------------------------------------
-----------------------------Hammad 2024-05-13 ---------------------------------------------------
SET IDENTITY_INSERT [dbo].[EmailTemplateType] ON 
GO
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode],[HaveUserAccount]) 
VALUES (412, N'Send Email to New User', N'ارسال  بريد الكترونى الى المستخدم الجديد', 0, 6, 1)
GO
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode],[HaveUserAccount]) 
VALUES (413, N'Update User Name or Password', N'تعديل أسم المستخدم او كلمة السر', 0, 6, 1)
GO
SET IDENTITY_INSERT [dbo].[EmailTemplateType] OFF
GO

INSERT[dbo].[EmailTemplate]( [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) 
VALUES(N'Send Email to New User',N'ارسال  بريد الكترونى الى المستخدم الجديد',412,N'مستخدم جديد',N'تم إنشاء مستخدم جديد',1,NULL)
GO
INSERT[dbo].[EmailTemplate]( [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) 
VALUES(N'Send Email to Updated User Name or Password',N'إرسال بريد الكترونى  بتعديل أسم المستخدم او كلمة السر',413,N'تعديل بيانات المستخدم',N'تم تعديل أسم المستخدم او كلمة السر',1,NULL)
GO
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId], [ConfigDescription]) 
VALUES (N'SendEmailToNewOrUpdatedUser', N'Send Email to New or updated User  ', N' إرسال بريد الكترونى بانشاء او  بتعديل أسم المستخدم او كلمة السر ', N'false', 1, 57, 1, 1, NULL, NULL, NULL, N' إرسال بريد الكترونى بانشاء او  بتعديل أسم المستخدم او كلمة السر ')
GO
-----------------------------End 2024-05-13 ------------------------------------------------------

-----------------------------Negm  2024-05-13 ---------------------------------------------------

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1849,N'WorkFlow',N'LetterAuthority',N'Index',0,N'get',15255)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1850,N'WorkFlow',N'LetterAuthority',N'LetterAuthority_Read',0,N'post',15256)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1851,N'WorkFlow',N'LetterAuthority',N'Save',1,N'get',15257)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1852,N'WorkFlow',N'LetterAuthority',N'Save',2,N'get',15258)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1853,N'WorkFlow',N'LetterAuthority',N'Delete',0,N'post',15259)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1854,N'WorkFlow',N'LetterAuthority',N'Save',0,N'post',15260)
Go



INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1262,NULL, NULL,N'LetterAuthority',N'GetLetterAuthoritySearch',N'post')
Go

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1263,NULL, NULL,N'LetterAuthority',N'GetLetterAuthority',N'Get')
Go																													

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1264,NULL, NULL,N'LetterAuthority',N'Put',N'Put')
Go																													

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1265,NULL, NULL,N'LetterAuthority',N'post',N'post')
Go																													

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1266,NULL, NULL,N'LetterAuthority',N'Delete',N'Delete')
Go																													

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1267,NULL, NULL,N'LetterAuthority',N'Get',N'Get')
Go


INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1540,1262,15256, NULL)
Go

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1541,1264,15260, NULL)
Go

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1542,1265,15260, NULL)
Go

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1543,1266,15259, NULL)
Go

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1544,1267,15258, NULL)
Go

-----------------------------End 2024-05-13 ------------------------------------------------------
-----------------------------Mostafa 2024-05-14 ------------------------------------------------------

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1825,N'WorkFlow',N'BonusType',N'Index',0,N'get',3485)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1826,N'WorkFlow',N'BonusType',N'BonusType_Read',0,N'post',3486)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1827,N'WorkFlow',N'BonusType',N'Save',1,N'get',3487)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1828,N'WorkFlow',N'BonusType',N'Save',2,N'get',3488)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1829,N'WorkFlow',N'BonusType',N'Delete',0,N'post',3489)
GO
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1830,N'WorkFlow',N'BonusType',N'Save',0,N'post',3490)
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1238,NULL, NULL,N'BonusType',N'GetBonusTypeSearch',N'post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1239,NULL, NULL,N'BonusType',N'GetBonusType',N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1240,NULL, NULL,N'BonusType',N'Put',N'Put')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1241,NULL, NULL,N'BonusType',N'post',N'post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1242,NULL, NULL,N'BonusType',N'Delete',N'Delete')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1243,NULL, NULL,N'BonusType',N'Get',N'Get')
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1519,1238,3486, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1520,1239,3486, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1521,1240,3490, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1522,1241,3490, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1523,1242,3489, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1524,1243,3488, NULL)
GO
UPDATE WF_BonusType SET CreatedBy = 1 WHERE CreatedBy IS NULL OR CreatedBy = 0;
GO
UPDATE WF_BonusType SET CreationDate = GETDATE() WHERE CreationDate IS NULL;
GO

-----------------------------End 2024-05-14 ------------------------------------------------------

-----------------------------Negm  2024-05-14 ---------------------------------------------------


INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1855,N'WorkFlow',N'MissionPlace',N'Index',0,N'get',3535)
Go
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1856,N'WorkFlow',N'MissionPlace',N'MissionPlace_Read',0,N'post',3536)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1857,N'WorkFlow',N'MissionPlace',N'Save',1,N'get',3537)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1858,N'WorkFlow',N'MissionPlace',N'Save',2,N'get',3538)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1859,N'WorkFlow',N'MissionPlace',N'Delete',0,N'post',3539)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1860,N'WorkFlow',N'MissionPlace',N'Save',0,N'post',3540)
Go



INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1268,NULL, NULL,N'MissionPlace',N'GetMissionPlaceSearch',N'post')
Go																											

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1269,NULL, NULL,N'MissionPlace',N'Put',N'Put')
Go																													

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1270,NULL, NULL,N'MissionPlace',N'post',N'post')
Go																													

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1271,NULL, NULL,N'MissionPlace',N'Delete',N'Delete')
Go																													

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES(1272,NULL, NULL,N'MissionPlace',N'Get',N'Get')
Go


INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1545,1268,3536, NULL)
Go

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1546,1269,3540, NULL)
Go

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1547,1270,3540, NULL)
Go

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1548,1271,3539, NULL)
Go

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES(1549,1272,3538, NULL)
Go

-----------------------------End 2024-05-14 ------------------------------------------------------
-------------------------------------Negm 26-9-2023------------------------------

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) 
VALUES(1242,N'WorkFlow',N'NewEmployeesRequest',N'Index',0,N'get',3228)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) 
VALUES(1243,N'WorkFlow',N'NewEmployeesRequest',N'NewEmployeesRequest_Read',0,N'post',3229)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1244,N'WorkFlow',N'NewEmployeesRequest',N'Save',1,N'get',3230)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1245,N'WorkFlow',N'NewEmployeesRequest',N'Save',2,N'get',3231)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1246,N'WorkFlow',N'NewEmployeesRequest',N'Delete',0,N'post',3232)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) 
VALUES(1247,N'WorkFlow',N'NewEmployeesRequest',N'Save',0,N'post',3233)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1248,N'WorkFlow',N'NewEmployeesRequest',N'Cancel',0,N'post',3234)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1255,N'WorkFlow',N'NewEmployeesRequestSignature',N'Index',0,N'get',3235)
GO

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) 
VALUES(1256,N'WorkFlow',N'NewEmployeesRequestSignature',N'NewEmployeesRequestSignature_Read',0,N'post',3236)
GO

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) 
VALUES(1257,N'WorkFlow',N'NewEmployeesRequestSignature',N'Save',2,N'get',3237)
GO

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1258,N'WorkFlow',N'NewEmployeesRequestSignature',N'Save',0,N'post',3238)
GO

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES (826, NULL, NULL, N'NewEmplyeesRequestSignature', N'GetSignatureById', N'Get')
GO

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES (827, NULL, NULL, N'NewEmplyeesRequestSignature', N'GetNewEmployeesRequestSignatures', N'Get')
GO

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES (828, NULL, NULL, N'NewEmplyeesRequestSignature', N'GetRequestSignaturesByUser', N'Post')
GO

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES (829, NULL, NULL, N'NewEmplyeesRequestSignature', N'GetRequestHistory', N'Post')
GO

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES (830, NULL, NULL, N'NewEmplyeesRequestSignature', N'CancelRequest', N'Post')
GO

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod])
VALUES (831, NULL, NULL, N'NewEmplyeesRequestSignature', N'SaveSignature', N'Post')
Go

 INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) 
 VALUES (1051, 826, 3237, 14)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (1052, 827, 3237, 14)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (1053, 828, 3236, 14)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (1054, 829, 3237, 14)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (1055, 830, 3234, 14)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId])
VALUES (1056, 831, 3238, 14)
Go


------------------------------------ End ----------------------------------------

--------------------------Ali 2023-09-26-----------------------------

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(1019,N'Notifications',N'الاشعارات',479,N'',N'','fa fa-thumb-tack',N'',3,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(1019,13)
Go



INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(1020,N'Employees Notifications',N'اشعارات الموظفين',1019,N'/NotificationService/EmployeeNotification',N'Index','fa fa-thumb-tack',N'get',1,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(1020,13)
Go

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(16036,N'اشعارات الموظفين',N'Employees Notifications',1020,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(16037,N'عرض اشعارات الموظفين',N'View Employees Notifications',1020,2)
Go



INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1249,N'NotificationService',N'EmployeeNotification',N'Index',0,N'get',16036)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(1250,N'NotificationService',N'EmployeeNotification',N'EmployeeNotification_Read',0,N'post',16037)

Go

--------------------------End 2023-09-26-----------------------------
--------------------------Hammad 2023-09-27--------------------------
delete ConfigParameter where ConfigKey='RedirectLinkText'

INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId], [ConfigDescription]) 
VALUES (N'RedirectLinkText', N'Redirect link text', N'الاسم الظاهر على رابط الايميل', N'اضغط هنا', 1, 54, 4, 1, NULL, NULL, NULL, N'الاسم الظاهر على رابط الايميل')
GO
--------------------------End 2023-09-27--------------------------
--------------------------Hammad 2023-10-02-----------------------
ALTER TABLE dbo.WF_Track ADD
	TimePermissionCode tinyint NULL
GO

ALTER TABLE dbo.TimePermissionsTypes ADD
	HaveDifferentTrack bit NOT NULL CONSTRAINT DF_TimePermissionsTypes_HaveDifferentTrack DEFAULT ((0))
GO

--------------------------End 2023-10-02-----------------------
--------------------------Hammad 2023-10-03--------------------
ALTER TABLE dbo.WF_MissionPlaceLevel ADD
	BandCode int NULL
GO
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId], [ConfigDescription]) 
VALUES (N'WF_MissionPlaceBandWithLevel', N'Mission Place Band With Level', N'البند مع المستوى الوظيفى لمكان المامورية', N'false',2, 19, 1, 1, NULL, NULL, 0, N'امكانية تحديد اكثر من بند وكل بند له قيمة معينة فى المكان الواحد')
GO
--------------------------End 2023-10-03-----------------------
--------------------------Ali 2023-10-03--------------------
update [SecurityPrivilegeEndPoints] set [ControllerName]=N'NewEmplyeesRequest' where  Id=830
GO
--------------------------End 2023-10-03-----------------------

