I have very complex requirement in one of the asp.net application . user defines the rules dynamically in asp.net page. and saves the Rule defnition into database.
For ex
Rule1
Name status
Country Status
Rule2
City status
so on
I need to store the values in to datatbase when the above rules satisfy i need to send recurrence email.
can some body advise me how can i implement how should be the table design
i dont think storing those rule values in database is a problem...but if wanted to send emails on completion of these rules then write some triggers in sql which willsend email form sql environment, or else you can write a simple windows service or schedule
an exe in task scheduler to send email on periodic basis....
pprakashaii
0 Points
1 Post
Rules defined in the asp.net template
Aug 08, 2012 01:29 AM|LINK
Hi,
I have very complex requirement in one of the asp.net application . user defines the rules dynamically in asp.net page. and saves the Rule defnition into database.
For ex
Rule1
Name status
Country Status
Rule2
City status
so on
I need to store the values in to datatbase when the above rules satisfy i need to send recurrence email.
can some body advise me how can i implement how should be the table design
Regards
Pat
pradeep shar...
Contributor
3988 Points
760 Posts
Re: Rules defined in the asp.net template
Aug 08, 2012 04:42 AM|LINK
do you want send these automically or by hitting some button on front end
if you want to send mail using db automatically use sql agent mail functionality
http://www.techrepublic.com/article/sending-e-mail-with-database-mail-in-sql-server-2005/6164310
ramiramilu
All-Star
95503 Points
14106 Posts
Re: Rules defined in the asp.net template
Aug 08, 2012 06:07 PM|LINK
i dont think storing those rule values in database is a problem...but if wanted to send emails on completion of these rules then write some triggers in sql which willsend email form sql environment, or else you can write a simple windows service or schedule an exe in task scheduler to send email on periodic basis....
send email in sql - http://blog.netnerds.net/2008/02/create-a-basic-sql-server-2005-trigger-to-send-e-mail-alerts/
windows service - http://www.intstrings.com/ramivemula/articles/sending-automated-emails-asynchronously-using-a-c-windows-service-in-conjunction-with-database-email-records-part-i/
Thanks,
JumpStart