public void TestAddAndGetEventFromDatabase()
{
List <EventDataModel> eventsBeforeAdd = databaseConnection.GetAllEventsFromDatabase();
databaseConnection.AddEventToDatabase("FormatException", "HIGH", Convert.ToDateTime("07.05.2015 10:10:10"), "2", "Nice try", "Stacktrace");
List <EventDataModel> eventsAfterAdd = databaseConnection.GetAllEventsFromDatabase();
int lastIndex = 0;
// Check added Event
Assert.AreEqual("FormatException", eventsAfterAdd[lastIndex].ExceptionType);
Assert.AreEqual("HIGH", eventsAfterAdd[lastIndex].Category);
Assert.AreEqual("07.05.2015 10:10:10", eventsAfterAdd[lastIndex].EventTimestamp.ToString());
Assert.AreEqual(2, eventsAfterAdd[lastIndex].HResult);
Assert.AreEqual("Nice try", eventsAfterAdd[lastIndex].Message);
Assert.AreEqual("Stacktrace", eventsAfterAdd[lastIndex].Stacktrace);
}
public static void SaveExceptionToDB(string category, Exception exc)
{
DatabaseConnectionMonitor connectionManager = new DatabaseConnectionMonitor(Properties.Settings.Default.ProdDatabase);
connectionManager.AddEventToDatabase(exc.GetType().ToString(), category, DateTime.Now, exc.HResult.ToString(), exc.Message, exc.StackTrace);
}
