Multiple Approval System in asp.net C#

Question

0.00/5 (No votes)

See more:

i have a Project in which user send a request to change data and insert data which is to be changed. It will go to admin for approval. If admin approve that request , it will change to main database and if not it should not change. Problem is, i have lot of fields in my database. Suppose user sends a request to change 5 fields in database and sends data to be changed, it all depends upon admin he might accept only one or two or all.
how can i manage this? Really stuck in it

Posted 20-May-13 21:00pm

Sunil Dhanerwal1

Add a Solution

Comments

Prasad Khandekar 21-May-13 3:09am

One simple way that worked for me is to store the changed data in a serialized (JSON) form in some table say undo_table. Then in approval page use the original record along with this serialized data and ask administrator to select the fields he is interested in approving via (checkbox). Upon submit only update the checked fields.

Sunil Dhanerwal1 21-May-13 3:13am

Thanks for your quick reply prasad. This is what i was thinking but i am confused about the thing how i come to know at tun time which fields user has demanded to change?
one more thing, Do i need to make table (undo_table) with same fields as in original table?
Any help will be appreciated. if possible plz suggest any link or aexample

Sunasara Imdadhusen 21-May-13 3:23am

Have you tried anything before?

Sunil Dhanerwal1 21-May-13 3:25am

never faced this type of query. I think i might add bool value for each changed field demanded by user but looks like that too lengthy and might not work.

Mahesh Bailwal 21-May-13 3:41am

Instead using bool value for each changed field you can also think about using Nullable Types, where changed field will have value and other fields will have NULL value.

Sunil Dhanerwal1 21-May-13 3:53am

Thanks Mahesh Sir for Valuable reply. It reduces my some confusions. With the help of nullable data type , i can understand which fields user has demanded to change but admin want each fields seperately for approval. How should i mange this?

Sunil Dhanerwal1 21-May-13 5:21am

Any Solution???

Mahesh Bailwal 21-May-13 6:06am

So you don't want to pass fields separately for approval to the admin or something else?

Sunil Dhanerwal1 21-May-13 6:15am

Actually requirement is to pass fields separately to admin. Now, If i store them in a single table and if user demand changes in more than one field then how can i pass them separately to admin?
One more thing, How should i avail look of a form to user so that he can exactly put what he want to change in database.
Sir, actually problem is i m stick in this and my mind is not working at all. Can you please give me full detail how to handle such situation where multiple approval is required.
Any help will be appreciated

Mahesh Bailwal 21-May-13 6:35am

Sunil, I can understand your situation but providing whole solution is not possible for me as I never worked on this sort of requirement. I hope someone else can help you. Sorry :(

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)