Last post Feb 28, 2018 10:15 AM by DA924
Feb 27, 2018 07:15 AM|Cloudfiers|LINK
Hi Good Day to all,
I have a web site in ASP.NET(C#). And I want to add an automatic email sending functionality in it, i.e. an email will be send if reach the MINQTY and MAXQTY vs ACTUAL INVENTORY to all the stock holders about the orders details placed by registered users.
I have two Tables which is
How can I do this in asp.net(C#)? any idea?, could you please give me an reference related my problem above, thank you.
Feb 28, 2018 10:15 AM|DA924|LINK
If using MS SQL Server or similar type database like Oracle, then you can use an insert or update table trigger that calls a database function that can use the database's email stored procedure to send the emails.
Or you can call a database function or stored procedure from C# code, that can use the database's stored procedure to send the emails, based on registered uses, which I would assume are kept in a user table.
Or you could call on MS SQL Server Service Broker to do the emailing too.
All of this is about you are going to have to do your homework, and find out how to use the technologies..