public dto.sm.AttachmentTO addAttachment(string pwd, Int32 messageId, Int32 messageOplock, string fileName, string mimeType, byte[] attachment)
{
AttachmentTO result = new AttachmentTO();
if (String.IsNullOrEmpty(pwd))
{
result.fault = new FaultTO("Missing pwd");
}
else if (messageId <= 0)
{
result.fault = new FaultTO("Invalid message ID");
}
else if (String.IsNullOrEmpty(fileName) || String.IsNullOrEmpty(mimeType) || attachment == null || attachment.Length <= 0)
{
result.fault = new FaultTO("Must supply all attachment properties");
}
if (result.fault != null)
{
return result;
}
try
{
using (MdoOracleConnection cxn = new MdoOracleConnection(new mdo.DataSource() { ConnectionString = pwd }))
{
AttachmentDao dao = new AttachmentDao(cxn);
MessageAttachment newAttachment = dao.attachToMessage(
new MessageAttachment() { AttachmentName = fileName, MimeType = mimeType, SmFile = attachment },
new Message() { Id = messageId, Oplock = messageOplock });
result = new AttachmentTO(newAttachment);
}
}
catch (Exception exc)
{
result.fault = new FaultTO(exc);
}
return result;
}
public dto.sm.AttachmentTO updateAttachment(string pwd, Int32 attachmentId, Int32 attachmentOplock, string fileName, string mimeType, byte[] attachment)
{
AttachmentTO result = new AttachmentTO();
if (String.IsNullOrEmpty(pwd))
{
result.fault = new FaultTO("Missing pwd");
}
else if (attachmentId <= 0)
{
result.fault = new FaultTO("Invalid attachment ID");
}
else if (String.IsNullOrEmpty(fileName) || String.IsNullOrEmpty(mimeType) || attachment == null || attachment.Length <= 0)
{
result.fault = new FaultTO("Must supply all attachment properties");
}
if (result.fault != null)
{
return result;
}
try
{
using (MdoOracleConnection cxn = new MdoOracleConnection(new mdo.DataSource() { ConnectionString = pwd }))
{
AttachmentDao dao = new AttachmentDao(cxn);
MessageAttachment updatedAttachment = dao.updateAttachment(new MessageAttachment()
{ Id = attachmentId, Oplock = attachmentOplock, AttachmentName = fileName, MimeType = mimeType, SmFile = attachment });
updatedAttachment.SmFile = null; // don't pass back - client already has image so save the bandwidth
result = new AttachmentTO(updatedAttachment);
}
}
catch (Exception exc)
{
result.fault = new FaultTO(exc);
}
return result;
}
public dto.sm.AttachmentTO getAttachment(string pwd, Int32 attachmentId)
{
AttachmentTO result = new AttachmentTO();
if (String.IsNullOrEmpty(pwd))
{
result.fault = new FaultTO("Missing pwd");
}
else if (attachmentId <= 0)
{
result.fault = new FaultTO("Invalid attachment ID");
}
if (result.fault != null)
{
return result;
}
try
{
using (MdoOracleConnection cxn = new MdoOracleConnection(new mdo.DataSource() { ConnectionString = pwd }))
{
AttachmentDao dao = new AttachmentDao(cxn);
MessageAttachment attachment = dao.getAttachment(attachmentId);
result = new AttachmentTO(attachment);
}
}
catch (Exception exc)
{
result.fault = new FaultTO(exc);
}
return result;
}
