﻿---------------------Mostafa 2021-07-26------------

ALTER TABLE WF_RequestType ADD  SendEmailNotification bit  Not Null  DEFAULT ((1)) 
GO
---------------------end 2021-07-26------------
---------------------Ali 2021-07-26------------
INSERT INTO SecurityPrivilege (ID, DescriptionAR, DescriptionEN, SystemMenuCode,PrivilegeType)
VALUES (1297,N'عرض الاذونات',N'View Permissions', 3,2);
Go
---------------------end 2021-07-26------------
---------------------Hammad 2021-07-26---------
update SystemMenu set ControllerName='/Personal/SystemPersonalConfig' where SystemMenuCode=549
---------------------End 2021-07-26---------
---------------------Ali 2021-07-27---------

SET IDENTITY_INSERT [dbo].[Reports] ON 
INSERT [dbo].[Reports] ([ReportCode], [Name], [Arabic_Name], [ReportName], [AppModuleCode]) VALUES (13, N'Supplier Transaction', N'  حركات الموردين', N'SupplierTransactionReport.trdx', 12)
INSERT [dbo].[Reports] ([ReportCode], [Name], [Arabic_Name], [ReportName], [AppModuleCode]) VALUES (14, N'Item Balance', N'كارت الصنف', N'ItemBalance.trdx', 12)
SET IDENTITY_INSERT [dbo].[Reports] OFF
Go
---------------------End 2021-07-27---------


---------------------Mostafa 2021-07-28---------
ALTER TABLE [SST.ERP_Client].dbo.Clients ADD  IsHotel bit  Not Null  DEFAULT ((0)) 
GO

ALTER TABLE [SST.ERP_Client].dbo.Branches ADD  RoomsCount int Not Null DEFAULT 0
GO
---------------------End 2021-07-28---------
---------------------Ali 2021-07-28---------

  update SystemMenu
  set [Arabic_Name]=N'تقارير مجمعة بالفرع', Name =N'Consolidated Report By Branch' 
  where SystemMenuCode=541
  Go

  update [SecurityPrivilege] set 
	[DescriptionAR]=N'تقارير مجمعة بالفرع',
	[DescriptionEN]=N'Consolidated Report By Branch'
	where [ID]=11040

	update [SecurityPrivilege] set 
	[DescriptionAR]=N'عرض تقارير مجمعة بالفرع',
	[DescriptionEN]=N'View Consolidated Report By Branch'
	where [ID]=11041

 ALTER TABLE dbo.ConsolidatedReport ADD
	IsForAllBranchs bit NOT NULL DEFAULT ((0))
GO

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(551,N'Consolidated Report',N'تقارير مجمعة',182,N'/ConsolidatedDashboard/ConsolidatedBranchesReport',N'Index','fa fa-thumb-tack',N'get',7,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(551,9)
Go

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(11042,N'تقارير مجمعة',N'Consolidated Report',551,1)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(11043,N'عرض تقارير مجمعة',N'View Consolidated Report',551,2)
Go

INSERT [dbo].[ConsolidatedReport] ([ConsolidatedReportCode], [ReportName], [ReportNameAr], [Name], [Arabic_Name], [IsForAllBranchs]) VALUES (19, N'  BudgetAfterTaskForce.trdx', N' BudgetAfterTaskForce.trdx', N'Budget after task force', N'الموازنة العددية بعد الانتداب', 1)
INSERT [dbo].[ConsolidatedReport] ([ConsolidatedReportCode], [ReportName], [ReportNameAr], [Name], [Arabic_Name], [IsForAllBranchs]) VALUES (20, N'106_BasicData.trdx', N'106_BasicData.trdx', N'Basic Data', N'البيانات الاساسية ', 1)
INSERT [dbo].[ConsolidatedReport] ([ConsolidatedReportCode], [ReportName], [ReportNameAr], [Name], [Arabic_Name], [IsForAllBranchs]) VALUES (21, N'AttendaceByDetails.trdx', N'AttendaceByDetails.trdx', N'Attendance By Details', N'الحضور والانصراف بالتفاصيل', 0)
Go
---------------------End 2021-07-28---------
