-------------------------------Ali 2020-03-02-----------------------
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1196, N'عرض التامين الطبى', N'View Medical Insurance', 3, 2)
Go



ALTER procedure [dbo].[Emp_GetEmployeeProfile] 
(
	@userCode	int
)
AS
SELECT  
	   e.[EmployeeCode]
      ,e.[Name]
      ,e.[Arabic_Name]
      ,[Sex]
      ,[BirthDate]
      ,[BirthCityCode]
      ,[BirthDestination]
      ,[BirthDestinationArabic]
          
      ,[LokerNumber]
      ,[IDTypeCode]
      ,[IdIssueFrom]
      ,[IdIssueFromArabic]
      ,[IdNumber]
      ,[IDpolice_station]
      ,[IdCityCode]
      ,[IdIssueDate]
      ,[IdExpireDate]
     
      ,[Children_Number]
     
      ,[HiringDate]
      ,[ContractDate]
      ,[ContractExpireDate]    
     
      ,[InsuranceNumber]
      ,e.[ReligionCode]      
    
      ,[ResignationCode]
      ,[ResignationDate]     
      ,[Active]
   
      ,[CityCode]
      ,[EngFullAddress]
      ,[ArabicFullAddress]
      ,[OldFullAddress]    
      ,[Police_Station]
      ,[EngArea]
      ,[EngPolice_Station]
     
      ,[MotherName]
      ,e.[Telephone]
      ,[Mobile]
      ,e.[EMail]
      ,[CurrPercent]
      ,[Hidden]
      ,[Transfer]
      ,[VacationCalcCode]
      ,[DayRate]
      ,[WorkHoures]     
      ,[RoomNumber]     
      ,[BasicSalary]
    
      ,[StopSalaryReason]
      ,[NotApplicableToTransportationAllowance]
      ,[StopSalary]
      ,[ResignationPostingDate]
       
      ,[EmployeeType]
      ,[BirthDateHijri]
      ,[ContractDateHijri]
      ,[ContractExpireDateHijri]
      ,[HiringDateHijri]
	  ,[ProbationDate]
      ,[ProbationDateHijri]
      ,[ExperienceDateHijri]
      ,[LastWageHijri]
      ,[InsureDateHijri]
      ,[ResignationDateHijri]
      ,[ResignationPostingDateHijri]
      
	  ,dbo.Location.[Name] LocationNameEn
	  ,dbo.Location.[Arabic_Name] LocationNameAr	
	  ,dbo.SocialInsurance.[BasicEmployeeShare]
	  ,dbo.SocialInsurance.[BasicCompanyShare]
	  ,dbo.SocialInsurance.[VariableEmployeeShare]
	  ,dbo.SocialInsurance.[VariableCompanyShare]
	  ,dbo.SocialInsurance.[InsuranceDate]
	  ,dbo.SocialInsurance.[InsuranceDateHijri]
	  ,dbo.Insurer.[Name] as InsurerNameEn
	  ,dbo.Insurer.[Arabic_Name] as InsurerNameAr
	  ,dbo.InsuranceTypes.[Name] as InsuranceTypesNameEn
	  ,dbo.InsuranceTypes.[Arabic_Name] as InsuranceTypesNameAr
	  ,dbo.Sections.Name SectionsNameEn
	  ,dbo.Sections.Arabic_Name SectionsNameAr
	  ,dbo.Departments.Name DepartmentsNameEn
	  ,dbo.Departments.Arabic_Name DepartmentsNameAr
	  ,dbo.Divisions.Name DivisionsNameEn
	  ,dbo.Divisions.Arabic_Name DivisionsNameAr
	  ,dbo.Nationality.[Name] NationalityNameEn
	  ,dbo.Nationality.[Arabic_Name] NationalityNameAr
	  ,dbo.Nationality.[CountryName]
	  ,dbo.Nationality.[CountryArabic_Name]
	  ,dbo.MaritalStatus.[Name] MaritalStatusNameEn
	  ,dbo.MaritalStatus.[Arabic_Name] MaritalStatusNameAr
	  ,dbo.EmployeeEducationData.[EducationDescription]
	  ,dbo.[Contract].[Name] ContractNameEn
	  ,dbo.[Contract].[Arabic_Name] ContractNameAr
	  ,dbo.[Currencies].[Name] CurrenciesNameEn
	  ,dbo.[Currencies].[Arabic_Name] CurrenciesNameAr
	  ,dbo.Levels.Name LevelsNameEn
	  ,dbo.Levels.Arabic_Name LevelsNameAr
	  ,dbo.Positions.Name PositionsNameEn
	  ,dbo.Positions.Arabic_Name PositionsNameAr
	  ,dbo.[GeneralTypes].[Name] GeneralTypesNameEn
	  ,dbo.[GeneralTypes].[Arabic_Name] GeneralTypesNameAr
	  ,UserImage
	  ,RecieveEmailNotifications
	  ,UserName



	  ,dbo.EmployeesExtend.[IssuePlace] as EmpExtendIssuePlace
	  ,dbo.EmployeesExtend.[CardNumber] as  EmpExtendCardNumber
	  ,dbo.EmployeesExtend.[IssueDate] as EmpExtendIssueDate
	  ,dbo.EmployeesExtend.[IssueDateHijri] as EmpExtendIssueDateHijri
	  ,dbo.EmployeesExtend.[ExpireDate] as EmpExtendExpireDate
	  ,dbo.EmployeesExtend.[ExpireDateHijri] as EmpExtendExpireDateHijri

	  ,dbo.[HealthInsuranceTypes].[Name] as MedicalInsuranceTypeNameEn
	  ,dbo.[HealthInsuranceTypes].[Arabic_Name] as MedicalInsuranceTypeNameAr
	



	 
	  ,dbo.Relatives.[MedicalIssuePlace] 
	  ,dbo.Relatives.[MedicalCardNumber] 
	  ,dbo.Relatives.[MedicalIssueDate] 
	  ,dbo.Relatives.[MedicalIssueDateHijri] 
	  ,dbo.Relatives.[MedicalExpireDate] 
	  ,dbo.Relatives.[MedicalExpireDateHijri] 
	  ,dbo.[RelativeTypes].[Name] as RelativeTypeNameEn
	  ,dbo.[RelativeTypes].[Arabic_Name] as RelativeTypeNameAr
	 

	  
     
   
