public bool LogError_Insert(LogError insertLogError)
{
bool insertSuccessful = true;
SqlCommand cmd = ConfigSettings.DBCmd;
cmd.Parameters.Clear();
cmd.CommandText = "LogError_Insert";
cmd.CommandType = CommandType.StoredProcedure;
SqlTransaction transaction;
// Start a local transaction.
transaction = cmd.Connection.BeginTransaction(IsolationLevel.ReadCommitted, "LogError_Insert");
cmd.Transaction = transaction;
try
{
cmd.Parameters.Add("@LogErrorMethod", SqlDbType.Text, 50);
cmd.Parameters.Add("@LogErrorMessage", SqlDbType.Text, 4000);
cmd.Parameters.Add("@LogErrorSource", SqlDbType.Text, 4000);
cmd.Parameters["@LogErrorMethod"].Value = insertLogError.LogErrorMethod;
cmd.Parameters["@LogErrorMessage"].Value = insertLogError.LogErrorMessage;
cmd.Parameters["@LogErrorSource"].Value = insertLogError.LogErrorSource;
cmd.Parameters.Add("@RETURNVALUE", SqlDbType.Int);
cmd.Parameters["@RETURNVALUE"].Direction = ParameterDirection.ReturnValue;
cmd.ExecuteNonQuery();
transaction.Commit();
int returnValue = int.Parse(cmd.Parameters["@RETURNVALUE"].Value.ToString());
if (returnValue < 0)
{
throw new Exception("Error Text Added to the Database: " + returnValue.ToString());
}
}
catch (Exception e)
{
try
{
transaction.Rollback();
}
catch (SqlException ex)
{
if (transaction.Connection != null)
{
Console.WriteLine("An exception of type " + ex.GetType() +
" was encountered while attempting to roll back the transaction.");
}
}
Console.WriteLine("An exception of type " + e.GetType() +
" was encountered while inserting the data.");
Console.WriteLine("Neither record was written to database.");
insertSuccessful = false;
}
return insertSuccessful;
}
public static bool AddLogError(
string _logErrorMethod,
string _logErrorMessage,
string _logErrorSource
)
{
bool returnvalue;
LogError addError = new LogError();
addError.LogErrorMethod = _logErrorMethod;
addError.LogErrorMessage = _logErrorMessage;
addError.LogErrorSource = _logErrorSource;
returnvalue = _dac.LogError_Insert(addError);
return returnvalue;
}
public static bool AddLogError(LogError newLogError)
{
bool returnvalue;
returnvalue = _dac.LogError_Insert(newLogError);
return returnvalue;
}
