------------------------------- Hammad 2020-11-26 -----------------------


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

INSERT [dbo].[WF_RequestType] ([RequestTypeId], [RequestTypeName], [RequestTypeNameEn], [IsEditable], [SenderUserName], [SenderFrom], [SenderPassword], [SenderHostName], [SenderPort], [SenderName], [SubmitBeforRequestDate], [SubmitAfterRequestDate], [IsUsed]) VALUES (29, N'طلب إقامة', N'Residence Request', 0, N'sayedmustafa84@yahoo.com', N'sayedmustafa84@yahoo.com', N'1', N'smtp.sendgrid.net', 587, N'SST', NULL, NULL, 1)
Go



CREATE TABLE [dbo].[WF_ResidenceRequest](
	[MasterRequestCode] [int] NOT NULL,
	[ResidenceTypeCode] [int] NOT NULL,
	[Fee1] [float] NULL,
	[Fee2] [float] NULL,
	[Fee3] [float] NULL,
	[Fee4] [float] NULL,
	[Fee5] [float] NULL,
	[ResidenceExpireDate] [datetime] NULL,
 CONSTRAINT [PK_WF_ResidenceRequest] 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_ResidenceRequest] ADD  CONSTRAINT [DF_WF_ResidenceRequest_Fee1]  DEFAULT ((0)) FOR [Fee1]
GO

ALTER TABLE [dbo].[WF_ResidenceRequest] ADD  CONSTRAINT [DF_WF_ResidenceRequest_Fee11]  DEFAULT ((0)) FOR [Fee2]
GO

ALTER TABLE [dbo].[WF_ResidenceRequest] ADD  CONSTRAINT [DF_WF_ResidenceRequest_Fee11_1]  DEFAULT ((0)) FOR [Fee3]
GO

ALTER TABLE [dbo].[WF_ResidenceRequest] ADD  CONSTRAINT [DF_WF_ResidenceRequest_Fee31]  DEFAULT ((0)) FOR [Fee4]
GO

ALTER TABLE [dbo].[WF_ResidenceRequest] ADD  CONSTRAINT [DF_WF_ResidenceRequest_Fee41]  DEFAULT ((0)) FOR [Fee5]
GO

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

ALTER TABLE [dbo].[WF_ResidenceRequest] CHECK CONSTRAINT [FK_WF_ResidenceRequest_WF_MasterRequests]
GO

ALTER TABLE [dbo].[WF_ResidenceRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_ResidenceRequest_WF_ResidenceTypes] FOREIGN KEY([ResidenceTypeCode])
REFERENCES [dbo].[WF_ResidenceTypes] ([ResidenceTypeCode])
GO

ALTER TABLE [dbo].[WF_ResidenceRequest] CHECK CONSTRAINT [FK_WF_ResidenceRequest_WF_ResidenceTypes]
GO

------------------------------- End 2020-11-26 -----------------------
 ---------------------Ali 2020-11-22----------------------------------