FROM [dbo].[SecurityUser]

left join [dbo].[Employees] e on [dbo].SecurityUser.[EmployeeCode] = e.EmployeeCode
left join [dbo].[Location] on [dbo].Location.[LocationCode] = e.LocationCode
left join [dbo].[SocialInsurance] on [dbo].SocialInsurance.[EmployeeCode] = e.EmployeeCode
left join [dbo].[Insurer] on [dbo].Insurer.[InsurerCode] = [dbo].SocialInsurance.[InsurerCode]
left join [dbo].[InsuranceTypes] on [dbo].InsuranceTypes.InsuranceCode = e.InsuranceCode
left join [dbo].[Sections] on [dbo].Sections.SectionCode = e.SectionCode
left join [dbo].[Departments] on [dbo].Departments.DepartmentCode = [dbo].Sections.DepartmentCode
left join [dbo].Divisions on [dbo].Divisions.DivisionCode = [dbo].Departments.DivisionCode
left join [dbo].[Nationality] on [dbo].Nationality.[NationalityCode] = e.NationalityCode
left join [dbo].[MaritalStatus] on [dbo].MaritalStatus.[MaritalCode] = e.MaritalCode
left join [dbo].[EmployeeEducationData] on [dbo].EmployeeEducationData.[EmployeeCode] = e.EmployeeCode
left join [dbo].[Contract] on [dbo].[Contract].[ContractCode] = e.ContractCode
left join [dbo].[Currencies] on [dbo].[Currencies].CurrencyCode = e.CurrencyCode
left join [dbo].[Levels] on [dbo].Levels.LevelCode = e.LevelCode
left join [dbo].[GeneralTypes] on [dbo].GeneralTypes.[GeneralTypeCode] = e.GeneralTypeCode
left join [dbo].[Positions] on [dbo].Positions.PositionCode = e.PositionCode

