﻿-------------------------------------------Hammad 2024-09-02 ------------------------
SET IDENTITY_INSERT [dbo].[EmailTemplateType] ON 
GO
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode], [RequestTypeCode], [HaveUserAccount]) VALUES (385, N'Missing Sign In', N'عدم قيام الموظف بتسجيل بصمة الدخول', 0, 13, NULL, 1)
GO
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode], [RequestTypeCode], [HaveUserAccount]) VALUES (386, N'Missing Sign Out', N'عدم قيام الموظف بتسجيل بصمة الخروج', 0, 13, NULL, 1)
GO
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode], [RequestTypeCode], [HaveUserAccount]) VALUES (387, N'Late Time', N'التأخير', 0, 13, NULL, 1)
GO
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode], [RequestTypeCode], [HaveUserAccount]) VALUES (388, N'Short Time', N'التقصير', 0, 13, NULL, 1)
GO
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode], [RequestTypeCode], [HaveUserAccount]) VALUES (389, N'Time Permissions Out', N'اسنفاذ الموظف عدد الأذون الشخصية', 0, 13, NULL, 1)
GO
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode], [RequestTypeCode], [HaveUserAccount]) VALUES (390, N'New Hire', N'المعينين الجدد', 0, 13, NULL, 1)
GO
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode], [RequestTypeCode], [HaveUserAccount]) VALUES (391, N'Expired Probation Period', N'نهاية فترة الاختبار', 0, 13, NULL, 1)
GO
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode], [RequestTypeCode], [HaveUserAccount]) VALUES (392, N'Resignations', N'الاستقالات', 0, 13, NULL, 1)
GO
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode], [RequestTypeCode], [HaveUserAccount]) VALUES (393, N'Departmental Changes', N'التغييرات الإدارية', 0, 13, NULL, 1)
GO
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode], [RequestTypeCode], [HaveUserAccount]) VALUES (394, N'Birth Day', N'أعياد الميلاد', 0, 13, NULL, 1)
GO
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode], [RequestTypeCode], [HaveUserAccount]) VALUES (395, N'Vacation Balance', N'رصيد الاجازات', 0, 13, NULL, 1)
GO
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode], [RequestTypeCode], [HaveUserAccount]) VALUES (396, N'Contract Expiration', N'انتهاء التعاقد', 0, 13, NULL, 1)
GO
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode], [RequestTypeCode], [HaveUserAccount]) VALUES (397, N'Pay Slip', N'كشف الراتب', 0, 13, NULL, 1)
GO
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode], [RequestTypeCode], [HaveUserAccount]) VALUES (398, N'ID Personal Expiration', N' انتهاء البطاقة الشخصية', 0, 13, NULL, 1)
GO
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode], [RequestTypeCode], [HaveUserAccount]) VALUES (399, N'Military Certificate', N'شهادة التجنيد', 0, 13, NULL, 1)
GO
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode], [RequestTypeCode], [HaveUserAccount]) VALUES (400, N'Health Card', N'الشهادة الصحية', 0, 13, NULL, 1)
GO
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode], [RequestTypeCode], [HaveUserAccount]) VALUES (401, N'Driving License', N'رخصة القيادة', 0, 13, NULL, 1)
GO
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode], [RequestTypeCode], [HaveUserAccount]) VALUES (402, N'Medical Insurance', N'التأمين الصحي', 0, 13, NULL, 1)
GO
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode], [RequestTypeCode], [HaveUserAccount]) VALUES (403, N'Rescue Certificate', N'شهادة الانقاذ', 0, 13, NULL, 1)
GO
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode], [RequestTypeCode], [HaveUserAccount]) VALUES (404, N'Skill Test Expiration', N'شهادة قياس مستوى المهارة', 0, 13, NULL, 1)
GO
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode], [RequestTypeCode], [HaveUserAccount]) VALUES (405, N'Marine Certificate', N'شهادة البحارة', 0, 13, NULL, 1)
GO
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode], [RequestTypeCode], [HaveUserAccount]) VALUES (406, N'Criminal Investigation', N'كارنيه البحث الجنائي', 0, 13, NULL, 1)
GO
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode], [RequestTypeCode], [HaveUserAccount]) VALUES (407, N'Work Permission', N'تصاريح العمل', 0, 13, NULL, 1)
GO
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode], [RequestTypeCode], [HaveUserAccount]) VALUES (408, N'Residence', N'الاقامة', 0, 13, NULL, 1)
GO
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode], [RequestTypeCode], [HaveUserAccount]) VALUES (409, N'Retirement', N'المعاش', 0, 13, NULL, 1)
GO
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode], [RequestTypeCode], [HaveUserAccount]) VALUES (410, N'Anniversary of employee joining the facility', N'الذكرى السنوية للالتحاق الموظف بالمنشأة', 0, 13, NULL, 1)
GO
INSERT [dbo].[EmailTemplateType] ([EmailTemplateTypeCode], [Name], [Arabic_Name], [IsEditable], [AppModuleCode], [RequestTypeCode], [HaveUserAccount]) VALUES (411, N'Vaction Due', N'أرصدة الإجازات', 0, 13, NULL, 1)
GO

SET IDENTITY_INSERT [dbo].[EmailTemplateType] OFF
GO

------------------------------------------- End Hammad 2024-09-02 -------------------
  --------------------------------------- AK 2024-09-03 ---------
DELETE [SST.ERP_Client]. [dbo].[APIs] WHERE [ApiId] = 14
Go	
--------------------------------------- End AK 2024-09-03 ------------
--------------------------------------- Ali 2024-09-03 ---------------------------------
delete  from SecurityPrivilegeEndPointsDetails where SecurityPrivilegeEndPointId in(1439,1440,1441,1442,1443,1444,1445,1446,1447,1448,1449)
delete from SecurityPrivilegeEndPoints  where Id in(1439,1440,1441,1442,1443,1444,1445,1446,1447,1448,1449)

--------------------------------------- End  2024-09-03 ----------------------------
