﻿--------------------------Hammad 2021-05-23--

CREATE TABLE [dbo].[Rec_ParameterType](
	[ParameterTypeCode] [tinyint] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](500) NOT NULL,
	[Arabic_Name] [nvarchar](500) NOT NULL,
	[IsActive] [bit] NOT NULL,
 CONSTRAINT [PK_Rec_ParameterType] PRIMARY KEY CLUSTERED 
(
	[ParameterTypeCode] 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
SET IDENTITY_INSERT [dbo].[Rec_ParameterType] ON 

INSERT [dbo].[Rec_ParameterType] ([ParameterTypeCode], [Name], [Arabic_Name], [IsActive]) VALUES (1, N'True Or False', N'صحيح أو خطأ', 1)
INSERT [dbo].[Rec_ParameterType] ([ParameterTypeCode], [Name], [Arabic_Name], [IsActive]) VALUES (2, N'Integer Number', N'عدد صحيح	', 1)
INSERT [dbo].[Rec_ParameterType] ([ParameterTypeCode], [Name], [Arabic_Name], [IsActive]) VALUES (3, N'Decimal Number', N'عدد عشرى', 1)
INSERT [dbo].[Rec_ParameterType] ([ParameterTypeCode], [Name], [Arabic_Name], [IsActive]) VALUES (4, N'Text', N'نص', 1)
INSERT [dbo].[Rec_ParameterType] ([ParameterTypeCode], [Name], [Arabic_Name], [IsActive]) VALUES (5, N'Date', N'تاريخ', 1)
INSERT [dbo].[Rec_ParameterType] ([ParameterTypeCode], [Name], [Arabic_Name], [IsActive]) VALUES (6, N'Money', N'نقود', 1)
INSERT [dbo].[Rec_ParameterType] ([ParameterTypeCode], [Name], [Arabic_Name], [IsActive]) VALUES (7, N'Degree', N'الدرجة', 1)
INSERT [dbo].[Rec_ParameterType] ([ParameterTypeCode], [Name], [Arabic_Name], [IsActive]) VALUES (8, N'Choice', N'اختيار', 1)
SET IDENTITY_INSERT [dbo].[Rec_ParameterType] OFF


EXECUTE sp_rename N'dbo.Rec_EvaluationParameter.ParameterType', N'ParameterTypeCode', 'COLUMN' 
GO

ALTER TABLE [dbo].[Rec_EvaluationParameter]  WITH CHECK ADD  CONSTRAINT [FK_Rec_EvaluationParameter_Rec_ParameterType] FOREIGN KEY([ParameterTypeCode])
REFERENCES [dbo].[Rec_ParameterType] ([ParameterTypeCode])
GO

ALTER TABLE [dbo].[Rec_EvaluationParameter] CHECK CONSTRAINT [FK_Rec_EvaluationParameter_Rec_ParameterType]
GO

ALTER TABLE dbo.Rec_EvaluationParameter ADD
	MaxValueDegree int NULL
GO

CREATE TABLE [dbo].[Rec_EvaluationParameterChoice](
	[EvaluationParameterChoiceCode] [int] IDENTITY(1,1) NOT NULL,
	[EvaluationParameterCode] [int] NOT NULL,
	[Description] [nvarchar](250) NOT NULL,
	[IsTrue] [bit] NOT NULL,
 CONSTRAINT [PK_Rec_EvaluationParameterChoice] PRIMARY KEY CLUSTERED 
(
	[EvaluationParameterChoiceCode] 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].[Rec_EvaluationParameterChoice]  WITH CHECK ADD  CONSTRAINT [FK_Rec_EvaluationParameterChoice_Rec_EvaluationParameter] FOREIGN KEY([EvaluationParameterCode])
REFERENCES [dbo].[Rec_EvaluationParameter] ([EvaluationParameterCode])
GO

ALTER TABLE [dbo].[Rec_EvaluationParameterChoice] CHECK CONSTRAINT [FK_Rec_EvaluationParameterChoice_Rec_EvaluationParameter]
GO
--------------------------End 2021-05-23--
--------------------------Ali 2021-05-23--

  
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(526,N'Reimbursement Request',N'طلب سداد',496,N'/WorkFlow/ReimbursementRequest',N'Index','fa fa-thumb-tack',N'get',20,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(526,1)
Go

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15194,N'طلب سداد',N'Reimbursement Request',526,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15195,N'عرض طلب سداد',N'View Reimbursement Request',526,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15196,N'إضافة طلب سداد',N'Add Reimbursement Request',526,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15197,N'تعديل طلب سداد',N'Edit Reimbursement Request',526,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15198,N'حذف طلب سداد',N'Delete Reimbursement Request',526,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15199,N'حفظ طلب سداد',N'Save Reimbursement Request',526,2)
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15208,N'الغاء طلب سداد',N'Cancel Reimbursement Request',526,2)

Go


INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(789,N'WorkFlow',N'ReimbursementRequest',N'Index',0,N'get',15194)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(790,N'WorkFlow',N'ReimbursementRequest',N'ReimbursementRequest_Read',0,N'post',15195)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(791,N'WorkFlow',N'ReimbursementRequest',N'Save',1,N'get',15196)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(792,N'WorkFlow',N'ReimbursementRequest',N'Save',2,N'get',15197)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(793,N'WorkFlow',N'ReimbursementRequest',N'Delete',0,N'post',15198)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(794,N'WorkFlow',N'ReimbursementRequest',N'Save',0,N'post',15199)
Go

INSERT[dbo].[WF_RequestType]([RequestTypeId], [RequestTypeName], [RequestTypeNameEn], [IsEditable], [SenderUserName], [SenderFrom], [SenderPassword], [SenderHostName], [SenderPort], [SenderName], [SubmitBeforRequestDate], [SubmitAfterRequestDate], [IsUsed], [CanDelegation], [DisplayUserName], [HaveAttachment]) VALUES(52,N'طلب سداد',N'Reimbursement Request',0,N'sayedmustafa84@yahoo.com',N'sayedmustafa84@yahoo.com',N'1',N'smtp.sendgrid.net',587,N'SST',NULL,NULL,1,1,0,0)
Go
SET IDENTITY_INSERT[dbo].[EmailTemplateType] ON
INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode]) VALUES(256,N'Reimbursement Request Sending',N'ارسال طلب سداد',0,1)

INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode]) VALUES(257,N'Reimbursement Request Accept',N'الموافقة على طلب سداد',0,1)

INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode]) VALUES(258,N'Reimbursement Request Refuse',N'رفض طلب سداد',0,1)

INSERT[dbo].[EmailTemplateType]([EmailTemplateTypeCode], [Name],[Arabic_Name], [IsEditable],[AppModuleCode]) VALUES(259,N'Reimbursement Request Cancel',N'الغاء طلب سداد',0,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(256,N'Reimbursement Request Sending',N'ارسال طلب سداد',256,N'ارسال',N'ارسال',1,NULL)

INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(257,N'Reimbursement Request Accept',N'الموافقة على طلب سداد',257,N'الموافقة على',N'الموافقة على',1,NULL)

INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(258,N'Reimbursement Request Refuse',N'رفض طلب سداد',258,N'رفض',N'رفض',1,NULL)

INSERT[dbo].[EmailTemplate]([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES(259,N'Reimbursement Request Cancel',N'الغاء طلب سداد',259,N'الغاء',N'الغاء',1,NULL)
SET IDENTITY_INSERT [dbo].[EmailTemplate] OFF



INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(527,N'Reimbursement Request Signature',N'اعتماد طلب سداد',501,N'/WorkFlow/ReimbursementRequestSignature',N'Index','fa fa-thumb-tack',N'get',22,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(527,1)
Go

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15200,N'اعتماد طلب سداد',N'Reimbursement Request Signature',527,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15201,N'عرض اعتماد طلب سداد',N'View Reimbursement Request Signature',527,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15202,N'تعديل اعتماد طلب سداد',N'Edit Reimbursement Request Signature',527,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15203,N'حفظ اعتماد طلب سداد',N'Save Reimbursement Request Signature',527,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15204,N'حفظ متعدد للاعتماد',N'Multiple Save',527,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15205,N'عرض سجل الموظف',N'View Employee History',527,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15206,N'ارجاع الطلب',N'Inverse Request',527,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(15207,N'اختيار كل الطلبات',N'Choose All Requests',527,2)

Go


INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(795,N'WorkFlow',N'ReimbursementRequestSignature',N'Index',0,N'get',15200)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(796,N'WorkFlow',N'ReimbursementRequestSignature',N'ReimbursementRequestSignature_Read',0,N'post',15201)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(797,N'WorkFlow',N'ReimbursementRequestSignature',N'Save',2,N'get',15202)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(798,N'WorkFlow',N'ReimbursementRequestSignature',N'Save',0,N'post',15203)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(799,N'WorkFlow',N'ReimbursementRequestSignature',N'SaveRequestSignatureLst',0,N'post',15204)
Go
--------------------------End 2021-05-23--
--------------------------Sayed 2021-05-24--------------------------------
CREATE TABLE [dbo].[VacationsBalances](
	[SerialAuto] [int] IDENTITY(1,1) NOT NULL,
	[PYear] [smallint] NOT NULL,
	[Period] [tinyint] NOT NULL,
	[EmployeeCode] [int] NOT NULL,
	[PAnnual] [float] NULL,
	[PDayOff] [float] NULL,
	[PHolidays] [float] NULL,
	[POther] [float] NULL,
	[DueAnnual] [float] NULL,
	[DueDayOff] [float] NULL,
	[DueHolidays] [float] NULL,
	[DueOther] [float] NULL,
	[BAnnual] [float] NULL,
	[BDayOff] [float] NULL,
	[BHolidays] [float] NULL,
	[BOther] [float] NULL,
	[CAnnual] [float] NULL,
	[CDayOff] [float] NULL,
	[CHolidays] [float] NULL,
	[COther] [float] NULL,
	[DisAnnual] [float] NULL,
	[DisDayOff] [float] NULL,
	[DisHolidays] [float] NULL,
	[DisOther] [float] NULL,
	[TAnnual] [float] NULL,
	[TDayOff] [float] NULL,
	[THolidays] [float] NULL,
	[TOther] [float] NULL,
	[C1] [float] NULL,
	[C2] [float] NULL,
	[C3] [float] NULL,
	[C4] [float] NULL,
	[C5] [float] NULL,
	[C6] [float] NULL,
	[C7] [float] NULL,
	[C8] [float] NULL,
	[C9] [float] NULL,
	[C10] [float] NULL,
	[C11] [float] NULL,
	[C12] [float] NULL,
	[C13] [float] NULL,
	[C14] [float] NULL,
	[C15] [float] NULL,
	[C16] [float] NULL,
	[C17] [float] NULL,
	[C18] [float] NULL,
	[C19] [float] NULL,
	[C20] [float] NULL,
	[C21] [float] NULL,
	[C22] [float] NULL,
	[C23] [float] NULL,
	[C24] [float] NULL,
	[C25] [float] NULL,
	[C26] [float] NULL,
	[C27] [float] NULL,
	[C28] [float] NULL,
	[C29] [float] NULL,
	[C30] [float] NULL,
	[C31] [float] NULL,
	[Closed] [int] NULL,
	[MDT] [datetime] NULL,
	[PSick] [float] NULL,
	[DueSick] [float] NULL,
	[CSick] [float] NULL,
	[DisSick] [float] NULL,
	[TSick] [float] NULL,
 CONSTRAINT [PK_VacationsBalances] PRIMARY KEY CLUSTERED 
(
	[PYear] ASC,
	[Period] ASC,
	[EmployeeCode] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[VacationsBalances] ADD  CONSTRAINT [DF_VacationsBalances_PAnnual]  DEFAULT ((0)) FOR [PAnnual]
GO

ALTER TABLE [dbo].[VacationsBalances] ADD  CONSTRAINT [DF_VacationsBalances_PDayOff]  DEFAULT ((0)) FOR [PDayOff]
GO

ALTER TABLE [dbo].[VacationsBalances] ADD  CONSTRAINT [DF_VacationsBalances_PHolidays]  DEFAULT ((0)) FOR [PHolidays]
GO

ALTER TABLE [dbo].[VacationsBalances] ADD  CONSTRAINT [DF_VacationsBalances_POther]  DEFAULT ((0)) FOR [POther]
GO

ALTER TABLE [dbo].[VacationsBalances] ADD  CONSTRAINT [DF_VacationsBalances_TAnnual1]  DEFAULT ((0)) FOR [DueAnnual]
GO

ALTER TABLE [dbo].[VacationsBalances] ADD  CONSTRAINT [DF_VacationsBalances_TDayOff1]  DEFAULT ((0)) FOR [DueDayOff]
GO

ALTER TABLE [dbo].[VacationsBalances] ADD  CONSTRAINT [DF_VacationsBalances_TOther1]  DEFAULT ((0)) FOR [DueOther]
GO

ALTER TABLE [dbo].[VacationsBalances] ADD  CONSTRAINT [DF_VacationsBalances_BAnnual]  DEFAULT ((0)) FOR [BAnnual]
GO

ALTER TABLE [dbo].[VacationsBalances] ADD  CONSTRAINT [DF_VacationsBalances_BDayOff]  DEFAULT ((0)) FOR [BDayOff]
GO

ALTER TABLE [dbo].[VacationsBalances] ADD  CONSTRAINT [DF_VacationsBalances_BHolidays]  DEFAULT ((0)) FOR [BHolidays]
GO

ALTER TABLE [dbo].[VacationsBalances] ADD  CONSTRAINT [DF_VacationsBalances_BOther]  DEFAULT ((0)) FOR [BOther]
GO

ALTER TABLE [dbo].[VacationsBalances] ADD  CONSTRAINT [DF_VacationsBalances_CAnnual]  DEFAULT ((0)) FOR [CAnnual]
GO

ALTER TABLE [dbo].[VacationsBalances] ADD  CONSTRAINT [DF_VacationsBalances_CDayOff]  DEFAULT ((0)) FOR [CDayOff]
GO

ALTER TABLE [dbo].[VacationsBalances] ADD  CONSTRAINT [DF_VacationsBalances_CHolidays]  DEFAULT ((0)) FOR [CHolidays]
GO

ALTER TABLE [dbo].[VacationsBalances] ADD  CONSTRAINT [DF_VacationsBalances_COther]  DEFAULT ((0)) FOR [COther]
GO

ALTER TABLE [dbo].[VacationsBalances] ADD  CONSTRAINT [DF_VacationsBalances_TAnnual]  DEFAULT ((0)) FOR [TAnnual]
GO

ALTER TABLE [dbo].[VacationsBalances] ADD  CONSTRAINT [DF_VacationsBalances_TDayOff]  DEFAULT ((0)) FOR [TDayOff]
GO

ALTER TABLE [dbo].[VacationsBalances] ADD  CONSTRAINT [DF_VacationsBalances_TOther]  DEFAULT ((0)) FOR [TOther]
GO

ALTER TABLE [dbo].[VacationsBalances] ADD  CONSTRAINT [DF_VacationsBalances_Closed]  DEFAULT ((0)) FOR [Closed]
GO

  ALTER TABLE dbo.Rec_RecruitJob ADD
	UserCodeResponsibleEvaluation int NULL,
	GeneralTypeCode tinyint NULL
GO

ALTER TABLE dbo.Rec_RecruitJobStages ADD
	UserCodeResponsibleInterview int NULL
GO

ALTER TABLE dbo.EmailTemplate ADD
	GeneralTypeCode tinyint NULL
GO

--------------------------End 2021-05-24---------------------------
--------------------------Ali 2021-05-24---------------------------

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(528,N'Reports',N'التقارير',357,N'',N'','fa fa-thumb-tack',N'',7,1,1)
Go
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(528,12)
Go

Update [dbo].[SystemMenu] Set Name=N'Collected reports',Arabic_Name=N'تقارير مجمعة',ParentID=528,ControllerName=N'/Inventory/ReportSearch',ActionName=N'Index',ImageURL='fa fa-thumb-tack',HTTPMethod=N'get',Sequence=1,IsVisible=1,ShowInPrivilegePage=1
 Where  SystemMenuCode= 387
Go

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(529,N'Items Reports',N'تقارير الاصناف',528,N'',N'','fa fa-thumb-tack',N'',2,1,1)
Go
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(529,12)
Go

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(530,N'Item Card Report',N'تقرير كارت الصنف',529,N'/Inventory/ItemCardReport',N'Index','fa fa-thumb-tack',N'get',1,1,1)
Go
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(530,12)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(14200,N'تقرير كارت الصنف',N'Item Card Report',530,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(14201,N'عرض تقرير كارت الصنف',N'View Item Card Report',530,2)


----------------------------End 2021-05-24---------------------------
----------------------------Hammad 2021-05-26------------------------
CREATE TABLE [dbo].[Rec_ShowOnlineRecruitColumn](
	[RecruitColumnCode] [int] NOT NULL,
	[Name] [nvarchar](500) NOT NULL,
	[Arabic_Name] [nvarchar](500) NOT NULL,
 CONSTRAINT [PK_Rec_ShowOnlineRecruitColumn] PRIMARY KEY CLUSTERED 
(
	[RecruitColumnCode] 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

INSERT [dbo].[Rec_ShowOnlineRecruitColumn] ([RecruitColumnCode], [Name], [Arabic_Name]) VALUES (1, N'Gender', N'الجنس')
INSERT [dbo].[Rec_ShowOnlineRecruitColumn] ([RecruitColumnCode], [Name], [Arabic_Name]) VALUES (2, N'Constant Job Location', N'موقع العمل ثابت')
INSERT [dbo].[Rec_ShowOnlineRecruitColumn] ([RecruitColumnCode], [Name], [Arabic_Name]) VALUES (3, N'Internal Job', N'الوظيفة داخلية')
INSERT [dbo].[Rec_ShowOnlineRecruitColumn] ([RecruitColumnCode], [Name], [Arabic_Name]) VALUES (4, N'Working Hours ', N'عدد ساعات العمل ')
INSERT [dbo].[Rec_ShowOnlineRecruitColumn] ([RecruitColumnCode], [Name], [Arabic_Name]) VALUES (5, N'Job Salary ', N'المرتب')
INSERT [dbo].[Rec_ShowOnlineRecruitColumn] ([RecruitColumnCode], [Name], [Arabic_Name]) VALUES (6, N'Available Positions', N'عدد الوظائف المتاحة')
INSERT [dbo].[Rec_ShowOnlineRecruitColumn] ([RecruitColumnCode], [Name], [Arabic_Name]) VALUES (7, N'Last Applay Date ', N'أخر ميعاد للتقديم للوظيفة')
INSERT [dbo].[Rec_ShowOnlineRecruitColumn] ([RecruitColumnCode], [Name], [Arabic_Name]) VALUES (8, N'Job Description', N'التوصيف الوظيفى')
INSERT [dbo].[Rec_ShowOnlineRecruitColumn] ([RecruitColumnCode], [Name], [Arabic_Name]) VALUES (9, N'Attachment', N'المرفق')
Go


CREATE TABLE [dbo].[Rec_RecruitJobOnlineColumn](
	[RecruitJobOnlineColumnCode] [int] IDENTITY(1,1) NOT NULL,
	[RecruitJobCode] [int] NOT NULL,
	[RecruitColumnCode] [int] NOT NULL,
	[IsOnline] [bit] NOT NULL,
 CONSTRAINT [PK_Rec_RecruitJobOnlineColumn] PRIMARY KEY CLUSTERED 
(
	[RecruitJobOnlineColumnCode] 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].[Rec_RecruitJobOnlineColumn]  WITH CHECK ADD  CONSTRAINT [FK_Rec_RecruitJobOnlineColumn_Rec_RecruitJob] FOREIGN KEY([RecruitJobCode])
REFERENCES [dbo].[Rec_RecruitJob] ([RecruitJobCode])
GO

ALTER TABLE [dbo].[Rec_RecruitJobOnlineColumn] CHECK CONSTRAINT [FK_Rec_RecruitJobOnlineColumn_Rec_RecruitJob]
GO

ALTER TABLE [dbo].[Rec_RecruitJobOnlineColumn]  WITH CHECK ADD  CONSTRAINT [FK_Rec_RecruitJobOnlineColumn_Rec_ShowOnlineRecruitColumn] FOREIGN KEY([RecruitColumnCode])
REFERENCES [dbo].[Rec_ShowOnlineRecruitColumn] ([RecruitColumnCode])
GO

ALTER TABLE [dbo].[Rec_RecruitJobOnlineColumn] CHECK CONSTRAINT [FK_Rec_RecruitJobOnlineColumn_Rec_ShowOnlineRecruitColumn]
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) 
VALUES (5133, N'عرض عناصر الشاشة في الإعلان', N'Show Fields Online', 59, 2)
Go
----------------------------End 2021-05-26------------------------