left join [dbo].[EmployeesExtend] on [dbo].EmployeesExtend.[EmployeeExtendCode] = e.EmployeeCode
left join [dbo].[Relatives] on [dbo].Relatives.[EmployeeCode] = e.EmployeeCode
left join [dbo].[RelativeTypes] on [dbo].RelativeTypes.RelativeTypeCode = [dbo].[Relatives].RelativeTypeCode
left join [dbo].[HealthInsuranceTypes] on [dbo].HealthInsuranceTypes.HealthInsuranceTypeCode = [dbo].[EmployeesExtend].HealthInsuranceTypeCode



where [dbo].[SecurityUser].[EmployeeCode] = @userCode;


Go
-------------------------------End 2020-03-02-----------------------
-------------------------------Ali 2020-03-03-----------------------
ALTER TABLE dbo.TimePermissionsTypes ADD
	EffectInAppraisal bit NOT NULL DEFAULT (1)
GO

ALTER TABLE dbo.VacationType ADD
	EffectInAppraisal bit NOT NULL DEFAULT (1)
GO

  update [SystemMenu] set [ParentID]=52 , [Sequence]=7
  where SystemMenuCode=201
  GO
    update [SystemMenu] set [ParentID]=52 , [Sequence]=8
  where SystemMenuCode=215
  GO
-------------------------------End 2020-03-03-----------------------
-------------------------------Sayed 2020-03-04---------------


