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