/// <summary>
/// Выполняет запрос без результатов
/// </summary>
/// <param name="connection"></param>
/// <param name="command"></param>
/// <param name="parameters"></param>
/// <param name="timeout"></param>
/// <param name="close"></param>
/// <param name="showCommandTextWithParams">показать в Debug</param>
/// <exception cref="Exception"></exception>
public static int ExecuteNonQuery(this IDbConnection connection, object command,
object parameters = null, int timeout = 30, bool close = false, bool showCommandTextWithParams = false)
{
connection.WellOpen();
IDbCommand cmd = connection.CreateCommand(command, parameters, timeout);
cmd.CommandTimeout = timeout;
int r;
try{
if (showCommandTextWithParams)
{
Log.Debug("Sql command: [\r\n" + cmd.CommandAsSql() + "\r\n]");
}
r = cmd.ExecuteNonQuery();
}
catch (Exception ex) {
throw new Exception("error in query:" + cmd.CommandText, ex);
}
finally{
if (close)
{
connection.Close();
}
}
return(r);
}
public bool IsMatch(IPEndPoint remote, IPEndPoint local, string origin)
{
var result = InternalMatch(remote, local, origin);
if (logg.IsForDebug())
{
var loggm = new {
lan = LocalAddressName,
ran = RemoteAddressName,
lp = LocalPort,
o = Origin,
n = Name,
rm = remote.ToString(),
lc = local.ToString(),
or = origin,
rs = result
};
logg.Debug(loggm.stringify());
}
return(result);
}
