/// <summary>
/// Audits the content edit.
/// </summary>
/// <param name="action">Content Editing Action</param>
/// <param name="identifiableObject">The identifiable object.</param>
/// <param name="comments">Optional comments.</param>
/// <param name="xml">Optional Xml blob.</param>
private void AuditContentEdit(String action, IdentifiableObject identifiableObject, String comments, SqlXml xml)
{
try
{
using (SqlConnection connection = Connection)
{
// Register the content editing action
using (SqlCommand sqlAuditContentEdit = new SqlCommand()
{
CommandText = "AuditContentEdit",
CommandType = CommandType.StoredProcedure,
Connection = connection
})
{
sqlAuditContentEdit.AddParameter("@Action", SqlDbType.VarChar, action);
sqlAuditContentEdit.AddParameter("@ItemID", SqlDbType.VarChar, identifiableObject.VersionedItemId());
sqlAuditContentEdit.AddParameter("@ItemTitle", SqlDbType.NVarChar, identifiableObject.Title);
sqlAuditContentEdit.AddParameter("@Username", SqlDbType.VarChar, identifiableObject.Session.User.Title.ToUpper());
sqlAuditContentEdit.AddParameter("@UserDescription", SqlDbType.NVarChar, identifiableObject.Session.User.Description);
if (!String.IsNullOrEmpty(comments))
{
sqlAuditContentEdit.AddParameter("@Comments", SqlDbType.NVarChar, comments);
}
else
{
sqlAuditContentEdit.AddParameter("@Comments", SqlDbType.NVarChar, DBNull.Value);
}
if (xml != null)
{
sqlAuditContentEdit.AddParameter("@Xml", SqlDbType.Xml, xml);
}
else
{
sqlAuditContentEdit.AddParameter("@Xml", SqlDbType.Xml, DBNull.Value);
}
sqlAuditContentEdit.ExecuteNonQuery();
}
}
}
catch (Exception ex)
{
Logger.Write(ex, "TcmEvents.Audit", LoggingCategory.General, TraceEventType.Error);
}
}
/// <summary>
/// Audits the content edit.
/// </summary>
/// <param name="action">Content Editing Action</param>
/// <param name="identifiableObject">The identifiable object.</param>
/// <param name="comments">Optional comments.</param>
/// <param name="xml">Optional Xml blob.</param>
private void AuditContentEdit(String action, IdentifiableObject identifiableObject, String comments, SqlXml xml)
{
try
{
using (SqlConnection connection = Connection)
{
// Register the content editing action
using (SqlCommand sqlAuditContentEdit = new SqlCommand()
{
CommandText = "AuditContentEdit",
CommandType = CommandType.StoredProcedure,
Connection = connection
})
{
sqlAuditContentEdit.AddParameter("@Action", SqlDbType.VarChar, action);
sqlAuditContentEdit.AddParameter("@ItemID", SqlDbType.VarChar, identifiableObject.VersionedItemId());
sqlAuditContentEdit.AddParameter("@ItemTitle", SqlDbType.NVarChar, identifiableObject.Title);
sqlAuditContentEdit.AddParameter("@Username", SqlDbType.VarChar, identifiableObject.Session.User.Title.ToUpper());
sqlAuditContentEdit.AddParameter("@UserDescription", SqlDbType.NVarChar, identifiableObject.Session.User.Description);
if (!String.IsNullOrEmpty(comments))
sqlAuditContentEdit.AddParameter("@Comments", SqlDbType.NVarChar, comments);
else
sqlAuditContentEdit.AddParameter("@Comments", SqlDbType.NVarChar, DBNull.Value);
if (xml != null)
sqlAuditContentEdit.AddParameter("@Xml", SqlDbType.Xml, xml);
else
sqlAuditContentEdit.AddParameter("@Xml", SqlDbType.Xml, DBNull.Value);
sqlAuditContentEdit.ExecuteNonQuery();
}
}
}
catch (Exception ex)
{
Logger.Write(ex, "TcmEvents.Audit", LoggingCategory.General, TraceEventType.Error);
}
}