/// <summary>
/// Executes the stored procedures
/// </summary>
/// <param name="logEntry">The LogEntry to store in the database</param>
private void ExecuteStoredProcedure(LogEntry logEntry)
{
using (DbConnection connection = database.CreateConnection())
{
connection.Open();
try
{
using (DbTransaction transaction = connection.BeginTransaction())
{
try
{
int logID = Convert.ToInt32(ExecuteWriteLogStoredProcedure(logEntry, database, transaction));
ExecuteAddCategoryStoredProcedure(logEntry, logID, database, transaction);
transaction.Commit();
}
catch
{
transaction.Rollback();
throw;
}
}
}
finally
{
connection.Close();
}
}
}