Uploaded image for project: 'Document Management System'
  1. Document Management System
  2. DMS-1890

Changing values of form from Console[Developer Tools] should not be allowed

    Details

    • Company:
      All Clients/Multiple Clients

      Description

      Disallow User to manipulate data from console of form on Review and Sign page and on Admin Preview page.
      Manipulated data should not be saved in Database.

      CC: Rohan J Khandave,Samir,Priya Dhamande

        Attachments

          Activity

          ramya.tantry Ramya Tantry (Inactive) created issue -
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Field Original Value New Value
          Summary Changing values of PDF from Console should not be allowed Changing values of form from Console[Developer Tools] should not be allowed
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Status To Do [ 10000 ] In Progress [ 3 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Status In Progress [ 3 ] To Do [ 10000 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Status To Do [ 10000 ] In Progress [ 3 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Description Disallow User to manipulate data from console of form on Review and Sign page and on Admin Preview page.
          Manipulated should not be saved in Database.

          CC: [~rohan.khandave],[~samir],[~priya.dhamande]
          Disallow User to manipulate data from console of form on Review and Sign page and on Admin Preview page.
           Manipulated data should not be saved in Database.

          CC: [~rohan.khandave],[~samir],[~priya.dhamande]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Remaining Estimate 16h [ 57600 ]
          Original Estimate 16h [ 57600 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Sprint DMS - Gap Fall & Win Sprint 4 [ 179 ]
          ramya.tantry Ramya Tantry (Inactive) logged work - 17/Sep/19 05:36 AM
          • Time Spent:
            1h
             

            Issue analysis

             

          ramya.tantry Ramya Tantry (Inactive) made changes -
          Remaining Estimate 16h [ 57600 ] 15h [ 54000 ]
          Time Spent 1h [ 3600 ]
          Worklog Id 200670 [ 200670 ]
          ramya.tantry Ramya Tantry (Inactive) logged work - 18/Sep/19 05:48 AM
          • Time Spent:
            2h
             

            Code changes

          ramya.tantry Ramya Tantry (Inactive) made changes -
          Remaining Estimate 15h [ 54000 ] 13h [ 46800 ]
          Time Spent 1h [ 3600 ] 3h [ 10800 ]
          Worklog Id 200954 [ 200954 ]
          ramya.tantry Ramya Tantry (Inactive) logged work - 19/Sep/19 05:49 AM
          • Time Spent:
            7.5h
             

            Code changes

            Discussion with Rohan

            Testing

          Hide
          ramya.tantry Ramya Tantry (Inactive) added a comment -

          Areas impacted:

          1. Admin preview -> changes done to view only and/or no rights field from developer tools -> Send
          2. Candidate Review and Sign -> changes done to view only and/or no rights field from developer tools -> Submit/Decline
          3. API : Custom create -> open link in browser -> changes done to view only and/or no rights field from developer tools -> Save

          Implementation:

          1. If previous JSON data is not present, form data is compared with database values. If manipulated data is found, it is replaced with database value.
          2. If previous JSON data is present, form data is compared with previous JSON values.  If manipulated data is found, it is replaced with previous JSON value.

           

          We are reusing the functionality done for fetching history data but will need additional changes. So extending the estimates 16h to 24h

           

          Show
          ramya.tantry Ramya Tantry (Inactive) added a comment - Areas impacted: Admin preview -> changes done to view only and/or no rights field from developer tools -> Send Candidate Review and Sign -> changes done to view only and/or no rights field from developer tools -> Submit/Decline API : Custom create -> open link in browser -> changes done to view only and/or no rights field from developer tools -> Save Implementation: If previous JSON data is not present, form data is compared with database values. If manipulated data is found, it is replaced with database value. If previous JSON data is present, form data is compared with previous JSON values.  If manipulated data is found, it is replaced with previous JSON value.   We are reusing the functionality done for fetching history data but will need additional changes. So extending the estimates 16h to 24h  
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Remaining Estimate 13h [ 46800 ] 5.5h [ 19800 ]
          Time Spent 3h [ 10800 ] 10.5h [ 37800 ]
          Worklog Id 201279 [ 201279 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Remaining Estimate 5.5h [ 19800 ] 13.5h [ 48600 ]
          Original Estimate 16h [ 57600 ] 24h [ 86400 ]
          ramya.tantry Ramya Tantry (Inactive) logged work - 20/Sep/19 06:11 AM
          • Time Spent:
            3.5h
             

            Code changes

          ramya.tantry Ramya Tantry (Inactive) made changes -
          Remaining Estimate 13.5h [ 48600 ] 10h [ 36000 ]
          Time Spent 10.5h [ 37800 ] 14h [ 50400 ]
          Worklog Id 201529 [ 201529 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Status In Progress [ 3 ] To Do [ 10000 ]
          Hide
          ramya.tantry Ramya Tantry (Inactive) added a comment -

          Putting on hold as I am working on DMS-1913.

          Show
          ramya.tantry Ramya Tantry (Inactive) added a comment - Putting on hold as I am working on DMS-1913 .
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Status To Do [ 10000 ] In Progress [ 3 ]
          Hide
          ramya.tantry Ramya Tantry (Inactive) added a comment -

          Concern: Manipulated data of no rights and view only permissions was getting saved in JSON of the document.

          Cause: The JSON data received from UI was getting saved into DB directly without it getting verified with the DB values. So in case if the data has been manipulated from DEV tools and saved, this data will be saved into DB as document JSON and the same will be fetched to candidate.This is data security breach.

          Correction: While saving the JSON data, additional code changes have been done to verify - 

          1. If previous JSON data is not present, form data is compared with database values. If manipulated data is found, it is replaced with database value.
          2. If previous JSON data is present, form data is compared with previous JSON values.  If manipulated data is found, it is replaced with previous JSON value.

          Files Affected:

          1. DMS\DMS.App\src\DMS_AppLogic\BuisnessLogic\DocumentData.cs
          2. DMS\DMS.App\src\DMS_AppLogic\BuisnessLogic\PersonData.cs
          3. DMS\DMS.App\src\DMS_AppLogic\Common\HistoryData.cs
          4. DMS\DMS.App\src\DMS_AppLogic\Common\IHistoryData.cs
          5. DMS\DMS.App\src\DMS_AppLogic\Common\Routines\CommonRoutines.cs
          6. DMS\DMS.App\src\DMS_AppLogic\Common\Routines\ICommonRoutines.cs
          7. DMS\DMS.App\src\DMS_AppLogic\IntegrationLogic\CandidateProfile.cs
          8. DMS\DMS.App\src\DMS_AppLogic\Repository\IDocumentRepository.cs
          9. DMS\DMS.App\src\DMS_WebApi\Startup.cs
          10. DMS\DMS.App\src\Entities\Document\FieldsDto.cs
          11. DMS\DMS.Web\src\DMS_WebApp\ClientApp\src\app\candidate\document-review\document-review.component.ts
          Show
          ramya.tantry Ramya Tantry (Inactive) added a comment - Concern : Manipulated data of no rights and view only permissions was getting saved in JSON of the document. Cause : The JSON data received from UI was getting saved into DB directly without it getting verified with the DB values. So in case if the data has been manipulated from DEV tools and saved, this data will be saved into DB as document JSON and the same will be fetched to candidate.This is data security breach. Correction : While saving the JSON data, additional code changes have been done to verify -  If previous JSON data is not present, form data is compared with database values. If manipulated data is found, it is replaced with database value. If previous JSON data is present, form data is compared with previous JSON values.  If manipulated data is found, it is replaced with previous JSON value. Files Affected: DMS\DMS.App\src\DMS_AppLogic\BuisnessLogic\DocumentData.cs DMS\DMS.App\src\DMS_AppLogic\BuisnessLogic\PersonData.cs DMS\DMS.App\src\DMS_AppLogic\Common\HistoryData.cs DMS\DMS.App\src\DMS_AppLogic\Common\IHistoryData.cs DMS\DMS.App\src\DMS_AppLogic\Common\Routines\CommonRoutines.cs DMS\DMS.App\src\DMS_AppLogic\Common\Routines\ICommonRoutines.cs DMS\DMS.App\src\DMS_AppLogic\IntegrationLogic\CandidateProfile.cs DMS\DMS.App\src\DMS_AppLogic\Repository\IDocumentRepository.cs DMS\DMS.App\src\DMS_WebApi\Startup.cs DMS\DMS.App\src\Entities\Document\FieldsDto.cs DMS\DMS.Web\src\DMS_WebApp\ClientApp\src\app\candidate\document-review\document-review.component.ts
          ramya.tantry Ramya Tantry (Inactive) logged work - 24/Sep/19 05:31 AM
          • Time Spent:
            3.5h
             

            Code changes

            Testing

            Draft reply

          ramya.tantry Ramya Tantry (Inactive) made changes -
          Remaining Estimate 10h [ 36000 ] 6.5h [ 23400 ]
          Time Spent 14h [ 50400 ] 17.5h [ 63000 ]
          Worklog Id 202091 [ 202091 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Status In Progress [ 3 ] Code Review [ 11801 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Assignee Ramya Tantry [ ramya.tantry ] Harshveer Singh [ harshveer.singh ]
          ramya.tantry Ramya Tantry (Inactive) logged work - 25/Sep/19 05:36 AM
          • Time Spent:
            1h
             

            Jira updation

            raise pr

          ramya.tantry Ramya Tantry (Inactive) made changes -
          Remaining Estimate 6.5h [ 23400 ] 5.5h [ 19800 ]
          Time Spent 17.5h [ 63000 ] 18.5h [ 66600 ]
          Worklog Id 202343 [ 202343 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Assignee Harshveer Singh [ harshveer.singh ] Ramya Tantry [ ramya.tantry ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Status Code Review [ 11801 ] In Progress [ 3 ]
          ramya.tantry Ramya Tantry (Inactive) logged work - 27/Sep/19 06:22 AM
          • Time Spent:
            5.5h
             

            Code changes

          ramya.tantry Ramya Tantry (Inactive) made changes -
          Remaining Estimate 5.5h [ 19800 ] 0h [ 0 ]
          Time Spent 18.5h [ 66600 ] 24h [ 86400 ]
          Worklog Id 202932 [ 202932 ]
          shashikant.mishra ShashiKant Mishra (Inactive) made changes -
          Sprint DMS - Gap Fall & Win Sprint 4 [ 179 ] DMS - Gap Fall & Win Sprint 4, DMS - Gap Fall & Win Sprint 5 [ 179, 181 ]
          ramya.tantry Ramya Tantry (Inactive) logged work - 29/Sep/19 10:50 PM
          • Time Spent:
            2h
             

            Code review changes and testing

          ramya.tantry Ramya Tantry (Inactive) made changes -
          Time Spent 24h [ 86400 ] 26h [ 93600 ]
          Worklog Id 203160 [ 203160 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Status In Progress [ 3 ] Code Review [ 11801 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Assignee Ramya Tantry [ ramya.tantry ] Harshveer Singh [ harshveer.singh ]
          Ashish.Durani Ashish Durani made changes -
          Status Code Review [ 11801 ] In QA Testing [ 11901 ]
          Ashish.Durani Ashish Durani made changes -
          Assignee Harshveer Singh [ harshveer.singh ] Priya Dhamande [ priya.dhamande ]
          Hide
          priya.dhamande Priya Dhamande (Inactive) added a comment -

          No testing input required. So, marking jira done.

          Show
          priya.dhamande Priya Dhamande (Inactive) added a comment - No testing input required. So, marking jira done.
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Resolution Done [ 10000 ]
          Status In QA Testing [ 11901 ] Done [ 10001 ]
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Assignee Priya Dhamande [ priya.dhamande ] Rohan J Khandave [ rohan.khandave ]
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Status Done [ 10001 ] In QA Testing [ 11901 ]
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Assignee Rohan J Khandave [ rohan.khandave ] Priya Dhamande [ priya.dhamande ]
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Status In QA Testing [ 11901 ] Done [ 10001 ]
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Assignee Priya Dhamande [ priya.dhamande ] Ramya Tantry [ ramya.tantry ]
          samir Samir made changes -
          Assignee Ramya Tantry [ ramya.tantry ] Rohan J Khandave [ rohan.khandave ]
          Transition Time In Source Status Execution Times
          Ramya Tantry (Inactive) made transition -
          In Progress To Do
          6d 20h 11m 2
          Ramya Tantry (Inactive) made transition -
          To Do In Progress
          6d 37m 3
          Ramya Tantry (Inactive) made transition -
          Code Review In Progress
          1d 23h 40m 1
          Ramya Tantry (Inactive) made transition -
          In Progress Code Review
          4d 2h 3m 2
          Ashish Durani made transition -
          Code Review In QA Testing
          1d 1h 40m 1
          Priya Dhamande (Inactive) made transition -
          Done In QA Testing
          12m 34s 1
          Priya Dhamande (Inactive) made transition -
          In QA Testing Done
          9d 5h 4m 2

            People

            Assignee:
            rohan.khandave Rohan J Khandave (Inactive)
            Reporter:
            ramya.tantry Ramya Tantry (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 24h Original Estimate - 24h
                24h
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 26h
                26h