none
How Create Maker-Checker functionality in MVC using ADO.Net? RRS feed

  • Question

  • I want to Create Simple Maker-Checker demo in MVC using ADO.Net technology.

    For example if one user insert or update any record another user should verify that record.

    UserA and UserB

    If UserA Create New Record or update existing record then UserB will only authorized that record.

    I want to implement this maker-checker in MVC

    • Moved by CoolDadTx Wednesday, September 12, 2018 1:43 PM ASP.NET related
    Wednesday, September 12, 2018 4:32 AM

All replies

  • You can update table and add more columns as below - 

    Maker- user Id who add/update that table

    Checker- user Id who will approve that change

    Status - Like Approved/Rejected/Pending Approval

    DateApproved - DateTime when approved

    For retrieval - you can query only approved status record only

    Lets say User A update a record and it will update that record with Pending approval,Maker user Id

    Check will approve the change - it will update table with Checker Id and Date approval

    You can twik this as per your flow.


    Thanks,
    Vivek Bansod
    Blog | MSDN | LinkedIn
     

    Wednesday, September 12, 2018 12:52 PM
  • Please post questions related to MVC in the ASP.NET forums.

    Michael Taylor http://www.michaeltaylorp3.net

    Wednesday, September 12, 2018 1:43 PM