﻿---------------------Ali 2021-12-16--------------------

update [ConfigParameter] 
  set [IsVisible]=1 ,[RequestTypeId]=2
  where [ConfigKey]='WFPermissionMissionNo'
  Go

  INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(578,N'Purchase Order Signature',N'اعتماد اوامر الشراء',575,N'/Inventory/PurchaseOrderSignature',N'Index','fa fa-thumb-tack',N'get',3,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(578,17)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(22016,N'اعتماد اوامر الشراء',N'Purchase Order Signature',578,1)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(22017,N'عرض اعتماد اوامر الشراء',N'View Purchase Order Signature',578,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(22018,N'إجراء اعتماد اوامر الشراء',N'Action Purchase Order Signature',578,2)  
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(22019,N'حفظ اعتماد اوامر الشراء',N'Save Purchase Order Signature',578,2) 
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(22020,N'إعادة فتح اوامر الشراء',N'Delete Purchase Order Signature',578,2)   
Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(933,N'Inventory',N'PurchaseOrderSignature',N'Index',0,N'get',22016)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(934,N'Inventory',N'PurchaseOrderSignature',N'PurchaseOrderSignature_Read',0,N'post',22017)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(935,N'Inventory',N'PurchaseOrderSignature',N'Save',2,N'get',22018)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(936,N'Inventory',N'PurchaseOrderSignature',N'Save',0,N'post',22019)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(937,N'Inventory',N'PurchaseOrderSignature',N'Save',1,N'get',22020)
Go
---------------------End 2021-12-16--------------------

---------------------Hammad 2021-12-16--------------------


CREATE TABLE [dbo].[TablesName](
	[TableCode] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](100) NULL,
 CONSTRAINT [PK_TablesName] PRIMARY KEY CLUSTERED 
(
	[TableCode] 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

CREATE TABLE [dbo].[MappingResources](
	[MappingResourceCode] [int] IDENTITY(1,1) NOT NULL,
	[Arabic_Name] [nvarchar](250) NOT NULL,
	[Name] [nvarchar](250) NOT NULL,
	[TableCode] [int] NOT NULL,
 CONSTRAINT [PK_MappingResources] PRIMARY KEY CLUSTERED 
(
	[MappingResourceCode] 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].[MappingResources]  WITH CHECK ADD  CONSTRAINT [FK_MappingResources_TablesName] FOREIGN KEY([TableCode])
REFERENCES [dbo].[TablesName] ([TableCode])
GO

ALTER TABLE [dbo].[MappingResources] CHECK CONSTRAINT [FK_MappingResources_TablesName]
GO


ALTER TABLE dbo.Positions ADD
	MappingCode int NULL
GO
ALTER TABLE dbo.Sections ADD
	ProgramMappingCode int NULL,
	CollegeMappingCode int NULL,
	DepartmentMappingCode int NULL
GO
ALTER TABLE dbo.Nationality ADD
	MappingCode int NULL
GO
ALTER TABLE dbo.Cities ADD
	MappingCode int NULL
GO
ALTER TABLE dbo.Contract ADD
	MappingCode int NULL
GO

--Add CONSTRAINT
ALTER TABLE [dbo].[Positions]  WITH CHECK ADD  CONSTRAINT [FK_Positions_MappingResources] FOREIGN KEY([MappingCode])
REFERENCES [dbo].[MappingResources] ([MappingResourceCode])
GO
ALTER TABLE [dbo].[Sections]  WITH CHECK ADD  CONSTRAINT [FK_Sections_MappingProgram] FOREIGN KEY([ProgramMappingCode])
REFERENCES [dbo].[MappingResources] ([MappingResourceCode])
GO
ALTER TABLE [dbo].[Sections]  WITH CHECK ADD  CONSTRAINT [FK_Sections_MappingCollege] FOREIGN KEY([CollegeMappingCode])
REFERENCES [dbo].[MappingResources] ([MappingResourceCode])
GO
ALTER TABLE [dbo].[Sections]  WITH CHECK ADD  CONSTRAINT [FK_Sections_MappingDepartment] FOREIGN KEY([DepartmentMappingCode])
REFERENCES [dbo].[MappingResources] ([MappingResourceCode])
GO
ALTER TABLE [dbo].[Nationality]  WITH CHECK ADD  CONSTRAINT [FK_Nationality_MappingNationality] FOREIGN KEY([MappingCode])
REFERENCES [dbo].[MappingResources] ([MappingResourceCode])
GO
ALTER TABLE [dbo].[Cities]  WITH CHECK ADD  CONSTRAINT [FK_Cities_MappingCites] FOREIGN KEY([MappingCode])
REFERENCES [dbo].[MappingResources] ([MappingResourceCode])
GO
ALTER TABLE [dbo].[Contract]  WITH CHECK ADD  CONSTRAINT [FK_Contract_MappingContract] FOREIGN KEY([MappingCode])
REFERENCES [dbo].[MappingResources] ([MappingResourceCode])
GO

---------------------End 2021-12-16--------------------

---------------------Mostafa 2021-12-16--------------------


 INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(579,N'Compare Purchase Quotation',N'قارن عرض أسعار الشراء',575,N'/Inventory/ComparePurchaseQuotation',N'Index','fa fa-thumb-tack',N'Get',4,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(579,17)
Go

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(22021,N'قارن عرض أسعار الشراء',N'Compare Purchase Quotation',579,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(22022,N'عرض قارن عرض أسعار الشراء',N'View Compare Purchase Quotation',579,2)

Go

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(938,N'Inventory',N'ComparePurchaseQuotation',N'Index',0,N'get',22021)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(939,N'Inventory',N'ComparePurchaseQuotation',N'ComparePurchaseQuotation_Read',0,N'post',22022)
GO

---------------------End 2021-12-16--------------------
---------------------Hammad 2021-12-16--------------------
 INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
 VALUES (580, N'Mapping Data', N'تسكين البيانات', 52, N'/BasicData/Mapping', N'Index', N'fa fa-thumb-tack', N'get', 11, 1, 1)
 Go
 INSERT [dbo].[SystemMenuModule] ([SystemMenuCode], [AppModuleCode]) VALUES (580, 6)
 GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1300, N'تسكين البيانات', N'Mapping Data', 580, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1301, N'عرض تسكين البيانات ', N'View Mapping Data', 580, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1302, N'حفظ  تسكين البيانات', N'Save Mapping Data', 580, 2)
GO
---------------------End 2021-12-16--------------------
---------------------Hammad 2021-12-16-----------------
SET IDENTITY_INSERT [dbo].[TablesName] ON 

INSERT [dbo].[TablesName] ([TableCode], [Name]) VALUES (1, N'Positions')
INSERT [dbo].[TablesName] ([TableCode], [Name]) VALUES (2, N'Program')
INSERT [dbo].[TablesName] ([TableCode], [Name]) VALUES (3, N'College')
INSERT [dbo].[TablesName] ([TableCode], [Name]) VALUES (4, N'Department')
INSERT [dbo].[TablesName] ([TableCode], [Name]) VALUES (5, N'Nationality')
INSERT [dbo].[TablesName] ([TableCode], [Name]) VALUES (6, N'Cities')
INSERT [dbo].[TablesName] ([TableCode], [Name]) VALUES (7, N'Contract')
SET IDENTITY_INSERT [dbo].[TablesName] OFF

ALTER TABLE dbo.Employees ADD
	MDT datetime NULL
GO
ALTER TABLE dbo.EmployeesExtend ADD
	MDT datetime NULL
GO
 update ConfigParameter set ConfigCategoryCode=14 where ConfigKey='REDisplayMilitaryStatus'
  Go
---------------------End 2021-12-16-----------------

---------------------Ali 2021-12-20-----------------
delete from [ConfigParameter]
  where [ConfigKey] ='WFPermissionAllowedExceedMaximumMonth'
  Go
 
  ---------------------End 2021-12-20-----------------
  ---------------------Hammad 2021-12-21--------------
update  ConfigParameter set Name=N'Maximum Employee Archive File Size(MB)',
Arabic_Name=N'اقصي حجم لملف أرشيف الموظفين (MB)',ConfigValue='5'
 where ConfigKey='ArcEmpDocumentMaxFileSize'
 GO
ALTER TABLE Sections
ALTER COLUMN CostCenter nvarchar(150);
Go
   ---------------------End 2021-12-20---------------
    ---------------------Ali 2021-12-21---------------


   CREATE TABLE [dbo].[SecurityGrouplevels](
	[SecurityGrouplevelCode] [int] IDENTITY(1,1) NOT NULL,
	[SecurityGroupCode] [int] NOT NULL,
	[LevelCode] [tinyint] NOT NULL,
 CONSTRAINT [PK_SecurityGrouplevels] PRIMARY KEY CLUSTERED 
(
	[SecurityGrouplevelCode] 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].[SecurityGrouplevels]  WITH CHECK ADD  CONSTRAINT [FK_SecurityGrouplevels_Levels] FOREIGN KEY([LevelCode])
REFERENCES [dbo].[Levels] ([LevelCode])
GO

ALTER TABLE [dbo].[SecurityGrouplevels] CHECK CONSTRAINT [FK_SecurityGrouplevels_Levels]
GO

ALTER TABLE [dbo].[SecurityGrouplevels]  WITH CHECK ADD  CONSTRAINT [FK_SecurityGrouplevels_SecurityGroup] FOREIGN KEY([SecurityGroupCode])
REFERENCES [dbo].[SecurityGroup] ([SecurityGroupCode])
GO

ALTER TABLE [dbo].[SecurityGrouplevels] CHECK CONSTRAINT [FK_SecurityGrouplevels_SecurityGroup]
GO

CREATE TABLE [dbo].[SecurityGroupGeneralTypes](
	[SecurityGroupGeneralTypeCode] [int] IDENTITY(1,1) NOT NULL,
	[SecurityGroupCode] [int] NOT NULL,
	[GeneralTypeCode] [tinyint] NOT NULL,
 CONSTRAINT [PK_SecurityGroupGeneralTypes] PRIMARY KEY CLUSTERED 
(
	[SecurityGroupGeneralTypeCode] 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].[SecurityGroupGeneralTypes]  WITH CHECK ADD  CONSTRAINT [FK_SecurityGroupGeneralTypes_GeneralTypes] FOREIGN KEY([GeneralTypeCode])
REFERENCES [dbo].[GeneralTypes] ([GeneralTypeCode])
GO

ALTER TABLE [dbo].[SecurityGroupGeneralTypes] CHECK CONSTRAINT [FK_SecurityGroupGeneralTypes_GeneralTypes]
GO

ALTER TABLE [dbo].[SecurityGroupGeneralTypes]  WITH CHECK ADD  CONSTRAINT [FK_SecurityGroupGeneralTypes_SecurityGroup] FOREIGN KEY([SecurityGroupCode])
REFERENCES [dbo].[SecurityGroup] ([SecurityGroupCode])
GO

ALTER TABLE [dbo].[SecurityGroupGeneralTypes] CHECK CONSTRAINT [FK_SecurityGroupGeneralTypes_SecurityGroup]
GO



   ---------------------End 2021-12-21---------------


