Click here to Skip to main content
15,894,539 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
In working on website where the user have to take a year membership to use it I need to notify him before 30 days via mail of expiration date. My mail code is working properly but i don't know when to Fire the Event.
plz Provide me solution where where I can call the event which will notify the the user that Expiry date is less than 30 days.
Posted

1 solution

You can create windows service which will be checking for that once a day an sending email if necessary.
Or checking this from SQL server
http://msdn.microsoft.com/en-us/library/ms191439%28v=sql.105%29.aspx[^]
and sending emails from it:
SQL SERVER - 2008 - Configure Database Mail - Send Email From SQL Database[^]

Or you can create Wcf service executed from Task Scheduler.
Or something different. It depends what you want.
 
Share this answer
 

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900