
-------------------------------Hammad 2020-03-26-----------
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType])
 VALUES (3515, N'إضافة طلب وقت إضافى لموظفين', N' Add Employees OverTime Request ', 64, 2)
GO
-------------------------------End 2020-03-26------------
-------------------------------Hammad 2020-03-29---------
ALTER TABLE WF_OverTimeRequest 
Alter COLUMN SectionCode nvarchar(6)  null;
Go
-------------------------------End 2020-03-29------------
-------------------------------Hammad 2020-03-30------------


INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) 
VALUES (246, N' Appraisal Settings', N'إعدادات التقيم', 161, NULL, NULL, N'fa fa-cogs', NULL, 1, 1, 1)
Go

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) 
VALUES (10074, N'إعدادات التقيم', N' Appraisal Settings', 246, 1)
Go

INSERT [dbo].[SystemMenuModule] ([SystemMenuCode], [AppModuleCode]) VALUES ( 246, 8)
Go

update SystemMenu set ParentID=246
where SystemMenuCode in (162,166,167,170,171,188,235,339,341)

update SystemMenu set Sequence=18
where SystemMenuCode=224
GO
-------------------------------End 2020-03-30------------
-------------------------------Hammad 2020-03-31------------
 INSERT [dbo].[ConfigParameter] ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId]) 
VALUES (N'DisplayMovementVacationsCalendar', N'Display Movement Vacations in Calendar', N'عرض حركة الاجازة على هيئة تقويم', N'false', 1, 9, 1, 1, NULL, NULL, NULL)
Go
-------------------------------End 2020-03-31------------
-------------------------------Hammad 2020-04-01---------

 INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType])
 VALUES (1197, N'عرض  حضورى', N'View My Attendance', 3, 2)
 GO
 -------------------------------End 2020-04-01---------
  ------------------------------- A.Khaled 2020-04-02 --------------------------    
