Uploaded image for project: 'New Features 2017'
  1. New Features 2017
  2. NF-409

TSR : Platform for 3rd party API communication - implementation to Store API details - credentials

    Details

    • Type: Enhancement
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Integrations
    • Labels:
      None
    • Module:
      TSR
    • Reported by:
      Harbinger
    • Item State:
      Production Complete
    • Issue Importance:
      Q1
    • Sprint:
      NF Sprint 6
    • Severity:
      Simple

      Description

      Implementation to Store API details - credentials

        Attachments

          Issue Links

            Activity

            prasadp Prasad Pise (Inactive) created issue -
            ramya.tantry Ramya Tantry (Inactive) logged work - 09/Mar/17 03:57 PM - edited
            • Time Spent:
              1h
               

              Analysis and discussion with Saurabh.

            ramya.tantry Ramya Tantry (Inactive) made changes -
            Field Original Value New Value
            Remaining Estimate 32h [ 115200 ]
            Original Estimate 32h [ 115200 ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Remaining Estimate 32h [ 115200 ] 31h [ 111600 ]
            Time Spent 1h [ 3600 ]
            Worklog Id 30119 [ 30119 ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Worklog Id 30119 [ 30119 ]
            ramya.tantry Ramya Tantry (Inactive) logged work - 10/Mar/17 12:51 PM
            • Time Spent:
              3.5h
               

              Discussion
              Database scripts creation
              Discussion with Saurabh
              New files creation in project

            ramya.tantry Ramya Tantry (Inactive) made changes -
            Remaining Estimate 31h [ 111600 ] 27.5h [ 99000 ]
            Time Spent 1h [ 3600 ] 4.5h [ 16200 ]
            Worklog Id 30284 [ 30284 ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Assignee Saurabh Sablaka [ saurabh.sablaka ] Ramya Tantry [ ramya.tantry ]
            ramya.tantry Ramya Tantry (Inactive) logged work - 13/Mar/17 04:02 PM
            • Time Spent:
              5.5h
               

              UI changes and coding

            ramya.tantry Ramya Tantry (Inactive) made changes -
            Remaining Estimate 27.5h [ 99000 ] 22h [ 79200 ]
            Time Spent 4.5h [ 16200 ] 10h [ 36000 ]
            Worklog Id 30677 [ 30677 ]
            ramya.tantry Ramya Tantry (Inactive) logged work - 14/Mar/17 12:42 PM
            • Time Spent:
              5h
               

              Coding - Get and Save functionality
              Added new business logic file

            ramya.tantry Ramya Tantry (Inactive) made changes -
            Remaining Estimate 22h [ 79200 ] 17h [ 61200 ]
            Time Spent 10h [ 36000 ] 15h [ 54000 ]
            Worklog Id 30880 [ 30880 ]
            ramya.tantry Ramya Tantry (Inactive) logged work - 15/Mar/17 12:41 PM
            • Time Spent:
              7h
               

              Functionality review
              Localization
              Business logic changes
              discussion with Saurabh

            ramya.tantry Ramya Tantry (Inactive) made changes -
            Remaining Estimate 17h [ 61200 ] 10h [ 36000 ]
            Time Spent 15h [ 54000 ] 22h [ 79200 ]
            Worklog Id 31267 [ 31267 ]
            ramya.tantry Ramya Tantry (Inactive) logged work - 16/Mar/17 12:51 PM
            • Time Spent:
              7h
               

              coding of changes suggested by Saurabh
              Discussion with saurabh
              worked on additional changes suggested by him

            ramya.tantry Ramya Tantry (Inactive) made changes -
            Remaining Estimate 10h [ 36000 ] 3h [ 10800 ]
            Time Spent 22h [ 79200 ] 29h [ 104400 ]
            Worklog Id 31793 [ 31793 ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Code Review Date 16/Mar/2017
            Code Reviewed By Saurabh Sablaka [ 11909 ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Status New Request [ 10029 ] Pending for Approval [ 10002 ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Status Pending for Approval [ 10002 ] Approved for Development [ 10003 ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Status Approved for Development [ 10003 ] In Development [ 10007 ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
            Hide
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Files Affected

            1. App/BusinessLogic/CollectionManager/CollectionManager.vb
            2. App/BusinessLogic/WORKTERRA/APIStatusMappings.cs
            3. App/BusinessLogic/WORKTERRA/WORKTERRA.csproj
            4. App/ControllerAppTier/ControllerAppTier/WORKTERRAControllerAppTier.cs
            5. Database Objects/MasterCompanyDB/01_DDL/504_NF-409_WTB_Platform_NewTable_APIClientDetails.sql
            6. Database Objects/MasterCompanyDB/01_DDL/505_NF-409_WTB_Platform_NewTable_APIStatusTriggers.sql
            7. Database Objects/MasterCompanyDB/07_Data/357_NF-409_WTB_Platform_NewData_APIClientDetails.sql
            8. Database Objects/MasterCompanyDB/07_Data/358_NF-409_WTB_Platform_NewData_APIStatusTriggers.sql
            9. Database Objects/OnlineEnrollment/01_DDL/105_NF-409_WTB_Platform_NewTable_APIServices.sql
            10. Database Objects/OnlineEnrollment/01_DDL/106_NF-409_WTB_Platform_NewTable_APIServiceEndpoints.sql
            11. Database Objects/OnlineEnrollment/01_DDL/107_NF-409_WTB_Platform_NewTable_AuthenticationType.sql
            12. Database Objects/OnlineEnrollment/07_Data/268_NF-409_WTB_Platform_NewData_PageLevelAccess.sql
            13. Database Objects/OnlineEnrollment/07_Data/269_NF-409_WTB_Platform_NewData_APIServices.sql
            14. Database Objects/OnlineEnrollment/07_Data/270_NF-409_WTB_Platform_NewData_APIServiceEndpoints.sql
            15. Database Objects/OnlineEnrollment/07_Data/271_NF-409_WTB_Platform_NewData_AuthenticationType.sql
            16. Shared Library/SharedFunction/SharedFunction/WORKTERRASharedFunction.cs
            17. Shared Library/ValueObjects/ValueObjects/ValueObjects.csproj
            18. Shared Library/ValueObjects/ValueObjects/WORKTERRA/APIStatusTrigger.cs
            19. Shared Library/WORKTERRALocalization/WORKTERRAResource.Designer.cs
            20. Shared Library/WORKTERRALocalization/WORKTERRAResource.en-GB.Designer.cs
            21. Shared Library/WORKTERRALocalization/WORKTERRAResource.en-GB.resx
            22. Shared Library/WORKTERRALocalization/WORKTERRAResource.es-mx.Designer.cs
            23. Shared Library/WORKTERRALocalization/WORKTERRAResource.es-mx.resx
            24. Shared Library/WORKTERRALocalization/WORKTERRAResource.fr-CA.Designer.cs
            25. Shared Library/WORKTERRALocalization/WORKTERRAResource.fr-CA.resx
            26. Shared Library/WORKTERRALocalization/WORKTERRAResource.resx
            27. Web/Web Projects/WORKTERRA/Areas/Configuration/Controllers/APIStatusMapping
            28. Web/Web Projects/WORKTERRA/Areas/Configuration/Controllers/APIStatusMapping/APIStatusMappingController.cs
            29. Web/Web Projects/WORKTERRA/Areas/Configuration/Models/APIStatusMapping
            30. Web/Web Projects/WORKTERRA/Areas/Configuration/Models/APIStatusMapping/APIStatusMappingModel.cs
            31. Web/Web Projects/WORKTERRA/Areas/Configuration/Views/Configuration/APIStatusMapping
            32. Web/Web Projects/WORKTERRA/Areas/Configuration/Views/Configuration/APIStatusMapping/_APIStatusMappingPV.cshtml
            33. Web/Web Projects/WORKTERRA/Areas/Configuration/Views/Configuration/APIStatusMapping/APIStatusMapping.cshtml
            34. Web/Web Projects/WORKTERRA/WORKTERRAShared.csproj
            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Files Affected App/BusinessLogic/CollectionManager/CollectionManager.vb App/BusinessLogic/WORKTERRA/APIStatusMappings.cs App/BusinessLogic/WORKTERRA/WORKTERRA.csproj App/ControllerAppTier/ControllerAppTier/WORKTERRAControllerAppTier.cs Database Objects/MasterCompanyDB/01_DDL/504_ NF-409 _WTB_Platform_NewTable_APIClientDetails.sql Database Objects/MasterCompanyDB/01_DDL/505_ NF-409 _WTB_Platform_NewTable_APIStatusTriggers.sql Database Objects/MasterCompanyDB/07_Data/357_ NF-409 _WTB_Platform_NewData_APIClientDetails.sql Database Objects/MasterCompanyDB/07_Data/358_ NF-409 _WTB_Platform_NewData_APIStatusTriggers.sql Database Objects/OnlineEnrollment/01_DDL/105_ NF-409 _WTB_Platform_NewTable_APIServices.sql Database Objects/OnlineEnrollment/01_DDL/106_ NF-409 _WTB_Platform_NewTable_APIServiceEndpoints.sql Database Objects/OnlineEnrollment/01_DDL/107_ NF-409 _WTB_Platform_NewTable_AuthenticationType.sql Database Objects/OnlineEnrollment/07_Data/268_ NF-409 _WTB_Platform_NewData_PageLevelAccess.sql Database Objects/OnlineEnrollment/07_Data/269_ NF-409 _WTB_Platform_NewData_APIServices.sql Database Objects/OnlineEnrollment/07_Data/270_ NF-409 _WTB_Platform_NewData_APIServiceEndpoints.sql Database Objects/OnlineEnrollment/07_Data/271_ NF-409 _WTB_Platform_NewData_AuthenticationType.sql Shared Library/SharedFunction/SharedFunction/WORKTERRASharedFunction.cs Shared Library/ValueObjects/ValueObjects/ValueObjects.csproj Shared Library/ValueObjects/ValueObjects/WORKTERRA/APIStatusTrigger.cs Shared Library/WORKTERRALocalization/WORKTERRAResource.Designer.cs Shared Library/WORKTERRALocalization/WORKTERRAResource.en-GB.Designer.cs Shared Library/WORKTERRALocalization/WORKTERRAResource.en-GB.resx Shared Library/WORKTERRALocalization/WORKTERRAResource.es-mx.Designer.cs Shared Library/WORKTERRALocalization/WORKTERRAResource.es-mx.resx Shared Library/WORKTERRALocalization/WORKTERRAResource.fr-CA.Designer.cs Shared Library/WORKTERRALocalization/WORKTERRAResource.fr-CA.resx Shared Library/WORKTERRALocalization/WORKTERRAResource.resx Web/Web Projects/WORKTERRA/Areas/Configuration/Controllers/APIStatusMapping Web/Web Projects/WORKTERRA/Areas/Configuration/Controllers/APIStatusMapping/APIStatusMappingController.cs Web/Web Projects/WORKTERRA/Areas/Configuration/Models/APIStatusMapping Web/Web Projects/WORKTERRA/Areas/Configuration/Models/APIStatusMapping/APIStatusMappingModel.cs Web/Web Projects/WORKTERRA/Areas/Configuration/Views/Configuration/APIStatusMapping Web/Web Projects/WORKTERRA/Areas/Configuration/Views/Configuration/APIStatusMapping/_APIStatusMappingPV.cshtml Web/Web Projects/WORKTERRA/Areas/Configuration/Views/Configuration/APIStatusMapping/APIStatusMapping.cshtml Web/Web Projects/WORKTERRA/WORKTERRAShared.csproj
            ramya.tantry Ramya Tantry (Inactive) logged work - 17/Mar/17 09:02 AM
            • Time Spent:
              4.5h
               

              Additional changes done.
              Discussion with Saurabh
              Checkin to trunk,LB and UI refresh branch

            ramya.tantry Ramya Tantry (Inactive) made changes -
            Remaining Estimate 3h [ 10800 ] 0h [ 0 ]
            Time Spent 29h [ 104400 ] 33.5h [ 120600 ]
            Worklog Id 32000 [ 32000 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            Hide
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Hi Prasad Pise,

            Please verify the enhancement using below URL:

            [Site URL]/Platform/Configuration/Configuration/APIStatusMapping

            Please replace the site URL of the environment on which you are testing.

            As this is page is not to be exposed to client,we have not implemented any menu action for the same.

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Hi Prasad Pise , Please verify the enhancement using below URL: [Site URL] /Platform/Configuration/Configuration/APIStatusMapping Please replace the site URL of the environment on which you are testing. As this is page is not to be exposed to client,we have not implemented any menu action for the same.
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Assignee Ramya Tantry [ ramya.tantry ] Prasad Pise [ prasadp ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            prasadp Prasad Pise (Inactive) made changes -
            Link This issue relates to NF-410 [ NF-410 ]
            prasadp Prasad Pise (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
            prasadp Prasad Pise (Inactive) made changes -
            Link This issue relates to NF-567 [ NF-567 ]
            Hide
            prasadp Prasad Pise (Inactive) added a comment -

            Hi Ramya Tantry

            I have completed testing for this enhancement on LB. Please refer attached test cases.
            Also, I have reported one issue. Please refer NF-567 for more details.

            I will mark this ticket as Ready for Stage once NF-567 gets resolved.

            CC: Saurabh SablakaRakesh RoyKunal Kedari

            Thanks
            -Prasad

            Show
            prasadp Prasad Pise (Inactive) added a comment - Hi Ramya Tantry I have completed testing for this enhancement on LB. Please refer attached test cases. Also, I have reported one issue. Please refer NF-567 for more details. I will mark this ticket as Ready for Stage once NF-567 gets resolved. CC: Saurabh Sablaka Rakesh Roy Kunal Kedari Thanks -Prasad
            prasadp Prasad Pise (Inactive) made changes -
            Attachment TC_TSR_NF-409 API Status Mapping Page.xls [ 42598 ]
            prasadp Prasad Pise (Inactive) logged work - 18/Mar/17 05:55 PM
            • Time Spent:
              4.5h
               

              Test Execution, Internal Discussions Test Case Writing on LB

            prasadp Prasad Pise (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
            prasadp Prasad Pise (Inactive) made changes -
            Original Estimate 32h [ 115200 ] 38h [ 136800 ]
            prasadp Prasad Pise (Inactive) made changes -
            Time Spent 33.5h [ 120600 ] 38h [ 136800 ]
            Worklog Id 32222 [ 32222 ]
            prasadp Prasad Pise (Inactive) made changes -
            Status Local Testing [ 10200 ] Pending for Stage Approval [ 10300 ]
            prasadp Prasad Pise (Inactive) made changes -
            Status Pending for Stage Approval [ 10300 ] Approved for Stage [ 10030 ]
            ramya.tantry Ramya Tantry (Inactive) logged work - 22/Mar/17 04:54 AM
            • Time Spent:
              0.5h
               

              Stage checkins

            ramya.tantry Ramya Tantry (Inactive) made changes -
            Time Spent 38h [ 136800 ] 38.5h [ 138600 ]
            Worklog Id 32793 [ 32793 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
            prasadp Prasad Pise (Inactive) made changes -
            Status Approved for Stage [ 10030 ] Stage Testing [ 10201 ]
            prasadp Prasad Pise (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224)
            Hide
            prasadp Prasad Pise (Inactive) added a comment -

            Testing completed on Stage.

            Show
            prasadp Prasad Pise (Inactive) added a comment - Testing completed on Stage.
            prasadp Prasad Pise (Inactive) logged work - 27/Mar/17 02:09 PM
            • Time Spent:
              0.5h
               

              Testing on Stage

            prasadp Prasad Pise (Inactive) made changes -
            Time Spent 38.5h [ 138600 ] 39h [ 140400 ]
            Worklog Id 34056 [ 34056 ]
            shyam.sharma shyam sharma (Inactive) made changes -
            Sprint NF Sprint 6 [ 47 ]
            shyam.sharma shyam sharma (Inactive) made changes -
            Rank Ranked higher
            prasadp Prasad Pise (Inactive) made changes -
            Link This issue relates to NF-52 [ NF-52 ]
            ramya.tantry Ramya Tantry (Inactive) logged work - 24/Apr/17 12:29 PM - edited
            • Time Spent:
              2h
               

              Production checkins and build verification

            ramya.tantry Ramya Tantry (Inactive) made changes -
            Time Spent 39h [ 140400 ] 40h [ 144000 ]
            Worklog Id 40369 [ 40369 ]
            prasadp Prasad Pise (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Time Spent 40h [ 144000 ] 41h [ 147600 ]
            Worklog Id 40369 [ 40369 ]
            ashwin.wankhede Ashwin Wankhede (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
            ramya.tantry Ramya Tantry (Inactive) logged work - 25/Apr/17 04:57 PM
            • Time Spent:
              2.5h
               

              Production testing

            ramya.tantry Ramya Tantry (Inactive) made changes -
            Time Spent 41h [ 147600 ] 43.5h [ 156600 ]
            Worklog Id 40812 [ 40812 ]
            prasadp Prasad Pise (Inactive) made changes -
            Status Stage Testing [ 10201 ] Pending for Production Approval [ 10301 ]
            prasadp Prasad Pise (Inactive) made changes -
            Status Pending for Production Approval [ 10301 ] Approved for production [ 10034 ]
            prasadp Prasad Pise (Inactive) made changes -
            Status Approved for production [ 10034 ] Production Testing [ 10202 ]
            prasadp Prasad Pise (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production QA(10203)Level 1 values: In Testing(10218)
            Hide
            prasadp Prasad Pise (Inactive) added a comment -

            Testing completed on production.

            CC: Kunal KedariRakesh RoyRamya TantrySaurabh Sablaka

            Show
            prasadp Prasad Pise (Inactive) added a comment - Testing completed on production. CC: Kunal Kedari Rakesh Roy Ramya Tantry Saurabh Sablaka
            prasadp Prasad Pise (Inactive) made changes -
            prasadp Prasad Pise (Inactive) made changes -
            Attachment TC_TSR_NF-409 API Status Mapping Page.xls [ 42598 ]
            prasadp Prasad Pise (Inactive) logged work - 26/Apr/17 12:30 PM
            • Time Spent:
              0.75h
               

              Testing on Production

            prasadp Prasad Pise (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            prasadp Prasad Pise (Inactive) made changes -
            Time Spent 43.5h [ 156600 ] 44.25h [ 159300 ]
            Worklog Id 40986 [ 40986 ]
            prasadp Prasad Pise (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: In Testing(10218) Parent values: Production Complete(10222)
            prasadp Prasad Pise (Inactive) made changes -
            Status Production Complete [ 10028 ] Closed [ 6 ]
            Transition Time In Source Status Execution Times
            Ramya Tantry (Inactive) made transition -
            New Request Pending for Approval
            8d 18h 40m 1
            Ramya Tantry (Inactive) made transition -
            Pending for Approval Approved for Development
            2s 1
            Ramya Tantry (Inactive) made transition -
            Approved for Development In Development
            3s 1
            Ramya Tantry (Inactive) made transition -
            In Development In LB Testing
            3h 4m 1
            Prasad Pise (Inactive) made transition -
            In LB Testing Pending for Stage Approval
            2d 17h 59m 1
            Prasad Pise (Inactive) made transition -
            Pending for Stage Approval Approved for Stage
            6s 1
            Prasad Pise (Inactive) made transition -
            Approved for Stage Stage Testing
            7d 3h 1
            Prasad Pise (Inactive) made transition -
            Stage Testing Pending for Production Approval
            29d 21h 28m 1
            Prasad Pise (Inactive) made transition -
            Pending for Production Approval Approved for production
            2s 1
            Prasad Pise (Inactive) made transition -
            Approved for production In Production Testing
            2s 1
            Prasad Pise (Inactive) made transition -
            In Production Testing Production Complete
            6h 3m 1
            Prasad Pise (Inactive) made transition -
            Production Complete Closed
            2m 8s 1

              People

              Assignee:
              prasadp Prasad Pise (Inactive)
              Reporter:
              prasadp Prasad Pise (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Code Review Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 38h Original Estimate - 38h
                  38h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 44.25h
                  44.25h