public List <Event> GetAllEvents() { List <Event> eventList = new List <Event>(); try { List <EventDataModel> resultList = _databaseConnection.GetAllEventsFromDatabase(); foreach (EventDataModel eventData in resultList) { eventList.Add(new Event(eventData.EventNr, eventData.ExceptionType, eventData.Category, eventData.EventTimestamp, eventData.HResult, eventData.Message, eventData.Stacktrace)); } } catch (SqlException e) { ExceptionCore.HandleException(ExceptionCategory.Fatal, e); } catch (InvalidCastException e) { ExceptionCore.HandleException(ExceptionCategory.High, e); } catch (Exception e) { ExceptionCore.HandleException(ExceptionCategory.Normal, e); } return(eventList); }
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); }