Embed Link in Email with Information to Write to Database

Question

User564995064 posted

Hi all!

In my application, we have to send an email out to have a person's information verified.  I would like the email to have a Confirm and a Cannot Confirm button.  When the recipient presses the Confirm button, it will redirect to my site and write a 'Y' in the confirmed field in the database for the person we are confirming.  Likewise, it will write a 'N' if the recipient presses the Cannot Confirm button. (This can be buttons or links, doesn't matter.)  I do not want to include the social security number for the person for obvious reasons, but I can include enough information like name, employer, etc to ensure it is the correct person.  My question is how do I structure the url in the link to get to my site and complete this task.

Thanks for any assistance you can give.

Answer 1

User475983607 posted

Simple, generate a unique key. 

Create database table to save the unique key and any other information you need.  Create a new Action or Web Page to process the email confirmation.   Add a link in the confirmation email that points to the new Action or Web Page and append the key to the URL querystring.

The new page reads the querystring unique key, queries the table to fetch the stored data, then process the confirmation.

Answer 2

User-369506445 posted

hi

according mgebhard post , here a sample for register and confirm with email, you can try it and change to your scenario

please follow below link:

https://www.codeproject.com/Tips/738090/ASP-NET-MVC-Confirm-Registration-Email

another sample about Account Confirmation and Password Recovery

https://docs.microsoft.com/en-us/aspnet/identity/overview/features-api/account-confirmation-and-password-recovery-with-aspnet-identity

https://docs.microsoft.com/en-us/aspnet/core/security/authentication/accconfirm?view=aspnetcore-2.1&tabs=aspnetcore2x