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; }