 -------------------------------- Hammad 2019-12-18-------
 ALTER TABLE dbo.WF_RequestType ADD
	IsUsed bit NOT NULL CONSTRAINT DF_WF_RequestType_IsUsed DEFAULT ((1))
GO
 -------------------------------- Hammad 2019-12-15-------

  -------------------------------- Ali 2019-12-19-------

  ALTER TABLE dbo.SecurityUserEmployee ADD
	FullOption bit NOT NULL CONSTRAINT DF_SecurityUserEmployee_FullOption DEFAULT 0
	GO
-------------------------------- End 2019-12-19----------
-------------------------------- Hammad 2019-12-24-------
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType])
 VALUES (3456, N'   طلب اجازة مجمعة للموظفين', N' Employees Combined Vacations Request', 91, 2)
 Go
 -------------------------------- End 2019-12-24-------
  -------------------------------- Ali 2019-12-30-------
 ALTER TABLE VoteSettings
DROP COLUMN Month,VotingStartDay,VotingEndDay;
GO

ALTER TABLE VoteSettings
ADD Year int  NULL,
     FromDate datetime  NULL,
	ToDate datetime  NULL,
	CandidacySetupCode int  NULL,
	FromDateHijri	nvarchar(10)	NULL,
    ToDateHijri	nvarchar(10)	NULL
	GO

	ALTER TABLE dbo.VoteSettings ADD CONSTRAINT
	FK_VoteSettings_CandidacySetup FOREIGN KEY
	(
	CandidacySetupCode
	) REFERENCES dbo.CandidacySetup
	(
	CandidacySetupCode
	) ON UPDATE  NO ACTION 
	 ON DELETE  NO ACTION 
	
GO

 -------------------------------- End 2019-12-30-------

 -------------------------------- Ali 2020-1-2-------
 INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (236, N'Actual Cost Type', N'انواع التكلفة الفعلية', 203, N'/Budget/BudgetActualCostType', N'Index', NULL, N'get', 4, 1, 1)
 GO
SET IDENTITY_INSERT [dbo].[SystemMenuModule] ON 
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (4513, 236, 6)
SET IDENTITY_INSERT [dbo].[SystemMenuModule] OFF
GO


INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (12053, N'انواع التكلفة الفعلية', N'Actual Cost Type', 236, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (12054, N'عرض انواع التكلفة الفعلية', N'View Actual Cost Type', 236, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (12055, N'إضافة انواع التكلفة الفعلية', N'Add Actual Cost Type', 236, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (12056, N'تعديل انواع التكلفة الفعلية', N'Edit Actual Cost Type', 236, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (12057, N'حفظ انواع التكلفة الفعلية', N'Save Actual Cost Type', 236, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (12058, N'حذف انواع التكلفة الفعلية', N'Delete Actual Cost Type', 236, 2)
GO

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (153, N'Budget', N'BudgetActualCostType', N'Index', 0, N'get', 12053)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (154, N'Budget', N'BudgetActualCostType', N'BudgetActualCostType_Read', 0, N'post', 12054)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (155, N'Budget', N'BudgetActualCostType', N'Save', 1, N'get', 12055)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (156, N'Budget', N'BudgetActualCostType', N'Save', 2, N'get', 12056)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (157, N'Budget', N'BudgetActualCostType', N'Save', 0, N'post', 12057)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (158, N'Budget', N'BudgetActualCostType', N'Delete', 0, N'post', 12058)
GO

 -------------------------------- End 2020-1-2---------------------------------------
 -------------------------------- Hammad 2020-1-6-------------------------------------
 
ALTER TABLE dbo.WF_MasterRequests ADD
	EmployeeCode int NULL
GO

ALTER TABLE [dbo].[WF_MasterRequests]  WITH CHECK ADD  CONSTRAINT [FK_WF_MasterRequests_Employees] FOREIGN KEY([EmployeeCode])
REFERENCES [dbo].[Employees] ([EmployeeCode])
GO

ALTER TABLE [dbo].[WF_MasterRequests] CHECK CONSTRAINT [FK_WF_MasterRequests_Employees]
GO

----------------Move employee Code---------------------------------------
declare @EmployeeCode bigint
declare @MasterRequestCode bigint

declare cursorforsrno cursor fast_forward for select EmployeeCode ,MasterRequestCode from WF_TransferRequest
open cursorforsrno
fetch next from cursorforsrno into @EmployeeCode,@MasterRequestCode
while @@FETCH_STATUS=0
begin

 update WF_MasterRequests set EmployeeCode=@EmployeeCode where MasterRequestCode=@MasterRequestCode
                                                 

fetch next from cursorforsrno into @EmployeeCode,@MasterRequestCode
end
close cursorforsrno
deallocate cursorforsrno

----------------End Move employee Code---------------------------------------

ALTER TABLE dbo.WF_TransferRequest
	DROP CONSTRAINT FK_WF_TransferRequest_Employees
GO
ALTER TABLE dbo.Employees SET (LOCK_ESCALATION = TABLE)
GO
ALTER TABLE dbo.WF_TransferRequest
	DROP COLUMN EmployeeCode
GO
ALTER TABLE dbo.WF_TransferRequest SET (LOCK_ESCALATION = TABLE)
GO

 -------------------------------- End 2020-1-6----
 --------------------------------Sayed 2020-01-06------------------
 GO
CREATE TABLE [dbo].[CostCenter](
	[CostCenter] [nvarchar](50) NOT NULL,
	[Name] [nvarchar](100) NULL,
	[Arabic_Name] [nvarchar](50) NULL,
	[LessServiceCharge] [nvarchar](255) NULL,
	[AllocationAcc] [nvarchar](100) NULL,
	[TCode] [nvarchar](10) NULL,
	[AcountStatisticCode] [nvarchar](100) NULL,
	[CostCenterDepartmentCode] [nvarchar](10) NULL,
	[Closed] [bit] NULL,
	[DaysAllocationApplicable] [bit] NULL,
	[VacationAccrualAccount] [nvarchar](100) NULL,
	[AccountAirTickets] [nvarchar](100) NULL,
	[AccountAccruedAirTickets] [nvarchar](100) NULL,
	[AccountOtherIncentive] [nvarchar](100) NULL,
	[AccountAccruedBonus] [nvarchar](100) NULL,
	[AccountEosExpense] [nvarchar](100) NULL,
	[AccountAccruedEosExpense] [nvarchar](100) NULL,
	[AccountSocialSecurity] [nvarchar](100) NULL,
	[AccountAccruedSocialSecurity] [nvarchar](100) NULL,
	[CostAccountHours] [nvarchar](100) NULL,
	[FatherTCode] [nvarchar](150) NULL,
	[TCode3] [nvarchar](20) NULL,
	[TCode4] [nvarchar](20) NULL,
	[MDT] [datetime] NULL,
	[StatisticT0] [nvarchar](20) NULL,
	[StatisticT1] [nvarchar](20) NULL,
	[StatisticT2] [nvarchar](20) NULL,
	[StatisticT3] [nvarchar](20) NULL,
	[StatisticT4] [nvarchar](20) NULL,
	[StatisticT5] [nvarchar](20) NULL,
	[AccountVacations] [nvarchar](30) NULL,
	[AccountAccruedVacations] [nvarchar](30) NULL,
 CONSTRAINT [PK_CostCenter] PRIMARY KEY CLUSTERED 
(
	[CostCenter] 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
--------------------------End 2020-01-06-----------------------------
--------------------------Ali 2020-01-06-----------------------------
 INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'WFCheckRequestMaxNumber',N'Maximum number of fingerprint requests per month',N'الحد الاقصى لعدد مرات طلب البصمة فى الشهر',N'1',2,1,2,1,Null,Null,6)
Go

--------------------------End 2019-01-06-----------------------------
--------------------------Hammad 2019-01-08--------------------------
 insert into WF_FactorType values (10,'Amount',N'مبلغ')
 Go
 --------------------------End 2019-01-08--------------------------


  -------------------------------A.Khaled 2020-01-06--------------------------    
UPDATE [dbo].[SystemMenu] SET [Sequence]=4 WHERE [SystemMenuCode]=204
UPDATE [dbo].[SystemMenu] SET [Sequence]=5 WHERE [SystemMenuCode]=205
UPDATE [dbo].[SystemMenu] SET [Sequence]=2 WHERE [SystemMenuCode]=207
UPDATE [dbo].[SystemMenu] SET [Sequence]=6 WHERE [SystemMenuCode]=216
UPDATE [dbo].[SystemMenu] SET [Sequence]=3 WHERE [SystemMenuCode]=230
UPDATE [dbo].[SystemMenu] SET [Sequence]=7 WHERE [SystemMenuCode]=231
UPDATE [dbo].[SystemMenu] SET [Sequence]=1 WHERE [SystemMenuCode]=236
  -------------------------------End 2020-01-06-------------------------------

    -------------------------------Ali 2020-01-08-------------------------------
  
SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[WF_NewJobRequest](
	[MasterRequestCode] [int] NOT NULL,
	[Name] [nvarchar](30) NOT NULL,
	[Arabic_Name] [nvarchar](30) NOT NULL,
 CONSTRAINT [PK_WF_NewJobRequest] 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_NewJobRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_NewJobRequest_WF_MasterRequests] FOREIGN KEY([MasterRequestCode])
REFERENCES [dbo].[WF_MasterRequests] ([MasterRequestCode])
GO

ALTER TABLE [dbo].[WF_NewJobRequest] CHECK CONSTRAINT [FK_WF_NewJobRequest_WF_MasterRequests]
GO


INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (237, N'New Job Request', N'طلب وظيفة جديدة', 29, N'/WorkFlow/NewJobRequest', N'Index', N'fa fa-thumb-tack', N'get', 38, 1, 1)
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (238, N'New Job Request Signature', N'اعتماد طلب وظيفة جديدة ', 108, N'/WorkFlow/NewJobRequestSignature', N'Index', N'fa fa-thumb-tack', N'get', 41, 1, 1)
Go

SET IDENTITY_INSERT [dbo].[SystemMenuModule] ON 
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (5527, 237, 1)
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (5528, 238, 1)
SET IDENTITY_INSERT [dbo].[SystemMenuModule] OFF
Go

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3457, N'طلب وظيفة جديدة', N'New Job Request', 237, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3458, N'عرض طلب وظيفة جديدة', N'View New Job Request', 237, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3459, N'اضافة طلب وظيفة جديدة', N'Add New Job Request', 237, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3460, N'تعديل طلب وظيفة جديدة', N'Edit New Job Request', 237, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3461, N'حفظ طلب وظيفة جديدة', N'Save New Job Request', 237, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3462, N'حذف طلب وظيفة جديدة', N'Delete New Job Request', 237, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3463, N'الغاء طلب وظيفة جديدة', N'Cancel New Job Request', 237, 2)
Go

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3464, N'اعتماد طلب وظيفة جديدة', N'New Job Request Signature', 238, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3465, N'عرض اعتماد طلب وظيفة جديدة', N'View New Job Request Signature', 238, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3466, N'تعديل اعتماد طلب وظيفة جديدة', N'Edit New Job Request Signature', 238, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3467, N'حفظ اعتماد طلب وظيفة جديدة', N'Save New Job Request Signature', 238, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3468, N'حفظ متعدد اعتماد طلب وظيفة جديدة', N'Multiple Save New Job Request Signature', 238, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3470, N'ارجاع طلب وظيفة جديدة', N'Inverse New Job Request', 238, 2)
Go

INSERT [dbo].[WF_RequestType] ([RequestTypeId], [RequestTypeName], [RequestTypeNameEn], [IsEditable], [SenderUserName], [SenderFrom], [SenderPassword], [SenderHostName], [SenderPort], [SenderName], [SubmitBeforRequestDate], [SubmitAfterRequestDate], [IsUsed]) VALUES (26, N'طلب وظيفة جديدة', N'New Job Request', 0, N'sayedmustafa1984@gmail.com', N'sayedmustafa1984@gmail.com', N'123', N'smtp.sendgrid.net', 587, N'Sayed', NULL, NULL, 1)
Go

SET IDENTITY_INSERT [dbo].[EmailTemplateType] ON 
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode]) VALUES (148, N'New Job Request Sending', N'ارسال طلب وظيفة جديدة', 0, 1)
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode]) VALUES (149, N'New Job Request Accept', N'الموافقة على طلب وظيفة جديدة', 0, 1)
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode]) VALUES (150, N'New Job Request Refuse', N'رفض طلب وظيفة جديدة', 0, 1)
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode]) VALUES (151, N'New Job Request Cancellation', N'الغاء طلب وظيفة جديدة', 0, 1)
SET IDENTITY_INSERT [dbo].[EmailTemplateType] OFF
Go

