------------------------------- Ali 2020-11-16 ------------------------

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (388, N'Terms and Conditions', N'الشروط والاحكام', 4, N'/TermAndCondition', N'Index', N'fa fa-thumb-tack', N'get', 14, 1, 1)
Go

INSERT [dbo].[SystemMenuModule] ([SystemMenuCode], [AppModuleCode]) VALUES ( 388, 6)
Go

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1230, N'الشروط والاحكام', N'Terms and Conditions', 388, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1231, N'عرض الشروط والاحكام', N'View Terms and Conditions', 388, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1232, N'حفظ الشروط والاحكام', N'Save Terms and Conditions', 388, 2)
Go

CREATE TABLE [dbo].[TermsAndConditions](
	[TermsAndConditionsId] [int] IDENTITY(1,1) NOT NULL,
	[TermsAndConditions] [nvarchar](max) NOT NULL,
	[Arabic_TermsAndConditions] [nvarchar](max) NOT NULL,
	[CreatedBy] [int] NOT NULL,
	[CreationDate] [datetime] NOT NULL,
	[ModifiedBy] [int] NULL,
	[ModificationDate] [datetime] NULL,
 CONSTRAINT [PK_TermAndCondition] PRIMARY KEY CLUSTERED 
(
	[TermsAndConditionsId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO


 ------------------------------- End 2020-11-16 ------------------------
 -------------------------------Sayed 2020-11-16------------------------
 INSERT [dbo].[ConfigLookup] ([ConfigLookupCode], [Name], [Arabic_Name], [ConfigKey]) 
VALUES (60, N'Time Attendance', N'الحضور والانصراف', N'WFCheckDayOffDependOn')
INSERT [dbo].[ConfigLookup] ([ConfigLookupCode], [Name], [Arabic_Name], [ConfigKey])
 VALUES (61, N'Time Schedule', N'الجدول الزمني', N'WFCheckDayOffDependOn')
 Go
 ---------------------End 2020-11-16-------------------------------------
 ------------------------------- Ali 2020-11-17 ------------------------
  ALTER TABLE dbo.SecurityUser 
  ADD IsFirstLogin bit NOT NULL DEFAULT 1
  GO

  ALTER TABLE [WF_GeneralRequestType]
  ALTER COLUMN [Arabic_Name] nvarchar(100);
  Go
    ALTER TABLE [WF_GeneralRequestType]
  ALTER COLUMN [Name] nvarchar(100);
    Go
 ---------------------End 2020-11-17-------------------------------------

 ------------------------------- Ali 2020-11-18 ------------------------
 INSERT [dbo].[ConfigLookup] ([ConfigLookupCode], [Name], [Arabic_Name], [ConfigKey])
 VALUES (63, N'Nothing', N'لاشىء', N'WFCheckDayOffDependOn')
 Go

  update [ConfigParameter] set [IsVisible]=1,[ConfigValue]=1
  where [ConfigKey]='TheNoCharactersSearchSection'
  Go
  
 update [ConfigParameter] set [IsVisible]=1,[ConfigValue]=1
  where [ConfigKey]='TheNoCharactersSearchEmployee'
  Go
 ---------------------End 2020-11-18-------------------------------------

 ---------------------Hammad 2020-11-18----------------------------------

 SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WF_ResidenceTypes](
	[ResidenceTypeCode] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](150) NOT NULL,
	[Arabic_Name] [nvarchar](150) NOT NULL,
	[IsEditable] [bit] NOT NULL,
	[IsVisible] [bit] NOT NULL,
	[HaveDifferentTrack] [bit] NOT NULL,
	[CreatedBy] [int] NULL,
	[CreationDate] [datetime] NULL,
	[ModifiedBy] [int] NULL,
	[ModificationDate] [datetime] NULL,
 CONSTRAINT [PK_WF_ResidenceTypes] PRIMARY KEY CLUSTERED 
(
	[ResidenceTypeCode] 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_ResidenceTypes] ADD  CONSTRAINT [DF_WF_ResidenceTypes_IsVisible]  DEFAULT ((0)) FOR [IsVisible]
GO

ALTER TABLE [dbo].[WF_ResidenceTypes] ADD  CONSTRAINT [DF_WF_ResidenceTypes_HaveDifferentTrack]  DEFAULT ((0)) FOR [HaveDifferentTrack]
GO




SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WF_TypeResidencyFees](
	[TypeResidencyFeeCode] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](150) NOT NULL,
	[Arabic_Name] [nvarchar](150) NOT NULL,
	[IsVisible] [bit] NOT NULL,
	[ModifiedBy] [int] NULL,
	[ModificationDate] [datetime] NULL,
 CONSTRAINT [PK_WF_TypeResidencyFees] PRIMARY KEY CLUSTERED 
(
	[TypeResidencyFeeCode] 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_TypeResidencyFees] ADD  CONSTRAINT [DF_WF_TypeResidencyFees_IsVisible]  DEFAULT ((0)) FOR [IsVisible]
GO



INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (389, N'Residence Types', N'انواع الاقامة', 28, N'/WorkFlow/ResidenceType', N'Index', N'fa fa-thumb-tack', N'get', 21, 1, 1)
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (390, N'Type Residency Fees', N'انواع رسوم الاقامة', 28, N'/WorkFlow/TypeResidencyFees', N'Index', N'fa fa-thumb-tack', N'get', 22, 1, 1)
GO


INSERT [dbo].[SystemMenuModule] ( [SystemMenuCode], [AppModuleCode]) VALUES ( 389, 1)
INSERT [dbo].[SystemMenuModule] ( [SystemMenuCode], [AppModuleCode]) VALUES ( 390, 1)
GO


INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3565, N'انواع الإقامات', N'Residence Types', 389, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3566, N'عرض انواع الإقامات', N'View Residence Types', 389, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3567, N'اضافة انواع الإقامات', N'Add Residence Types', 389, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3568, N'تعديل انواع الإقامات', N'EditResidence Types', 389, 2)
GO
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3569, N'حذف انواع الإقامات', N'Delete Residence Types', 389, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3570, N'حفظ انواع الإقامات', N'Save Residence Types', 389, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3571, N'انواع رسوم الاقامة', N'Type Residency Fees', 390, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3572, N'عرض انواع رسوم الاقامة', N'View Type Residency Fees', 390, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3573, N'تعديل انواع رسوم الاقامة', N'Edit Type Residency Fees', 390, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (3574, N'حفظ انواع رسوم الاقامة', N'Save Type Residency Fees', 390, 2)
GO

