public virtual void CreateIncomingMessageContent(IncomingMessageContent incomingMessageContent)
{
try
{
Database database = DatabaseFactory.CreateDatabase("CustommerServiceConnection");
DbCommand dbCommand = database.GetStoredProcCommand("spIncomingMessageContentInsert");
database.AddInParameter(dbCommand, "@ServiceTypeID", DbType.Int32, incomingMessageContent.ServiceTypeID);
database.AddInParameter(dbCommand, "@Sender", DbType.String, incomingMessageContent.Sender);
database.AddInParameter(dbCommand, "@Receiver", DbType.String, incomingMessageContent.Receiver);
database.AddInParameter(dbCommand, "@Subject", DbType.String, incomingMessageContent.Subject);
database.AddInParameter(dbCommand, "@BodyContentType", DbType.String, incomingMessageContent.BodyContentType);
database.AddInParameter(dbCommand, "@BodyEncoding", DbType.String, incomingMessageContent.BodyEncoding);
database.AddInParameter(dbCommand, "@BodyMessage", DbType.String, incomingMessageContent.BodyMessage);
database.AddInParameter(dbCommand, "@Status", DbType.Int32, incomingMessageContent.Status);
database.AddInParameter(dbCommand, "@CreatedDate", DbType.DateTime, incomingMessageContent.CreatedDate);
database.AddInParameter(dbCommand, "@ModifiedDate", DbType.DateTime, incomingMessageContent.ModifiedDate);
database.AddInParameter(dbCommand, "@ServiceID", DbType.String, incomingMessageContent.ServiceID);
database.AddInParameter(dbCommand, "@CommandCode", DbType.String, incomingMessageContent.CommandCode);
database.AddInParameter(dbCommand, "@Request", DbType.String, incomingMessageContent.Request);
database.AddInParameter(dbCommand, "@MoID", DbType.String, incomingMessageContent.MoID);
database.AddOutParameter(dbCommand, "@IncomingMessageContentID", DbType.Int32, 0);
database.ExecuteNonQuery(dbCommand);
incomingMessageContent.IncomingMessageContentID = (int)database.GetParameterValue(dbCommand, "@IncomingMessageContentID");
}
catch (Exception ex)
{
// log this exception
log4net.Util.LogLog.Error(ex.Message, ex);
// wrap it and rethrow
throw new ApplicationException(SR.DataAccessCreateIncomingMessageContentException, ex);
}
}
public virtual IncomingMessageContent CreateIncomingMessageContentFromReader(IDataReader reader)
{
IncomingMessageContent item = new IncomingMessageContent();
try
{
if (!reader.IsDBNull(reader.GetOrdinal("IncomingMessageContentID"))) item.IncomingMessageContentID = (int)reader["IncomingMessageContentID"];
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("Status"))) item.Status = (int)reader["Status"];
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("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"];
}
catch (Exception ex)
{
// log this exception
log4net.Util.LogLog.Error(ex.Message, ex);
// wrap it and rethrow
throw new ApplicationException(SR.DataAccessCreateIncomingMessageContentFromReaderException, ex);
}
return item;
}
public static void UpdateIncomingMessageContent(IncomingMessageContent incomingMessageContent)
{
try
{
IncomingMessageContentDAO incomingMessageContentDAO = new IncomingMessageContentDAO();
incomingMessageContentDAO.UpdateIncomingMessageContent(incomingMessageContent);
}
catch (ApplicationException)
{
throw;
}
catch (Exception ex)
{
// log this exception
log4net.Util.LogLog.Error(ex.Message, ex);
// wrap it and rethrow
throw new ApplicationException(SR.BusinessUpdateIncomingMessageContentException, ex);
}
}
public static string SendMessage(string UserID, string ServiceID, string CommandCode, string Message, string RequestID, string MoID, string Username, string Password, Int32 transferMoneyContentTemplateId, string email)
{
string returnValue = "1";
int result;
try
{
IncomingMessageContent incomingMessageContent = new IncomingMessageContent();
incomingMessageContent.ServiceTypeID = 2;
incomingMessageContent.CommandCode = CommandCode;
incomingMessageContent.ServiceID = ServiceID;
incomingMessageContent.Sender = UserID;
incomingMessageContent.MoID = MoID;
incomingMessageContent.CreatedDate = DateTime.Now;
incomingMessageContent.ModifiedDate = DateTime.Now;
incomingMessageContent.BodyMessage = Message;
incomingMessageContent.Request = RequestID;
incomingMessageContent.BodyContentType = "PlainText";
incomingMessageContent.BodyEncoding = "UTF-8";
incomingMessageContent.Status = 0;
IncomingMessageContentService.CreateIncomingMessageContent(incomingMessageContent);
SendEmail sendMail = new SendEmail();
sendMail.Sender = ContentParameterService.GetContentParameter(1).ContentParameterValue;
sendMail.Receiver = email;
sendMail.Subject = "Dich Vu chuyen tien:" + UserID;
sendMail.SmtpServer = ContentParameterService.GetContentParameter(4).ContentParameterValue;
sendMail.IsHtmlMail = true;
sendMail.BodyText = "Yeu cau thuc hien dich vu chuyen tien cua: " + UserID + "<br />" + Message;
bool success = Int32.TryParse(ContentParameterService.GetContentParameter(5).ContentParameterValue, out result);
if (success == true)
{
sendMail.SmtpPort = result;
}
sendMail.Send();
ContentTemplate contentTemplate = null;
contentTemplate = ContentTemplateService.GetContentTemplate(transferMoneyContentTemplateId);
MessageContent messageContent = null;
if (contentTemplate != null)
{
messageContent = new MessageContent();
messageContent.Sender = contentTemplate.Sender;
messageContent.Receiver = UserID;
messageContent.Subject = contentTemplate.Subject;
messageContent.BodyContentType = contentTemplate.BodyContentType;
messageContent.BodyEncoding = contentTemplate.BodyEncoding;
messageContent.BodyMessage = contentTemplate.BodyMessage;
messageContent.ContentTemplateID = contentTemplate.ContentTemplateID;
messageContent.ServiceTypeID = contentTemplate.ServiceTypeID;
messageContent.ModifiedDate = DateTime.Now;
messageContent.CreatedDate = DateTime.Now;
messageContent.Status = 0;
messageContent.Request = RequestID;
messageContent.MoID = MoID;
messageContent.ServiceID = ServiceID;
messageContent.CommandCode = CommandCode;
}
MessageContentService.CreateMessageContent(messageContent);
return returnValue;
}
catch (ApplicationException)
{
throw;
}
catch (Exception ex)
{
// log this exception
log4net.Util.LogLog.Error(ex.Message, ex);
// wrap it and rethrow
throw new ApplicationException(SR.BusinessSendSMSToCoreSecuritiesException, ex);
}
}
public static string SendInValidResponseMessage(string UserID, string ServiceID, string CommandCode, string Message, string RequestID, string MoID, string Username, string Password, Int32 invalidSMSContentTemplateId)
{
string returnValue = "1";
// int result;
try
{
IncomingMessageContent incomingMessageContent = new IncomingMessageContent();
incomingMessageContent.ServiceTypeID = 2;
incomingMessageContent.CommandCode = CommandCode;
incomingMessageContent.ServiceID = ServiceID;
incomingMessageContent.Sender = UserID;
incomingMessageContent.MoID = MoID;
incomingMessageContent.CreatedDate = DateTime.Now;
incomingMessageContent.ModifiedDate = DateTime.Now;
incomingMessageContent.BodyMessage = Message;
incomingMessageContent.Request = RequestID;
incomingMessageContent.BodyContentType = "PlainText";
incomingMessageContent.BodyEncoding = "UTF-8";
incomingMessageContent.Status = 0;
IncomingMessageContentService.CreateIncomingMessageContent(incomingMessageContent);
ContentTemplate contentTemplate = null;
contentTemplate = ContentTemplateService.GetContentTemplate(invalidSMSContentTemplateId);
MessageContent messageContent = null;
if (contentTemplate != null)
{
messageContent = new MessageContent();
messageContent.Sender = contentTemplate.Sender;
messageContent.Receiver = UserID;
messageContent.Subject = contentTemplate.Subject;
messageContent.BodyContentType = contentTemplate.BodyContentType;
messageContent.BodyEncoding = contentTemplate.BodyEncoding;
messageContent.BodyMessage = contentTemplate.BodyMessage;
messageContent.ContentTemplateID = contentTemplate.ContentTemplateID;
messageContent.ServiceTypeID = contentTemplate.ServiceTypeID;
messageContent.ModifiedDate = DateTime.Now;
messageContent.CreatedDate = DateTime.Now;
messageContent.Status = 0;
messageContent.Request = RequestID;
messageContent.MoID = MoID;
messageContent.ServiceID = ServiceID;
messageContent.CommandCode = CommandCode;
}
MessageContentService.CreateMessageContent(messageContent);
return returnValue;
}
catch (ApplicationException)
{
throw;
}
catch (Exception ex)
{
// log this exception
log4net.Util.LogLog.Error(ex.Message, ex);
// wrap it and rethrow
throw new ApplicationException(SR.BusinessSendSMSToCoreSecuritiesException, ex);
}
}
