﻿----------------------------AK 2022-06-12-----
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(1353,N'عرض بيانات فريق عملي',N'View My Teamwork',623,2)
Go
insert into LabelsName(LabelKey,Name,Arabic_Name) values('MyTeamworkLabel','My Teamwork',N'فريق عملي')
GO
----------------------------End 2022-06-12-----
----------------------------Mostafa 2022-06-13-----
INSERT INTO SecurityPrivilege (ID, DescriptionAR, DescriptionEN, SystemMenuCode,PrivilegeType)
VALUES  (7038, N'عرض الطلبات الأكاديمية', N'Academic Applications View', 104,2)
GO
----------------------------End 2022-06-13-----
----------------------------AK 2022-06-13-----
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Arabic_Name], [Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(633,N'بيانات فريق عملي',N'View My Teamwork',613,N'',N'','fa fa-thumb-tack',N'',12,0,1)
Go
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(633,6)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(1354,N'عرض بيانات فريق عملي',N'View My Teamwork',633,2)
Go
UPDATE [dbo].[SecurityPrivilege] SET [DescriptionAR]=N'بيانات فريق عملي', [DescriptionEN]=N'My Teamwork', [PrivilegeType]=1, [SystemMenuCode]=633  WHERE Id=1353
Go
UPDATE [dbo].[SecurityPrivilege] SET [SystemMenuCode]=633  WHERE Id=1354
Go
----------------------------End 2022-06-13-----
----------------------------Hammad 2022-06-14-----
INSERT INTO SecurityPrivilege (ID, DescriptionAR, DescriptionEN, SystemMenuCode,PrivilegeType)
VALUES  (7040, N'عرض  مدن الموظفين', N'Employees Cities View', 104,2)
GO
----------------------------End 2022-06-14-----
----------------------------MOstafa 2022-06-15-----
INSERT INTO SecurityPrivilege (ID, DescriptionAR, DescriptionEN, SystemMenuCode,PrivilegeType)
VALUES  (7041, N'عرض  اعداد الذكور والاناث', N'Numbers Males And Females View', 104,2)
GO
----------------------------End 2022-06-15-----
----------------------------Hammad 2022-06-16-----
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType])
 VALUES (7042, N'عرض زيادة المرتبات بالادارات', N'View Department Promotion Statistics', 107, 2)
GO
----------------------------End 2022-06-16-----
----------------------------MOstafa 2022-06-16-----
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType])
 VALUES (7043, N'عرض الاجازات بالادارات', N'View Department vacations Statistics ', 104, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType])
 VALUES (7044, N'عرض الجزاء بالادارات', N'View Department Penalties Statistics ', 104, 2)
GO
----------------------------End 2022-06-16-----
----------------------------MOstafa 2022-06-19-----
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType])
 VALUES (7045, N'عرض المؤهلات الدراسية', N'View Qualifications', 104, 2)
GO
----------------------------End 2022-06-19-----
----------------------------Hammad 2022-06-20-----
delete SecurityGroupDetail where PrivilegeID=7039
delete SecurityPrivilege where ID=7039
Go
----------------------------End 2022-06-20-----


----------------------------Ali 2022-06-21-----
 
  DROP TABLE WF_VehicleRequestSignature
  DROP TABLE WF_VehicleRequest
  DROP TABLE WF_MaintenanceRequestSignature
  DROP TABLE WF_MaintenanceRequest
  DROP TABLE WF_BonusRequestSignature
  DROP TABLE WF_BonusRequest
  Go
----------------------------End 2022-06-21-----
----------------------------Hammad 2022-06-22-----
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
 VALUES (632, N'Publication Request Report', N'تقارير المنشور  ', 627, N'/WFAcademic/PublicationRequestReport', N'Index', N'fa fa-thumb-tack', N'get', 2, 1, 1)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15304, N'تقارير المنشور    ', N'Publication Request Report', 632, 1)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (15305, N'عرض تقارير المنشور  ', N'View Publication Request Report', 632, 2)
