How do I send an email to specific users on my database automatically on a certain date, a step by step answer would be really appreciated

Question

1.50/5 (2 votes)

See more:

I am trying to send emails to users at maybe on the 7th that they hvnt paid their installments but not send emails to those that hv paid. I hv read about using window service but my problems are

0. Can I integrate it with my web application

1. I hv no control of the server it'd the school server.

I hv also read using hangfire but I dnt get it

What I have tried:

I am trying using windows services but my problem is that will I be able to integrate with my existing MVC application

Posted 4-Jul-16 20:27pm

Member 12618795

Updated 14-Jul-19 1:58am

#realJSOP

v2

Add a Solution

Comments

Suvendu Shekhar Giri 5-Jul-16 2:41am

Would like to request you to try something first, take the suggestion from Google result.
If you don't have access to the server then how are you deploying your application there?

Member 12618795 5-Jul-16 5:32am

I might be using the wrong term when I say I dnt have access to the server, but if I have to configure the server I dnt hv the privileges to do that..... what I can do is just deploy and view my deployed files on the server

Suvendu Shekhar Giri 5-Jul-16 5:40am

In that case try hangfire (although I haven't used it yet but seems to help your resolve your issue)

Member 12618795 5-Jul-16 6:25am

Thank you.....il try that

Richard MacCutchan 5-Jul-16 3:41am

hvnt, hv, dnt, it'd
Are these words?

Suvendu Shekhar Giri 5-Jul-16 5:33am

dnt, sayvi
:D

Member 12618795 5-Jul-16 5:36am

Forgive me for using short hand. Hvnt- have not, hv - have, dnt-do not,

Richard MacCutchan 5-Jul-16 8:43am

It's the sort of childish script that makes us think you are a child.

Member 12618795 5-Jul-16 9:51am

Mr rude and know it all, I did not know that this platform was for people who know how to do everything. If you know how to do everything good for you, but let the people that don't know ask, every child crawls before they can walk..... if you want to be rude please just ignore posts.

Richard MacCutchan 5-Jul-16 10:26am

And if you want to be taken seriously please do not use childish txtspk.

MadMyche 14-Jul-19 7:46am

Your shorthand can limit quality responses- not everyone here uses English as their primary language and of those that do if they may not know what your SMS friendly abbreviations mean.

2 solutions

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)

#realJSOP · Answer 1 · 2019-07-14T01:18:00

If your DBA was smart (or even just a little self-aware), he will have turned off the ability to send emails from the database. You can ask him, but be prepared for a negative response.

Sending emails from a web site is beyond trivial. When the user logs on, send the email to him if appropriate, or when an admin logs on, he can be notified that there are pending emails to be sent, and he can click a button to send all of the pending emails at the same time. Caveat - either of these two options require that a human log onto the web site in order to send the emails.

Your only real option is to create a Windows service that performs the neccessary check on a daily basis (hopefully when the database server is least busy), and sends any emails that need to be sent. This will require a number of moving parts to implement, but it is by far the best solution because a windows service runs even when nobody is logged onto the server, and requires absolutely no human intervention.

Advice based on comments you've received:

"Shorthand" for you is gibberish to us. You're on a programmer's forum, asking for *our* help. It's hard enough for us to deal with unintentionally broken English (and we do it EVERY DAY), we don't need people INTENTIONALLY breaking English. Use complete words (even if they might be the wrong words), because not doing so just pisses off the adults.

Finally, every real programmer knows that all lists start with 0. I'm going to go ahead and fix your crass mistake, but please remember this in the future.

MadMyche · Answer 2 · 2019-07-14T01:59:00

Solution 3

So you have an MVC application already & limited other access to servers.

What I would do is your option #3: Integrate into your existing web application.

1. Create a class for those who will get emails: InstallmentMissed
2. Create another class for InstallmentMissedLastRun
3. Create a Controller and an Action to utilize #1 & 2.
4. Create a scheduled task on some computer to hit the URL associated to #3

Posted 14-Jul-19 1:59am

MadMyche

Comments

Dave Kreskowiak 14-Jul-19 10:10am

3 years old.

MadMyche 14-Jul-19 12:45pm

Obviously I did not see that before I replied