﻿-----------------------Hammad 2021-03-31------------------------------------
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) 
VALUES (475, N'ReOpen Attendance', N'إعادة فتح الحضور و الإنصراف', 345, N'Attendance/ReOpenAttendance', N'Index', N'fa fa-thumb-tack', N'get', 6, 1, 1)
Go

INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13071, N' إعادة فتح الحضور و الإنصراف', N'ReOpen Attendance', 475, 1)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13072, N' عرض إعادة فتح الحضور و الإنصراف ', N' View ReOpen Attendance ', 475, 2)
INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (13073, N' حفظ  إعادة فتح الحضور و الإنصراف', N' Save ReOpen Attendance ', 475, 2)
Go

INSERT [dbo].[SystemMenuModule] ([SystemMenuCode], [AppModuleCode]) VALUES (475, 11)
GO

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (621, N'Attendance', N'ReOpenAttendance', N'Index', 0, N'get', 13071)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (622, N'Attendance', N'ReOpenAttendance', N'ReOpenAttendance_Read', 0, N'post', 13072)
INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES (623, N'Attendance', N'ReOpenAttendance', N'Save', 0, N'post', 13073)
Go

ALTER TABLE dbo.CloseAttendanceDetail ADD
	CreationDate datetime NULL
GO
update SystemMenu set  ControllerName='/Attendance/ReOpenAttendance'  where SystemMenuCode=475
Go
 -----------------------End 2021-03-31------------------------------------
 -----------------------Ali 2021-04-01------------------------------------
   ALTER TABLE [SystemMenu]
  ALTER COLUMN [Name] nvarchar(100);
  Go

  ALTER TABLE [SystemMenu]
  ALTER COLUMN [Arabic_Name] nvarchar(100);
  Go
 -----------------------End 2021-04-01------------------------------------
 -----------------------Hammad 2021-04-01---------------------------------
CREATE TABLE [dbo].[UserModifyAttendance](
	[UserModifyAttendanceCode] [int] IDENTITY(1,1) NOT NULL,
	[SecurityUserCode] [int] NOT NULL,
	[PeriodAllowedModifiedBeforeTodayDate] [int] NOT NULL,
	[PeriodAllowedModifiedAfterTodayDate] [int] NOT NULL,
	[CreatedBy] [int] NOT NULL,
	[CreationDate] [datetime] NOT NULL,
	[ModifiedBy] [int] NULL,
	[ModificationDate] [datetime] NULL,
 CONSTRAINT [PK_UserModifyAttendance] PRIMARY KEY CLUSTERED 
(
	[UserModifyAttendanceCode] 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


 -----------------------End 2021-04-01---------------------------------
 -----------------------Hammad 2021-04-04------------------------------
 

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(478,N'Privilege Modify Attendance',N'صلاحيات تعديل الحضور والإنصراف',345,N'/Attendance/PrivilegeModifyAttendance',N'Index','fa fa-thumb-tack',N'get',7,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(478,11)
Go

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(13074,N'صلاحيات تعديل الحضور والإنصراف',N'Privilege Modify Attendance',478,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(13075,N'عرض صلاحيات تعديل الحضور والإنصراف',N'View Privilege Modify Attendance',478,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(13076,N'حفظ صلاحيات تعديل الحضور والإنصراف',N'Save Privilege Modify Attendance',478,2)
Go


INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(636,N'Attendance',N'PrivilegeModifyAttendance',N'Index',0,N'get',13074)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(637,N'Attendance',N'PrivilegeModifyAttendance',N'PrivilegeModifyAttendance_Read',0,N'post',13075)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(641,N'Attendance',N'PrivilegeModifyAttendance',N'Save',0,N'post',13076)
Go

 -----------------------End 2021-04-04------------------------------
 -----------------------Ali 2021-04-06------------------------------

   update [SecurityPrivilege] set [DescriptionAR]=N'إضافة أنواع السلف ',[DescriptionEN]=N'Add Loan Type'
  where [ID]= 3307
  Go

   update [SecurityPrivilege] set [DescriptionAR]=N'تعديل أنواع السلف ',[DescriptionEN]=N'Edit Loan Type'
  where [ID]= 3308
  Go

   INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) 
  VALUES(3309,N'حذف انواع السلف',N'Delete Loan Type',154,2)
  Go
   INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) 
  VALUES(3310,N'حفظ أنواع السلف',N'Save Loan Type',154,2)
  Go

 -----------------------End 2021-04-06------------------------------