public MailAttachmentData GetAttachment(IAttachmentExp exp)
{
using (var daoFactory = new DaoFactory())
{
var daoAttachment = daoFactory.CreateAttachmentDao(Tenant, User);
var attachment = daoAttachment.GetAttachment(exp);
return(ToAttachmentData(attachment));
}
}
public Attachment GetAttachment(IAttachmentExp exp)
{
var query = Query(AttachmentTable.TABLE_NAME)
.InnerJoin(MailTable.TABLE_NAME.Alias(MailTable.TABLE_NAME),
Exp.EqColumns(MailTable.Columns.Id.Prefix(MailTable.TABLE_NAME),
AttachmentTable.Columns.MailId.Prefix(AttachmentTable.TABLE_NAME)))
.Select(MailTable.Columns.Stream.Prefix(MailTable.TABLE_NAME),
MailTable.Columns.User.Prefix(MailTable.TABLE_NAME))
.Where(exp.GetExpression());
return(Db.ExecuteList(query)
.ConvertAll(ToAttachment)
.FirstOrDefault());
}