ALTER procedure [dbo].[Emp_GetEmployeeProfile] 
(
	@userCode	int
)
AS
SELECT  
	   e.[EmployeeCode]
      ,e.[Name]
      ,e.[Arabic_Name]
      ,[Sex]
      ,[BirthDate]
      ,[BirthCityCode]
      ,[BirthDestination]
      ,[BirthDestinationArabic]
          
      ,[LokerNumber]
      ,[IDTypeCode]
      ,[IdIssueFrom]
      ,[IdIssueFromArabic]
      ,[IdNumber]
      ,[IDpolice_station]
      ,[IdCityCode]
      ,[IdIssueDate]
      ,[IdExpireDate]
     
      ,[Children_Number]
     
      ,[HiringDate]
      ,[ContractDate]
      ,[ContractExpireDate]    
     
      ,[InsuranceNumber]
      ,e.[ReligionCode]      
    
      ,[ResignationCode]
      ,[ResignationDate]     
      ,[Active]
   
      ,[CityCode]
      ,[EngFullAddress]
      ,[ArabicFullAddress]
      ,[OldFullAddress]    
      ,[Police_Station]
      ,[EngArea]
      ,[EngPolice_Station]
     
      ,[MotherName]
      ,e.[Telephone]
      ,[Mobile]
      ,e.[EMail]
      ,[CurrPercent]
      ,[Hidden]
      ,[Transfer]
      ,[VacationCalcCode]
      ,[DayRate]
      ,[WorkHoures]     
      ,[RoomNumber]     
      ,[BasicSalary]
    
      ,[StopSalaryReason]
      ,[NotApplicableToTransportationAllowance]
      ,[StopSalary]
      ,[ResignationPostingDate]
       
      ,[EmployeeType]
      ,[BirthDateHijri]
      ,[ContractDateHijri]
      ,[ContractExpireDateHijri]
      ,[HiringDateHijri]
	  ,[ProbationDate]
      ,[ProbationDateHijri]
      ,[ExperienceDateHijri]
      ,[LastWageHijri]
      ,[InsureDateHijri]
      ,[ResignationDateHijri]
      ,[ResignationPostingDateHijri]
      
	  ,dbo.Location.[Name] LocationNameEn
	  ,dbo.Location.[Arabic_Name] LocationNameAr	
	  ,dbo.SocialInsurance.[BasicEmployeeShare]
	  ,dbo.SocialInsurance.[BasicCompanyShare]
	  ,dbo.SocialInsurance.[VariableEmployeeShare]
	  ,dbo.SocialInsurance.[VariableCompanyShare]
	  ,dbo.SocialInsurance.[InsuranceDate]
	  ,dbo.SocialInsurance.[InsuranceDateHijri]
	   ,dbo.SocialInsurance.MaxBasic

	  ,dbo.Insurer.[Name] as InsurerNameEn
	  ,dbo.Insurer.[Arabic_Name] as InsurerNameAr
	  ,dbo.InsuranceTypes.[Name] as InsuranceTypesNameEn
	  ,dbo.InsuranceTypes.[Arabic_Name] as InsuranceTypesNameAr
	  ,dbo.Sections.Name SectionsNameEn
	  ,dbo.Sections.Arabic_Name SectionsNameAr
	  ,dbo.Departments.Name DepartmentsNameEn
	  ,dbo.Departments.Arabic_Name DepartmentsNameAr
	  ,dbo.Divisions.Name DivisionsNameEn
	  ,dbo.Divisions.Arabic_Name DivisionsNameAr
	  ,dbo.Nationality.[Name] NationalityNameEn
	  ,dbo.Nationality.[Arabic_Name] NationalityNameAr
	  ,dbo.Nationality.[CountryName]
	  ,dbo.Nationality.[CountryArabic_Name]
	  ,dbo.MaritalStatus.[Name] MaritalStatusNameEn
	  ,dbo.MaritalStatus.[Arabic_Name] MaritalStatusNameAr
	  ,dbo.EmployeeEducationData.[EducationDescription]
	  ,dbo.[Contract].[Name] ContractNameEn
	  ,dbo.[Contract].[Arabic_Name] ContractNameAr
	  ,dbo.[Currencies].[Name] CurrenciesNameEn
	  ,dbo.[Currencies].[Arabic_Name] CurrenciesNameAr
	  ,dbo.Levels.Name LevelsNameEn
	  ,dbo.Levels.Arabic_Name LevelsNameAr
	  ,dbo.Positions.Name PositionsNameEn
	  ,dbo.Positions.Arabic_Name PositionsNameAr
	  ,dbo.[GeneralTypes].[Name] GeneralTypesNameEn
	  ,dbo.[GeneralTypes].[Arabic_Name] GeneralTypesNameAr
	  ,UserImage
	  ,RecieveEmailNotifications
	  ,UserName



	  ,dbo.EmployeesExtend.[IssuePlace] as EmpExtendIssuePlace
	  ,dbo.EmployeesExtend.[CardNumber] as  EmpExtendCardNumber
	  ,dbo.EmployeesExtend.[IssueDate] as EmpExtendIssueDate
	  ,dbo.EmployeesExtend.[IssueDateHijri] as EmpExtendIssueDateHijri
	  ,dbo.EmployeesExtend.[ExpireDate] as EmpExtendExpireDate
	  ,dbo.EmployeesExtend.[ExpireDateHijri] as EmpExtendExpireDateHijri
	  ,dbo.EmployeesExtend.ExtensionNumber

	  ,dbo.[HealthInsuranceTypes].[Name] as MedicalInsuranceTypeNameEn
	  ,dbo.[HealthInsuranceTypes].[Arabic_Name] as MedicalInsuranceTypeNameAr
	



	 
	  ,dbo.Relatives.[MedicalIssuePlace] 
	  ,dbo.Relatives.[MedicalCardNumber] 
	  ,dbo.Relatives.[MedicalIssueDate] 
	  ,dbo.Relatives.[MedicalIssueDateHijri] 
	  ,dbo.Relatives.[MedicalExpireDate] 
	  ,dbo.Relatives.[MedicalExpireDateHijri] 
	  ,dbo.[RelativeTypes].[Name] as RelativeTypeNameEn
	  ,dbo.[RelativeTypes].[Arabic_Name] as RelativeTypeNameAr
	   ,dbo.[Relatives].[Name] as RelativesNameEn
	  ,dbo.[Relatives].[Arabic_Name] as RelativesNameAr
	 

	  
     
   
FROM [dbo].[SecurityUser]

