﻿-------------------------Hammad 2022-10-04--------------------------
SET IDENTITY_INSERT [dbo].[EmailTemplateType] ON 
GO
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode], [RequestTypeCode], [HaveUserAccount]) 
VALUES (339, N'Evaluation have been approved', N'تمت الموافقه على  التقييم ', 0, 8, NULL, 1)
GO
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode], [RequestTypeCode], [HaveUserAccount]) 
VALUES (340, N'The opinion was given in the evaluation', N'  تم ابداء الرأى فى  التقييم ', 0, 8, NULL, 1)
GO
SET IDENTITY_INSERT [dbo].[EmailTemplateType] OFF

INSERT [dbo].[EmailTemplate] ( [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode], [GeneralTypeCode], [JobTypeCode], [MessageTemplate])
VALUES ( N'Evaluation have been approved', N'تمت الموافقه على  التقييم', 339, N' تمت الموافقه على  التقييم', N'تمت الموافقه على  التقييم', 1, NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[EmailTemplate] ([Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode], [GeneralTypeCode], [JobTypeCode], [MessageTemplate])
VALUES (N'The opinion was given in the evaluation', N'تم ابداء الرأى فى  التقييم', 340, N'تم ابداء الرأى فى  التقييم', N'تم ابداء الرأى فى  التقييم', 1, NULL, NULL, NULL, NULL)
GO

--------------------------End 2022-10-04--------------------------
--------------------------Mostafa 2022-10-04--------------------------
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(654,N'Attendance And Leaving Registration',N'تسجيل الحضور والانصراف',345,N'/Attendance/AttendanceLeavingRegistration',N'index','fa fa-thumb-tack',N'get',9,1,1)
Go
INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(654,11)
Go
INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(13098,N'تسجيل الحضور والانصراف',N'Attendance And Leaving Registration',654,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(13099,N'عرض تسجيل الحضور والانصراف',N'View Attendance And Leaving Registration',654,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(13100,N'إضافة تسجيل الحضور والانصراف',N'Add Attendance And Leaving Registration',654,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(13103,N'حفظ تسجيل الحضور والانصراف',N'Save Attendance And Leaving Registration',654,2)
Go
INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'MachineNumber',N'Machine Number',N'رقم الماكينة',N'999',12,12,2,1,Null,Null,Null)
Go
INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'FingerprintCodeIN',N'Fingerprint Code IN',N'كود بصمة الدخول',N'0',12,13,4,1,Null,Null,Null)
Go
INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'FingerprintCodeOUT',N'Fingerprint Code OUT',N'كود بصمة الخروج',N'1',12,14,4,1,Null,Null,Null)
Go
--------------------------End 2022-10-04--------------------------
--------------------------Hammad 2022-10-04-----------------------

SET IDENTITY_INSERT [dbo].[EmailTemplateType] ON 
GO
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode], [RequestTypeCode], [HaveUserAccount]) 
VALUES (341, N'Evaluation Final Approved', N'الموافقة النهائية على التقييم ', 0, 8, NULL, 1)
GO

SET IDENTITY_INSERT [dbo].[EmailTemplateType] OFF

INSERT [dbo].[EmailTemplate] ( [Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode], [GeneralTypeCode], [JobTypeCode], [MessageTemplate])
VALUES ( N'Evaluation Final Approved', N'الموافقة النهائية على التقييم', 341, N' الموافقة النهائية على التقييم', N'الموافقة النهائية على التقييم', 1, NULL, NULL, NULL, NULL)
GO
--------------------------End 2022-10-04-----------------------
--------------------------Ali 2022-10-05-----------------------


ALTER TABLE dbo.SecurityUser ADD
	IsHr bit NOT NULL CONSTRAINT DF_SecurityUser_IsHr DEFAULT (0)
GO

 INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'WF_ViewInsteadOFTimeSignAndForPartNo',N'View Instead OF Time Sign and For Part No',N'عرض بديل علامة الوقت وجزء الدوام',N'true',2,34,1,1,Null,Null,2)
Go
--------------------------End 2022-10-05-----------------------
