public EmailSearchDocument(Email email)
{
Email = email;
DatabaseID = email.ID;
Title = email.Subject;
Description = String.Empty;
Type = "EventDescription";
UniqueID = string.Format("{0}_{1}", Type, email.ID);
}
public bool Create(Email email, out int id)
{
using (var cn = Connection)
{
using (var transaction = new TransactionScope())
{
cn.Open();
AuditService.DbConnect(cn);
var success = true;
id = -1;
const string sql = "INSERT INTO `Emails` (`To`, `CC`, `BCC`, `Subject`, `Body`, `Priority`, `IsBodyHtml`, `Enabled`) Values (@To, @CC, @BCC, @Subject, @Body, @Priority, @IsBodyHtml, @Enabled);";
success &= cn.Execute(sql, new
{
To = email.To,
CC = email.CC,
BCC = email.BCC,
Subject = email.Subject,
Body = email.Body,
Priority = email.Priority,
Enabled = email.Enabled,
IsBodyHtml = email.IsBodyHtml
}) > 0;
var newId = cn.Query<ulong>("SELECT CAST(LAST_INSERT_ID() AS UNSIGNED INTEGER);").SingleOrDefault();
id = email.ID = Convert.ToInt32(newId);
if (success)
AuditService.ObjectAuditLog(ActionType.Create, n => n.ID, email);
transaction.Complete();
return success | newId > 0;
}
}
}
public bool Send(Email email, /*IDictionary<string, string> replacements = null,*/ BinaryAttachment[] binaryAttachments = null)
{
var client = new SmtpClient();
var message = new MailMessage();
message.To.Add(email.To);
message.Priority = email.Priority;
// message.Attachments = email.Attachments;
message.From = new MailAddress("*****@*****.**");
message.Subject = email.Subject;
message.Body = email.Body;
message.IsBodyHtml = email.IsBodyHtml;
if (email.Enabled)
{
client.Send(message);
}
client.Dispose();
message.Dispose();
return true;
}
public bool Update(Email email)
{
using (var cn = Connection)
{
AuditService.DbConnect(cn);
const string sql = "UPDATE `Emails` SET `To`=@To, `CC`=@CC, `BCC`=@BCC, `Subject`=@Subject, `Body`=@Body, `Priority`=@Priority, `IsBodyHtml`=@IsBodyHtml, `Enabled`=@Enabled WHERE `ID`=@id;";
var success = cn.Execute(sql, new
{
To = email.To,
CC = email.CC,
BCC = email.BCC,
Subject = email.Subject,
Body = email.Body,
Priority = email.Priority,
Enabled = email.Enabled,
IsBodyHtml = email.IsBodyHtml,
Id = email.ID
}) > 0;
if (success)
AuditService.ObjectAuditLog(ActionType.Update, n => n.ID, email);
return success;
}
}
public bool Put(Email email)
{
throw new System.NotImplementedException();
}