left join [dbo].[Employees] e on [dbo].SecurityUser.[EmployeeCode] = e.EmployeeCode
left join [dbo].[Location] on [dbo].Location.[LocationCode] = e.LocationCode
left join [dbo].[SocialInsurance] on [dbo].SocialInsurance.[EmployeeCode] = e.EmployeeCode
left join [dbo].[Insurer] on [dbo].Insurer.[InsurerCode] = [dbo].SocialInsurance.[InsurerCode]
left join [dbo].[InsuranceTypes] on [dbo].InsuranceTypes.InsuranceCode = e.InsuranceCode
left join [dbo].[Sections] on [dbo].Sections.SectionCode = e.SectionCode
left join [dbo].[Departments] on [dbo].Departments.DepartmentCode = [dbo].Sections.DepartmentCode
left join [dbo].Divisions on [dbo].Divisions.DivisionCode = [dbo].Departments.DivisionCode
left join [dbo].[Nationality] on [dbo].Nationality.[NationalityCode] = e.NationalityCode
left join [dbo].[MaritalStatus] on [dbo].MaritalStatus.[MaritalCode] = e.MaritalCode
left join [dbo].[EmployeeEducationData] on [dbo].EmployeeEducationData.[EmployeeCode] = e.EmployeeCode
left join [dbo].[Contract] on [dbo].[Contract].[ContractCode] = e.ContractCode
left join [dbo].[Currencies] on [dbo].[Currencies].CurrencyCode = e.CurrencyCode
left join [dbo].[Levels] on [dbo].Levels.LevelCode = e.LevelCode
left join [dbo].[GeneralTypes] on [dbo].GeneralTypes.[GeneralTypeCode] = e.GeneralTypeCode
left join [dbo].[Positions] on [dbo].Positions.PositionCode = e.PositionCode

left join [dbo].[EmployeesExtend] on [dbo].EmployeesExtend.[EmployeeExtendCode] = e.EmployeeCode
left join [dbo].[Relatives] on [dbo].Relatives.[EmployeeCode] = e.EmployeeCode
left join [dbo].[RelativeTypes] on [dbo].RelativeTypes.RelativeTypeCode = [dbo].[Relatives].RelativeTypeCode
left join [dbo].[HealthInsuranceTypes] on [dbo].HealthInsuranceTypes.HealthInsuranceTypeCode = [dbo].[EmployeesExtend].HealthInsuranceTypeCode



where [dbo].[SecurityUser].[EmployeeCode] = @userCode;


GO
--------------------------End 2020-03-04-----------------------------

--------------------------Ali 2020-03-05-----------------------------
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (341, N'Attendance Point Setup', N'اعداد نقاط الحضور والانصراف', 161, N'/Appraisal/AttendancePointSetup', N'Index', NULL, N'get', 16, 1, 1)
Go

INSERT [dbo].[SystemMenuModule] ([SystemMenuCode], [AppModuleCode]) VALUES ( 341, 8)
Go

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10065, N'إعداد نقاط الحضور والانصراف', N'Attendance Point Setup', 341, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10066, N'عرض إعداد نقاط الحضور والانصراف', N'View Attendance Point Setup', 341, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10067, N'اضافة إعداد نقاط الحضور والانصراف', N'Add Attendance Point Setup', 341, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10068, N'تعديل إعداد نقاط الحضور والانصراف', N'Edit Attendance Point Setup', 341, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10069, N'حذف إعداد نقاط الحضور والانصراف', N'Delete Attendance Point Setup', 341, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10070, N'حفظ إعداد نقاط الحضور والانصراف', N'Save Attendance Point Setup', 341, 2)
Go

--------------------------End 2020-03-05-----------------------------
--------------------------Sayed 2020-03-08---------------------------


