public virtual void CreateIncomingMessageContentSent(IncomingMessageContentSent incomingMessageContentSent)
{
try
{
Database database = DatabaseFactory.CreateDatabase("CustommerServiceConnection");
DbCommand dbCommand = database.GetStoredProcCommand("spIncomingMessageContentSentInsert");
database.AddInParameter(dbCommand, "@IncomingMessageContentID", DbType.Int64, incomingMessageContentSent.IncomingMessageContentID);
database.AddInParameter(dbCommand, "@ServiceTypeID", DbType.Int32, incomingMessageContentSent.ServiceTypeID);
database.AddInParameter(dbCommand, "@Sender", DbType.String, incomingMessageContentSent.Sender);
database.AddInParameter(dbCommand, "@Receiver", DbType.String, incomingMessageContentSent.Receiver);
database.AddInParameter(dbCommand, "@Subject", DbType.String, incomingMessageContentSent.Subject);
database.AddInParameter(dbCommand, "@BodyContentType", DbType.String, incomingMessageContentSent.BodyContentType);
database.AddInParameter(dbCommand, "@BodyEncoding", DbType.String, incomingMessageContentSent.BodyEncoding);
database.AddInParameter(dbCommand, "@BodyMessage", DbType.String, incomingMessageContentSent.BodyMessage);
database.AddInParameter(dbCommand, "@Status", DbType.Int32, incomingMessageContentSent.Status);
database.AddInParameter(dbCommand, "@CreatedDate", DbType.DateTime, incomingMessageContentSent.CreatedDate);
database.AddInParameter(dbCommand, "@ModifiedDate", DbType.DateTime, incomingMessageContentSent.ModifiedDate);
database.AddInParameter(dbCommand, "@ServiceID", DbType.String, incomingMessageContentSent.ServiceID);
database.AddInParameter(dbCommand, "@CommandCode", DbType.String, incomingMessageContentSent.CommandCode);
database.AddInParameter(dbCommand, "@Request", DbType.String, incomingMessageContentSent.Request);
database.AddInParameter(dbCommand, "@MoID", DbType.String, incomingMessageContentSent.MoID);
database.AddOutParameter(dbCommand, "@IncomingMessageContentSentID", DbType.Int64, 0);
database.ExecuteNonQuery(dbCommand);
incomingMessageContentSent.IncomingMessageContentSentID = (long)database.GetParameterValue(dbCommand, "@IncomingMessageContentSentID");
}
catch (Exception ex)
{
// log this exception
log4net.Util.LogLog.Error(ex.Message, ex);
// wrap it and rethrow
throw new ApplicationException(SR.DataAccessCreateIncomingMessageContentSentException, ex);
}
}
public virtual IncomingMessageContentSent CreateIncomingMessageContentSentFromReader(IDataReader reader)
{
IncomingMessageContentSent item = new IncomingMessageContentSent();
try
{
if (!reader.IsDBNull(reader.GetOrdinal("IncomingMessageContentSentID"))) item.IncomingMessageContentSentID = (long)reader["IncomingMessageContentSentID"];
if (!reader.IsDBNull(reader.GetOrdinal("IncomingMessageContentID"))) item.IncomingMessageContentID = (long)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.DataAccessCreateIncomingMessageContentSentFromReaderException, ex);
}
return item;
}
public static void UpdateIncomingMessageContentSent(IncomingMessageContentSent incomingMessageContentSent)
{
try
{
IncomingMessageContentSentDAO incomingMessageContentSentDAO = new IncomingMessageContentSentDAO();
incomingMessageContentSentDAO.UpdateIncomingMessageContentSent(incomingMessageContentSent);
}
catch (ApplicationException)
{
throw;
}
catch (Exception ex)
{
// log this exception
log4net.Util.LogLog.Error(ex.Message, ex);
// wrap it and rethrow
throw new ApplicationException(SR.BusinessUpdateIncomingMessageContentSentException, ex);
}
}
