INSERT [dbo].[Pages] ([Id], [Name], [Url], [CreatedDate], [CreatedBy], [ModifiedDate], [ModifiedBy], [DeletedDate], [DeletedBy], [IsDeleted]) VALUES (N'e13e353b-f871-43a4-018b-08dcf4e029b6', N'Reminder', N'/reminder', CAST(N'2024-10-25T16:01:18.9641955' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', CAST(N'2024-10-25T16:01:28.9418746' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', NULL, NULL, 0)
INSERT [dbo].[Pages] ([Id], [Name], [Url], [CreatedDate], [CreatedBy], [ModifiedDate], [ModifiedBy], [DeletedDate], [DeletedBy], [IsDeleted]) VALUES (N'0eb89f77-e08b-461b-018c-08dcf4e029b6', N'Page_Helper', N'/page_Helper', CAST(N'2024-10-25T16:01:40.2756849' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', CAST(N'2024-10-25T16:01:40.2756885' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', NULL, NULL, 0)
INSERT [dbo].[Pages] ([Id], [Name], [Url], [CreatedDate], [CreatedBy], [ModifiedDate], [ModifiedBy], [DeletedDate], [DeletedBy], [IsDeleted]) VALUES (N'f696987f-611d-423c-018d-08dcf4e029b6', N'Company_Profile', N'/company_Profile', CAST(N'2024-10-25T16:01:53.2447149' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', CAST(N'2024-10-25T16:01:53.2447195' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', NULL, NULL, 0)

INSERT [dbo].[PageActions] ([Id], [ActionId], [PageId], [CreatedDate], [CreatedBy], [ModifiedDate], [ModifiedBy], [DeletedDate], [DeletedBy], [IsDeleted]) VALUES (N'eb93667d-5d91-4ada-93c9-714291181cbd', N'6db3646c-77aa-430c-b259-c8643476935e', N'e13e353b-f871-43a4-018b-08dcf4e029b6', CAST(N'2024-10-25T16:02:01.8030154' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', CAST(N'2024-10-25T16:02:01.8030188' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', NULL, NULL, 0);
INSERT [dbo].[PageActions] ([Id], [ActionId], [PageId], [CreatedDate], [CreatedBy], [ModifiedDate], [ModifiedBy], [DeletedDate], [DeletedBy], [IsDeleted]) VALUES (N'f0086edd-9be6-4dc3-bc62-d74f25e75385', N'80120352-300f-4115-a203-d1758ac65241', N'e13e353b-f871-43a4-018b-08dcf4e029b6', CAST(N'2024-10-25T16:02:02.2963259' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', CAST(N'2024-10-25T16:02:02.2963291' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', NULL, NULL, 0);
INSERT [dbo].[PageActions] ([Id], [ActionId], [PageId], [CreatedDate], [CreatedBy], [ModifiedDate], [ModifiedBy], [DeletedDate], [DeletedBy], [IsDeleted]) VALUES (N'ed3e63a5-378c-4557-97b0-dbd17eda4caf', N'e887e9fe-cba3-4ed1-995b-506909327182', N'e13e353b-f871-43a4-018b-08dcf4e029b6', CAST(N'2024-10-25T16:02:01.1722845' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', CAST(N'2024-10-25T16:02:01.1722877' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', NULL, NULL, 0);
INSERT [dbo].[PageActions] ([Id], [ActionId], [PageId], [CreatedDate], [CreatedBy], [ModifiedDate], [ModifiedBy], [DeletedDate], [DeletedBy], [IsDeleted]) VALUES (N'c597674c-330b-4688-b98a-f0af0d6c198b', N'31b90345-4a48-4d7e-b11e-1d513493243b', N'e13e353b-f871-43a4-018b-08dcf4e029b6', CAST(N'2024-10-25T16:02:00.5946069' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', CAST(N'2024-10-25T16:02:00.5946104' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', NULL, NULL, 0);
INSERT [dbo].[PageActions] ([Id], [ActionId], [PageId], [CreatedDate], [CreatedBy], [ModifiedDate], [ModifiedBy], [DeletedDate], [DeletedBy], [IsDeleted]) VALUES (N'64e8d10a-b70d-42e2-8491-18a6d07d2e0c', N'80120352-300f-4115-a203-d1758ac65241', N'0eb89f77-e08b-461b-018c-08dcf4e029b6', CAST(N'2024-10-25T16:02:20.9875525' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', CAST(N'2024-10-25T16:02:20.9875545' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', NULL, NULL, 0)
INSERT [dbo].[PageActions] ([Id], [ActionId], [PageId], [CreatedDate], [CreatedBy], [ModifiedDate], [ModifiedBy], [DeletedDate], [DeletedBy], [IsDeleted]) VALUES (N'6a4c7709-391b-42e1-905c-28c3d85a4a6e', N'31b90345-4a48-4d7e-b11e-1d513493243b', N'0eb89f77-e08b-461b-018c-08dcf4e029b6', CAST(N'2024-10-25T16:02:17.9458736' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', CAST(N'2024-10-25T16:02:17.9458795' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', NULL, NULL, 0)
INSERT [dbo].[PageActions] ([Id], [ActionId], [PageId], [CreatedDate], [CreatedBy], [ModifiedDate], [ModifiedBy], [DeletedDate], [DeletedBy], [IsDeleted]) VALUES (N'0713129e-5365-4ab7-8645-11374c327271', N'31b90345-4a48-4d7e-b11e-1d513493243b', N'f696987f-611d-423c-018d-08dcf4e029b6', CAST(N'2024-10-25T16:02:11.9230069' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', CAST(N'2024-10-25T16:02:11.9230116' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', NULL, NULL, 0)

INSERT [dbo].[RoleClaims] ([ActionId], [PageId], [RoleId], [ClaimType], [ClaimValue]) VALUES (N'31b90345-4a48-4d7e-b11e-1d513493243b', N'e13e353b-f871-43a4-018b-08dcf4e029b6', N'49e35563-4e7e-4607-9543-6208abd3b89d', N'Reminder_Edit', N'')
INSERT [dbo].[RoleClaims] ([ActionId], [PageId], [RoleId], [ClaimType], [ClaimValue]) VALUES (N'e887e9fe-cba3-4ed1-995b-506909327182', N'e13e353b-f871-43a4-018b-08dcf4e029b6', N'49e35563-4e7e-4607-9543-6208abd3b89d', N'Reminder_Add', N'')
INSERT [dbo].[RoleClaims] ([ActionId], [PageId], [RoleId], [ClaimType], [ClaimValue]) VALUES (N'6db3646c-77aa-430c-b259-c8643476935e', N'e13e353b-f871-43a4-018b-08dcf4e029b6', N'49e35563-4e7e-4607-9543-6208abd3b89d', N'Reminder_Delete', N'')
INSERT [dbo].[RoleClaims] ([ActionId], [PageId], [RoleId], [ClaimType], [ClaimValue]) VALUES (N'80120352-300f-4115-a203-d1758ac65241', N'e13e353b-f871-43a4-018b-08dcf4e029b6', N'49e35563-4e7e-4607-9543-6208abd3b89d', N'Reminder_List', N'')
INSERT [dbo].[RoleClaims] ([ActionId], [PageId], [RoleId], [ClaimType], [ClaimValue]) VALUES (N'31b90345-4a48-4d7e-b11e-1d513493243b', N'0eb89f77-e08b-461b-018c-08dcf4e029b6', N'49e35563-4e7e-4607-9543-6208abd3b89d', N'Page_Helper_Edit', N'')
INSERT [dbo].[RoleClaims] ([ActionId], [PageId], [RoleId], [ClaimType], [ClaimValue]) VALUES (N'80120352-300f-4115-a203-d1758ac65241', N'0eb89f77-e08b-461b-018c-08dcf4e029b6', N'49e35563-4e7e-4607-9543-6208abd3b89d', N'Page_Helper_List', N'')
INSERT [dbo].[RoleClaims] ([ActionId], [PageId], [RoleId], [ClaimType], [ClaimValue]) VALUES (N'31b90345-4a48-4d7e-b11e-1d513493243b', N'f696987f-611d-423c-018d-08dcf4e029b6', N'49e35563-4e7e-4607-9543-6208abd3b89d', N'Company_Profile_Edit', N'')


INSERT [dbo].[CompanyProfiles] ([Id], [Name], [LogoUrl], [BannerUrl], [CreatedDate], [CreatedBy], [ModifiedDate], [ModifiedBy], [DeletedDate], [DeletedBy], [IsDeleted]) VALUES (N'5bf73f1d-4679-4901-b833-7963b2799f33', N'User Management', N'logo.png', N'banner.jpg', CAST(N'2024-10-01T12:39:07.6685564' AS DateTime2), N'00000000-0000-0000-0000-000000000000', CAST(N'2024-10-28T12:38:52.6991349' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', NULL, NULL, 0)

INSERT [dbo].[PageHelpers] ([Id], [Code], [Name], [Description], [CreatedDate], [CreatedBy], [ModifiedDate], [ModifiedBy], [DeletedDate], [DeletedBy], [IsDeleted]) VALUES (N'eccba93d-48bb-48f6-9784-14968d8843c8', N'MANAGE_USER', N'Manage User', N'<p>The User Information page is designed to collect and manage your personal details. This page is essential for setting up your user profile and ensuring you have a seamless experience using our application. Below is a brief overview of the fields you will encounter:</p><h4><strong>Fields on the User Information Page</strong></h4><ol><li><strong>First Name</strong>:<ul><li><strong>What it is</strong>: Your given name.</li><li><strong>Importance</strong>: Helps us address you properly within the application.</li></ul></li><li><strong>Last Name</strong>:<ul><li><strong>What it is</strong>: Your family name or surname.</li><li><strong>Importance</strong>: Completes your identity and is often required for official documents.</li></ul></li><li><strong>Mobile Number</strong>:<ul><li><strong>What it is</strong>: Your phone number.</li><li><strong>Importance</strong>: Used for account recovery, notifications, and two-factor authentication. It’s optional but recommended for security purposes.</li></ul></li><li><strong>Email Address</strong>:<ul><li><strong>What it is</strong>: Your electronic mail address.</li><li><strong>Importance</strong>: Serves as your primary communication channel with us. It’s required for account verification, notifications, and password recovery.</li></ul></li><li><strong>Password</strong>:<ul><li><strong>What it is</strong>: A secret word or phrase you create to secure your account.</li><li><strong>Importance</strong>: Protects your account from unauthorized access. It must be at least 6 characters long.</li></ul></li><li><strong>Confirm Password</strong>:<ul><li><strong>What it is</strong>: A second entry of your chosen password.</li><li><strong>Importance</strong>: Ensures you’ve entered your password correctly.</li></ul></li><li><strong>Role</strong>:<ul><li><strong>What it is</strong>: Your assigned position or function within the application (e.g., Admin, User, Editor).</li><li><strong>Importance</strong>: Determines your access level and permissions within the application. This field is required to define your responsibilities and capabilities.</li></ul></li></ol><h4><strong>How to Use the Page</strong></h4><ul><li><strong>Filling Out the Form</strong>:<ul><li>Enter your information in the required fields.</li><li>Ensure that your password and confirm password entries match to avoid any errors.</li></ul></li><li><strong>Submitting Your Information</strong>:<ul><li>Once you have filled in all required fields, click the "Submit" button.</li><li>If any required fields are left blank or contain errors, you will see helpful messages prompting you to correct them.</li></ul></li><li><strong>Visual Feedback</strong>:<ul><li>Fields that require your attention will be highlighted, and error messages will guide you in making the necessary corrections.</li></ul></li></ul>', CAST(N'2023-06-03T05:22:22.0000000' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', CAST(N'0001-01-01T00:00:00.0000000' AS DateTime2), N'00000000-0000-0000-0000-000000000000', NULL, NULL, 0)
INSERT [dbo].[PageHelpers] ([Id], [Code], [Name], [Description], [CreatedDate], [CreatedBy], [ModifiedDate], [ModifiedBy], [DeletedDate], [DeletedBy], [IsDeleted]) VALUES (N'a1c28412-9590-4cdb-b7a0-1687e890ad5d', N'ADD_REMINDER', N'Manage reminder', N'<p><strong>The "Add Reminder" functionality in the "Manage Reminders" section allows users to create reminders or notifications related to specific events or tasks. These reminders can be customized according to the user''s needs and can be sent to specific other users.</strong></p><p><strong>Components and Features:</strong></p><ul><li><strong>Subject:</strong> This field allows the user to enter a title or theme for the reminder. This will be the main subject of the notification.</li><li><strong>Message:</strong> Here, users can add additional details or information related to the reminder. This can be a descriptive message or specific instructions.</li><li><strong>Repeat Reminder:</strong> This option allows setting the frequency with which the reminder will be repeated, such as daily, weekly, or monthly.</li><li><strong>Send Email:</strong> If this option is enabled, the reminder will also be sent as an email to the selected users.</li><li><strong>Select Users:</strong> This field allows the selection of users to whom the reminder will be sent. Users can be selected individually or in groups.</li><li><strong>Reminder Date:</strong> This is the time at which the reminder will be activated and sent to the selected users.</li></ul><p><strong>How to Add a New Reminder:</strong></p><ul><li>Go to the "Manage Reminders" section.</li><li>Click the "Add Reminder" button.</li><li>Fill in all required fields with the desired information.</li><li>After entering all the details, click "Save" or "Confirm" to add the reminder to the system.</li></ul>', CAST(N'2023-06-03T05:09:44.0000000' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', CAST(N'2024-11-13T13:58:54.3502934' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', NULL, NULL, 0)
INSERT [dbo].[PageHelpers] ([Id], [Code], [Name], [Description], [CreatedDate], [CreatedBy], [ModifiedDate], [ModifiedBy], [DeletedDate], [DeletedBy], [IsDeleted]) VALUES (N'2b728c10-c0b3-451e-8d08-2be1e3f6d5b3', N'USERS', N'Users', N'<p><strong>The "Users" page is the central hub for managing all registered users in CMR DMS. Here, administrators can add, edit, or delete users, as well as manage permissions and reset passwords. Each user has associated details such as first name, last name, mobile phone number, and email address.</strong></p><p><strong>Main Components:</strong></p><ul><li><p><strong>"Add User" Button:</strong> Allows administrators to create a new user in the system.</p><p>Opens a form where details such as first name, last name, mobile phone number, email address, password, and password confirmation can be entered.</p></li><li><p><strong>List of Existing Users:</strong> Displays all registered users in the system in a tabular format.</p><p>Each entry includes the user’s email address, first name, last name, and mobile phone number.</p><p>Next to each user, there is an action menu represented by three vertical dots.</p></li><li><p><strong>Action Menu for Each User:</strong> This menu opens by clicking on the three vertical dots next to each user.</p><p>Includes the options:</p><ul><li><strong>Edit:</strong> Allows modification of the user’s details.</li><li><strong>Delete:</strong> Removes the user from the system. This action may require confirmation to prevent accidental deletions.</li><li><strong>Permissions:</strong> Opens a window or form where administrators can set or modify the user’s permissions.</li><li><strong>Reset Password:</strong> Allows administrators to initiate a password reset process for the selected user.</li></ul></li></ul><p><strong>How to Add a New User:</strong></p><ol><li>Click on the "Add User" button.</li><li>A form will open where you can enter the user’s details: first name, last name, mobile phone number, email address, password, and password confirmation.</li><li>After completing the details, click "Save" or "Add" to add the user to the system.</li></ol>', CAST(N'2023-06-03T05:21:00.0000000' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', CAST(N'2024-10-04T14:17:56.5874730' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', NULL, NULL, 0)
INSERT [dbo].[PageHelpers] ([Id], [Code], [Name], [Description], [CreatedDate], [CreatedBy], [ModifiedDate], [ModifiedBy], [DeletedDate], [DeletedBy], [IsDeleted]) VALUES (N'f5cecacd-f0e6-45b3-8de2-348d8ec29556', N'LOGIN_AUDIT_LOGS', N'Audit logs', N'<p><strong>The "Login Audit Logs" page serves as a centralized record for all authentication activities within CMR DMS. Here, administrators can monitor and review all login attempts, successful or failed, made by users. This provides a clear perspective on system security and user activities.</strong></p><p><strong>Main Components:</strong></p><ul><li><p><strong>Authentication Logs Table:</strong> Displays all login entries in a tabular format.</p><p>Each entry includes details such as the username, login date and time, the IP address from which the login was made, and the result (success/failure).</p></li></ul><p><strong>How to View Log Entries:</strong></p><ol><li>Navigate to the "Login Audit Logs" page.</li><li>Browse through the table to view all login entries.</li><li>Use the search or filter function, if available, to find specific entries.</li></ol>', CAST(N'2023-06-03T05:25:13.0000000' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', CAST(N'2024-10-04T14:20:41.4415623' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', NULL, NULL, 0)
INSERT [dbo].[PageHelpers] ([Id], [Code], [Name], [Description], [CreatedDate], [CreatedBy], [ModifiedDate], [ModifiedBy], [DeletedDate], [DeletedBy], [IsDeleted]) VALUES (N'ab28cf5c-0d89-4a52-a87b-359106897cba', N'MANAGE_EMAIL_SMTP_SETTING', N'Manage Email SMTP Setting', N'<p>The <strong>"Email SMTP Settings"</strong> page within CMR DMS allows administrators to configure and manage the SMTP settings for sending emails. This ensures that emails sent from the system are correctly and efficiently delivered to recipients.</p><p><strong>Key Components:</strong></p><ul><li><p><strong>SMTP Settings Table:</strong> Displays all configured SMTP settings in a tabular format.</p><p>Each entry in the table includes details such as the username, host, port, and whether that configuration is set as the default.</p></li><li><p><strong>"Add Settings" Button:</strong> Allows administrators to add a new SMTP configuration.</p><p>Clicking the button opens a form where details like username, host, port, and the option to set it as the default configuration can be entered.</p></li></ul><p><strong>"Add Settings" Form:</strong></p><p>This form opens when administrators click the "Add Settings" button and includes the following fields:</p><ul><li><strong>Username:</strong> The username required for authentication on the SMTP server.</li><li><strong>Host:</strong> The SMTP server address.</li><li><strong>Port:</strong> The port on which the SMTP server listens.</li><li><strong>Is Default:</strong> A checkbox that allows setting this configuration as the default for sending emails.</li></ul><p><strong>How to Add a New SMTP Configuration:</strong></p><ol><li>Click the "Add Settings" button.</li><li>The "Add Settings" form will open, where you can enter the SMTP configuration details.</li><li>Fill in the necessary fields and select the desired options.</li><li>After completing the details, click "Save" or "Add" to add the configuration to the system.</li></ol>', CAST(N'2023-06-03T05:27:13.0000000' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', CAST(N'0001-01-01T00:00:00.0000000' AS DateTime2), N'00000000-0000-0000-0000-000000000000', NULL, NULL, 0)
INSERT [dbo].[PageHelpers] ([Id], [Code], [Name], [Description], [CreatedDate], [CreatedBy], [ModifiedDate], [ModifiedBy], [DeletedDate], [DeletedBy], [IsDeleted]) VALUES (N'66bad8b3-560b-4ad6-939a-3977602eafac', N'ACTIONS', N'Actions', N'<p><strong>Actions</strong> refer to a collection of operations or tasks that can be performed on specific pages within an application or system. These actions are typically contextual and aligned with the functionality of the respective page, providing users with tools to interact with, modify, or navigate through the system effectively.</p><p>For example, on a <strong>user management page</strong>, actions may include "Add User," "Edit User," "Delete User," or "View Details." On a <strong>document management page</strong>, actions could encompass "Upload Document," "Download," "Share," or "Delete." Each action is designed to enhance user interaction and streamline workflows, ensuring that the necessary tasks can be completed efficiently on the respective pages.</p>', CAST(N'2023-06-03T05:22:44.0000000' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', CAST(N'2024-11-17T10:40:57.9790347' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', NULL, NULL, 0)
INSERT [dbo].[PageHelpers] ([Id], [Code], [Name], [Description], [CreatedDate], [CreatedBy], [ModifiedDate], [ModifiedBy], [DeletedDate], [DeletedBy], [IsDeleted]) VALUES (N'5d858491-f9db-4aef-959f-5af9d7f3b7bd', N'MANAGE_ROLE', N'Manage Role', N'<ul><li>Allows administrators or users with appropriate permissions to create a new role in the system.</li><li>Opens a form or a pop-up window where permissions and role details can be defined.</li><li>Enter the role name and select the appropriate permissions from the available list.</li><li>Click <strong>"Save"</strong> or <strong>"Add"</strong> to add the role to the system with the specified permissions.</li></ul>', CAST(N'2023-06-03T05:20:37.0000000' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', CAST(N'2024-11-17T10:35:16.8485990' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', NULL, NULL, 0)
INSERT [dbo].[PageHelpers] ([Id], [Code], [Name], [Description], [CreatedDate], [CreatedBy], [ModifiedDate], [ModifiedBy], [DeletedDate], [DeletedBy], [IsDeleted]) VALUES (N'664c77b5-5da9-4241-ac39-6587f27b90a0', N'APP_SETTINGS', N'App Settings', N'<p><strong>App Settings </strong>refer to configurable options within an application that allow users or administrators to customize its behavior, appearance, and functionality to suit their preferences or requirements. These settings can range from basic personalization features to advanced configurations that impact how the application operates.</p><p><strong>Common Categories of App Settings: &nbsp;</strong><br>1. <strong>General Settings</strong>: Options for basic preferences like language, time zone, and theme (e.g., dark or light mode). &nbsp;<br>2. <strong>Notifications: </strong>Controls for enabling, disabling, or customizing alerts such as email, push, or in-app notifications. &nbsp;<br>3. <strong>Account Settings: </strong>User-related configurations like profile updates, password management, and security features such as two-factor authentication. &nbsp;<br>4. <strong>Privacy and Security: </strong>Settings that govern data sharing, permissions, and visibility, helping users manage their privacy. &nbsp;<br>5. <strong>Integration and Connectivity: </strong>Options to link external tools or services like APIs, social accounts, or cloud storage. &nbsp;<br>6. <strong>Advanced Options:</strong> Developer or admin-specific settings, such as API keys, debugging tools, or system performance tuning. &nbsp;</p><p>App Settings enhance user experience by providing flexibility and control, making the application adaptable to diverse needs and workflows.</p>', CAST(N'2023-06-03T05:22:44.0000000' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', CAST(N'2024-11-17T10:40:03.7223437' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', NULL, NULL, 0)
INSERT [dbo].[PageHelpers] ([Id], [Code], [Name], [Description], [CreatedDate], [CreatedBy], [ModifiedDate], [ModifiedBy], [DeletedDate], [DeletedBy], [IsDeleted]) VALUES (N'fac3d38a-5267-4b09-aea2-6682256ba777', N'ERROR_LOGS', N'Error Logs', N'<h4>Overview</h4><p>The <strong>ERROR_LOGS</strong> feature allows users to view the application logs generated by the backend REST API. This functionality is essential for monitoring application performance, diagnosing issues, and troubleshooting errors that may arise during API interactions.</p><h4>Features</h4><ol><li><strong>Accessing Error Logs</strong><ul><li><strong>Navigation:</strong><ul><li>Users can access the <strong>ERROR_LOGS</strong> section through the application’s administration panel or settings menu.</li></ul></li><li><strong>User Permissions:</strong><ul><li>Access to error logs may be restricted to users with specific roles, such as administrators or support staff, to maintain security and data integrity.</li></ul></li></ul></li><li><strong>Viewing Logs</strong><ul><li><strong>Log List:</strong><ul><li>The error logs are displayed in a list format, showing relevant details for each entry, including:<ul><li><strong>Timestamp:</strong> The date and time when the error occurred.</li><li><strong>Error Code:</strong> A unique code associated with the error.</li><li><strong>Error Message:</strong> A brief description of the error.</li><li><strong>Endpoint:</strong> The API endpoint that triggered the error.</li><li><strong>Request Data:</strong> The payload or parameters sent with the request (if applicable).</li><li><strong>Response Data:</strong> The response returned from the server (if applicable).</li></ul></li></ul></li><li><strong>Pagination:</strong><ul><li>Logs can be paginated to avoid overwhelming users with too much information at once, allowing users to navigate through entries easily.</li></ul></li></ul></li><li><strong>Filtering and Searching</strong><ul><li><strong>Filter Options:</strong><ul><li>Users can filter logs by various criteria, such as date range, error code, or specific endpoints, to quickly locate relevant entries.</li></ul></li><li><strong>Search Functionality:</strong><ul><li>A search bar allows users to enter keywords or phrases to find specific logs, improving the efficiency of troubleshooting.</li></ul></li></ul></li><li><strong>Log Details</strong><ul><li><strong>Expand/Collapse Feature:</strong><ul><li>Users can click on a log entry to expand and view additional details, such as:<ul><li>Full error stack trace (if available).</li><li>Contextual information regarding the request and server response.</li></ul></li></ul></li><li><strong>Export Option:</strong><ul><li>Users can export the logs in various formats (e.g., CSV, JSON) for offline analysis or reporting purposes.</li></ul></li></ul></li><li><strong>User Interaction Flow</strong><ul><li><strong>Navigating to Error Logs:</strong><ul><li>Users select the <strong>ERROR_LOGS</strong> option from the administration panel to access the log list.</li></ul></li><li><strong>Viewing and Filtering Logs:</strong><ul><li>Users can apply filters and search for specific logs to identify issues effectively.</li></ul></li><li><strong>Exploring Log Details:</strong><ul><li>Users can expand log entries to review detailed error information and troubleshoot accordingly.</li></ul></li></ul></li></ol><h3>Summary</h3><p>The <strong>ERROR_LOGS</strong> functionality provides a robust interface for users to view and manage application logs related to the backend REST API. With features such as filtering, searching, and detailed log views, users can effectively monitor application performance, diagnose errors, and troubleshoot issues, ensuring a smoother user experience and improved application reliability.</p>', CAST(N'2023-06-03T05:22:43.7270890' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', CAST(N'2024-10-05T09:14:40.3391298' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', NULL, NULL, 0)
INSERT [dbo].[PageHelpers] ([Id], [Code], [Name], [Description], [CreatedDate], [CreatedBy], [ModifiedDate], [ModifiedBy], [DeletedDate], [DeletedBy], [IsDeleted]) VALUES (N'3ff74fc0-ea53-453e-b843-674399aa053e', N'MANAGE_EMAIL_TEMPLATE', N'Manage Email Template', N'<p><strong>Managing Email Templates</strong> refers to the process of creating, organizing, editing, and optimizing email templates to ensure efficient and consistent communication. It involves handling a repository of pre-designed email layouts tailored for various purposes like marketing, customer service, transactional updates, or internal notifications.</p><p>Key aspects of managing email templates include: &nbsp;</p><p>1. <strong>Creation and Editing: </strong>Designing templates with a consistent format and placeholders for dynamic content (e.g., ##UserName##, ##OrderID##). Tools like HTML editors or drag-and-drop builders are commonly used for this purpose. &nbsp;</p><p>2. <strong>Categorization and Organization:</strong> Structuring templates into categories (e.g., newsletters, promotions, confirmations) for easy access and management. &nbsp;</p><p>3. <strong>Brand Consistency</strong>: Ensuring templates align with brand guidelines in terms of colors, fonts, and tone of voice. &nbsp;</p><p>4. <strong>Testing and Optimization</strong>: Previewing templates on different devices and email clients to verify responsiveness and readability, and analyzing performance metrics (e.g., open rates, click-through rates) for improvement. &nbsp;</p>', CAST(N'2023-06-03T05:22:44.0000000' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', CAST(N'2024-11-17T10:38:24.8047160' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', NULL, NULL, 0)
INSERT [dbo].[PageHelpers] ([Id], [Code], [Name], [Description], [CreatedDate], [CreatedBy], [ModifiedDate], [ModifiedBy], [DeletedDate], [DeletedBy], [IsDeleted]) VALUES (N'c1864171-0876-469d-ba46-834a8315a076', N'RECENTLY_REGISTERED', N'Recently Registered', N'<p>Recently Registered Users are individuals who have newly created accounts or signed up on a platform. This group is typically characterized by minimal activity, incomplete profiles, and being in the early stages of engagement. They represent potential for growth and retention, often requiring targeted efforts to onboard and familiarize them with the platform’s features and benefits.</p>', CAST(N'2023-06-03T05:22:44.0000000' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', CAST(N'2024-11-17T10:34:09.2351139' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', NULL, NULL, 0)
INSERT [dbo].[PageHelpers] ([Id], [Code], [Name], [Description], [CreatedDate], [CreatedBy], [ModifiedDate], [ModifiedBy], [DeletedDate], [DeletedBy], [IsDeleted]) VALUES (N'a044d090-1e04-405d-ba7d-8f81fad982aa', N'ONLINE_USERS', N'Online Users', N'<p>Online Users are those actively connected to a platform or application in real-time. They may be browsing content, interacting with features, engaging in conversations, or utilizing services. This group reflects the current active audience, providing valuable insights into the platform''s engagement levels and activity patterns. Monitoring online users helps administrators understand peak usage times and make informed decisions about resource allocation, scalability, and performance optimization. &nbsp;</p><p>The presence of online users can signify active engagement and community interaction, especially in platforms like social media, forums, or gaming applications. It also serves as a critical metric for analyzing user behavior, such as session duration, interaction frequency, and content preferences. Platforms often use this data to enhance user experience, identify trends, and ensure seamless functionality during high-traffic periods.</p>', CAST(N'2023-06-03T05:22:44.0000000' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', CAST(N'2024-11-17T10:34:57.3360158' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', NULL, NULL, 0)
INSERT [dbo].[PageHelpers] ([Id], [Code], [Name], [Description], [CreatedDate], [CreatedBy], [ModifiedDate], [ModifiedBy], [DeletedDate], [DeletedBy], [IsDeleted]) VALUES (N'68253345-7003-455f-9c52-9b556150645b', N'EMAIL_TEMPLATE', N'Email Template', N'<p>Email templates are pre-designed and pre-written structures used to create consistent, professional, and time-efficient email communications. They typically include placeholders for dynamic content such as recipient names, dates, or specific details, making them highly customizable for various purposes. Templates are widely used for marketing campaigns, customer support, newsletters, transactional emails, and onboarding sequences. &nbsp;</p><p>These templates ensure branding consistency by incorporating standard layouts, fonts, and colors, aligned with a company’s style guidelines. They are designed to be user-friendly and adaptable, often responsive to different devices and email clients. Using templates saves time, enhances efficiency, and ensures clarity and professionalism in email communications.</p>', CAST(N'2023-06-03T05:22:44.0000000' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', CAST(N'2024-11-17T10:36:42.9848229' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', NULL, NULL, 0)
INSERT [dbo].[PageHelpers] ([Id], [Code], [Name], [Description], [CreatedDate], [CreatedBy], [ModifiedDate], [ModifiedBy], [DeletedDate], [DeletedBy], [IsDeleted]) VALUES (N'b1c70caf-ce26-4dff-8f8a-aed4c8eab097', N'PAGE_HELPERS', N'Page Helpers', N'<p>Users can manage the pages within the application using a user-friendly interface that displays a list of available pages. Each entry in the list includes options to <strong>Edit</strong> or <strong>View</strong> the corresponding page''s details.</p><h4>Features</h4><ol><li><h4><strong>List of Pages</strong></h4><ul><li>Users can see a comprehensive list of all pages in the application, each with the following details:<ul><li><strong>Unique Code:</strong> A non-editable code for each page.</li><li><strong>Editable Name:</strong> An editable field that allows users to change the page name.</li><li><strong>Page Info Content:</strong> A section that displays the functionality description of each page.</li><li>&nbsp;</li></ul></li></ul></li><li><h4><strong>Edit Feature</strong></h4><ul><li><strong>Edit Button:</strong><ul><li>When a user clicks the <strong>Edit</strong> button next to a page, they are directed to an editable form.</li><li>Users can modify the page name and update the page info content to reflect any changes or improvements.</li><li><strong>Validation:</strong><ul><li>The form includes validation checks to ensure that the new name is unique and meets any defined requirements (e.g., length, special characters).</li></ul></li><li><strong>Save Changes:</strong><ul><li>Users can save the changes, which are then reflected in the list of pages and will persist across sessions.</li><li>&nbsp;</li></ul></li></ul></li></ul></li><li><h4><strong>View Feature</strong></h4><ul><li><strong>View Button:</strong><ul><li>Clicking the <strong>View</strong> button opens a dialog box displaying a preview of the page info content.</li><li>This preview includes &nbsp;current page name, and detailed functionality description.</li><li><strong>Modal Dialog:</strong><ul><li>The dialog box is modal, meaning users cannot interact with the rest of the application until they close the dialog.</li><li>Users can close the dialog by clicking an "X" button or a "Close" button.</li></ul></li></ul></li></ul></li><li>&nbsp;<ul><li><h4><strong>Navigating to the Page List:</strong></h4><ul><li>Users can easily navigate to the page list through the main navigation menu.</li></ul></li><li><strong>Editing a Page:</strong><ul><li>Users select the <strong>Edit</strong> button next to the desired page, modify the name and content, and click <strong>Save</strong> to apply the changes.</li></ul></li><li><strong>Viewing a Page:</strong><ul><li>Users can click the <strong>View</strong> button to open the dialog box, review the details, and close the dialog when finished.</li></ul></li></ul></li></ol><h3>Summary</h3><p>This functionality empowers users to effectively manage page names and content within the application, ensuring that information is accurate and up-to-date. The combination of edit and view features enhances the user experience by allowing for quick modifications and easy access to page details.</p>', CAST(N'2023-06-03T05:22:43.7270890' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', CAST(N'2024-10-05T08:53:15.1785445' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', NULL, NULL, 0)
INSERT [dbo].[PageHelpers] ([Id], [Code], [Name], [Description], [CreatedDate], [CreatedBy], [ModifiedDate], [ModifiedBy], [DeletedDate], [DeletedBy], [IsDeleted]) VALUES (N'ccb67040-27de-4931-a854-b0d229252c23', N'PAGES', N'Pages', N'<p><strong>Pages</strong> refer to the distinct sections or screens of an application that serve specific purposes or functionalities. Each page is designed to display relevant content, provide user interactions, and support workflows within the application. Pages are typically organized based on the application''s structure, enabling users to navigate and perform tasks efficiently.</p><p>For example, in a web or mobile application, pages may include a <strong>Dashboard</strong>, <strong>User Management</strong>, <strong>Settings</strong>, <strong>Profile</strong>, <strong>Reports</strong>, or <strong>Help Center</strong>. Each page focuses on a particular feature or activity, offering actions, data, or tools tailored to its purpose. Pages are fundamental to the user experience, acting as the primary interface between the user and the application’s capabilities.</p>', CAST(N'2023-06-03T05:22:44.0000000' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', CAST(N'2024-11-17T10:41:55.2267033' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', NULL, NULL, 0)
INSERT [dbo].[PageHelpers] ([Id], [Code], [Name], [Description], [CreatedDate], [CreatedBy], [ModifiedDate], [ModifiedBy], [DeletedDate], [DeletedBy], [IsDeleted]) VALUES (N'd8506639-f4ec-42d8-9939-bae893abef57', N'ROLES', N'Roles', N'<p><strong>The "User Roles" page is essential for managing and defining permissions within the CMR DMS. Roles represent predefined sets of permissions that can be assigned to users, ensuring that each user has access only to the functionalities and documents appropriate to their position and responsibilities within the organization.</strong></p><h3><strong>Main Components:</strong></h3><p><strong>"Add Roles" Button:</strong></p><ul><li>Allows administrators or users with appropriate permissions to create a new role in the system.</li><li>Opens a form or pop-up window where the role’s permissions and details can be defined.</li></ul><p><strong>List of Existing Roles:</strong></p><ul><li>Displays all roles created within the system in a tabular format.</li><li>Each entry includes the role name and associated action options.</li></ul><p><strong>Action Menu for Each Role:</strong></p><ul><li>Includes options for "Edit" and "Delete."<ul><li><strong>Edit:</strong> Allows modification of the role''s details and permissions.</li><li><strong>Delete:</strong> Removes the role from the system. This action may require confirmation to prevent accidental deletions.</li></ul></li></ul><p><strong>Role Creation Page:</strong></p><ul><li>Here, administrators can define specific permissions for each role.</li><li>Permissions can include rights such as viewing, editing, deleting, or sharing documents, managing users, defining categories, and more.</li><li>Once permissions are set, they can be saved to create a new role or update an existing one.</li></ul><h3><strong>How to Add a New Role:</strong></h3><ol><li>Click on the "Add Roles" button.</li><li>A form or pop-up window will open.</li><li>Enter the role name and select the appropriate permissions from the available list.</li><li>Click "Save" or "Add" to add the role to the system with the specified permissions.</li></ol>', CAST(N'2023-06-03T05:18:29.0000000' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', CAST(N'2024-10-05T05:52:38.0563727' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', NULL, NULL, 0)
INSERT [dbo].[PageHelpers] ([Id], [Code], [Name], [Description], [CreatedDate], [CreatedBy], [ModifiedDate], [ModifiedBy], [DeletedDate], [DeletedBy], [IsDeleted]) VALUES (N'ba5ae073-4746-4552-836b-bfce8d5dd834', N'SETUP_PAGE_ACTION', N'Setup Page Action', N'<p><strong>Setup Page Action</strong> refers to the actions associated with configuring or managing the behavior of a specific page within an application. These actions are designed to define, customize, or control the functionalities and layout of the page, enabling administrators or users to tailor it to their needs.</p><p>For example, in a content management system, a setup page action might include options like "Add Widgets," "Reorder Sections," "Configure Page Settings," or "Assign Permissions." These actions ensure that the page serves its intended purpose effectively and aligns with the overall application workflow.</p>', CAST(N'2023-06-03T05:22:44.0000000' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', CAST(N'2024-11-17T10:42:44.1257655' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', NULL, NULL, 0)
INSERT [dbo].[PageHelpers] ([Id], [Code], [Name], [Description], [CreatedDate], [CreatedBy], [ModifiedDate], [ModifiedBy], [DeletedDate], [DeletedBy], [IsDeleted]) VALUES (N'25ccccd4-bd60-4f8b-8bc1-c49eca98fb49', N'EMAIL_SMTP_SETTINGS', N' Email SMTP Settings', N'<p>The <strong>"Email SMTP Settings"</strong> page within CMR DMS allows administrators to configure and manage the SMTP settings for sending emails. This ensures that emails sent from the system are correctly and efficiently delivered to recipients.</p><p><strong>Key Components:</strong></p><ul><li><p><strong>SMTP Settings Table:</strong> Displays all configured SMTP settings in a tabular format.</p><p>Each entry in the table includes details such as the username, host, port, and whether that configuration is set as the default.</p></li><li><p><strong>"Add Settings" Button:</strong> Allows administrators to add a new SMTP configuration.</p><p>Clicking the button opens a form where details like username, host, port, and the option to set it as the default configuration can be entered.</p></li></ul><p><strong>"Add Settings" Form:</strong></p><p>This form opens when administrators click the "Add Settings" button and includes the following fields:</p><ul><li><strong>Username:</strong> The username required for authentication on the SMTP server.</li><li><strong>Host:</strong> The SMTP server address.</li><li><strong>Port:</strong> The port on which the SMTP server listens.</li><li><strong>Is Default:</strong> A checkbox that allows setting this configuration as the default for sending emails.</li></ul><p><strong>How to Add a New SMTP Configuration:</strong></p><ol><li>Click the "Add Settings" button.</li><li>The "Add Settings" form will open, where you can enter the SMTP configuration details.</li><li>Fill in the necessary fields and select the desired options.</li><li>After completing the details, click "Save" or "Add" to add the configuration to the system.</li></ol>', CAST(N'2023-06-03T05:25:45.0000000' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', CAST(N'2024-11-13T14:33:28.1722231' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', NULL, NULL, 0)
INSERT [dbo].[PageHelpers] ([Id], [Code], [Name], [Description], [CreatedDate], [CreatedBy], [ModifiedDate], [ModifiedBy], [DeletedDate], [DeletedBy], [IsDeleted]) VALUES (N'3e0fe36d-cde5-4bd9-b65d-cfaeadcffce3', N'COMPANY_PROFILE', N'Company Profile', N'<p>Here’s a detailed description of the functionality for managing the company profile, focusing on the company name, logo, and banner logo on the login screen.</p><h3>&nbsp;</h3><h4>Overview</h4><p>The Company Profile feature allows users to customize the branding of the application by entering the company name and uploading logos. This customization will reflect on the login screen, enhancing the professional appearance and brand identity of the application.</p><h4>Features</h4><ol><li><h4><strong>Company Name</strong></h4><ul><li><strong>Input Field:</strong><ul><li>Users can enter the name of the company in a text input field.</li><li><strong>Validation:</strong><ul><li>The field will have validation to ensure the name is not empty and meets any specified length requirements (e.g., minimum 2 characters, maximum 50 characters).</li><li><strong>Browser Title Setting:</strong></li><li>Upon saving the company name, the application will dynamically set the browser title to match the company name, improving brand visibility in browser tabs.</li></ul></li></ul></li></ul></li><li><h4><strong>Logo Upload</strong></h4><ul><li><strong>Upload Button:</strong><ul><li>Users can upload a company logo that will be displayed in the header of the login page.</li><li><strong>File Requirements:</strong><ul><li>Supported file formats: PNG, JPG, JPEG (with size limits, e.g., up to 2 MB).</li><li>Recommended dimensions for optimal display (e.g., width: 200px, height: 100px).</li></ul></li></ul></li><li><strong>Preview:</strong><ul><li>After uploading, a preview of the logo will be displayed to confirm the upload.</li></ul></li></ul></li><li><h4><strong>Banner Logo Upload</strong></h4><ul><li><strong>Upload Button:</strong><ul><li>Users can upload a banner logo that will appear prominently on the login screen.</li><li><strong>File Requirements:</strong><ul><li>Supported file formats: PNG, JPG, JPEG (with size limits, e.g., up to 3 MB).</li><li>Recommended dimensions for optimal display (e.g., width: 1200px, height: 300px).</li></ul></li></ul></li><li><strong>Preview:</strong><ul><li>A preview of the banner logo will be displayed after the upload for confirmation.</li></ul></li></ul></li><li><h4><strong>User Interaction Flow</strong></h4><ul><li><h4><strong>Navigating to the Company Profile:</strong></h4><ul><li>Users can access the company profile settings from the application’s settings menu or administration panel.</li></ul></li><li><strong>Editing Company Profile:</strong><ul><li>Users enter the company name, upload the logo, and the banner logo.</li><li>A "Save Changes" button will be available to apply the modifications.</li></ul></li><li><strong>Saving Changes:</strong><ul><li>Upon clicking "Save Changes," the uploaded logos and company name will be saved and reflected on the login screen.</li><li>Confirmation messages will be displayed to indicate successful updates.</li></ul></li></ul></li><li><strong>Display on Login Screen</strong><ul><li><strong>Header Display:</strong><ul><li>The company logo will be displayed in the header at the top of the login page, maintaining a consistent branding experience.</li></ul></li><li><strong>Banner Display:</strong><ul><li>The banner logo will be displayed prominently below the header, enhancing the visual appeal of the login interface.</li></ul></li></ul></li></ol><h3>Summary</h3><p>The Company Profile functionality allows for a customizable branding experience, enabling users to set their company name and logos that will be visible on the login screen. This feature enhances user engagement and presents a professional image right from the login phase of the application.</p>', CAST(N'2023-06-03T05:22:43.7270890' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', CAST(N'2024-10-05T08:59:50.4836430' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', NULL, NULL, 0)
INSERT [dbo].[PageHelpers] ([Id], [Code], [Name], [Description], [CreatedDate], [CreatedBy], [ModifiedDate], [ModifiedBy], [DeletedDate], [DeletedBy], [IsDeleted]) VALUES (N'762a5894-0c49-48d8-9e0c-e5062a4c3322', N'SEND_EMAIL', N'Send mail', N'<ul><li><strong>How to Send a Document as an Email Attachment:</strong></li><li><strong>Select the email field</strong>: Navigate to the section where you can compose an email and select the field for entering the recipient''s email address.</li><li><strong>Enter the email address</strong>: Type the recipient''s email address in the provided field.</li><li><strong>Subject field</strong>: Enter a relevant subject for your email.</li><li><strong>Email content</strong>: Write the body of your email, providing any necessary context or information.</li><li><strong>Attach the document</strong>: Find the option to "Attach" or "Upload" a document, then select the file you wish to send.</li><li><strong>Send the email</strong>: After attaching the document and ensuring the recipient, subject, and content are correct, click the "Send" button to deliver the email with the attached document.</li></ul>', CAST(N'2023-06-03T05:16:00.0000000' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', CAST(N'2024-10-05T06:16:51.7893891' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', NULL, NULL, 0)
INSERT [dbo].[PageHelpers] ([Id], [Code], [Name], [Description], [CreatedDate], [CreatedBy], [ModifiedDate], [ModifiedBy], [DeletedDate], [DeletedBy], [IsDeleted]) VALUES (N'dd0c9840-b7c6-4a51-b78a-e674918ff7e5', N'NOTIFICATIONS', N'Notifications', N'<ul><li><strong>Reminder Notifications</strong>:<ul><li>Sends reminders to users for upcoming deadlines or actions related to documents (e.g., review deadlines or document expiration).</li><li>Users can configure reminder frequency and set specific reminders for important documents.</li><li>Reminders are delivered via both email and in-app notifications.</li></ul></li></ul><p>&nbsp;</p>', CAST(N'2023-06-03T05:28:05.0000000' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', CAST(N'2024-11-17T10:44:05.5800411' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', NULL, NULL, 0)
INSERT [dbo].[PageHelpers] ([Id], [Code], [Name], [Description], [CreatedDate], [CreatedBy], [ModifiedDate], [ModifiedBy], [DeletedDate], [DeletedBy], [IsDeleted]) VALUES (N'509dfdb8-8e5c-4370-8427-f6a9c2c78007', N'ROLE_USER', N'Role users', N'<p><strong>The "User with Role" page is dedicated to assigning specific roles to users within the DMS. It allows administrators to associate users with particular roles using an intuitive "drag and drop" system. Users can be moved from the general user list to the "Users with Role" list, thereby assigning them the selected role.</strong></p><h3><strong>Main Components:</strong></h3><ul><li><strong>Title "User with Role":</strong> Indicates the purpose and functionality of the page.</li><li><strong>Department:</strong> Displays the currently selected department, in this case, "Approvals."<ul><li>There may be an option to change the department if needed.</li></ul></li><li><strong>Select Role:</strong> A dropdown menu or selection box where administrators can choose the role they wish to assign to users.<ul><li>Once a role is selected, users can be moved into the "Users with Role" list to assign them that role.</li></ul></li><li><strong>Note:</strong> A short instruction explaining how to use the page, indicating that users can be moved from the "All Users" list to the "Users with Role" list to assign them a role.</li><li><strong>"All Users" and "Users with Role" Lists:</strong><ul><li><strong>"All Users":</strong> Displays a complete list of all registered users in the CMR DMS.</li><li><strong>"Users with Role":</strong> Displays the users who have been assigned the selected role.</li><li>Users can be moved between these lists using the "drag and drop" functionality.</li></ul></li></ul><h3><strong>How to Assign a Role to a User:</strong></h3><ol><li>Select the desired role from the "Select Role" box.</li><li>Locate the desired user in the "All Users" list.</li><li>Using the mouse or a touch device, drag the user from the "All Users" list and drop them into the "Users with Role" list.</li><li>The selected user will now be associated with the chosen role and will appear in the "Users with Role" list.</li></ol>', CAST(N'2023-06-03T05:23:23.0000000' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', CAST(N'2024-10-05T06:17:44.8519754' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', NULL, NULL, 0)
INSERT [dbo].[PageHelpers] ([Id], [Code], [Name], [Description], [CreatedDate], [CreatedBy], [ModifiedDate], [ModifiedBy], [DeletedDate], [DeletedBy], [IsDeleted]) VALUES (N'0cc83192-f05b-4c97-ab20-f7f3b5ba16d0', N'REMINDERS', N'Reminders', N'<p>The <strong>"Reminders"</strong> page is the central hub for managing reminders within CMR DMS, where users can create, view, and manage reminders or notifications related to documents or other activities. Reminders can be set to repeat at regular intervals and can be associated with a specific document for efficient tracking of tasks and activities.</p><h3>Main components:</h3><ol><li><strong>"Add Reminder" Button</strong>:<ul><li>Allows users to create a new reminder.</li><li>Upon clicking, it opens a form where details such as subject, message, frequency, associated document, and reminder date can be entered.</li></ul></li><li><strong>Reminders Table</strong>:<ul><li>Displays all created reminders in a tabular format.</li><li>Each entry includes:<ul><li>Start date</li><li>End date</li><li>Reminder subject</li><li>Associated message</li><li>Recurrence frequency</li><li>Associated document (if applicable)</li></ul></li></ul></li></ol><h3>"Add Reminder" Form:</h3><p>When users click on the <strong>"Add Reminder"</strong> button, a form opens with the following fields:</p><ul><li><strong>Subject</strong>: The title or topic of the reminder (e.g., "Document Review").</li><li><strong>Message</strong>: Additional details about the reminder (e.g., "Review the document by X date").</li><li><strong>Repeat Reminder</strong>: Sets the recurrence frequency, with options such as:<ul><li>Daily</li><li>Weekly</li><li>Monthly</li><li>Semi-annually</li></ul></li><li><strong>Send Email</strong>: An option to send an email notification when the reminder is activated.</li><li><strong>Select Users</strong>: Allows selecting users to whom the reminder will be sent. It can be customized for specific teams or individuals.</li><li><strong>Reminder Date</strong>: The date and time when the reminder will be activated and sent.</li></ul><h3>How to add a new reminder:</h3><ol><li>Navigate to the <strong>"Reminders"</strong> page.</li><li>Click the <strong>"Add Reminder"</strong> button.</li><li>Fill in the form fields with the necessary information.</li><li>After entering all the details, click <strong>"Save"</strong> or <strong>"Add"</strong> to save the reminder in the system.</li></ol><h3>"Add Reminder" Functionality in the "Manage Reminders" section:</h3><p>This is the dedicated place for creating and managing notifications related to events or tasks. The <strong>"Add Reminder"</strong> functionality offers full customization, and reminders can be sent to selected users.</p><ul><li><strong>Subject</strong>: Enter a descriptive title for the reminder.</li><li><strong>Message</strong>: Add a clear and concise message to detail the purpose of the reminder.</li><li><strong>Repeat Reminder</strong>: Set whether the reminder will be repeated periodically (daily, weekly, etc.).</li><li><strong>Send Email</strong>: If this option is checked, the reminder will also be sent as an email.</li><li><strong>Select Users</strong>: Select users from the system''s list to whom the reminder will be sent.</li><li><strong>Reminder Date</strong>: Set the date and time for the reminder to be triggered.</li></ul>', CAST(N'2023-06-02T17:31:21.0000000' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', CAST(N'2024-10-05T04:41:27.0060525' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', NULL, NULL, 0)
INSERT [dbo].[PageHelpers] ([Id], [Code], [Name], [Description], [CreatedDate], [CreatedBy], [ModifiedDate], [ModifiedBy], [DeletedDate], [DeletedBy], [IsDeleted]) VALUES (N'a3664127-34f1-494c-84c5-fc3f307a9d11', N'USER_PAGE_PERMISSION_TO', N'User Page Permission To', N'<ul><li>Enable the ability to assign specific permissions to users that are not tied to their assigned roles. This gives admins the flexibility to grant access to particular features for individual users.</li><li>Click <strong>"Save"</strong> or <strong>"Add"</strong> to assign the user to the system with the specified permissions.</li></ul>', CAST(N'2023-06-03T05:22:44.0000000' AS DateTime2), N'4b352b37-332a-40c6-ab05-e38fcf109719', CAST(N'0001-01-01T00:00:00.0000000' AS DateTime2), N'00000000-0000-0000-0000-000000000000', NULL, NULL, 0)