CREATE TABLE [dbo].[TimePermissions](
	[MySerial] [int] NOT NULL,
	[EmployeeCode] [int] NULL,
	[Reason] [nvarchar](200) NULL,
	[PermissionsDate] [datetime] NULL,
	[TimeFrom] [nvarchar](5) NULL,
	[TimeTo] [nvarchar](5) NULL,
	[TotalMinutes] [int] NULL,
	[TotalMinutesActual] [int] NULL,
	[AddBy] [nvarchar](20) NULL,
	[AddDate] [datetime] NULL,
	[LastChangeBy] [nvarchar](20) NULL,
	[ChangeDate] [datetime] NULL,
	[MainType] [tinyint] NULL,
	[ComeLateOrOutEarly] [tinyint] NULL,
	[TimePermissionCode] [tinyint] NULL,
	[Closed] [bit] NULL,
	[EquivalentDate] [datetime] NULL,
	[Approved1] [tinyint] NULL,
	[Approved1UserFullName] [nvarchar](150) NULL,
	[Approved1Date] [datetime] NULL,
	[Approved1Comment] [nvarchar](255) NULL,
	[Approved2] [tinyint] NULL,
	[Approved2UserFullName] [nvarchar](150) NULL,
	[Approved2Date] [datetime] NULL,
	[Approved2Comment] [nvarchar](255) NULL,
	[Status] [int] NULL,
	[CurrentBalance] [float] NULL,
	[NewBalance] [float] NULL,
	[PermissionsDateHijri] [nvarchar](10) NULL,
	[PYear] [int] NULL,
	[Period] [tinyint] NULL,
	[InsteadOfTimeSignCode] [tinyint] NULL,
	[PartCode] [tinyint] NULL,
	[MDT] [datetime] NULL,
 CONSTRAINT [PK_TimePermissions] PRIMARY KEY CLUSTERED 
(
	[MySerial] 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].[TimePermissions] ADD  CONSTRAINT [DF_TimePermissions_Closed]  DEFAULT ((0)) FOR [Closed]
GO

ALTER TABLE [dbo].[TimePermissions] ADD  CONSTRAINT [DF_TimePermissions_InsteadOfTimeSignCode]  DEFAULT ((0)) FOR [InsteadOfTimeSignCode]
GO

ALTER TABLE [dbo].[TimePermissions] ADD  CONSTRAINT [DF_TimePermissions_PartCode]  DEFAULT ((0)) FOR [PartCode]
GO

	 drop table [dbo].[AC_SecurityUserEmailTemplate]
 Go
-----------------------------End 2020-03-08-----------------------------------
-----------------------------Ali 2020-03-09-----------------------------------
Create proc [dbo].[Emp_GetEmployeeLeaveTransactionWithoutYear] 
(
	@EmpCode			int 
)
AS
SELECT  [Serial]
      ,[EmployeeCode]
      ,[VacationCode]
      ,[FromDate]
      ,[ToDate]
      ,[FromDateHijri]
      ,[ToDateHijri]
      ,[Comment]
      ,[DaysCount]
      ,[AddBy]
      ,[AddDate]
      ,[LastChangeBy]
      ,[ChangeDate]
      ,[VacationRequestSerial]
      ,[MainType]
      ,[Return]
      ,[RequiredReturnNotification]
      ,[FCClosed]
      ,[VacationStatusCode],
	  (select Name from VacationType where VacationCode=LeaveTransaction.VacationCode) as VacationNameEN,
	  (select Arabic_Name from VacationType where VacationCode=LeaveTransaction.VacationCode) as VacationNameAR
  FROM [dbo].[LeaveTransaction]


   where 
 
	EmployeeCode= @EmpCode
	GO

-----------------------------End 2020-03-09-----------------------------------
-----------------------------Hammad 2020-03-09--------------------------------
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
 VALUES (245, N'Calculate Attendance Evaluation', N'إحتساب تقيم الحضور', 161, N'/Appraisal/AttendanceEvaluation', N'Index', NULL, N'get', 17, 1, 1)
 Go
 INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10071, N'إحتساب تقيم الحضور', N'Time Attendance Evaluation', 245, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10072, N'عرض إحتساب تقيم الحضور', N'View Time Attendance Evaluation', 245, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (10073, N'حفظ إحتساب تقيم الحضور ', N'Save Time Attendance Evaluation', 245, 2)
Go

INSERT [dbo].[SystemMenuModule] ( [SystemMenuCode], [AppModuleCode]) VALUES ( 245, 8)
Go

-----------------------------End 2020-03-09--------------------------------


-------------------------------Ali 2020-03-10---------------


ALTER procedure [dbo].[Emp_GetEmployeeProfile] 
(
	@userCode	int
)
AS
SELECT  
	   e.[EmployeeCode]
      ,e.[Name]
      ,e.[Arabic_Name]
      ,[Sex]
      ,[BirthDate]
      ,[BirthCityCode]
      ,[BirthDestination]
      ,[BirthDestinationArabic]
          
      ,[LokerNumber]
      ,[IDTypeCode]
      ,[IdIssueFrom]
      ,[IdIssueFromArabic]
      ,[IdNumber]
      ,[IDpolice_station]
      ,[IdCityCode]
      ,[IdIssueDate]
      ,[IdExpireDate]
     
      ,[Children_Number]
     
      ,[HiringDate]
      ,[ContractDate]
      ,[ContractExpireDate]    
     
      ,[InsuranceNumber]
      ,e.[ReligionCode]      
    
      ,[ResignationCode]
      ,[ResignationDate]     
      ,[Active]
   
      ,[CityCode]
      ,[EngFullAddress]
      ,[ArabicFullAddress]
      ,[OldFullAddress]    
      ,[Police_Station]
      ,[EngArea]
      ,[EngPolice_Station]
     
      ,[MotherName]
      ,e.[Telephone]
      ,[Mobile]
      ,e.[EMail]
      ,[CurrPercent]
      ,[Hidden]
      ,[Transfer]
      ,[VacationCalcCode]
      ,[DayRate]
      ,[WorkHoures]     
      ,[RoomNumber]     
      ,[BasicSalary]
    
      ,[StopSalaryReason]
      ,[NotApplicableToTransportationAllowance]
      ,[StopSalary]
      ,[ResignationPostingDate]
       
      ,[EmployeeType]
      ,[BirthDateHijri]
      ,[ContractDateHijri]
      ,[ContractExpireDateHijri]
      ,[HiringDateHijri]
	  ,[ProbationDate]
      ,[ProbationDateHijri]
      ,[ExperienceDateHijri]
      ,[LastWageHijri]
      ,[InsureDateHijri]
      ,[ResignationDateHijri]
      ,[ResignationPostingDateHijri]
      
	  ,dbo.Location.[Name] LocationNameEn
	  ,dbo.Location.[Arabic_Name] LocationNameAr	
	  ,dbo.SocialInsurance.[BasicEmployeeShare]
	  ,dbo.SocialInsurance.[BasicCompanyShare]
	  ,dbo.SocialInsurance.[VariableEmployeeShare]
	  ,dbo.SocialInsurance.[VariableCompanyShare]
	  ,dbo.SocialInsurance.[InsuranceDate]
	  ,dbo.SocialInsurance.[InsuranceDateHijri]
	   ,dbo.SocialInsurance.MaxBasic

	  ,dbo.Insurer.[Name] as InsurerNameEn
	  ,dbo.Insurer.[Arabic_Name] as InsurerNameAr
	  ,dbo.InsuranceTypes.[Name] as InsuranceTypesNameEn
	  ,dbo.InsuranceTypes.[Arabic_Name] as InsuranceTypesNameAr
	  ,dbo.Sections.Name SectionsNameEn
	  ,dbo.Sections.Arabic_Name SectionsNameAr
	  ,dbo.Departments.Name DepartmentsNameEn
	  ,dbo.Departments.Arabic_Name DepartmentsNameAr
	  ,dbo.Divisions.Name DivisionsNameEn
	  ,dbo.Divisions.Arabic_Name DivisionsNameAr
	  ,dbo.Nationality.[Name] NationalityNameEn
	  ,dbo.Nationality.[Arabic_Name] NationalityNameAr
	  ,dbo.Nationality.[CountryName]
	  ,dbo.Nationality.[CountryArabic_Name]
	  ,dbo.MaritalStatus.[Name] MaritalStatusNameEn
	  ,dbo.MaritalStatus.[Arabic_Name] MaritalStatusNameAr
	  ,dbo.EmployeeEducationData.[EducationDescription]
	  ,dbo.[Contract].[Name] ContractNameEn
	  ,dbo.[Contract].[Arabic_Name] ContractNameAr
	  ,dbo.[Currencies].[Name] CurrenciesNameEn
	  ,dbo.[Currencies].[Arabic_Name] CurrenciesNameAr
	  ,dbo.Levels.Name LevelsNameEn
	  ,dbo.Levels.Arabic_Name LevelsNameAr
	  ,dbo.Positions.Name PositionsNameEn
	  ,dbo.Positions.Arabic_Name PositionsNameAr
	  ,dbo.[GeneralTypes].[Name] GeneralTypesNameEn
	  ,dbo.[GeneralTypes].[Arabic_Name] GeneralTypesNameAr
	  ,UserImage
	  ,RecieveEmailNotifications
	  ,UserName



	  ,dbo.EmployeesExtend.[IssuePlace] as EmpExtendIssuePlace
	  ,dbo.EmployeesExtend.[CardNumber] as  EmpExtendCardNumber
	  ,dbo.EmployeesExtend.[IssueDate] as EmpExtendIssueDate
	  ,dbo.EmployeesExtend.[IssueDateHijri] as EmpExtendIssueDateHijri
	  ,dbo.EmployeesExtend.[ExpireDate] as EmpExtendExpireDate
	  ,dbo.EmployeesExtend.[ExpireDateHijri] as EmpExtendExpireDateHijri
	  ,dbo.EmployeesExtend.ExtensionNumber

	  ,dbo.[HealthInsuranceTypes].[Name] as MedicalInsuranceTypeNameEn
	  ,dbo.[HealthInsuranceTypes].[Arabic_Name] as MedicalInsuranceTypeNameAr
	

   
FROM [dbo].[SecurityUser]

left join [dbo].[Employees] e on [dbo].SecurityUser.[EmployeeCode] = e.EmployeeCode
left join [dbo].[Location] on [dbo].Location.[LocationCode] = e.LocationCode
left join [dbo].[SocialInsurance] on [dbo].SocialInsurance.[EmployeeCode] = e.EmployeeCode
left join [dbo].[Insurer] on [dbo].Insurer.[InsurerCode] = [dbo].SocialInsurance.[InsurerCode]
left join [dbo].[InsuranceTypes] on [dbo].InsuranceTypes.InsuranceCode = e.InsuranceCode
left join [dbo].[Sections] on [dbo].Sections.SectionCode = e.SectionCode
left join [dbo].[Departments] on [dbo].Departments.DepartmentCode = [dbo].Sections.DepartmentCode
left join [dbo].Divisions on [dbo].Divisions.DivisionCode = [dbo].Departments.DivisionCode
left join [dbo].[Nationality] on [dbo].Nationality.[NationalityCode] = e.NationalityCode
left join [dbo].[MaritalStatus] on [dbo].MaritalStatus.[MaritalCode] = e.MaritalCode
left join [dbo].[EmployeeEducationData] on [dbo].EmployeeEducationData.[EmployeeCode] = e.EmployeeCode
left join [dbo].[Contract] on [dbo].[Contract].[ContractCode] = e.ContractCode
left join [dbo].[Currencies] on [dbo].[Currencies].CurrencyCode = e.CurrencyCode
left join [dbo].[Levels] on [dbo].Levels.LevelCode = e.LevelCode
left join [dbo].[GeneralTypes] on [dbo].GeneralTypes.[GeneralTypeCode] = e.GeneralTypeCode
left join [dbo].[Positions] on [dbo].Positions.PositionCode = e.PositionCode

left join [dbo].[EmployeesExtend] on [dbo].EmployeesExtend.[EmployeeExtendCode] = e.EmployeeCode
left join [dbo].[HealthInsuranceTypes] on [dbo].HealthInsuranceTypes.HealthInsuranceTypeCode = [dbo].[EmployeesExtend].HealthInsuranceTypeCode

where [dbo].[SecurityUser].[EmployeeCode] = @userCode;

Go



CREATE PROCEDURE Emp_GetEmployeeMedicalIssue 
(
	@EmpCode	int
)
AS
SELECT 

       [MedicalIssuePlace] 
	  ,[MedicalCardNumber] 
	  ,[MedicalIssueDate] 
	  ,[MedicalIssueDateHijri] 
	  ,[MedicalExpireDate] 
	  ,[MedicalExpireDateHijri] 
	  ,dbo.[RelativeTypes].[Name] as RelativeTypeNameEn
	  ,dbo.[RelativeTypes].[Arabic_Name] as RelativeTypeNameAr
	  ,dbo.[Relatives].[Name] as RelativesNameEn
	  ,dbo.[Relatives].[Arabic_Name] as RelativesNameAr

	  FROM [dbo].[Relatives]
	  
left join [dbo].[RelativeTypes] on [dbo].RelativeTypes.RelativeTypeCode = [dbo].[Relatives].RelativeTypeCode

where [dbo].Relatives.[EmployeeCode] = @EmpCode

Go






-------------------------------Ali 2020-03-10---------------

