﻿
      -------------------------------------- M.Negm 2024-10-23 ---------------------

 delete from  EmailTemplate  where EmailTemplateCode in (4394, 4395, 4396)
 Go

 delete from  EmailTemplateType  where EmailTemplateTypeCode in (483, 484, 485)
 Go

 
SET IDENTITY_INSERT[dbo].[EmailTemplateType] ON
INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode],[RequestTypeCode],[HaveUserAccount])
VALUES(483,N' Request Delete',N'حذف طلب    ',0,1,Null , 1 )
SET IDENTITY_INSERT[dbo].[EmailTemplateType] OFF

SET IDENTITY_INSERT [dbo].[EmailTemplate] ON 
INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode])
VALUES(4394,N' Request Delete',N' حذف طلب   ',483,N'حذف طلب  ',N' حذف طلب  ',1,NULL)
SET IDENTITY_INSERT [dbo].[EmailTemplate] OFF 

  -------------------------------------- End 2024-10-22 ------------------------


       -------------------------------------- M.Negm 2024-10-30 ---------------------

     
  INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(1109,N'Financial Year',N'السنوات المالية ',584,N'/GenerlLedger/FinancialYears',N'Index','fa fa-thumb-tack',N'get',0,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(1109,18)
Go

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23119,N'السنوات المالية',N'Financial Year',1109,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23120,N'عرض السنوات المالية',N'View Financial Year',1109,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23121,N'إضافة السنوات المالية',N'Add Financial Year',1109,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23122,N'تعديل السنوات المالية',N'Edit Financial Year',1109,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23123,N'حذف السنوات المالية',N'Delete Financial Year',1109,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23124,N'حفظ السنوات المالية',N'Save Financial Year',1109,2)
Go

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(23125,N'إغلاق فترة فى السنة المالية',N'suspend Period in  Financial Year',1109,2)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType])
VALUES(23126,N'إغلاق  السنة المالية',N'Close Financial Year',1109,2)
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(2107,N'GenerlLedger',N'FinancialYears',N'Index',0,N'get',23119)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(2108,N'GenerlLedger',N'FinancialYears',N'FinancialYear_Read',0,N'post',23120)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(2109,N'GenerlLedger',N'FinancialYears',N'Save',1,N'get',23121)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(2110,N'GenerlLedger',N'FinancialYears',N'Save',2,N'get',23122)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(2111,N'GenerlLedger',N'FinancialYears',N'Delete',0,N'post',23123)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(2112,N'GenerlLedger',N'FinancialYears',N'Save',0,N'post',23124)


INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1543,NULL, NULL,N'FinancialYears',N'GetFinancialYearSearch',N'post')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1544,NULL, NULL,N'FinancialYears',N'Put',N'Put')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1545,NULL, NULL,N'FinancialYears',N'post',N'post')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1546,NULL, NULL,N'FinancialYears',N'Delete',N'Delete')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES(1547,NULL, NULL,N'FinancialYears',N'Get',N'Get')
Go


INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1897,1544,23122, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1898,1545,23124, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1899,1546,23123, NULL)
Go
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES(1900,1547,23120, NULL)
Go

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

  -------------------------------------- End 2024-10-30 ------------------------


