Collect data from user by using e-mail messages in asp.net

Question

1.00/5 (3 votes)

See more:

SQL-Server-2008

, +

Hi,

I have a table structure like below-
Product_Request_Id, Product_Name, Approver_ID, Approve_Status, Approve_Remarks in table called Product_Details

and

In ASP.NET (C#) Web Applicaiton Project - When end User Request for a Product, System will send Auto-mail to the Shelling Manager for Approve. So Shelling Manager will Approve/Reject that Request in Application as of now.. Now we got new requirement as either he can Approve/Reject in Application itself or he can simply reply to mail Subject as Approve/Reject with Request_ID. Show system should capture it and update it in Database.

[EDTI #1]
In Project - When end User Request for a Product, System will send Auto-mail to the Shelling Manager for Approve. So Shelling Manager will Approve/Reject that Request in Application as of now.. Now we got new requirement as either he can Approve/Reject in Application itself or he can simply reply to mail Subject as Approve/Reject with Request_ID. Show system should capture it and update it in Database.
[/EDIT]

I don't have any idea how to do this.. So I con't tell you where I will store incoming mails.. I want to know this how to achieve.

how can we achieve it. Please reply..

Thanks in advance..

Thanks,
Madan.

Posted 6-Jun-13 1:53am

madan2k6

Updated 7-Jun-13 6:34am

Maciej Los

v5

Add a Solution

Comments

joshrduncan2012 6-Jun-13 9:13am

What have you tried so far to accomplish this?

madan2k6 7-Jun-13 1:01am

Hi,
As of now our application is sending mail to person as telling "you have a request (Request ID) to approve, Please approve it" and in the same mail we where sending URL as a link to approve it.
But Since clients are requesting to implement some thing like when we reply to same mail instead of clicking link and approve the request, system should capture the mail as Approve or Reject and update in database.. since they are accessing mails in their office Intranet network to click on link in mail and approve it is not accessible for them..

Our database table have field like Request_ID, Appprove_Status, Approve_By, Approved_Date, Etc.. When they include Approve/Reject in the mail with remarks then system should capture it and update in database..

So, how can we achieve it. ??

Thanks,
Madan.

joshrduncan2012 7-Jun-13 9:10am

Descriptions of your attempts so far are useless. Please use "improve question" and post your code as to what you have accomplished.

Maciej Los 6-Jun-13 11:12am

We don't see the structure of your database and we don't see the project, concept, etc.
You need to be more specific if want our help.
Use "Improve question" widget to update your question.
ASAP - if something is ASAP for you, it doesn't mean that is ASAP for us ;(

madan2k6 7-Jun-13 1:03am

Dear Los,
Since I digging for this loggic in google for a week to impliment it i just include ASAP in it..

Thanks,
Madan.

Maciej Los 7-Jun-13 1:52am

Your information is totally useless... ;(
Thank you for removing ASAP.

These words are topical still: "You need to be more specific if want our help. Use "Improve question" widget to update your question."

madan2k6 7-Jun-13 3:22am

Im sorry..
What exactly you are telling that I didnt give full information.. can you give subjection...??

Thanks,
Madan.

Maciej Los 7-Jun-13 3:43am

Please, read my first comment to your question, especially sentence: "We don't see the structure of your database and we don't see the project, concept, etc."
Where do you store incoming mails with approving or rejecting message?

madan2k6 7-Jun-13 4:40am

Ok Los,
I a table structure like belo-
Product_Request_Id, Product_Name, Approver_ID, Approve_Status, Approve_Remarks in table called Product_Details

and

In Project - When end User Request for a Product, System will send Auto-mail to the Shelling Manager for Approve. So Shelling Manager will Approve/Reject that Request in Application as of now.. Now we got new requirement as either he can Approve/Reject in Application itself or he can simply reply to mail Subject as Approve/Reject with Request_ID. Show system should capture it and update it in Database.

I don't have any idea how to do this.. So I cont tell you where I will store incoming mails.. I want to know this how to achieve..

Thanks,
Madan.

Maciej Los 7-Jun-13 4:55am

I wrote in a past comment: "Use 'Improve question' widget to update your question".
My name is Maciej. So, please, don't use my Surame when you call me, OK?

madan2k6 7-Jun-13 6:00am

Im sorry.. ok Maciej ..

JasonMacD 7-Jun-13 12:39pm

Sorry madan2k6, Maciej Los (or Los) is a bit testy and acts like this is his site and he rules the world, get over yourself Los. Pay him no mind, all you trying to do is find some help.

Sergey Alexandrovich Kryukov 7-Jun-13 1:01am

Sorry, I checked my schedule and found it not urgent at all.
—SA

madan2k6 7-Jun-13 1:11am

Dear Sergey Alexandrovich,
I didn't understand what you are talking about.. I didn't schedule any thing..

Thanks,
Madan.

Sergey Alexandrovich Kryukov 7-Jun-13 1:14am

Then please read my post again. I scheduled. Maybe other members, too. There is no need to tell us that something is urgent.
You can only accelerate the resolution of a problem by good quality of your questions.
—SA

madan2k6 7-Jun-13 1:27am

Ok sure.. I will take care it from now...

Thanks,
Madan.

Sergey Alexandrovich Kryukov 7-Jun-13 1:42am

Thank you for understanding.
—SA

1 solution

Add a Solution

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)

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Answer 1 · 2013-06-07T07:16:00

The workaround may be either of the below.

Window Service, which will be scheduled to read incoming mails from the mail server/mail storage folder and update the database accordingly by checking the subject and data inside the mail.
- Simulate a Windows Service using ASP.NET to run scheduled jobs[^]
- How do I read incoming mail using C#[^]
A POP3 email client which will read emails as it pops up in mail server and updates accordingly.

Note

And if you check the right side bottom box in these links saying "Related Articles", you will get many more article on this same topic.

Good luck... :)