/****** Object:  Table [dbo].[WF_FinancialPaymentType]    Script Date: 22/11/2020 11:06:20 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[WF_FinancialPaymentType](
	[FinancialPaymentTypeCode] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](150) NOT NULL,
	[Arabic_Name] [nvarchar](150) NOT NULL,
	[RelatedTo] [tinyint] NOT NULL,
	[IsActive] [bit] NOT NULL,
	[CreatedBy] [int] NOT NULL,
	[CreationDate] [datetime] NOT NULL,
	[ModifiedBy] [int] NULL,
	[ModificationDate] [datetime] NULL,
 CONSTRAINT [PK_FinancialBondsType] PRIMARY KEY CLUSTERED 
(
	[FinancialPaymentTypeCode] 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_FinancialPaymentType] ADD  CONSTRAINT [DF_FinancialBondsType_IsActive]  DEFAULT ((0)) FOR [IsActive]
GO

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (391, N'Financial payment Type', N'انواع السندات المالية', 28, N'/WorkFlow/FinancialPaymentType', N'Index', N'fa fa-thumb-tack', N'get', 23, 1, 1)
Go

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

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3574, N'انواع السندات المالية', N'Financial payment Type', 391, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3575, N'عرض انواع السندات المالية', N'View Financial payment Type', 391, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3576, N'اضافة انواع السندات المالية', N'Add Financial payment Type', 391, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3577, N'تعديل انواع السندات المالية', N'Edit Financial payment Type', 391, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3578, N'حذف انواع السندات المالية', N'Delete Financial payment Type', 391, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3579, N'حفظ انواع السندات المالية', N'Save Financial payment Type', 391, 2)
Go

 ---------------------End 2020-11-22----------------------------------
-------------------------- A.Khaled 2020-11-22-----------------------------
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(392,N'Residence Request',N'طلب إقامة',29,N'/WorkFlow/ResidenceRequest',N'Index','fa fa-thumb-tack',N'get',41,1,1)
Go

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

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(3580,N'طلب إقامة',N'Residence Request',392,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(3581,N'عرض طلب إقامة',N'View Residence Request',392,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(3582,N'إضافة طلب إقامة',N'Add Residence Request',392,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(3583,N'تعديل طلب إقامة',N'Edit Residence Request',392,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(3584,N'حذف طلب إقامة',N'Delete Residence Request',392,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(3585,N'حفظ طلب إقامة',N'Save Residence Request',392,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(3586,N'إلغاء طلب إقامة',N'Cancel Residence Request',392,2)

Go
-------------------------- A.Khaled 2020-11-22-----------------------------
-------------------------- Ali 2020-11-23-----------------------------

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (393, N'Residence Request Signature', N'اعتماد طلب إقامة', 108, N'/WorkFlow/ResidenceRequestSignature', N'Index', N'fa fa-thumb-tack', N'get', 44, 1, 1)
Go
INSERT [dbo].[SystemMenuModule] ([SystemMenuModuleCode], [SystemMenuCode], [AppModuleCode]) VALUES (26821, 393, 1)
Go
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3587, N'اعتماد طلب إقامة', N'Residence Request Signature', 393, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3588, N'عرض اعتماد طلب إقامة', N'View Residence Request Signature', 393, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3589, N'تعديل اعتماد طلب إقامة', N'Edit Residence Request Signature', 393, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3590, N'حفظ اعتماد طلب إقامة', N'Save Residence Request Signature', 393, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3591, N'عرض سجل الموظف', N'View Employee History', 393, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3592, N'حفظ متعدد  اعتماد طلب إقامة', N'Save Multiple Residence Request Signature', 393, 3)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3593, N'ارجاع طلب إقامة', N'Inverse Residence Request', 393, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3594, N'اختيار كل الطلبات', N'Choose All Requests', 393, 2)
Go



  ALTER TABLE [WF_ResidenceRequest] ALTER COLUMN [Fee1] float NULL 
  ALTER TABLE [WF_ResidenceRequest] ALTER COLUMN [Fee2] float NULL  
   ALTER TABLE [WF_ResidenceRequest] ALTER COLUMN [Fee3] float NULL
  ALTER TABLE [WF_ResidenceRequest] ALTER COLUMN [Fee4] float NULL
  ALTER TABLE [WF_ResidenceRequest] ALTER COLUMN [Fee5] float NULL
  ALTER TABLE [WF_ResidenceRequest] ALTER COLUMN [ResidenceExpireDate] datetime NULL
  Go
-------------------------- End 2020-11-23-----------------------------
-------------------------- Sayed 2020-11-23---------------------------
Update [dbo].[EmailTemplateType] set [Arabic_Name]= N'ارسال طلب مخزن' where [EmailTemplateTypeCode]=156
Update [dbo].[EmailTemplateType] set [Arabic_Name]= N'الموافقة على طلب مخزن' where [EmailTemplateTypeCode]=157
Update [dbo].[EmailTemplateType] set [Arabic_Name]= N'رفض طلب مخزن' where [EmailTemplateTypeCode]=158
Update [dbo].[EmailTemplateType] set [Arabic_Name]= N'الغاء طلب مخزن' where [EmailTemplateTypeCode]=159
Go


Update [dbo].[EmailTemplate] set [Arabic_Name]=  N'إرسال طلب مخزن' where [EmailTemplateCode]=156
Update [dbo].[EmailTemplate] set [Arabic_Name]= N'الموافقة على طلب مخزن' where [EmailTemplateCode]=157
Update [dbo].[EmailTemplate] set [Arabic_Name]= N'رفض طلب مخزن'where [EmailTemplateCode]=158
Update [dbo].[EmailTemplate] set [Arabic_Name]=  N'إلغاء طلب مخزن'where [EmailTemplateCode]=159
Go

update [dbo].[SystemMenu] set [Arabic_Name]= N'طلب مخزن'Where SystemMenuCode=381
update [dbo].[SystemMenu] set [Arabic_Name]= N'اعتماد طلب مخزن 'Where SystemMenuCode=382
update [dbo].[SystemMenu] set [Arabic_Name]=  N'حفظ اعتماد طلب مخزن  'Where SystemMenuCode=383
update [dbo].[SystemMenu] set [Arabic_Name]=  N'إستلام الحركة المخزنية'Where SystemMenuCode=384
Go
-------------------------- End 2020-11-23-----------------------------
------------------------------- A.Khaled 2020-11-24 -------------------------- 
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) 
VALUES (394, N'Add a new residence request', N'اضافة طلب اقامة جديدة', 29, N'/WorkFlow/ResidenceRequest', N'save', N'fa fa-thumb-tack', N'get', 0, 0, 0)
INSERT INTO SystemMenuModule (SystemMenuCode,AppModuleCode) VALUES (394,1)
------------------------------- End 2020-11-24 ------------------------