Example #1
0
        public EmailMessageCollection LoadCandidateMessages(int batchCount)
        {
            string topDesp = batchCount >= 0 ? string.Format(" TOP {0} ", batchCount) : string.Empty;

            WhereSqlClauseBuilder builder = new WhereSqlClauseBuilder();

            builder.AppendItem("1", 1);
            builder.AppendTenantCode();

            string sql = string.Format("SELECT {0}* FROM MSG.EMAIL_MESSAGES WITH (UPDLOCK, READPAST) WHERE {1} ORDER BY SORT_ID",
                                       topDesp,
                                       builder.ToSqlString(TSqlBuilder.Instance));

            EmailMessageCollection result = new EmailMessageCollection();

            DataTable table = DbHelper.RunSqlReturnDS(sql, GetConnectionName()).Tables[0];

            foreach (DataRow row in table.Rows)
            {
                EmailMessage message = new EmailMessage();

                DataRowToEmailMessage(row, message);

                result.Add(message);
            }

            return(result);
        }
Example #2
0
        public void SendCandidateEmailMessageWithAttachmentsTest()
        {
            DeleteAllTestMessages();

            EmailMessage message1 = PrepareMailMessageWithAttachments();
            EmailMessage message2 = PrepareMailMessageWithAttachments();

            EmailMessageCollection messages = new EmailMessageCollection();

            messages.Add(message1);
            messages.Add(message2);

            EmailMessageAdapter.Instance.Insert(messages);

            try
            {
                SmtpParameters sp = PrepareSmtpParameters();

                EmailMessageAdapter.Instance.SendCandidateMessages(10, sp);

                CheckSentMessage(message1);
                CheckSentMessage(message2);
            }
            finally
            {
                DeleteAllTestMessages();
            }
        }
Example #3
0
        public void Send(EmailMessage message, SmtpParameters sp, bool throwError = false)
        {
            EmailMessageCollection messages = new EmailMessageCollection();

            messages.Add(message);

            Send(messages, sp, throwError);
        }
Example #4
0
        public void Send(EmailMessage message, SmtpParameters sp)
        {
            EmailMessageCollection messages = new EmailMessageCollection();

            messages.Add(message);

            Send(messages, sp);
        }
        public void Send(EmailMessage message, SmtpParameters sp)
        {
            EmailMessageCollection messages = new EmailMessageCollection();

            messages.Add(message);

            Send(messages, sp);
        }
Example #6
0
        public void SendEmailMessageWithAttachmentTest()
        {
            EmailMessage message = PrepareMailMessageWithAttachments();

            SmtpParameters sp = PrepareSmtpParameters();

            EmailMessageCollection messages = new EmailMessageCollection();

            messages.Add(message);

            EmailMessageAdapter.Instance.Send(messages, sp);
        }
Example #7
0
 public ActionResult Save(Bam.Net.Messaging.Data.EmailMessage[] values)
 {
     try
     {
         EmailMessageCollection saver = new EmailMessageCollection();
         saver.AddRange(values);
         saver.Save();
         return(Json(new { Success = true, Message = "", Dao = "" }));
     }
     catch (Exception ex)
     {
         return(GetErrorResult(ex));
     }
 }
Example #8
0
		public void SendEmailMessageTest()
		{
			EmailMessage message = PrepareMailMessage();

			SmtpParameters sp = PrepareSmtpParameters();

			EmailMessageCollection messages = new EmailMessageCollection();

			messages.Add(message);

			EmailMessageAdapter.Instance.Send(messages, sp);

			CheckSentMessage(message);
		}
Example #9
0
        /// <summary>
        /// 发送候选的邮件
        /// </summary>
        /// <param name="batchCount"></param>
        /// <param name="sp"></param>
        public void SendCandidateMessages(int batchCount, SmtpParameters sp)
        {
            sp.NullCheck("sp");

            using (TransactionScope scope = TransactionScopeFactory.Create())
            {
                EmailMessageCollection messages = LoadCandidateMessages(batchCount);

                this.Send(messages, sp);

                this.DeleteEmailMessagesMainData(messages);

                scope.Complete();
            }
        }
Example #10
0
		public void SendCandidateEmailMessageWithAttachmentsTest()
		{
			DeleteAllTestMessages();

			EmailMessage message1 = PrepareMailMessageWithAttachments();
			EmailMessage message2 = PrepareMailMessageWithAttachments();

			EmailMessageCollection messages = new EmailMessageCollection();

			messages.Add(message1);
			messages.Add(message2);

			EmailMessageAdapter.Instance.Insert(messages);

			try
			{
				SmtpParameters sp = PrepareSmtpParameters();

				EmailMessageAdapter.Instance.SendCandidateMessages(10, sp);

				CheckSentMessage(message1);
				CheckSentMessage(message2);
			}
			finally
			{
				DeleteAllTestMessages();
			}
		}
        public EmailMessageCollection LoadCandidateMessages(int batchCount)
        {
            string topDesp = batchCount >= 0 ? string.Format(" TOP {0} ", batchCount) : string.Empty;

            WhereSqlClauseBuilder builder = new WhereSqlClauseBuilder();

            builder.AppendItem("1", 1);
            builder.AppendTenantCode();

            string sql = string.Format("SELECT {0}* FROM MSG.EMAIL_MESSAGES WITH (UPDLOCK READPAST) WHERE {1} ORDER BY SORT_ID",
                topDesp,
                builder.ToSqlString(TSqlBuilder.Instance));

            EmailMessageCollection result = new EmailMessageCollection();

            DataTable table = DbHelper.RunSqlReturnDS(sql, GetConnectionName()).Tables[0];

            foreach (DataRow row in table.Rows)
            {
                EmailMessage message = new EmailMessage();

                DataRowToEmailMessage(row, message);

                result.Add(message);
            }

            return result;
        }