using System;
using System.Net;
using System.Net.Mail;

namespace YourNamespaceHere
{   
    public class SQLCLREmail
    {
        [Microsoft.SqlServer.Server.SqlProcedure]
        public void SendMail(string recipients, string CC, string BCC, string subject, string from, string body, string strAttachments, string strSMTPServer, int intSMTPServerPort, string strSMTPServerUser, string strSMTPServerPwd)
        {
            using (MailMessage MailMsg = new MailMessage())
            {
                MailMsg.From = new MailAddress(from);
                MailMsg.Subject = subject;
                MailMsg.Body = body;
                MailMsg.IsBodyHtml = true;

                if (!String.IsNullOrWhiteSpace(recipients))
                {
                    string[] strTo = recipients.Split(';');
                    foreach (string strRecip in strTo)
                    {
                        MailMsg.To.Add(new MailAddress(strRecip));
                    }
                }
            
                if (!String.IsNullOrWhiteSpace(CC))
                {
                    string[] strCCTo = CC.Split(';');
                    foreach (string strCCRecip in strCCTo)
                    {
                        MailMsg.To.Add(new MailAddress(strCCRecip));
                    }
                }

                if (!String.IsNullOrWhiteSpace(BCC))
                {
                    string[] strBCCTo = BCC.Split(';');
                    foreach (string strBCCRecip in strBCCTo)
                    {
                        MailMsg.To.Add(new MailAddress(strBCCRecip));
                    }
                }

                if (!String.IsNullOrWhiteSpace(strAttachments))
                {
                    string[] strAttach = strAttachments.Split(';');
                    foreach (string strFile in strAttach)
                    {
                        MailMsg.Attachments.Add(new Attachment(strFile.Trim()));
                    }
                }

                if (!String.IsNullOrWhiteSpace(strSMTPServer))
                {
                    SmtpClient smtp = new SmtpClient();
                    if (!String.IsNullOrWhiteSpace(strSMTPServerUser))
                    {
                        smtp.UseDefaultCredentials = false;
                        smtp.Credentials = new NetworkCredential(strSMTPServerUser, strSMTPServerPwd);
                        smtp.Host = strSMTPServer;
                        smtp.Port = intSMTPServerPort;

                        smtp.Send(MailMsg);
                    }
                    else
                    {
                        smtp.Host = "localhost";
                        smtp.Port = 25;
                        smtp.Send(MailMsg);
                    }
                }
            }
        }
    }
}