SET IDENTITY_INSERT [dbo].[WF_ResidenceTypes] ON 
INSERT [dbo].[WF_ResidenceTypes] ([ResidenceTypeCode], [Name], [Arabic_Name], [IsEditable], [IsVisible],[HaveDifferentTrack], [CreatedBy], [CreationDate], [ModifiedBy], [ModificationDate]) 
VALUES (1, N'Renewal  Residence', N'تجديد الاقامة', 0, 1,1, NULL, NULL, NULL, NULL)
INSERT [dbo].[WF_ResidenceTypes] ([ResidenceTypeCode], [Name], [Arabic_Name], [IsEditable], [IsVisible],[HaveDifferentTrack], [CreatedBy], [CreationDate], [ModifiedBy], [ModificationDate]) 
VALUES (2, N'New Residence', N'إقامة جديدة', 0, 1,1, NULL, NULL, NULL, NULL)
SET IDENTITY_INSERT [dbo].[WF_ResidenceTypes] OFF
GO

SET IDENTITY_INSERT [dbo].[WF_TypeResidencyFees] ON 

INSERT [dbo].[WF_TypeResidencyFees] ([TypeResidencyFeeCode], [Name], [Arabic_Name], [IsVisible], [ModifiedBy], [ModificationDate]) VALUES (1, N'Fee 1', N'رسوم 1', 1, NULL, NULL)
INSERT [dbo].[WF_TypeResidencyFees] ([TypeResidencyFeeCode], [Name], [Arabic_Name], [IsVisible], [ModifiedBy], [ModificationDate]) VALUES (2, N'Fee 2', N'رسوم 2', 1, NULL, NULL)
INSERT [dbo].[WF_TypeResidencyFees] ([TypeResidencyFeeCode], [Name], [Arabic_Name], [IsVisible], [ModifiedBy], [ModificationDate]) VALUES (3, N'Fee 3', N'رسوم 3', 1, NULL, NULL)
INSERT [dbo].[WF_TypeResidencyFees] ([TypeResidencyFeeCode], [Name], [Arabic_Name], [IsVisible], [ModifiedBy], [ModificationDate]) VALUES (4, N'Fee 4', N'رسوم 4', 0, NULL, NULL)
INSERT [dbo].[WF_TypeResidencyFees] ([TypeResidencyFeeCode], [Name], [Arabic_Name], [IsVisible], [ModifiedBy], [ModificationDate]) VALUES (5, N'Fee 5', N'رسوم 5', 0, NULL, NULL)
SET IDENTITY_INSERT [dbo].[WF_TypeResidencyFees] OFF
 ---------------------End 2020-11-18----------------------------------
 ------------------------------- Ali 2020-11-19 ------------------------
 EXEC sp_RENAME 'WF_TypeResidencyFees.IsVisible' , 'IsActive', 'COLUMN'
 Go
   EXEC sp_RENAME 'WF_ResidenceTypes.IsVisible' , 'IsActive', 'COLUMN'
   Go

     update [SecurityPrivilege] 
  set[DescriptionAR]=N'حفظ انواع رسوم الاقامة',[DescriptionEN]=N'Save Type Residency Fees'
  where ID=3573
   Go

  delete from [SecurityPrivilege]
    where ID=3574
	 Go
 ---------------------End 2020-11-19----------------------------------
