﻿
-------------------------------------- M.negm 2024-03-26 ---------------------
   
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) 
VALUES(1714,N'WorkFlow',N'ResignationRequestApi',N'Index',0,N'get',3100)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) 
VALUES(1715,N'WorkFlow',N'ResignationRequestApi',N'ResignationRequest_Read',0,N'post',3101)
Go

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

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

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

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

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


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

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) 
VALUES(1722,N'WorkFlow',N'ResignationRequestSignatureApi',N'ResignationRequest_Read',0,N'post',3108)
GO

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

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


 insert into SecurityPrivilegeEndPoints (id, ApiName,AreaName , ControllerName,ActionName, HTTPMethod)
 values(1183,NULL, NULL, N'ResignationRequestSignature', N'SaveSignature', N'Post')
Go 

 insert into SecurityPrivilegeEndPointsDetails
 (Id , SecurityPrivilegeEndPointId, SecurityPrivilegeId, RequestTypeId)
 values(1458,1183,3110,Null)
 Go

------------------------------------------ End 2024-03-26 --------------------------
------------------------------------------ Ali 2024-03-27 --------------------------

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) 
VALUES(13139,N'رفع مشاريع لمساحات البصمة',N'Upload Finger Areas Projectrs',582,2)
GO
------------------------------------------ End 2024-03-27 --------------------------
  --------------------------------------- AK 2024-03-27 ---------
INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId], [ConfigDescription])
 VALUES (N'SendWhatsAppMessageSetting', N'Send WhatsApp Message Settings', N'إعدادات إرسال رسالة الواتساب', N'99', 1, 51, 6, 1, NULL, NULL, NULL, N'إعدادات إرسال رسالة الواتساب')
 GO
 UPDATE ConfigParameter SET ConfigKey='SendWhatsAppMessageSetting', Name='Send WhatsApp Message Settings', Arabic_Name=N'إعدادات إرسال رسالة الواتساب', ConfigType=6, ConfigValue=99, ConfigDescription=N'إعدادات إرسال رسالة الواتساب', OrderNo=51 WHERE ConfigKey='SendWhatsAppMessageSetting'
 GO
 UPDATE ConfigParameter SET Arabic_Name=N'رقم الواتساب البديل', ConfigDescription=N'رقم الواتساب البديل' WHERE ConfigKey='WhatsAppAlternateMobileNumber' 
 GO
 DELETE ConfigParameter WHERE ConfigKey='SendWhatsAppMessages' 
 GO
 INSERT INTO ConfigLookup (ConfigLookupCode,Name, Arabic_Name, ConfigKey)
VALUES 
(99,N'Default settings', N'اعدادات افتراضية','SendWhatsAppMessageSetting'),
(100,N'Madar settings', N'اعدادات مدار','SendWhatsAppMessageSetting')
Go
--------------------------------------- End AK 2024-03-27 ------------

------------------------------------M.Negm 2024-03-27 ---------------------

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

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) 
VALUES(1765,N'WorkFlow',N'DisclaimerRequestSignatureApi',N'DisclaimerRequest_Read',0,N'post',3289)
GO

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

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID])
VALUES(1767,N'WorkFlow',N'DisclaimerRequestSignatureApi',N'Save',0,N'post',3291)
GO
----------------------------------- End 2024-03-27 ------------------------
------------------------------------Hammad 2024-03-28 ---------------------
SET IDENTITY_INSERT [dbo].[LookupTables] ON 
GO
INSERT [dbo].[LookupTables] ([LookupTableId], [TableName], [ControllerName], [ActionName], [DataValueField], [DataTextFieldEn], [DataTextFieldAr]) VALUES (9, N'TimeAttend', N'/Common', N'GetTimeAttend', N'MySerial', N'Date', N'Date')
GO
SET IDENTITY_INSERT [dbo].[LookupTables] OFF
GO

INSERT [dbo].[Parameters] ([ParameterCode], [DescriptionAr], [DescriptionEn], [ParameterName], [LookupTableId], [DataType], [IsString]) VALUES (11, N'تاريخ الحضور والإنصراف', N'Time Attend Date', N'Date', 9, 5, 0)
GO
----------------------------------- End 2024-03-28 ------------------------