SET IDENTITY_INSERT [dbo].[EmailTemplate] ON 
INSERT [dbo].[EmailTemplate] ([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES (148, N'New Job Request Sending', N'ارسال طلب وظيفة جديدة', 148, N'ارسال طلب وظيفة جديدة', N' نرجو الموافقة على طلب وظيفة جديدة', 1, NULL)
INSERT [dbo].[EmailTemplate] ([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES (149, N'Transfer Request Accept', N'الموافقة على طلب وظيفة جديدة', 149, N'اعتماد طلب تحويل', N'<p>تمت الموافقة</p>', 1, NULL)
INSERT [dbo].[EmailTemplate] ([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES (150, N'New Job Request Refuse', N'رفض طلب وظيفة جديدة', 150, N'رفض طلب وظيفة جديدة', N'تم رفض الطلب', 1, NULL)
INSERT [dbo].[EmailTemplate] ([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES (151, N'New Job Request Cancellation', N'الغاء طلب وظيفة جديدة', 151, N'اعتماد طلب تحويل', N'تم إلغاء الطلب', 1, NULL)
SET IDENTITY_INSERT [dbo].[EmailTemplate] OFF
Go

  -------------------------------End 2020-01-08-------------------------------
  -------------------------------Hammad 2020-01-09----------------------------

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) 
VALUES (239, N'Monthly Effects Request', N'طلب موثرات شهرية', 29, N'/WorkFlow/MonthlyEffectsRequest', N'Index', NULL, N'get', 39, 1, 1)
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
 VALUES (240, N'Monthly Effects Request Signature', N'اعتماد طلب موثرات شهرية', 108, N'/WorkFlow/MonthlyEffectsRequestSignature', N'Index', NULL, N'get', 42, 1, 1)
 Go

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3471, N'طلب موثرات شهرية', N'Monthly Effects Request', 239, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3472, N'عرض طلب موثرات شهرية', N'View Monthly Effects Request', 239, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3473, N'اضافة طلبم وثرات شهرية', N'Add Monthly Effects Request', 239, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3474, N'تعديل طلب موثرات شهرية', N'Edit Monthly Effects Request', 239, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3475, N'حفظ طلب موثرات شهرية', N'Save Monthly Effects Request', 239, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3476, N'حذف طلب موثرات شهرية', N'Delete Monthly Effects Request', 239, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3477, N'الغاء طلب موثرات شهرية', N'Cancel Monthly Effects Request', 239, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3478, N'اعتماد طلب موثرات شهرية', N'Monthly Effects Request Signature', 240, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3479, N'عرض اعتماد طلب موثرات شهرية', N'View Monthly Effects Request Signature', 240, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3480, N'تعديل اعتماد طلب موثرات شهرية', N'Edit Monthly Effects Request Signature', 240, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3481, N'حفظ اعتماد طلب موثرات شهرية', N'Save Monthly Effects Request Signature', 240, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3482, N'حفظ متعدد اعتماد طلب موثرات شهرية', N' Multiple Save Monthly Effects Request Signature', 240, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3483, N'عرض سجل الموظف', N'View Employee History', 240, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3484, N'ارجاع طلب موثرات شهرية', N'Inverse Monthly Effects Request', 240, 2)
Go

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



CREATE TABLE [dbo].[WF_MonthlyEffectsRequest](
	[MasterRequestCode] [int] NOT NULL,
	[BandCode] [int] NOT NULL,
	[CalculatedByCode] [int] NOT NULL,
	[Amount] [float] NOT NULL,
	[CostCenter] [nvarchar](50) NULL,
	[IsFixed] [bit] NOT NULL CONSTRAINT [DF_WF_MonthlyEffectsRequest_IsFixed]  DEFAULT ((0)),
 CONSTRAINT [PK_WF_MonthlyEffectsRequest] 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_MonthlyEffectsRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_MonthlyEffectsRequest_Basis] FOREIGN KEY([BandCode])
REFERENCES [dbo].[Basis] ([BandCode])
GO

ALTER TABLE [dbo].[WF_MonthlyEffectsRequest] CHECK CONSTRAINT [FK_WF_MonthlyEffectsRequest_Basis]
GO

ALTER TABLE [dbo].[WF_MonthlyEffectsRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_MonthlyEffectsRequest_CostCenter] FOREIGN KEY([CostCenter])
REFERENCES [dbo].[CostCenter] ([CostCenter])
GO

ALTER TABLE [dbo].[WF_MonthlyEffectsRequest] CHECK CONSTRAINT [FK_WF_MonthlyEffectsRequest_CostCenter]
GO

ALTER TABLE [dbo].[WF_MonthlyEffectsRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_MonthlyEffectsRequest_WF_FactorType] FOREIGN KEY([CalculatedByCode])
REFERENCES [dbo].[WF_FactorType] ([FactorTypeCode])
GO

ALTER TABLE [dbo].[WF_MonthlyEffectsRequest] CHECK CONSTRAINT [FK_WF_MonthlyEffectsRequest_WF_FactorType]
GO

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

ALTER TABLE [dbo].[WF_MonthlyEffectsRequest] CHECK CONSTRAINT [FK_WF_MonthlyEffectsRequest_WF_MasterRequests]
GO



INSERT [dbo].[WF_RequestType] ([RequestTypeId], [RequestTypeName], [RequestTypeNameEn], [IsEditable], [SenderUserName], [SenderFrom], [SenderPassword], [SenderHostName], [SenderPort], [SenderName], [SubmitBeforRequestDate], [SubmitAfterRequestDate], [IsUsed])
 VALUES (27, N'طلب موثرات شهرية', N'Monthly Effects Request', 0, N'sayedmustafa1984@gmail.com', N'sayedmustafa1984@gmail.com', N'123', N'smtp.sendgrid.net', 587, N'Sayed', NULL, NULL, 1)
Go


SET IDENTITY_INSERT [dbo].[EmailTemplateType] ON 
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode]) VALUES (152, N'Monthly Effects Request Sending', N'ارسال طلب مؤثرات شهرية', 0, 1)
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode]) VALUES (153, N'Monthly Effects Request Accept', N'الموافقة على طلب مؤثرات شهرية', 0, 1)
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode]) VALUES (154, N'Monthly Effects Request Refuse', N'رفض طلب مؤثرات شهرية', 0, 1)
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode]) VALUES (155, N'Monthly Effects Request Cancellation', 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 (152, N'Monthly Effects Request Sending', N'ارسال طلب مؤثرات شهرية', 152, N'ارسال طلب مؤثرات شهرية', N' نرجو الموافقة على طلب مؤثرات شهرية', 1, NULL)
INSERT [dbo].[EmailTemplate] ([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES (153, N'Monthly Effects Request Accept', N'الموافقة على طلب مؤثرات شهرية', 153, N'الموافقة على طلب مؤثرات شهرية', N'<p>تمت الموافقة</p>', 1, NULL)
INSERT [dbo].[EmailTemplate] ([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES (154, N'Monthly Effects Request Refuse', N'رفض طلب مؤثرات شهرية', 154, N'رفض طلب مؤثرات شهرية', N'تم رفض الطلب', 1, NULL)
INSERT [dbo].[EmailTemplate] ([EmailTemplateCode], [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode]) VALUES (155, N'Monthly Effects Request Cancellation', N'الغاء طلب مؤثرات شهرية', 155, N'الغاء طلب مؤثرات شهرية', N'تم إلغاء الطلب', 1, NULL)
SET IDENTITY_INSERT [dbo].[EmailTemplate] OFF

 -------------------------------End 2020-01-09----------------------------
 
 ------------------------------- Ali 2020-01-14----------------------------
   ALTER TABLE dbo.UserType ADD
	HaveEmployee bit NULL
GO

update [UserType] set HaveEmployee=1 where [UserTypeCode] in(1,2,10,11,12,13,16,17,18,19,20,21)
Go
update [UserType] set HaveEmployee=0 where [UserTypeCode]=15
Go
 -------------------------------End 2020-01-14----------------------------
   -------------------------------Ali 2020-01-16----------------------------
INSERT [dbo].[SystemMenuModule] ( [SystemMenuCode], [AppModuleCode]) VALUES ( 199, 1)
INSERT [dbo].[SystemMenuModule] ( [SystemMenuCode], [AppModuleCode]) VALUES ( 199, 2)
Go
 -------------------------------End 2020-01-16----------------------------