CREATE TABLE [dbo].[WF_StoreTransactionRequests](
	[MasterRequestCode] [int] NOT NULL,
	[StoreCode] [int] NOT NULL,
	[VendorCode] [int] NULL,
	[CustomerCode] [int] NULL,
 CONSTRAINT [PK_WF_StoreTransactionRequests] PRIMARY KEY CLUSTERED 
(
	[MasterRequestCode] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[WF_StoreTransactionRequests]  WITH CHECK ADD  CONSTRAINT [FK_WF_StoreTransactionRequests_INV_Stores] FOREIGN KEY([StoreCode])
REFERENCES [dbo].[INV_Stores] ([StoreCode])
GO

ALTER TABLE [dbo].[WF_StoreTransactionRequests] CHECK CONSTRAINT [FK_WF_StoreTransactionRequests_INV_Stores]
GO

ALTER TABLE [dbo].[WF_StoreTransactionRequests]  WITH CHECK ADD  CONSTRAINT [FK_WF_StoreTransactionRequests_WF_Customer] FOREIGN KEY([CustomerCode])
REFERENCES [dbo].[WF_Customer] ([CustomerCode])
GO

ALTER TABLE [dbo].[WF_StoreTransactionRequests] CHECK CONSTRAINT [FK_WF_StoreTransactionRequests_WF_Customer]
GO

ALTER TABLE [dbo].[WF_StoreTransactionRequests]  WITH CHECK ADD  CONSTRAINT [FK_WF_StoreTransactionRequests_WF_MasterRequests] FOREIGN KEY([MasterRequestCode])
REFERENCES [dbo].[WF_MasterRequests] ([MasterRequestCode])
GO

ALTER TABLE [dbo].[WF_StoreTransactionRequests] CHECK CONSTRAINT [FK_WF_StoreTransactionRequests_WF_MasterRequests]
GO

ALTER TABLE [dbo].[WF_StoreTransactionRequests]  WITH CHECK ADD  CONSTRAINT [FK_WF_StoreTransactionRequests_WF_Vendor] FOREIGN KEY([VendorCode])
REFERENCES [dbo].[WF_Vendor] ([VendorCode])
GO

ALTER TABLE [dbo].[WF_StoreTransactionRequests] CHECK CONSTRAINT [FK_WF_StoreTransactionRequests_WF_Vendor]
GO

CREATE TABLE [dbo].[WF_StoreTransactionRequestsDetails](
	[StoreTransactionRequestDetailCode] [int] IDENTITY(1,1) NOT NULL,
	[MasterRequestCode] [int] NOT NULL,
	[ItemCode] [int] NOT NULL,
	[Quantity] [float] NOT NULL,
	[AverageCost] [float] NOT NULL,
 CONSTRAINT [PK_WF_StoreTransactionRequestsDetails] PRIMARY KEY CLUSTERED 
(
	[StoreTransactionRequestDetailCode] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[WF_StoreTransactionRequestsDetails]  WITH CHECK ADD  CONSTRAINT [FK_WF_StoreTransactionRequestsDetails_INV_Items] FOREIGN KEY([ItemCode])
REFERENCES [dbo].[INV_Items] ([ItemCode])
GO

ALTER TABLE [dbo].[WF_StoreTransactionRequestsDetails] CHECK CONSTRAINT [FK_WF_StoreTransactionRequestsDetails_INV_Items]
GO

ALTER TABLE [dbo].[WF_StoreTransactionRequestsDetails]  WITH CHECK ADD  CONSTRAINT [FK_WF_StoreTransactionRequestsDetails_WF_StoreTransactionRequests] FOREIGN KEY([MasterRequestCode])
REFERENCES [dbo].[WF_StoreTransactionRequests] ([MasterRequestCode])
GO

ALTER TABLE [dbo].[WF_StoreTransactionRequestsDetails] CHECK CONSTRAINT [FK_WF_StoreTransactionRequestsDetails_WF_StoreTransactionRequests]
GO
------------------------------- End 2020-04-02--------------------------
------------------------------- A.Khaled 2020-04-05 --------------------------
DROP TABLE [dbo].[WF_PurchasesRequestSignature]
GO
DROP TABLE [dbo].[WF_PurchasesRequestDetails]
GO
DROP TABLE [dbo].[WF_PurchasesRequest]
GO

DROP TABLE [dbo].[WF_RequisitionFormRequestSignature]
GO
DROP TABLE [dbo].[WF_RequisitionFormRequestDetails]
GO
DROP TABLE [dbo].[WF_RequisitionFormRequest]
GO
------------------------------- End 2020-04-05 --------------------------

------------------------------- Ali 2020-04-05 --------------------------
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (342, N'Transactions Statistics quarterly', N' إحصائيات المعاملات ربع سنوى', 150, N'/AdminComm/ReportTransAuthStatisticsQuarterly', N'Index', N' fa fa-thumb-tack', N'grt', 4, 1, 1)
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (343, N'Transactions Statistics Semi  Annually', N' إحصائيات المعاملات نصف سنوى', 150, N'/AdminComm/ReportTransAuthStatisticsSemiAnnually', N'Index', N' fa fa-thumb-tack', N'grt', 5, 1, 1)
Go

INSERT [dbo].[SystemMenuModule] ( [SystemMenuCode], [AppModuleCode]) VALUES ( 342, 2)
INSERT [dbo].[SystemMenuModule] ( [SystemMenuCode], [AppModuleCode]) VALUES ( 343, 2)
Go

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (2129, N'  إحصائيات المعاملات ربع سنوى', N'Transactions Statistics Quarterly', 342, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (2130, N' عرض إحصائيات المعاملات ربع سنوى', N'View Transactions Statistics Quarterly', 342, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (2131, N'  إحصائيات المعاملات نصف سنوى', N'Transactions Statistics Semi annually', 343, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (2132, N'  عرض إحصائيات المعاملات نصف سنوى', N'ViewTransactions Statistics Semi annually', 343, 2)
Go
------------------------------- End 2020-04-05 --------------------------
------------------------------- A.Khaled 2020-04-06 --------------------------
CREATE TABLE [dbo].[WF_MaintenancesRequest](
	[MasterRequestCode] [int] NOT NULL,
	[MaintenanceTypeCode] [int] NOT NULL,
 CONSTRAINT [PK_WF_MaintenancesRequest] PRIMARY KEY CLUSTERED 
(
	[MasterRequestCode] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[WF_MaintenancesRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_MaintenancesRequest_WF_MaintenanceType] FOREIGN KEY([MaintenanceTypeCode])
REFERENCES [dbo].[WF_MaintenanceType] ([MaintenanceTypeCode])
GO

ALTER TABLE [dbo].[WF_MaintenancesRequest] CHECK CONSTRAINT [FK_WF_MaintenancesRequest_WF_MaintenanceType]
GO

ALTER TABLE [dbo].[WF_MaintenancesRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_MaintenancesRequest_WF_MasterRequests] FOREIGN KEY([MasterRequestCode])
REFERENCES [dbo].[WF_MasterRequests] ([MasterRequestCode])
GO

ALTER TABLE [dbo].[WF_MaintenancesRequest] CHECK CONSTRAINT [FK_WF_MaintenancesRequest_WF_MasterRequests]
GO
------------------------------- End 2020-04-06 --------------------------