GO
INSERT [dbo].[SystemMenuModule] ([SystemMenuCode], [AppModuleCode]) VALUES (632, 16)
GO
----------------------------End 2022-06-22-----
----------------------------AK 2022-06-22-----
INSERT INTO [dbo].[WF_CompensationAllowanceTypes]
SELECT top(1) N'Compensating allowance for a rest day',N'بدل تعويض يوم راحة',[AllowanceType],[Factor],[CalculationNumber],[FactorTypeCode],[ItemNumber],[VacationType],[IsVisable],[ShiftCode],[BalanceFactor],[BalanceFactorTypeCode],[DeserveOverTime],[OverTimeBandCode],[WorkingHourExchangeCode],1 [DayOfWeek] FROM [dbo].[WF_CompensationAllowanceTypes] WHERE VacationType=1 AND [DayOfWeek] IS NULL
INSERT INTO [dbo].[WF_CompensationAllowanceTypes]
SELECT top(1) N'Compensating allowance for a rest day',N'بدل تعويض يوم راحة',[AllowanceType],[Factor],[CalculationNumber],[FactorTypeCode],[ItemNumber],[VacationType],[IsVisable],[ShiftCode],[BalanceFactor],[BalanceFactorTypeCode],[DeserveOverTime],[OverTimeBandCode],[WorkingHourExchangeCode],2 [DayOfWeek] FROM [dbo].[WF_CompensationAllowanceTypes] WHERE VacationType=1 AND [DayOfWeek] IS NULL
INSERT INTO [dbo].[WF_CompensationAllowanceTypes]
SELECT top(1) N'Compensating allowance for a rest day',N'بدل تعويض يوم راحة',[AllowanceType],[Factor],[CalculationNumber],[FactorTypeCode],[ItemNumber],[VacationType],[IsVisable],[ShiftCode],[BalanceFactor],[BalanceFactorTypeCode],[DeserveOverTime],[OverTimeBandCode],[WorkingHourExchangeCode],3 [DayOfWeek] FROM [dbo].[WF_CompensationAllowanceTypes] WHERE VacationType=1 AND [DayOfWeek] IS NULL
INSERT INTO [dbo].[WF_CompensationAllowanceTypes]
SELECT top(1) N'Compensating allowance for a rest day',N'بدل تعويض يوم راحة',[AllowanceType],[Factor],[CalculationNumber],[FactorTypeCode],[ItemNumber],[VacationType],[IsVisable],[ShiftCode],[BalanceFactor],[BalanceFactorTypeCode],[DeserveOverTime],[OverTimeBandCode],[WorkingHourExchangeCode],4 [DayOfWeek] FROM [dbo].[WF_CompensationAllowanceTypes] WHERE VacationType=1 AND [DayOfWeek] IS NULL
INSERT INTO [dbo].[WF_CompensationAllowanceTypes]
SELECT top(1) N'Compensating allowance for a rest day',N'بدل تعويض يوم راحة',[AllowanceType],[Factor],[CalculationNumber],[FactorTypeCode],[ItemNumber],[VacationType],[IsVisable],[ShiftCode],[BalanceFactor],[BalanceFactorTypeCode],[DeserveOverTime],[OverTimeBandCode],[WorkingHourExchangeCode],5 [DayOfWeek] FROM [dbo].[WF_CompensationAllowanceTypes] WHERE VacationType=1 AND [DayOfWeek] IS NULL
INSERT INTO [dbo].[WF_CompensationAllowanceTypes]
SELECT top(1) N'Compensating allowance for a rest day',N'بدل تعويض يوم راحة',[AllowanceType],[Factor],[CalculationNumber],[FactorTypeCode],[ItemNumber],[VacationType],[IsVisable],[ShiftCode],[BalanceFactor],[BalanceFactorTypeCode],[DeserveOverTime],[OverTimeBandCode],[WorkingHourExchangeCode],6 [DayOfWeek] FROM [dbo].[WF_CompensationAllowanceTypes] WHERE VacationType=1 AND [DayOfWeek] IS NULL
INSERT INTO [dbo].[WF_CompensationAllowanceTypes]
SELECT top(1) N'Compensating allowance for a rest day',N'بدل تعويض يوم راحة',[AllowanceType],[Factor],[CalculationNumber],[FactorTypeCode],[ItemNumber],[VacationType],[IsVisable],[ShiftCode],[BalanceFactor],[BalanceFactorTypeCode],[DeserveOverTime],[OverTimeBandCode],[WorkingHourExchangeCode],7 [DayOfWeek] FROM [dbo].[WF_CompensationAllowanceTypes] WHERE VacationType=1 AND [DayOfWeek] IS NULL
Go
----------------------------End 2022-06-22-----
