﻿---------------------Ali 2021-08-18------------

ALTER TABLE dbo.UserType ADD
	IsVisible bit NOT NULL CONSTRAINT DF_UserType_IsVisible DEFAULT ((1))
GO
---------------------End 2021-08-18------------
---------------------Mostafa 2021-08-18------------
update SystemMenu set ControllerName='/Meeting/Topic' where SystemMenuCode=533
Go
update SystemMenu set ControllerName='/Meeting/Type' where SystemMenuCode=534
Go
update SystemMenu set ControllerName='/Meeting/Place' where SystemMenuCode=535
Go
update SystemMenu set ControllerName='/Meeting/Member' where SystemMenuCode=536
Go
update SystemMenu set ControllerName='/Meeting/Branch' where SystemMenuCode=558
Go
update SecurityPrivilegeActions set ControllerName='Topic' where ControllerName='MeetingTopic'
Go
update SecurityPrivilegeActions set ControllerName='Type' where ControllerName='MeetingType'
Go
update SecurityPrivilegeActions set ControllerName='Place' where ControllerName='MeetingPlace'
Go
update SecurityPrivilegeActions set ControllerName='Member' where ControllerName='MeetingMember'
Go
update SecurityPrivilegeActions set ControllerName='Branch' where ControllerName='MeetingBranch'
Go
update SecurityPrivilegeActions set ActionName='Topic_Read' where ActionName='MeetingTopic_Read'
Go
update SecurityPrivilegeActions set ActionName='Type_Read' where ActionName='MeetingType_Read'
Go
update SecurityPrivilegeActions set ActionName='Place_Read' where ActionName='MeetingPlace_Read'
Go
update SecurityPrivilegeActions set ActionName='Member_Read' where ActionName='MeetingMember_Read'
Go
update SecurityPrivilegeActions set ActionName='Branch_Read' where ActionName='MeetingBranch_Read'
Go
---------------------End 2021-08-18------------



---------------------Mostafa 2021-08-19------------


INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(559,N'Meeting',N'الاجتماع',532,N'/Meeting/Meeting',N'Index','fa fa-thumb-tack',N'get',7,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(559,15)
Go

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(17042,N'الاجتماع',N'Meeting',559,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(17043,N'عرض الاجتماع',N'View Meeting',559,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(17044,N'إضافة الاجتماع',N'Add Meeting',559,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(17045,N'تعديل الاجتماع',N'Edit Meeting',559,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(17046,N'حذف الاجتماع',N'Delete Meeting',559,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(17047,N'حفظ الاجتماع',N'Save Meeting',559,2)
Go



INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(848,N'Meeting',N'Meeting',N'Index',0,N'get',17042)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(849,N'Meeting',N'Meeting',N'Meeting_Read',0,N'post',17043)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(850,N'Meeting',N'Meeting',N'Save',1,N'get',17044)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(851,N'Meeting',N'Meeting',N'Save',2,N'get',17045)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(852,N'Meeting',N'Meeting',N'Delete',0,N'post',17046)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(853,N'Meeting',N'Meeting',N'Save',0,N'post',17047)

Go
---------------------End 2021-08-19------------

---------------------Hammad 2021-08-21---------
delete ConfigParameter where ConfigKey='WFLoanRequestDisplaySalary'
GO
---------------------End 2021-08-21---------

---------------------Ali 2021-08-22---------

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(504,N'Employee Documents',N'وثائق الموظف',489,N'/Archive/ArcEmpDocument',N'Index','fa fa-thumb-tack',N'get',2,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(504,14)
Go

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(505,N'Import Employees  files',N'استيراد ملفات الموظفين',489,N'/Archive/ArcEmpDocument',N'SaveImportEmployeefile','fa fa-thumb-tack',N'get',3,0,0)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(505,14)
Go


INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(9024,N'وثائق الموظف',N'Employee Documents',504,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(9025,N'عرض وثائق الموظف',N'View Employee Documents',504,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(9026,N'إضافة وثائق الموظف',N'Add Employee Documents',504,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(9027,N'تعديل وثائق الموظف',N'Edit Employee Documents',504,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(9028,N'حذف وثائق الموظف',N'Delete Employee Documents',504,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(9029,N'حفظ وثائق الموظف',N'Save Employee Documents',504,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(9030,N'استيراد ملفات الموظفين',N'Import Employees files',505,2)
Go



INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(668,N'Archive',N'ArcEmpDocument',N'Index',0,N'get',9024)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(669,N'Archive',N'ArcEmpDocument',N'EmployeeDocument_Read',0,N'post',9025)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(670,N'Archive',N'ArcEmpDocument',N'Save',1,N'get',9026)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(671,N'Archive',N'ArcEmpDocument',N'Save',2,N'get',9027)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(672,N'Archive',N'ArcEmpDocument',N'Delete',0,N'post',9028)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(673,N'Archive',N'ArcEmpDocument',N'Save',0,N'post',9029)
Go


  INSERT [dbo].[SecurityPrivilege] ([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES (1270, N'عرض وثائق الموظف', N'View Employee Decuments', 3, 2)
Go



INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES (549, N'Work Settings', N'إعدادات العمل', 27, N'/Personal/SystemPersonalConfig', N'Index', N'fa fa-thumb-tack', N'get', 4, 1, 1)
GO

INSERT [dbo].[SystemMenuModule] ([SystemMenuCode], [AppModuleCode]) VALUES (549, 2)
GO

INSERT INTO SecurityPrivilege (ID, DescriptionAR, DescriptionEN, SystemMenuCode,PrivilegeType)
VALUES (1294,N'إعدادات العمل',N'Work settings Config', 549,1);
Go 
INSERT INTO SecurityPrivilege (ID, DescriptionAR, DescriptionEN, SystemMenuCode,PrivilegeType)
VALUES (1295,N'عرض إعدادات العمل',N'View Work settings Config', 549,2);
Go 
INSERT INTO SecurityPrivilege (ID, DescriptionAR, DescriptionEN, SystemMenuCode,PrivilegeType)
VALUES (1296,N'حفظ إعدادات العمل',N'Save Work settings Config', 549,2);
Go
INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage]) VALUES (549, N'Work Settings', N'إعدادات العمل', 27, N'/Personal/SystemSecurityConfig', N'Index', N'fa fa-thumb-tack', N'get', 4, 1, 1)
GO

---------------------End 2021-08-22---------
---------------------Hammad 2021-08-22------
SET IDENTITY_INSERT [dbo].[AppModule] ON 
INSERT [dbo].[AppModule] ([AppModuleCode], [Name], [Arabic_Name], [IsLicensed], [LicenseNumber]) VALUES (16, N'Workflow Academic', N'سير العمل الأكاديمي', 1, NULL)
SET IDENTITY_INSERT [dbo].[AppModule] OFF
 update SystemMenuModule set AppModuleCode=16 
  where SystemMenuCode in (421,422,445,447) 
  or SystemMenuCode in (select SystemMenuCode from SystemMenu as sysm where sysm.ParentID in (421,422,445,447))
  GO
 INSERT INTO [SST.ERP_Client]. [dbo].[AppModule] ([AppModuleCode], [Name], [Arabic_Name]) VALUES (16, N'Workflow Academic', N'سير العمل الأكاديمي')
   Go
---------------------End 2021-08-22------
---------------------MOstafa 2021-08-23------

INSERT [dbo].[SystemMenu] ([SystemMenuCode], [Name], [Arabic_Name], [ParentID], [ControllerName], [ActionName], [ImageURL], [HTTPMethod], [Sequence], [IsVisible], [ShowInPrivilegePage])
VALUES(560,N'Member Type',N'نوع الاعضاء',532,N'/Meeting/MemberType',N'Index','fa fa-thumb-tack',N'get',8,1,1)
Go

INSERT[dbo].[SystemMenuModule]( [SystemMenuCode], [AppModuleCode]) VALUES(560,15)
Go

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(17048,N'نوع الاعضاء',N'Member Type',560,1)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(17049,N'عرض نوع الاعضاء',N'View Member Type',560,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(17050,N'إضافة نوع الاعضاء',N'Add Member Type',560,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(17051,N'تعديل نوع الاعضاء',N'Edit Member Type',560,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(17052,N'حذف نوع الاعضاء',N'Delete Member Type',560,2)

INSERT[dbo].[SecurityPrivilege]([ID], [DescriptionAR], [DescriptionEN], [SystemMenuCode], [PrivilegeType]) VALUES(17053,N'حفظ نوع الاعضاء',N'Save Member Type',560,2)
Go



INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(854,N'Meeting',N'MemberType',N'Index',0,N'get',17048)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(855,N'Meeting',N'MemberType',N'MemberType_Read',0,N'post',17049)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(856,N'Meeting',N'MemberType',N'Save',1,N'get',17050)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(857,N'Meeting',N'MemberType',N'Save',2,N'get',17051)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(858,N'Meeting',N'MemberType',N'Delete',0,N'post',17052)

INSERT [dbo].[SecurityPrivilegeActions] ([ID], [AreaName], [ControllerName], [ActionName], [ActionType], [HTTPMethod], [SecurityPrivilegeID]) VALUES(859,N'Meeting',N'MemberType',N'Save',0,N'post',17053)
---------------------End 2021-08-22------