Send Mass Emails using Database Queue in ASP.NET, C#¶

using System;
using System.Text;

// Add EASendMail namespace
using EASendMail;

namespace mysendemail
{
    class Program
    {
        static void Main(string[] args)
        {
            try
            {
                SmtpMail oMail = new SmtpMail("TryIt");

                // Set sender email address, please change it to yours
                oMail.From = "test@emailarchitect.net";
                // Set email subject
                oMail.Subject = "test email from c# project";

                // If you want EASendMail service to send the email after 10 minutes,
                // use the following code.
                // oMail.Date = System.DateTime.Now.AddMinutes(10);

                // change it to your sql server address, database, user and password.
                // The server/instance name syntax used in the server option is the same for all SQL Server connection strings.
                // e.g.: Server=serveraddress\\instancename;
                // EASendMail will use the following connection to connect to the database,
                // the syntax is same as ADO connection object.

                // SQL 2005
                oMail.Headers.ReplaceHeader("X-Data-Connection",
                    "Driver={SQL Native Client};Server=serveraddress;Database=database;Uid=user;Pwd=password;");

                // MS SQL Server 2005 Native provider
                // oMail.Headers.ReplaceHeader("X-Data-Connection",
                //      "Provider=SQLNCLI;Server=serveraddress;Database=database;Uid=user;Pwd=password;");

                // MS SQL Server 2008
                // oMail.Headers.ReplaceHeader("X-Data-Connection",
                //"Driver={SQL Server Native Client 10.0};Server=serveraddress;Database=database;Uid=myUsername;Pwd=myPassword;");

                // MS SQL Server 2008 Native provider
                //oMail.Headers.ReplaceHeader("X-Data-Connection",
                // "Provider=SQLNCLI10;Server=serveraddress;Database=database;Uid=user;Pwd=password;" );

                // MS SQL Server 2012
                // oMail.Headers.ReplaceHeader("X-Data-Connection",
                //"Driver={SQL Server Native Client 11.0};Server=serveraddress;Database=database;Uid=myUsername;Pwd=myPassword;");

                // MS SQL Server 2012 Native provider
                //oMail.Headers.ReplaceHeader("X-Data-Connection",
                // "Provider=SQLNCLI11;Server=serveraddress;Database=database;Uid=user;Pwd=password;");

                // EASendMail will select the fields by the following sql statement
                // before sending email, then pick the recipient address from specified field.
                oMail.Headers.ReplaceHeader("X-Sql-Select", "SELECT uid, name, email from rcpts");

                // pick "name" field as the recipient name and "email" field as
                // the recipient address.
                // you can also use {$var_srecord:fieldname} to pick any field
                // in X-Sql-Select statement and put it to subject, bodytext, then EASendMail will
                // replace it automatially.
                oMail.Headers.ReplaceHeader("To", "\"{$var_srecord:name}\" <{$var_srecord:email}>");
                oMail.Headers.ReplaceHeader("X-Rcpt-To", "{$var_srecord:email}");

                // EASendMail service will execute the following sql statement on
                // every email was sent successfully.
                oMail.Headers.ReplaceHeader("X-Sql-OnSentSuccess",
                    "INSERT INTO sentlog ( server, email ) VALUES( '{$var_server}', '{$var_rcptaddr}' )");

                // EASendMail service will execute the following sql statement on
                // every email could not be sent.
                oMail.Headers.ReplaceHeader("X-Sql-OnSentError",
                    "INSERT INTO errorlog( email, server, errorcode, errordescription )" +
                    " VALUES( '{$var_rcptaddr}', '{$var_server}', '{$var_errcode}', '{$var_errdesc}' )");

                string s = "Hi {$var_srecord:name}, \r\n";
                s += "this sample demonstrates how to send email using email queue.\r\n\r\n";
                s += "Your id in database is {$var_srecord:uid}.\r\n\r\n";
                s += "No matter how many recipients there are, EASendMail ";
                s += "service will send the email in background.\r\n\r\n";

                oMail.TextBody = s;
                // {$var_srecord:uid} {$var_srecord:name} {$var_srecord:email} in
                // body text will be replaced by EASendMail automatically.

                // Your SMTP server address
                SmtpServer oServer = new SmtpServer("smtp.emailarchitect.net");

                // User and password for ESMTP authentication
                oServer.User = "test@emailarchitect.net";
                oServer.Password = "testpassword";

                // Most mordern SMTP servers require SSL/TLS connection now.
                // ConnectTryTLS means if server supports SSL/TLS, SSL/TLS will be used automatically.
                oServer.ConnectType = SmtpConnectType.ConnectTryTLS;

                // If your SMTP server uses 587 port
                // oServer.Port = 587;

                // If your SMTP server requires SSL/TLS connection on 25/587/465 port
                // oServer.Port = 25; // 25 or 587 or 465
                // oServer.ConnectType = SmtpConnectType.ConnectSSLAuto;

                Console.WriteLine("start to send email ...");

                SmtpClient oSmtp = new SmtpClient();
                // You just need to change SendMail method to SendMailToQueue method in
                // your ASP.NET web application, then EASendMail uses queue to send email.
                // SendMailToQueue can be used in windows application as well.
                oSmtp.SendMailToQueue(oServer, oMail);

                // If you want to use SMTP server setting in EASendMail Service Manager, use
                // oSmtp.SendMailToQueue(null, oMail);

                Console.WriteLine("email was sent to queue successfully!");
            }
            catch (Exception ep)
            {
                Console.WriteLine("failed to send email with the following error:");
                Console.WriteLine(ep.Message);
            }
        }
    }
}