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