public MailSignatureData SaveSignature(int mailboxId, string html, bool isActive)
{
if (!string.IsNullOrEmpty(html))
{
var imagesReplacer = new StorageManager(Tenant, User, Log);
html = imagesReplacer.ChangeEditorImagesLinks(html, mailboxId);
}
CacheEngine.Clear(User);
var signature = new MailboxSignature
{
MailboxId = mailboxId,
Tenant = Tenant,
Html = html,
IsActive = isActive
};
using (var daoFactory = new DaoFactory())
{
var result = daoFactory
.CreateMailboxSignatureDao(Tenant, User)
.SaveSignature(signature);
if (result <= 0)
{
throw new Exception("Save failed");
}
}
return(ToMailMailSignature(signature));
}
public int SaveSignature(MailboxSignature signature)
{
var query = new SqlInsert(MailboxSignatureTable.TABLE_NAME, true)
.InColumnValue(MailboxSignatureTable.Columns.Html, signature.Html)
.InColumnValue(MailboxSignatureTable.Columns.IsActive, signature.IsActive)
.InColumnValue(MailboxSignatureTable.Columns.Tenant, signature.Tenant)
.InColumnValue(MailboxSignatureTable.Columns.MailboxId, signature.MailboxId);
return(Db.ExecuteNonQuery(query));
}
protected MailboxSignature ToSignature(object[] r)
{
var obj = new MailboxSignature
{
MailboxId = Convert.ToInt32(r[0]),
Tenant = Convert.ToInt32(r[1]),
Html = Convert.ToString(r[2]),
IsActive = Convert.ToBoolean(r[3])
};
return(obj);
}
protected MailSignatureData ToMailMailSignature(MailboxSignature signature)
{
return(new MailSignatureData(signature.MailboxId, signature.Tenant, signature.Html, signature.IsActive));
}
