public char AuditOperationTypeToChar(AuditOperationType type)
{
switch (type)
{
case AuditOperationType.Delete:
return 'D';
case AuditOperationType.GetAll:
return 'A';
case AuditOperationType.GetOne:
return 'O';
case AuditOperationType.Insert:
return 'I';
case AuditOperationType.Update:
return 'U';
default:
return ' ';
}
}
public static void AddAuditMessage(SqlConnection conn, SqlTransaction trans, string tbl, Guid id, AuditOperationType op, string msg, string comment = "")
{
SqlCommand cmd = new SqlCommand("csp_insert_audit_log", conn, trans);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@id", Guid.NewGuid());
cmd.Parameters.AddWithValue("@source_table", tbl.Trim());
cmd.Parameters.AddWithValue("@source_id", id);
cmd.Parameters.AddWithValue("@operation", op.ToString());
cmd.Parameters.AddWithValue("@comment", comment.Trim());
cmd.Parameters.AddWithValue("@value", Utils.Compress(msg.Trim()));
cmd.Parameters.AddWithValue("@create_date", DateTime.Now);
cmd.ExecuteNonQuery();
}
protected override AuditType GetActionAuditType(AuditTransacInfo transac, AuditOperationType operation, object entity)
{
if (entity == null)
{
return AuditType.None;
}
if (this.metaEntities.ContainsKey(entity.GetType()))
{
return this.metaEntities[entity.GetType()].AuditType;
}
return AuditType.None;
}
