﻿
--------------------------MOstafa 2022-10-18-----------------------
update SystemMenu set Name='In And Out Registration'  
 where SystemMenuCode=654
 Go
CREATE TABLE [dbo].[WebCheckInOut](
	[SerialAuto] [int] IDENTITY(1,1) NOT NULL,
	[EmployeeCode] [int] NOT NULL,
	[CHECKTIMEText] [nvarchar](255) NOT NULL,
	[MachineNumber] [nvarchar](20) NOT NULL,
	[MyDate] [datetime] NULL,
	[SureDate] [datetime] NULL,
	[MyTime] [nvarchar](10) NULL,
	[InOut] [nvarchar](1) NULL,
	[OriginalInOut] [nvarchar](1) NULL,
	[OtherType] [nvarchar](10) NULL,
	[AddBy] [nvarchar](20) NULL,
	[AddDate] [datetime] NULL,
	[LastChangeBy] [nvarchar](20) NULL,
	[ChangeDate] [datetime] NULL,
	[Ignored] [bit] NULL,
	[MachineEmployeeCode] [nvarchar](100) NULL,
	[WithDeductDays] [float] NULL,
	[MyDateHijri] [nvarchar](10) NULL,
	[ConvertedLineLogInToOutNextDay] [bit] NULL,
	[MDT] [datetime] NULL,
 CONSTRAINT [PK_WebCheckInOut] PRIMARY KEY CLUSTERED 
(
	[EmployeeCode] ASC,
	[CHECKTIMEText] ASC,
	[MachineNumber] 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].[WebCheckInOut] ADD  CONSTRAINT [DF_WebCheckInOut_Ignored]  DEFAULT ((0)) FOR [Ignored]
GO
ALTER TABLE [dbo].[WebCheckInOut] ADD  CONSTRAINT [DF_WebCheckInOut_ConvertedLineLogInToOutNextDay]  DEFAULT ((0)) FOR [ConvertedLineLogInToOutNextDay]
GO
--------------------------End 2022-10-18-----------------------
--------------------------Hammad 2022-10-18-----------------------
INSERT [dbo].[LabelsName] ([LabelKey], [Name], [Arabic_Name]) VALUES (N'InquiryClosed', N'Inquiry closed', N'تم إغلاق الإستفسار')
GO
INSERT [dbo].[LabelsName] ([LabelKey], [Name], [Arabic_Name]) VALUES (N'IsApproved', N'Is approved', N'تمت الموافقة')
GO
INSERT [dbo].[LabelsName] ([LabelKey], [Name], [Arabic_Name]) VALUES (N'IsRefused', N'Is refused', N'تم الرفض')
Go
INSERT [dbo].[LabelsName] ([LabelKey], [Name], [Arabic_Name]) VALUES (N'PenaltyExecuted', N'The penalty has been executed', N'تم تنفيذ الجزاء')
GO
--------------------------Hammad 2022-10-18-----------------------

--------------------------Ali 2022-10-19-----------------------

  INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (579, NULL, NULL, N'MeasureSetting', N'GetMeasureSettingsSearch', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (580, NULL, NULL, N'MeasureType', N'GetMeasureTypesSearch', N'Post')
Go
INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (581, NULL, NULL, N'MeasureCategory', N'GetMeasureCategorysSearch', N'Post')
GO

INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (777, 579, 10116, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (778, 580, 10110, NULL)
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (779, 581, 10122, NULL)
GO

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (582, NULL, NULL, N'ArcEmpDocumentType', N'GetArcEmpDocumentTypeSearch', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (780, 582, 9019, NULL)
GO

INSERT [dbo].[SecurityPrivilegeEndPoints] ([Id], [ApiName], [AreaName], [ControllerName], [ActionName], [HTTPMethod]) VALUES (583, NULL, NULL, N'ArcEmpDocument', N'GetArcEmpDocument', N'Post')
GO
INSERT [dbo].[SecurityPrivilegeEndPointsDetails] ([Id], [SecurityPrivilegeEndPointId], [SecurityPrivilegeId], [RequestTypeId]) VALUES (781, 583, 9025, NULL)
GO


--------------------------End 2022-10-19-----------------------
--------------------------Hammad 2022-10-19-----------------------
SET IDENTITY_INSERT [dbo].[EmailTemplateType] ON 
GO
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode], [RequestTypeCode], [HaveUserAccount]) 
VALUES (337, N'Evaluation elements final approved', N'الإعتماد النهائى لعناصر التقيم ', 0, 8, NULL, 1)
GO
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode], [RequestTypeCode], [HaveUserAccount]) 
VALUES (338, N'Employee Evaluation Finished', 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 elements final approved', N'الإعتماد النهائى لعناصر التقيم', 337, N'   الإعتماد النهائى لعناصر التقيم', N'   الإعتماد النهائى لعناصر التقيم', 1, NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[EmailTemplate] ([Name], [Arabic_Name], [EmailTemplateTypeCode], [Subject], [Body], [IsDefault], [SubjectAppendCode], [GeneralTypeCode], [JobTypeCode], [MessageTemplate])
VALUES (N'Employee Evaluation Finished', N'إنتهاء تقييم الموظف', 338, N'إنتهاء تقييم الموظف', N'إنتهاء تقييم الموظف', 1, NULL, NULL, NULL, NULL)
GO
--------------------------End 2022-10-19-----------------------