public virtual MessageContentSent CreateMessageContentSentFromReader(IDataReader reader)
{
MessageContentSent item = new MessageContentSent();
try
{
if (!reader.IsDBNull(reader.GetOrdinal("MessageContentID"))) item.MessageContentID = (int)reader["MessageContentID"];
if (!reader.IsDBNull(reader.GetOrdinal("ContentTemplateID"))) item.ContentTemplateID = (int)reader["ContentTemplateID"];
if (!reader.IsDBNull(reader.GetOrdinal("ServiceTypeID"))) item.ServiceTypeID = (int)reader["ServiceTypeID"];
if (!reader.IsDBNull(reader.GetOrdinal("Sender"))) item.Sender = (string)reader["Sender"];
if (!reader.IsDBNull(reader.GetOrdinal("Receiver"))) item.Receiver = (string)reader["Receiver"];
if (!reader.IsDBNull(reader.GetOrdinal("Subject"))) item.Subject = (string)reader["Subject"];
if (!reader.IsDBNull(reader.GetOrdinal("BodyContentType"))) item.BodyContentType = (string)reader["BodyContentType"];
if (!reader.IsDBNull(reader.GetOrdinal("BodyEncoding"))) item.BodyEncoding = (string)reader["BodyEncoding"];
if (!reader.IsDBNull(reader.GetOrdinal("BodyMessage"))) item.BodyMessage = (string)reader["BodyMessage"];
if (!reader.IsDBNull(reader.GetOrdinal("CreatedDate"))) item.CreatedDate = (DateTime)reader["CreatedDate"];
if (!reader.IsDBNull(reader.GetOrdinal("ModifiedDate"))) item.ModifiedDate = (DateTime)reader["ModifiedDate"];
if (!reader.IsDBNull(reader.GetOrdinal("MessageContentSentID"))) item.MessageContentSentID = (long)reader["MessageContentSentID"];
if (!reader.IsDBNull(reader.GetOrdinal("ServiceID"))) item.ServiceID = (string)reader["ServiceID"];
if (!reader.IsDBNull(reader.GetOrdinal("CommandCode"))) item.CommandCode = (string)reader["CommandCode"];
if (!reader.IsDBNull(reader.GetOrdinal("Request"))) item.Request = (string)reader["Request"];
if (!reader.IsDBNull(reader.GetOrdinal("MoID"))) item.MoID = (string)reader["MoID"];
if (!reader.IsDBNull(reader.GetOrdinal("ChargeYN"))) item.ChargeYN = (string)reader["ChargeYN"];
if (!reader.IsDBNull(reader.GetOrdinal("TotalMessages"))) item.TotalMessages = (short)reader["TotalMessages"];
}
catch (Exception ex)
{
// log this exception
log4net.Util.LogLog.Error(ex.Message, ex);
// wrap it and rethrow
throw new ApplicationException(SR.DataAccessCreateMessageContentSentFromReaderException, ex);
}
return item;
}
private void loadModify()
{
messageContentSent = MessageContentSentService.GetMessageContentSent(messagecontentSentID);
if (messageContentSent != null)
{
this.LoadTemplateType.SelectedValue = Convert.ToString(messageContentSent.ContentTemplateID);
this.LoadServiceType.SelectedValue = Convert.ToString(messageContentSent.ServiceTypeID);
this.InputSender.Value = messageContentSent.Sender;
this.InputReceiver.Value = messageContentSent.Receiver;
this.inputSuject.Value = messageContentSent.Subject;
this.InputBodyContentType.Text = messageContentSent.BodyContentType;
this.InputBodyEncoding.Value = messageContentSent.BodyEncoding;
this.InputBodyMessager.Value = messageContentSent.BodyMessage;
}
}
public void SendAllMailNotStart()
{
MessageContentCollection emailMessagesCollection = null;
Int32 totalRow = 0;
try
{
emailMessagesCollection = MessageContentService.GetMessageContentList((Int32)EmailCommandStatus.NotStart, (int)MessageServiceType.Email, MessageContentColumns.CreatedDate, "DESC", 1, commandBlockSize, out totalRow);
Ultility.Info("Process " + totalRow.ToString() + " email(s)");
//while (emailMessagesCollection.Count > 0)
//{
foreach (MessageContent email in emailMessagesCollection)
{
if (SendAnEmail(email) == (int)EmailCommandStatus.SuccessAndFinish)
{
MessageContentSent messageContentSent = new MessageContentSent();
messageContentSent.MessageContentID = email.MessageContentID;
messageContentSent.ContentTemplateID = email.ContentTemplateID;
messageContentSent.BodyContentType = email.BodyContentType;
messageContentSent.BodyEncoding = email.BodyEncoding;
messageContentSent.BodyMessage = email.BodyMessage;
messageContentSent.CreatedDate = email.CreatedDate;
messageContentSent.ModifiedDate = email.ModifiedDate;
messageContentSent.Receiver = email.Receiver;
messageContentSent.Sender = email.Sender;
messageContentSent.ServiceTypeID = email.ServiceTypeID;
messageContentSent.Subject = email.Subject;
}
else
{
email.Status = (int)EmailCommandStatus.FailAndFinish;
MessageContentService.UpdateMessageContent(email);
}
numberOfEmails++;
}
// emailMessagesCollection = MessageContentService.GetMessageContentList((Int32)EmailCommandStatus.NotStart, (int)MessageServiceType.Email, MessageContentColumns.CreatedDate, "DESC", 1, commandBlockSize, out totalRow);
//};
finishSendEmailTime = DateTime.Now;
}
catch (Exception ex)
{
listError.Add(ex);
}
}
public static void UpdateMessageContentSent(MessageContentSent messageContentSent)
{
try
{
MessageContentSentDAO messageContentSentDAO = new MessageContentSentDAO();
messageContentSentDAO.UpdateMessageContentSent(messageContentSent);
}
catch (ApplicationException)
{
throw;
}
catch (Exception ex)
{
// log this exception
log4net.Util.LogLog.Error(ex.Message, ex);
// wrap it and rethrow
throw new ApplicationException(SR.BusinessUpdateMessageContentSentException, ex);
}
}
public virtual void CreateMessageContentSent(MessageContentSent messageContentSent)
{
try
{
Database database = DatabaseFactory.CreateDatabase("CustommerServiceConnection");
DbCommand dbCommand = database.GetStoredProcCommand("spMessageContentSentInsert");
database.AddInParameter(dbCommand, "@MessageContentID", DbType.Int32, messageContentSent.MessageContentID);
database.AddInParameter(dbCommand, "@ContentTemplateID", DbType.Int32, messageContentSent.ContentTemplateID);
database.AddInParameter(dbCommand, "@ServiceTypeID", DbType.Int32, messageContentSent.ServiceTypeID);
database.AddInParameter(dbCommand, "@Sender", DbType.String, messageContentSent.Sender);
database.AddInParameter(dbCommand, "@Receiver", DbType.String, messageContentSent.Receiver);
database.AddInParameter(dbCommand, "@Subject", DbType.String, messageContentSent.Subject);
database.AddInParameter(dbCommand, "@BodyContentType", DbType.String, messageContentSent.BodyContentType);
database.AddInParameter(dbCommand, "@BodyEncoding", DbType.String, messageContentSent.BodyEncoding);
database.AddInParameter(dbCommand, "@BodyMessage", DbType.String, messageContentSent.BodyMessage);
database.AddInParameter(dbCommand, "@CreatedDate", DbType.DateTime, messageContentSent.CreatedDate);
database.AddInParameter(dbCommand, "@ModifiedDate", DbType.DateTime, messageContentSent.ModifiedDate);
database.AddOutParameter(dbCommand, "@MessageContentSentID", DbType.Int64, 0);
database.AddInParameter(dbCommand, "@ServiceID", DbType.String, messageContentSent.ServiceID);
database.AddInParameter(dbCommand, "@CommandCode", DbType.String, messageContentSent.CommandCode);
database.AddInParameter(dbCommand, "@Request", DbType.String, messageContentSent.Request);
database.AddInParameter(dbCommand, "@MoID", DbType.String, messageContentSent.MoID);
database.AddInParameter(dbCommand, "@ChargeYN", DbType.String, messageContentSent.ChargeYN);
database.AddInParameter(dbCommand, "@TotalMessages", DbType.Int16, messageContentSent.TotalMessages);
database.ExecuteNonQuery(dbCommand);
messageContentSent.MessageContentSentID = (long)database.GetParameterValue(dbCommand, "@MessageContentSentID");
}
catch (Exception ex)
{
// log this exception
log4net.Util.LogLog.Error(ex.Message, ex);
// wrap it and rethrow
throw new ApplicationException(SR.DataAccessCreateMessageContentSentException, ex);
}
}
public void SendAllMailNotStart()
{
MessageContentCollection emailMessagesCollection = null;
Int32 totalRow = 0;
try
{
//EmailMessageService.EmailMessageWS emailMessageService = new EmailMessageService.EmailMessageWS();
emailMessagesCollection = MessageContentService.GetMessageContentList((Int32)EmailCommandStatus.NotStart, MessageContentColumns.CreatedDate, "DESC", 1, commandBlockSize, out totalRow);
while (emailMessagesCollection.Count > 0)
{
foreach (MessageContent email in emailMessagesCollection)
{
// EmailCommandService.EmailCommandWS emailCommandService = new EmailCommandService.EmailCommandWS();
//SendTemplateEmailWithParam sendTemplateEmailWithParam = new SendTemplateEmailWithParam();
if (SendAnEmail(email) == (int)EmailCommandStatus.SuccessAndFinish)
{
MessageContentSent messageContentSent = new MessageContentSent();
messageContentSent.MessageContentID = email.MessageContentID;
messageContentSent.ContentTemplateID = email.ContentTemplateID;
messageContentSent.BodyContentType = email.BodyContentType;
messageContentSent.BodyEncoding = email.BodyEncoding;
messageContentSent.BodyMessage = email.BodyMessage;
messageContentSent.CreatedDate = email.CreatedDate;
messageContentSent.ModifiedDate = email.ModifiedDate;
messageContentSent.Receiver = email.Receiver;
messageContentSent.Sender = email.Sender;
messageContentSent.ServiceTypeID = email.ServiceTypeID;
messageContentSent.Subject = email.Subject;
MessageContentSentService.CreateMessageContentSent(messageContentSent);
//emailCommandService.UpdateStatusEmailCommand(email.EmailMessageId, (int)EmailCommandStatus.SuccessAndFinish, DateTime.Now);
}
else
{
email.Status = (int)EmailCommandStatus.FailAndFinish;
MessageContentService.UpdateMessageContent(email);
//emailCommandService.UpdateStatusEmailCommand(email.EmailMessageId, (int)EmailCommandStatus.FailAndFinish, DateTime.Now);
}
numberOfEmails++;
}
emailMessagesCollection = MessageContentService.GetMessageContentList((Int32)EmailCommandStatus.NotStart, MessageContentColumns.CreatedDate, "DESC", 0, commandBlockSize, out totalRow);
};
finishSendEmailTime = DateTime.Now;
}
catch (Exception ex)
{
listError.Add(ex);
}
}
