Last post Sep 24, 2019 03:20 AM by Fei Han - MSFT
Sep 23, 2019 08:15 PM|Roopesh1986|LINK
Hi, Required an expert opinion. I have an existing MVC web application project build on VS2017 & SQL 2017. What is the easiest method to build multi level approval process. My scenario is as follows, logged in users will be submitting some details of a product
( name, model, country of origin etc) with it's photos through the View Page. The Manager will be reviewing the submitted data and will input his comments and will approve or reject. Once Manager Approved the GM will review the same info and will approving
or rejecting with his comments. The notifications on the changes has to be pushed to the users as well.
Sep 23, 2019 10:16 PM|bruce (sqlwork.com)|LINK
its depends on the review and approval detail. but basically add review and approval columns at the data level. the use roles/claims for the approval process actions.
next will depend on the complexity of approval chain (who is a manger of who). can manger have approval anyone, or just their reports?
Sep 24, 2019 03:20 AM|Fei Han - MSFT|LINK
According to your description, it is an existing MVC application with database, to add approval process functionality, you may need to modify/add new tables to store data bout approval requests and process details, and as bruce mentioned, you may need
to maintain approval request-Manager-GM to control approval chain.
For functionality of sending/pushing notifications to the users, you can achieve it by sending email or using [SignalR](https://docs.microsoft.com/en-us/aspnet/signalr/overview/getting-started/tutorial-getting-started-with-signalr-and-mvc)
in your web application.
Note: please backup your database and web application first before you do modifications or updates on it.