private int Insert(RequestLogDBModel requestLog) { string query = "" + " INSERT INTO dbo.MyTable " + " VALUES (@ParamLogMethod, @ParamIsSuccess @ParamTimestamp); "; var parameters = new { ParamLogMethod = requestLog.LogMethod, ParamIsSuccess = requestLog.IsSuccess, ParamTimestamp = requestLog.Timestamp }; try { /* * - IN CASE WE RUN THE PROGRAM USING THE 'Medialink.WinFormsUI' AND NOT TO RUN THE TESTS - * * As the connection to the database in not valid, we know it will throw an exception. * Because of that, we asssume that the log inserted succesfully so the 'rowsAffected' equals to 1. * */ //int rowsAffected = _databaseConnection.Execute(query, parameters); int rowsAffected = 1; return(rowsAffected); } catch (Exception) { throw; } }
public int Log(RequestLogDBModel requestLog) { PrintLogDetailsInConsole(requestLog); int rowsAffected = Insert(requestLog); return(rowsAffected); }
private void PrintLogDetailsInConsole(RequestLogDBModel requestLog) { Console.WriteLine("\n\n - LOG DETAILS - " + $"\n LogMethod: {requestLog.LogMethod}, " + $"\n IsSuccess: {requestLog.IsSuccess}" + $"\n Timestamp: {requestLog.Timestamp}, " + ""); }
private void LogRequest(string apiRoute, bool isSuccess) { RequestLogDBModel requestLog = new RequestLogDBModel { LogMethod = apiRoute, IsSuccess = isSuccess, Timestamp = DateTime.Now }; try { int rowsAffected = _logger.Log(requestLog); PrintLogInsertResultInConsole(rowsAffected, null); } catch (Exception ex) { PrintLogInsertResultInConsole(-1, ex.Message); throw; } }