public static bool Add(Mail mail)
{
var result = false;
try
{
using (SqlConnection sqlConnection = DBUtil.CreateConnection(ConnectionSource.Communication))
using (SqlCommand cmd = new SqlCommand(InsertCommandText, sqlConnection))
{
cmd.Connection.Open();
bool hasAttachment = false;
if (mail.Attachments != null && mail.Attachments.Any())
{
hasAttachment = true;
}
mail.From = PrepareMailAddress(mail.From);
mail.ToRecipient = PrepareMailAddress(mail.ToRecipient);
mail.CcRecipients = PrepareMailAddress(mail.CcRecipients);
mail.BccRecipients = PrepareMailAddress(mail.BccRecipients);
if (MailQueueing != null)
{
var subs = MailQueueing.GetInvocationList();
foreach (MailQueueingEventHandler sub in subs)
{
sub.Invoke(mail);
}
}
string body = NheaMailingStarter;
MailParameters mailParameters = new MailParameters
{
Version = "2",
Body = mail.Body,
ListUnsubscribe = mail.ListUnsubscribe,
PlainText = mail.PlainText,
IsBulkEmail = mail.IsBulkEmail,
UnsubscribeOneClick = mail.UnsubscribeOneClick
};
body += JsonConvert.SerializeObject(mailParameters);
cmd.Parameters.Add(new SqlParameter("@From", mail.From));
cmd.Parameters.Add(new SqlParameter("@To", mail.ToRecipient));
cmd.Parameters.Add(new SqlParameter("@Cc", mail.CcRecipients));
cmd.Parameters.Add(new SqlParameter("@Bcc", mail.BccRecipients));
cmd.Parameters.Add(new SqlParameter("@Subject", mail.Subject));
cmd.Parameters.Add(new SqlParameter("@Body", body));
cmd.Parameters.Add(new SqlParameter("@PriorityDate", mail.Priority));
cmd.Parameters.Add(new SqlParameter("@MailProviderId", DBNull.Value));
cmd.Parameters.Add(new SqlParameter("@IsReadyToSend", !hasAttachment));
cmd.Parameters.Add(new SqlParameter("@HasAttachment", hasAttachment));
if (!String.IsNullOrEmpty(mail.ToRecipient))
{
int?mailProviderId = MailProvider.Find(mail.ToRecipient);
if (mailProviderId.HasValue)
{
cmd.Parameters["@MailProviderId"].Value = mailProviderId.Value;
}
}
Guid id = (Guid)cmd.ExecuteScalar();
if (hasAttachment)
{
foreach (var mailQueueAttachment in mail.Attachments)
{
using (SqlCommand attachmentCommand = new SqlCommand(InsertAttachmentCommandText, cmd.Connection))
{
attachmentCommand.Parameters.Add(new SqlParameter("@MailQueueId", id));
attachmentCommand.Parameters.Add(new SqlParameter("@AttachmentName", mailQueueAttachment.Name));
attachmentCommand.Parameters.Add(new SqlParameter("@AttachmentData", mailQueueAttachment.Data));
attachmentCommand.ExecuteNonQuery();
}
}
using (SqlCommand setStatusCommand = new SqlCommand(String.Format(UpdateStatusCommandText, "1"), sqlConnection))
{
setStatusCommand.Parameters.Add(new SqlParameter("@MailQueueId", id));
setStatusCommand.ExecuteNonQuery();
sqlConnection.Close();
}
}
cmd.Connection.Close();
result = true;
}
}
catch (Exception ex)
{
Logger.Log(ex, false);
}
if (MailQueued != null)
{
var subs = MailQueued.GetInvocationList();
foreach (MailQueuedEventHandler sub in subs)
{
sub.Invoke(mail, result);
}
}
return(result);
}
public static List <Mail> Fetch(MailProvider mailProvider)
{
List <Mail> mailList = new List <Mail>();
int mailProviderId = 0;
int packageSize = 25;
string cmdText = NullableSelectCommandText;
if (mailProvider != null)
{
mailProviderId = mailProvider.Id;
cmdText = SelectCommandText;
packageSize = mailProvider.PackageSize;
}
using (SqlConnection sqlConnection = DBUtil.CreateConnection(ConnectionSource.Communication))
using (SqlCommand cmd = new SqlCommand(cmdText, sqlConnection))
{
cmd.Connection.Open();
if (mailProvider != null)
{
cmd.Parameters.Add(new SqlParameter("@MailProviderId", mailProviderId));
}
cmd.Parameters.Add(new SqlParameter("@PackageSize", packageSize));
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Mail mail = new Mail();
mail.Id = reader.GetGuid(0);
try
{
mail.From = reader.GetString(1);
mail.ToRecipient = reader.GetString(2);
mail.CcRecipients = reader.GetString(3);
mail.BccRecipients = reader.GetString(4);
mail.Subject = reader.GetString(5);
mail.Body = reader.GetString(6);
mail.Priority = reader.GetDateTime(7);
mail.CreateDate = reader.GetDateTime(8);
mail.HasAttachment = reader.GetBoolean(9);
if (mail.HasAttachment)
{
using (SqlConnection attachmentConnection = DBUtil.CreateConnection(ConnectionSource.Communication))
using (SqlCommand attachmentCommand = new SqlCommand(SelectAttachmentsCommandText, attachmentConnection))
{
attachmentConnection.Open();
attachmentCommand.Parameters.Add(new SqlParameter("@MailQueueId", mail.Id));
SqlDataReader attachmentReader = attachmentCommand.ExecuteReader();
while (attachmentReader.Read())
{
string path = attachmentReader.GetString(0);
var attachment = new MailQueueAttachment
{
Name = attachmentReader.GetString(0),
Data = (byte[])attachmentReader["AttachmentData"]
};
mail.Attachments.Add(attachment);
}
attachmentConnection.Close();
}
}
mailList.Add(mail);
}
catch (Exception ex)
{
Logger.Log(ex, false);
mail.SetError();
}
}
cmd.Connection.Close();
}
return(mailList);
}
