public virtual void CreateMessageContentSentAttachement(MessageContentSentAttachement messageContentSentAttachement)
{
try
{
Database database = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = database.GetStoredProcCommand("spMessageContentSentAttachementInsert");
database.AddInParameter(dbCommand, "@AttachementDocument", DbType.String, messageContentSentAttachement.AttachementDocument);
database.AddInParameter(dbCommand, "@AttachementDescription", DbType.String, messageContentSentAttachement.AttachementDescription);
database.AddInParameter(dbCommand, "@MessageContentID", DbType.Int32, messageContentSentAttachement.MessageContentID);
database.AddInParameter(dbCommand, "@CreatedDate", DbType.DateTime, messageContentSentAttachement.CreatedDate);
database.AddInParameter(dbCommand, "@ModifiedDate", DbType.DateTime, messageContentSentAttachement.ModifiedDate);
database.AddOutParameter(dbCommand, "@MessageContentSentAttachementID", DbType.Int32, 0);
database.ExecuteNonQuery(dbCommand);
messageContentSentAttachement.MessageContentSentAttachementID = (int)database.GetParameterValue(dbCommand, "@MessageContentSentAttachementID");
}
catch (Exception ex)
{
// log this exception
log4net.Util.LogLog.Error(ex.Message, ex);
// wrap it and rethrow
throw new ApplicationException(SR.DataAccessCreateMessageContentSentAttachementException, ex);
}
}
public static void UpdateMessageContentSentAttachement(MessageContentSentAttachement messageContentSentAttachement)
{
try
{
MessageContentSentAttachementDAO messageContentSentAttachementDAO = new MessageContentSentAttachementDAO();
messageContentSentAttachementDAO.UpdateMessageContentSentAttachement(messageContentSentAttachement);
}
catch (ApplicationException)
{
throw;
}
catch (Exception ex)
{
// log this exception
log4net.Util.LogLog.Error(ex.Message, ex);
// wrap it and rethrow
throw new ApplicationException(SR.BusinessUpdateMessageContentSentAttachementException, ex);
}
}
public virtual MessageContentSentAttachement CreateMessageContentSentAttachementFromReader(IDataReader reader)
{
MessageContentSentAttachement item = new MessageContentSentAttachement();
try
{
if (!reader.IsDBNull(reader.GetOrdinal("MessageContentSentAttachementID"))) item.MessageContentSentAttachementID = (int)reader["MessageContentSentAttachementID"];
if (!reader.IsDBNull(reader.GetOrdinal("AttachementDocument"))) item.AttachementDocument = (string)reader["AttachementDocument"];
if (!reader.IsDBNull(reader.GetOrdinal("AttachementDescription"))) item.AttachementDescription = (string)reader["AttachementDescription"];
if (!reader.IsDBNull(reader.GetOrdinal("MessageContentID"))) item.MessageContentID = (int)reader["MessageContentID"];
if (!reader.IsDBNull(reader.GetOrdinal("CreatedDate"))) item.CreatedDate = (DateTime)reader["CreatedDate"];
if (!reader.IsDBNull(reader.GetOrdinal("ModifiedDate"))) item.ModifiedDate = (DateTime)reader["ModifiedDate"];
}
catch (Exception ex)
{
// log this exception
log4net.Util.LogLog.Error(ex.Message, ex);
// wrap it and rethrow
throw new ApplicationException(SR.DataAccessCreateMessageContentSentAttachementFromReaderException, ex);
}
return item;
}
