public List <MailAttachmentData> GetAttachments(IAttachmentsExp exp) { using (var daoFactory = new DaoFactory()) { var daoAttachment = daoFactory.CreateAttachmentDao(Tenant, User); var attachments = daoAttachment.GetAttachments(exp); return(attachments.ConvertAll(ToAttachmentData)); } }
public long GetAttachmentsSize(IAttachmentsExp exp) { using (var daoFactory = new DaoFactory()) { var daoAttachment = daoFactory.CreateAttachmentDao(Tenant, User); var size = daoAttachment.GetAttachmentsSize(exp); return(size); } }
public int GetAttachmentNextFileNumber(IAttachmentsExp exp) { using (var daoFactory = new DaoFactory()) { var daoAttachment = daoFactory.CreateAttachmentDao(Tenant, User); var number = daoAttachment.GetAttachmentsMaxFileNumber(exp); number++; return(number); } }
public List <Attachment> GetAttachments(IAttachmentsExp 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)); }
public bool SetAttachmnetsRemoved(IAttachmentsExp exp) { var query = new SqlUpdate(AttachmentTable.TABLE_NAME.Alias(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))) .Set(AttachmentTable.Columns.IsRemoved, true) .Where(exp.GetExpression()); var result = Db.ExecuteNonQuery(query); return(result > 0); }
public long GetAttachmentsSize(IAttachmentsExp exp) { var query = new SqlQuery(AttachmentTable.TABLE_NAME.Alias(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))) .SelectSum(AttachmentTable.Columns.Size.Prefix(AttachmentTable.TABLE_NAME)) .Where(exp.GetExpression()); var size = Db.ExecuteList(query) .ConvertAll(r => Convert.ToInt64(r[0])) .FirstOrDefault(); return(size); }
public int GetAttachmentsCount(IAttachmentsExp exp) { var query = new SqlQuery(AttachmentTable.TABLE_NAME.Alias(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))) .SelectCount(AttachmentTable.Columns.Id.Prefix(AttachmentTable.TABLE_NAME)) .Where(exp.GetExpression()); var count = Db.ExecuteList(query) .ConvertAll(r => Convert.ToInt32(r[0])) .SingleOrDefault(); return(count); }