protected static void OnInfoMessage(object sender, SqlInfoMessageEventArgs args)
{
Console.WriteLine("SQL Info Message");
foreach (SqlError err in args.Errors)
{
Console.WriteLine("The {0} has received a severity {1}, state {2} error number {3}\n" +
"on line {4} of procedure {5} on server {6}:\n{7}",
err.Source, err.Class, err.State, err.Number, err.LineNumber,
err.Procedure, err.Server, err.Message);
}
}
private void Conn_InfoMessage(
object sender,
SqlInfoMessageEventArgs e)
{
if (_aConnection.Conn.State == ConnectionState.Closed)
{
return;
}
Console.WriteLine(e.Errors[0].Message);
Console.ReadLine();
if (e.Errors[0].Message == "Warning: Null value is eliminated by an aggregate or other SET operation.")
{
}
else
{
MessageBox.Show
(
"Error Recieved - Unable to perform query successfully\r\n\r\n" + e.Errors[0].Message
+ "\r\n\r\n" +
_aSqlStatement,
"\r\n\r\nSQL Information Returned",
MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
_aConnection.CloseConnection();
}
private void OnInfoMessage(object sender, SqlInfoMessageEventArgs args)
{
if(this.Provider.Log != null)
{
this.Provider.Log.WriteLine(Strings.LogGeneralInfoMessage(args.Source, args.Message));
}
}
internal static void InfoMessageHandler(object Sender,
SqlInfoMessageEventArgs EventInfo)
{
File.AppendAllText(MessagesFile, EventInfo.Message + "\n", OutputEncoding);
return;
}
private void OnSqlInfoMessage(object sender,
System.Data.SqlClient.SqlInfoMessageEventArgs args)
{
foreach (SqlError err in args.Errors)
{
Logger.LogError("OnSqlInfoMessage", new Exception(err.Message));
}
}
protected void OnInfoMessage(object sender, SqlInfoMessageEventArgs args)
{
if (infoMessage.IsNull)
{
infoMessage = "";
}
infoMessage += args.Message + "\r\n";
}
private static void OnInfoMessage(object sender, System.Data.SqlClient.SqlInfoMessageEventArgs args)
{
System.Data.SqlClient.SqlError sqlEvent = null;
foreach (System.Data.SqlClient.SqlError sqlEvent_loopVariable in args.Errors)
{
sqlEvent = sqlEvent_loopVariable;
aaa = sqlEvent.Message;
}
//return aaa;
}
private static void SqlInfoHandler(object sqlConnection, SqlInfoMessageEventArgs e)
{
var stringBuilder = new StringBuilder("SQL Server Error in Custom Repository");
for (int i = 0; i < e.Errors.Count; i++)
{
stringBuilder.Append(Environment.NewLine);
stringBuilder.Append("ERROR #" + Convert.ToString(i + 1));
stringBuilder.Append(e);
}
throw new Exception(stringBuilder.ToString());
}
private void ConnectionOnInfoMessage(object sender, SqlInfoMessageEventArgs args)
{
if (string.IsNullOrEmpty(args.Message) && args.Errors.Count == 0)
return;
_log.Append(args.Message);
foreach (SqlError error in args.Errors)
{
_log.AppendLine(error.Message);
}
}
private void InfoMessage(object sender, System.Data.SqlClient.SqlInfoMessageEventArgs e)
{
for (int i = 0; i < e.Errors.Count; i++)
{
using (TextWriterTraceListener SqlInfoMessageWriter = new TextWriterTraceListener(Console.Out))
{
Trace.Listeners.Add(SqlInfoMessageWriter);
Trace.AutoFlush = true;
Trace.WriteLine("SqlServer message: {0}", e.Errors[i].Message);
}
}
}
private void OnSqlInfoMessage(object sender,
System.Data.SqlClient.SqlInfoMessageEventArgs args)
{
foreach (SqlError err in args.Errors)
{
ExceptionMessageBox emb = new ExceptionMessageBox();
emb.Text = String.Format(System.Globalization.CultureInfo.InvariantCulture,
Properties.Resources.SqlError,
err.Source, err.Class, err.State, err.Number, err.LineNumber,
err.Procedure, err.Server, err.Message);
emb.Show(this);
}
}
private void OnInfoMessage(object sender, SqlInfoMessageEventArgs args)
{
if (args.Errors.Count > 0 )
{
serverInfos = args.Errors;
// TODO: enable asynchronouse output to the gui
// StringBuilder builder = new StringBuilder();
// foreach(SqlError error in args.Errors)
// {
// builder.Remove(0, builder.Length - 1);
// builder.Append("***DBInfoMessage: severity = " + error.Number);
// builder.Append(", state = " + error.State + "\n");
// builder.Append("***\tmessage = " + error.Message);
// builder.Append(", procedure = " + error.Procedure);
// builder.Append(", line = " + error.LineNumber);
// Debug.Write(builder.ToString());
// }
}
}
private void connInfoMessage(object sender, SqlInfoMessageEventArgs e)
{
bool founderrors = false;
foreach (SqlError error in e.Errors)
{
if (error.Class > 10)
{
AppendOutputText("Error !!! " + Environment.NewLine); ;
AppendOutputText(error.Message + Environment.NewLine);
founderrors = true;
Status = TaskStatus.Failed;
Log.Error("Error while executing SQL command:" + error.Message);
}
}
if (!founderrors)
{
AppendOutputText(e.Message + Environment.NewLine);
}
}
private static void ConnectionInfoMessage(object sender, SqlInfoMessageEventArgs e)
{
if ( e.Errors.Count > 0 )
{
// Check to make sure we are information only messages
Console.WriteLine("Recieved {0} messages", e.Errors.Count);
foreach( SqlError info in e.Errors )
{
if ( info.Class > 9 ) // Severity
{
Console.WriteLine("Error Message : {0} : State : {1}", info.Message, info.State );
}
else
{
Console.WriteLine("Info Message : {0} : State : {1}", info.Message, info.State);
}
}
}
else
{
Console.WriteLine("Recieved Connection Info Message : {0}", e.Message);
}
}
private void OnSqlServerMessage(object sender, SqlInfoMessageEventArgs e)
{
if (null != OnMessage)
{
foreach (SqlError sqle in e.Errors)
{
if (!sqle.Message.StartsWith("Changed database context to"))
OnMessage(this, new MessageEventArgs(sqle.Message));
}
}
}
private void OnSqlInfoMessage (SqlInfoMessageEventArgs value)
{
if (InfoMessage != null)
InfoMessage (this, value);
}
static void infoMessageHandler(object sender, System.Data.SqlClient.SqlInfoMessageEventArgs e)
{
Logger.log(MethodBase.GetCurrentMethod(), e.Message);
}
private void InfoMessage(object sender, SqlInfoMessageEventArgs e)
{
if (Logger == null)
return;
foreach (SqlError error in e.Errors)
WriteLog("SQL Message '{0}', Number: {1}, Procedure: '{2}', Line: {3}".FormatWith(
error.Message, error.Number, error.Procedure, error.LineNumber));
}
void cnnSQL_InfoMessage(object sender, SqlInfoMessageEventArgs e)
{
Assert.Fail(e.Message);
}
private void OnInfoMessageUpdated(object sender, SqlInfoMessageEventArgs e)
{
this.StatusMessage = e.Message;
}
private void ConnectionContext_InfoMessage(object sender, SqlInfoMessageEventArgs e)
{
if (e.Message.Contains("ERROR"))
{
errors++;
outputLog.Append(e.Message + Environment.NewLine);
outputLog.Append("----------------------------------------------------------------------------------------------------------" + Environment.NewLine);
}
messageLog.Append(e.Message + Environment.NewLine);
messageLog.Append("----------------------------------------------------------------------------------------------------------" + Environment.NewLine);
}
private void sqlConnection1_InfoMessage(object sender, System.Data.SqlClient.SqlInfoMessageEventArgs e)
{
}
void Con_InfoMessage(object sender, SqlInfoMessageEventArgs e)
{
listBox1.Items.Add(e.Message);
}
private void Cn_InfoMessage(object sender, SqlInfoMessageEventArgs e)
{
//e.Erros --> solo errores
this.lblMensaje.Text = e.Message;
//throw new NotImplementedException();
}
void _Cn_InfoMessage(object sender, SqlInfoMessageEventArgs e)
{
///Double Check
//ShowError(ErrorNumber.SetType("00000000", errorType.DataOperationError), e.Message);
}
private void Connector_InfoMessageHandler(object sender, SqlInfoMessageEventArgs e)
{
InfoMessages = InfoMessages + e.Message + "\r\n";
ErrorMessages = ErrorMessages + e.Errors + "\r\n";
}
/// <summary>
/// Extends BeginInvoke so that when a state object is not needed, null does not need to be passed.
/// <example>
/// sqlinfomessageeventhandler.BeginInvoke(sender, e, callback);
/// </example>
/// </summary>
public static IAsyncResult BeginInvoke(this SqlInfoMessageEventHandler sqlinfomessageeventhandler, Object sender, SqlInfoMessageEventArgs e, AsyncCallback callback)
{
if(sqlinfomessageeventhandler == null) throw new ArgumentNullException("sqlinfomessageeventhandler");
return sqlinfomessageeventhandler.BeginInvoke(sender, e, callback, null);
}
internal void OnInfoMessage(SqlInfoMessageEventArgs imevent)
{
bool notified;
OnInfoMessage(imevent, out notified);
}
void conn_InfoMessage(object sender, SqlInfoMessageEventArgs e)
{
StringBuilder sb = new StringBuilder();
sb.AppendLine("from pipe");
sb.AppendLine(e.Message);
foreach (SqlError error in e.Errors)
{
sb.AppendLine(error.Message);
}
infoMessage = sb.ToString();
}
protected void OnInfoMessage(object sender, SqlInfoMessageEventArgs args)
{
foreach (SqlError err in args.Errors)
{
_SqlCommandMsgs += err.Message + NL;
}
}
//Activate This Construntor to log All To Standard output
//public TestClass():base(true){}
//Activate this constructor to log Failures to a log file
//public TestClass(System.IO.TextWriter tw):base(tw, false){}
//Activate this constructor to log All to a log file
//public TestClass(System.IO.TextWriter tw):base(tw, true){}
//BY DEFAULT LOGGING IS DONE TO THE STANDARD OUTPUT ONLY FOR FAILURES
private void con_InfoMessage(object sender, SqlInfoMessageEventArgs e)
{
errorCounter++;
}
void conn_InfoMessage(object sender, SqlInfoMessageEventArgs e)
{
foreach(SqlError err in e.Errors) {
if(err.Message == "+")
Writer.EnterObject((ObjectNode)writeQueue.Dequeue());
else if(err.Message == "-")
Writer.LeaveObject((ObjectNode)writeQueue.Dequeue());
else if(err.Message.StartsWith("="))
Writer.WriteField((FieldNode)writeQueue.Dequeue(), err.Message.Substring(1));
else
errors.Add(err);
}
int writesDone = writeCount - writeQueue.Count;
if(writesDone - lastWriteReport > 100) {
lastWriteReport = writesDone;
if(options.ProgressHandler != null)
options.ProgressHandler(this, writesDone, writeCount);
}
}
internal void OnInfoMessage(SqlInfoMessageEventArgs imevent, out bool notified) => throw new PlatformNotSupportedException(EXCEPTION_MESSAGE);
internal static void InfoMessageHandler(object sender, SqlInfoMessageEventArgs e)
{
System.Diagnostics.Trace.WriteLine(e.ToString(), string.Format("{0}[{1}]", typeof(Role_FeatureDb).FullName, e.Errors[0].Procedure));
}
void StoredProcedure_InfoMessage(object sender, SqlInfoMessageEventArgs e)
{
foreach (SqlError error in e.Errors)
{
Logger.Error(String.Format("Error While Execute StoredProcedure: {0} - {1}", error.Procedure, error.Message));
}
ppWait.Invoke(new MethodInvoker(() =>
{
ppWait.Description = e.Message;
//ppWait.Refresh();
//Application.DoEvents();
}));
}
void con_InfoMessage(object sender, SqlInfoMessageEventArgs e)
{
lbLog.Items.Add("INFO: " + e.Message);
}
private void cn_InfoMessage(object sender, System.Data.SqlClient.SqlInfoMessageEventArgs e)
{
Trace.WriteLine(e.Message);
}
void _conn_InfoMessage(object sender, SqlInfoMessageEventArgs e)
{
_builder.AppendLine(e.Message);
}
private void DisplayInfoMessage(object sender, SqlInfoMessageEventArgs e)
{
Trace.WriteLine(e.Message);
}
