public virtual void UpdateContentParameter(ContentParameter contentParameter)
{
try
{
Database database = DatabaseFactory.CreateDatabase("CustommerServiceConnection");
DbCommand dbCommand = database.GetStoredProcCommand("spContentParameterUpdate");
database.AddInParameter(dbCommand, "@ContentParameterID", DbType.Int32, contentParameter.ContentParameterID);
database.AddInParameter(dbCommand, "@ContentParameterName", DbType.String, contentParameter.ContentParameterName);
database.AddInParameter(dbCommand, "@ContentParameterDescription", DbType.String, contentParameter.ContentParameterDescription);
database.AddInParameter(dbCommand, "@ContentParameterActive", DbType.String, contentParameter.ContentParameterActive);
database.AddInParameter(dbCommand, "@CreatedDate", DbType.DateTime, contentParameter.CreatedDate);
database.AddInParameter(dbCommand, "@ModifiedDate", DbType.DateTime, contentParameter.ModifiedDate);
database.AddInParameter(dbCommand, "@ContentParameterValue", DbType.String, contentParameter.ContentParameterValue);
database.ExecuteNonQuery(dbCommand);
}
catch (Exception ex)
{
// log this exception
log4net.Util.LogLog.Error(ex.Message, ex);
// wrap it and rethrow
throw new ApplicationException(SR.DataAccessUpdateContentParameterException, ex);
}
}
public static void UpdateContentParameter(ContentParameter contentParameter)
{
try
{
ContentParameterDAO contentParameterDAO = new ContentParameterDAO();
contentParameterDAO.UpdateContentParameter(contentParameter);
}
catch (ApplicationException)
{
throw;
}
catch (Exception ex)
{
// log this exception
log4net.Util.LogLog.Error(ex.Message, ex);
// wrap it and rethrow
throw new ApplicationException(SR.BusinessUpdateContentParameterException, ex);
}
}
public virtual ContentParameter CreateContentParameterFromReader(IDataReader reader)
{
ContentParameter item = new ContentParameter();
try
{
if (!reader.IsDBNull(reader.GetOrdinal("ContentParameterID"))) item.ContentParameterID = (int)reader["ContentParameterID"];
if (!reader.IsDBNull(reader.GetOrdinal("ContentParameterName"))) item.ContentParameterName = (string)reader["ContentParameterName"];
if (!reader.IsDBNull(reader.GetOrdinal("ContentParameterDescription"))) item.ContentParameterDescription = (string)reader["ContentParameterDescription"];
if (!reader.IsDBNull(reader.GetOrdinal("ContentParameterActive"))) item.ContentParameterActive = (string)reader["ContentParameterActive"];
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("ContentParameterValue"))) item.ContentParameterValue = (string)reader["ContentParameterValue"];
}
catch (Exception ex)
{
// log this exception
log4net.Util.LogLog.Error(ex.Message, ex);
// wrap it and rethrow
throw new ApplicationException(SR.DataAccessCreateContentParameterFromReaderException, ex);
}
return item;
}
