public void TestFixtureSetup() { _src = new DataSource() { ConnectionString = "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=mhv.va.gov)(PORT=1))(CONNECT_DATA=(SERVICE_NAME=sid)));User ID=user;Password=password;" }; _cxn = new MdoOracleConnection(_src); }
public MessageTO deleteDraft(string pwd, Int32 messageId) { MessageTO result = new MessageTO(); if (String.IsNullOrEmpty(pwd)) { result.fault = new FaultTO("Missing pwd"); } else if (messageId <= 0) { result.fault = new FaultTO("Missing message ID"); } if (result.fault != null) { return(result); } try { Message message = new Message() { Id = messageId }; using (MdoOracleConnection cxn = new MdoOracleConnection(new mdo.DataSource() { ConnectionString = pwd })) { SecureMessageDao dao = new SecureMessageDao(cxn); dao.deleteDraft(message); } message.Addressees = null; message.MessageThread = null; message.Body = "OK"; message.Id = -1; result = new MessageTO(message); } 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 MessageTO moveMessage(string pwd, Int32 userId, Int32 messageId, Int32 newFolderId) { MessageTO result = new MessageTO(); try { Message message = new Message(); message.Id = messageId; message.Addressees = new List <Addressee>() { new Addressee() { FolderId = newFolderId, Owner = new User() { Id = userId } } }; using (MdoOracleConnection cxn = new MdoOracleConnection(new mdo.DataSource() { ConnectionString = pwd })) { AddresseeDao dao = new AddresseeDao(cxn); message.Addressees[0] = dao.moveMessage(new Message() { Id = messageId }, new User() { Id = userId }, new Folder() { Id = newFolderId }); result = new MessageTO(message); } } catch (Exception exc) { result.fault = new FaultTO(exc); } return(result); }
public dto.sm.MessageTO readMessage(string pwd, Int32 addresseeId, Int32 addresseeOplock) { MessageTO result = new MessageTO(); if (String.IsNullOrEmpty(pwd)) { result.fault = new FaultTO("Missing appPwd"); } else if (addresseeId <= 0) { result.fault = new FaultTO("Must supply addressee ID"); } if (result.fault != null) { return(result); } try { using (MdoOracleConnection cxn = new MdoOracleConnection(new mdo.DataSource() { ConnectionString = pwd })) { AddresseeDao dao = new AddresseeDao(cxn); gov.va.medora.mdo.domain.sm.Addressee addressee = dao.readMessage(new Addressee() { Id = addresseeId, Oplock = addresseeOplock }); MessageTO message = new MessageTO(addressee.Message); message.addressees = new AddresseeTO[1] { new AddresseeTO(addressee) }; result = message; } } catch (Exception exc) { result.fault = new FaultTO(exc); } return(result); }
public SecureMessageThreadsTO getMessages(string pwd, Int32 userId, Int32 folderId, Int32 pageStart, Int32 pageSize) { SecureMessageThreadsTO result = new SecureMessageThreadsTO(null); if (userId <= 0) { result.fault = new dto.FaultTO("Must supply a user ID"); } if (pageSize <= 0 || pageSize > 250) { result.fault = new FaultTO("Invalid pageSize argument"); } if (result.fault != null) { return(result); } try { using (MdoOracleConnection cxn = new MdoOracleConnection(new mdo.DataSource() { ConnectionString = pwd })) { SecureMessageDao dao = new SecureMessageDao(cxn); if (folderId > 0 || Enum.IsDefined(typeof(gov.va.medora.mdo.domain.sm.enums.SystemFolderEnum), folderId)) { return(new SecureMessageThreadsTO(dao.getMessagesInFolder(userId, folderId, pageStart, pageSize))); } else { return(new SecureMessageThreadsTO(dao.getSecureMessages(userId, pageStart, pageSize))); } } } catch (Exception exc) { result.fault = new dto.FaultTO(exc); } return(result); }
public MessageTO sendDraft(string pwd, Int32 messageId, Int32 messageOplock) { MessageTO result = new MessageTO(); pwd = getConnectionString(pwd); if (String.IsNullOrEmpty(pwd)) { result.fault = new FaultTO("No connection string specified or configured"); } else if (messageId <= 0) { result.fault = new FaultTO("Must supply a valid message ID"); } if (result.fault != null) { return(result); } try { using (MdoOracleConnection cxn = new MdoOracleConnection(new mdo.DataSource() { ConnectionString = pwd })) { SecureMessageDao dao = new SecureMessageDao(cxn); gov.va.medora.mdo.domain.sm.Message msg = new Message() { Id = messageId, Oplock = messageOplock }; result = new MessageTO(dao.sendDraft(msg)); } } catch (Exception exc) { result.fault = new FaultTO(exc); } return(result); }
public TaggedText getMOSReport(string appPwd, string EDIPI) { TaggedText result = new TaggedText(); if (String.IsNullOrEmpty(appPwd)) { result.fault = new FaultTO("Missing appPwd"); } else if (String.IsNullOrEmpty(EDIPI)) { result.fault = new FaultTO("Missing EDIPI"); } if (result.fault != null) { return(result); } try { AbstractConnection cxn = new MdoOracleConnection(new DataSource() { ConnectionString = mySession.MdwsConfiguration.MosConnectionString }); PatientApi api = new PatientApi(); Patient p = new Patient() { EDIPI = EDIPI }; TextReport rpt = api.getMOSReport(cxn, p); result.text = rpt.Text; result.tag = "VADIR"; } catch (Exception exc) { result.fault = new FaultTO(exc); } return(result); }
public dto.sm.AttachmentTO getAttachment(string pwd, Int32 attachmentId) { AttachmentTO result = new AttachmentTO(); pwd = getConnectionString(pwd); if (String.IsNullOrEmpty(pwd)) { result.fault = new FaultTO("No connection string specified or configured"); } 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); }
public dto.sm.MessageTO deleteAttachment(string pwd, Int32 messageId) { MessageTO result = new MessageTO(); pwd = getConnectionString(pwd); if (String.IsNullOrEmpty(pwd)) { result.fault = new FaultTO("No connection string specified or configured"); } else if (messageId <= 0) { result.fault = new FaultTO("Invalid message ID"); } if (result.fault != null) { return(result); } try { using (MdoOracleConnection cxn = new MdoOracleConnection(new mdo.DataSource() { ConnectionString = pwd })) { AttachmentDao dao = new AttachmentDao(cxn); Message dbMsg = dao.deleteAttachmentFromMessage(messageId); result = new MessageTO(dbMsg); } } catch (Exception exc) { result.fault = new FaultTO(exc); } return(result); }
public VbacorpClaimsDao(AbstractConnection cxn) { myCxn = (MdoOracleConnection)cxn; }
public UserProfileDao(AbstractConnection cxn) { _cxn = (MdoOracleConnection)cxn; }
public SecureMessageDao(AbstractConnection cxn) { _cxn = (MdoOracleConnection)cxn; }
public SmUserTO getUser(string pwd, string userId, string idType) { SmUserTO result = new SmUserTO(); if (String.IsNullOrEmpty(pwd)) { result.fault = new dto.FaultTO("Must supply password"); } else if (String.IsNullOrEmpty(userId)) { result.fault = new dto.FaultTO("Must supply user ID"); } else if (String.IsNullOrEmpty(idType) && !StringUtils.isNumeric(userId)) { result.fault = new FaultTO("Invalid user ID"); } else if (!String.IsNullOrEmpty(idType) && !String.Equals(idType, "SMID", StringComparison.CurrentCultureIgnoreCase) && !String.Equals(idType, "ICN", StringComparison.CurrentCultureIgnoreCase) && !String.Equals(idType, "SSN", StringComparison.CurrentCultureIgnoreCase)) { result.fault = new FaultTO("Invalid id type", "Use one of the following: SMID, ICN, SSN"); } if (result.fault != null) { return(result); } try { using (MdoOracleConnection cxn = new MdoOracleConnection(new mdo.DataSource() { ConnectionString = pwd })) { UserDao dao = new UserDao(cxn); if (String.IsNullOrEmpty(idType) || String.Equals(idType, "SMID", StringComparison.CurrentCultureIgnoreCase)) { result = new SmUserTO(dao.getUserDetail(Convert.ToInt32(userId))); } else if (String.Equals(idType, "ICN", StringComparison.CurrentCultureIgnoreCase)) { result = new SmUserTO(dao.getUserDetail(dao.getUserByIcn(userId).Id)); } else if (String.Equals(idType, "SSN", StringComparison.CurrentCultureIgnoreCase)) { // TODO - write get user by SSN function result.fault = new FaultTO("SSN lookup not currently enabled. Please try again later"); //result = new SmUserTO(dao.getUserDetail(dao.getUserBySsn(userId))); } else { throw new Exception("Invalid user type"); // should never get here with fault handling section but... just in case } } } catch (Exception exc) { result.fault = new dto.FaultTO(exc); } return(result); }
public MessageTO sendReplyMessage(string pwd, Int32 replyingToMessageId, Int32 senderId, Int32 recipientId, string messageBody) { MessageTO result = new MessageTO(); pwd = getConnectionString(pwd); if (String.IsNullOrEmpty(pwd)) { result.fault = new FaultTO("No connection string specified or configured"); } else if (replyingToMessageId <= 0) { result.fault = new FaultTO("Missing reply message ID"); } else if (senderId <= 0) { result.fault = new FaultTO("Missing sender ID"); } //else if (recipientId <= 0) //{ // result.fault = new FaultTO("Missing recipient ID"); //} else if (String.IsNullOrEmpty(messageBody)) { result.fault = new FaultTO("Must supply a message body"); } if (result.fault != null) { return(result); } try { using (MdoOracleConnection cxn = new MdoOracleConnection(new mdo.DataSource() { ConnectionString = pwd })) { SecureMessageDao dao = new SecureMessageDao(cxn); Message replyingTo = dao.getMessage(replyingToMessageId); if (replyingTo == null || replyingTo.Id <= 0) { throw new Exception("No message found for that ID"); } Message newReply = new Message() { SentDate = DateTime.Now, SenderId = senderId, RecipientId = recipientId, Body = messageBody, Checksum = StringUtils.getMD5Hash(messageBody), MessageThread = replyingTo.MessageThread }; result = new MessageTO(dao.sendReply(replyingTo, newReply)); } } catch (Exception exc) { result.fault = new FaultTO(exc); } return(result); }
public ThreadTO updateMessageThread(string pwd, Int32 threadId, string threadSubject, Int32 messageCategory, Int32 threadOplock) { ThreadTO result = new ThreadTO(); if (threadId <= 0) { result.fault = new FaultTO("Must specify a message thread"); } else if (String.IsNullOrEmpty(threadSubject)) { result.fault = new FaultTO("Missing thread subject"); } else if (messageCategory > 0 && !Enum.IsDefined(typeof(gov.va.medora.mdo.domain.sm.enums.MessageCategoryTypeEnum), messageCategory)) { result.fault = new FaultTO("That message category is not defined"); } if (result.fault != null) { return(result); } try { gov.va.medora.mdo.domain.sm.Thread thread = new gov.va.medora.mdo.domain.sm.Thread() { Id = threadId, Subject = threadSubject, MessageCategoryType = (gov.va.medora.mdo.domain.sm.enums.MessageCategoryTypeEnum)messageCategory, Oplock = threadOplock }; using (MdoOracleConnection cxn = new MdoOracleConnection(new mdo.DataSource() { ConnectionString = pwd })) { SecureMessageDao dao = new SecureMessageDao(cxn); gov.va.medora.mdo.domain.sm.Thread dbThread = dao.getMessagesFromThread(threadId); // we don't want to permit apps to change the mail group this way so just keep what's in the database which gets set through the proper channels thread.MailGroup = dbThread.MailGroup; if (dbThread == null || dbThread.Id <= 0 || dbThread.Messages == null || dbThread.Messages.Count <= 0) { throw new Exception("That thread does not exist in the database or appears malformed"); } // make sure the thread hasn't been marked as completed foreach (Message m in dbThread.Messages) { if (m.CompletedDate.Year > 1900) { throw new Exception("That message thread has already been completed. Unable to edit."); } } result = new ThreadTO(dao.updateThread(thread)); } } catch (Exception exc) { result.fault = new FaultTO(exc); } return(result); }
public ThreadTO sendNewMessage(string pwd, string threadSubject, Int32 groupId, Int32 messageCategory, Int32 senderId, Int32 recipientId, string messageBody) { ThreadTO result = new ThreadTO(); if (String.IsNullOrEmpty(threadSubject)) { result.fault = new FaultTO("Missing thread subject"); } else if (messageCategory >= 0 && !Enum.IsDefined(typeof(gov.va.medora.mdo.domain.sm.enums.MessageCategoryTypeEnum), messageCategory)) { result.fault = new FaultTO("That message category is not defined"); } else if (senderId <= 0) { result.fault = new FaultTO("Missing sender ID"); } else if (recipientId <= 0) { result.fault = new FaultTO("Missing recipient ID"); } else if (String.IsNullOrEmpty(messageBody)) { result.fault = new FaultTO("Must supply a message body"); } if (result.fault != null) { return(result); } try { gov.va.medora.mdo.domain.sm.Thread thread = new Thread() { MailGroup = new TriageGroup() { Id = groupId }, MessageCategoryType = (mdo.domain.sm.enums.MessageCategoryTypeEnum)messageCategory, Subject = threadSubject }; gov.va.medora.mdo.domain.sm.Message message = new Message() { Body = messageBody, Checksum = StringUtils.getMD5Hash(messageBody), MessageThread = thread, RecipientId = recipientId, SenderId = senderId, SentDate = DateTime.Now }; using (MdoOracleConnection cxn = new MdoOracleConnection(new mdo.DataSource() { ConnectionString = pwd })) { SecureMessageDao dao = new SecureMessageDao(cxn); Message newMsg = dao.sendNewMessage(message); result = new ThreadTO(newMsg.MessageThread); result.messages = new MessageTO[] { new MessageTO(newMsg) }; } } catch (Exception exc) { result.fault = new FaultTO(exc); } return(result); }
public ThreadTO saveDraft(string pwd, Int32 replyingToMessageId, string threadSubject, Int32 messageCategory, Int32 messageId, Int32 senderId, Int32 recipientId, string messageBody, Int32 messageOplock, Int32 threadOplock) { ThreadTO result = new ThreadTO(); if (String.IsNullOrEmpty(pwd)) { result.fault = new FaultTO("Missing pwd"); } else if (messageCategory > 0 && !Enum.IsDefined(typeof(gov.va.medora.mdo.domain.sm.enums.MessageCategoryTypeEnum), messageCategory)) { result.fault = new FaultTO("Invalid message category"); } else if (String.IsNullOrEmpty(messageBody)) { result.fault = new FaultTO("Missing message body"); } else if (messageId > 0 && messageOplock < 0) { result.fault = new FaultTO("Invalid message ID/message oplock"); } else if (senderId <= 0 || recipientId <= 0) { result.fault = new FaultTO("Invalid sender/recipient"); } if (result.fault != null) { return(result); } try { Message message = new Message() { Body = messageBody, Checksum = StringUtils.getMD5Hash(messageBody), Id = messageId, MessageThread = new Thread(), RecipientId = recipientId, SenderId = senderId, Oplock = messageOplock }; message.MessageThread.Subject = threadSubject; if (Enum.IsDefined(typeof(mdo.domain.sm.enums.MessageCategoryTypeEnum), messageCategory)) { message.MessageThread.MessageCategoryType = (mdo.domain.sm.enums.MessageCategoryTypeEnum)messageCategory; } message.MessageThread.Oplock = threadOplock; using (MdoOracleConnection cxn = new MdoOracleConnection(new mdo.DataSource() { ConnectionString = pwd })) { SecureMessageDao dao = new SecureMessageDao(cxn); if (replyingToMessageId > 0) { Message replyingToMsg = dao.getMessage(replyingToMessageId); if (replyingToMsg == null || replyingToMsg.Id <= 0 || replyingToMsg.MessageThread == null || replyingToMsg.MessageThread.Id <= 0) { throw new Exception("Invalid reply to message ID"); } message.MessageThread.Id = replyingToMsg.MessageThread.Id; } gov.va.medora.mdo.domain.sm.Message savedDraft = dao.saveDraft(message); MessageTO msg = new MessageTO(savedDraft); result = new ThreadTO(savedDraft.MessageThread); result.messages = new MessageTO[] { msg }; } } catch (Exception exc) { result.fault = new FaultTO(exc); } return(result); }
public AttachmentDao(AbstractConnection cxn) { _cxn = (MdoOracleConnection)cxn; }
public AttachmentDao(AbstractConnection cxn) { _cxn = (MdoOracleConnection)cxn; }
public AddresseeDao(AbstractConnection cxn) { _cxn = (MdoOracleConnection)cxn; }
public AddresseeDao(AbstractConnection cxn) { _cxn = (MdoOracleConnection)cxn; }
public MessageActivityDao(AbstractConnection cxn) { _cxn = (MdoOracleConnection)cxn; }
public VadirPatientDao(AbstractConnection cxn) { _cxn = (MdoOracleConnection)cxn; }
public AdrClaimsDao(AbstractConnection cxn) { myCxn = (MdoOracleConnection)cxn; }
public SystemDao(AbstractConnection cxn) { _cxn = (MdoOracleConnection)cxn; }
public FolderDao(AbstractConnection cxn) { _cxn = (MdoOracleConnection)cxn; }
// this class should use it's own DB connection since the cxn passed in may be disposed when wrapped in a 'using(AbstractConnection)' block void setConnection(AbstractConnection cxn) { _cxn = new MdoOracleConnection(new DataSource() { ConnectionString = cxn.DataSource.ConnectionString }); }
public UserDao(AbstractConnection cxn) { _cxn = (MdoOracleConnection)cxn; }