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