public static void SendEmail(MailMessage message)
{
try
{
SimplicityCommLib.DataSets.Common.EmailQueueTableAdapters.EmailQueueTableAdapter ta = new SimplicityCommLib.DataSets.Common.EmailQueueTableAdapters.EmailQueueTableAdapter();
string toEmails = "";
string toNames = "";
foreach(MailAddress address in message.To)
{
toNames += address.DisplayName + ",";
toEmails += address.Address + ",";
}
//ta.Connection = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["ShoppingCartConnectionString"].ConnectionString);
ta.Insert(DateTime.Now, 1, "Simplicity4Business", FROM_ADDRESS, toNames.Substring(0, toNames.Length - 1), toEmails.Substring(0, toEmails.Length),
message.Subject, message.Body, null);
}
catch (Exception ex)
{
}
}
private void SendEmails(object state)
{
try
{
SmtpClient smtp = new SmtpClient(SMTP_SERVER);
NetworkCredential userInfo = new NetworkCredential(USER_NAME, PASSWORD);
smtp.UseDefaultCredentials = false;
smtp.Credentials = userInfo;
SimplicityCommLib.DataSets.Common.EmailQueueTableAdapters.EmailQueueTableAdapter emailQTA = new SimplicityCommLib.DataSets.Common.EmailQueueTableAdapters.EmailQueueTableAdapter();
Log("Connection String:" + System.Configuration.ConfigurationSettings.AppSettings["DataAccessLayer.database.ConnectionString"],EventLogEntryType.Information);
//emailQTA.Connection = new System.Data.SqlClient.SqlConnection(@"Data Source=270882-WEB2\SQLEXPRESS;Initial Catalog=shop;Integrated Security=False;User Id=sa;password=3400663");
IEnumerator<SimplicityCommLib.DataSets.Common.EmailQueue.EmailQueueRow> ieEmails = emailQTA.GetRemaingQueue().GetEnumerator();
while(ieEmails.MoveNext())
{
try
{
MailMessage message = new MailMessage();
message.From = new MailAddress(ieEmails.Current.FromAddress, ieEmails.Current.FromName);
string[] toNames = ieEmails.Current.ToNames.Split(',');
string[] toAddresses = ieEmails.Current.ToAddresses.Split(',');
for (int index = 0; index < toAddresses.Length; index++)
{
if (toAddresses[index].Length > 0)
{
message.To.Add(new MailAddress(toAddresses[index], toNames[index]));
}
}
message.Subject = ieEmails.Current.Subject;
message.Body = ieEmails.Current.Body;
message.IsBodyHtml = true;
smtp.Send(message);
ieEmails.Current.SentTime = DateTime.Now;
emailQTA.Update(ieEmails.Current);
Log("Queue Id:" + ieEmails.Current.QueueId + " processed.", EventLogEntryType.Information);
}
catch (Exception ex)
{
Log("Queue Id:" + ieEmails.Current.QueueId + " errored.", EventLogEntryType.Error);
Log(ex.ToString(), EventLogEntryType.Error);
}
}
emailQTA.UpdateNumberOfTries();
}
catch (Exception ex)
{
//Log("Connection String:);
Log(ex.ToString(), EventLogEntryType.Error);
}
}
