Logging Exceptions and the Commands that Caused Them.

public void LogException(Exception ex)

{

    LogException(ex, null);

}

public void LogExceptionx(Exception ex, SqlCommand objBadCmd)

{

    int id = 0;

    if (this._WritingErrorLog == true)

    {

        // don't want to get in an infinite loop.

        return;

    }

    else

    {

        this._WritingErrorLog = true;

    }

    try

    {

        SqlCommand objCmd = this.GetNewCmd("dbo.insertException");

        string message = "";

        // Get the userId of the user that got the error.

        if (System.Web.HttpContext.Current.Request.Cookies["UID"] != null)

            message = System.Web.HttpContext.Current.Request.Cookies["UID"].Value + "|";

        // Add the command that gave the error.

        if (objBadCmd != null && !string.IsNullOrEmpty(objBadCmd.CommandText))

            message += objBadCmd.CommandText + "|";

        message += ex.ToString();

        if (message.Length > 8000)

            message = message.Substring(0, 7999);

        objCmd.Parameters.Add("@Message", SqlDbType.VarChar, 8000).Value = message;

        objCmd.Parameters.Add("@StackTrace", SqlDbType.VarChar, 8000).Value =

            ((ex.StackTrace == null) ? "no stack trace." : ex.StackTrace);

        //insert the exception and get the new ID.

        id = this.ExecuteScalarInt(objCmd);

        if (id > 0 && objBadCmd != null)

            insertExceptionCmd(id, objBadCmd);

    }

    catch (Exception ExLogException)

    {

        this.LogExceptionToFile(ex);

        this.LogExceptionToFile(ExLogException);

    }

    this._WritingErrorLog = false;

}

private string getCmdString(SqlCommand objBadCmd)

{

    if (objBadCmd == null)

        return string.Empty;

    if (objBadCmd.Parameters == null || objBadCmd.Parameters.Count == 0)

        return objBadCmd.CommandText;

    StringBuilder sb = new StringBuilder();

    try

    {

        sb.Append(objBadCmd.CommandText+" ");

        for (int i = 0; i < objBadCmd.Parameters.Count; i++)

        {

            SqlParameter p = objBadCmd.Parameters[i];

            if (i > 0)

                sb.Append(", ");

            sb.Append(p.ParameterName + "=");

            if (p.Value == null)

                sb.Append("null");

            else

            {

                switch (objBadCmd.Parameters[i].SqlDbType)

                {

                    case SqlDbType.BigInt:

                    case SqlDbType.Int:

                    case SqlDbType.Float:

                    case SqlDbType.Decimal:

                    case SqlDbType.SmallInt:

                    case SqlDbType.Money:

                    case SqlDbType.Image:

                    case SqlDbType.Real:

                    case SqlDbType.SmallMoney:

                    case SqlDbType.TinyInt:

                    case SqlDbType.DateTimeOffset:

                        sb.Append(p.Value.ToString());

                        break;

                    default:

                        sb.Append("'" + p.Value.ToString() + "'");

                        break;

                }

            }

        }

    }

    catch (Exception ex)

    {

        return "getCmdString created its own error processing:  " + 

            sb.ToString() + "      +++++" + ex.ToString().Substring(0, 8000);

    }

    return sb.ToString();

}