public List <Firm> GetAllFirms(string transactionID) { List <Firm> firmsList = new List <Firm>(); FinancingPMSLogger financingPMSLogger = new FinancingPMSLogger("GetAllFirms service (DB call) has started", transactionID); SqlDataReader reader = null; _logger.LogInformation(message: financingPMSLogger.ToString()); try { using (_logger.BeginScope("GetAllFirms")) using (SqlCommand sqlCommand = new SqlCommand()) { sqlCommand.Connection = _connection; sqlCommand.CommandType = CommandType.StoredProcedure; sqlCommand.CommandText = GETALLFIRMS_SP; if (_connection.State == ConnectionState.Closed) { _connection.Open(); } using (reader = sqlCommand.ExecuteReader()) { if (reader.HasRows) { while (reader.Read()) { Firm firm = new Firm() { Id = reader["Id"].ToString(), Name = reader["Name"].ToString() }; firmsList.Add(firm); } } } } } catch (Exception ex) { financingPMSLogger.message = "Error occured while getting Firms list from database"; _logger.LogError(exception: ex, message: financingPMSLogger.ToString()); throw ex; } finally { _connection.Close(); } financingPMSLogger.message = "GetAllFirms service (DB call) has ended"; _logger.LogInformation(message: financingPMSLogger.ToString()); return(firmsList); }
public async Task Invoke(HttpContext context) { Stopwatch time = new Stopwatch(); time.Start(); Guid transactionID = Guid.NewGuid(); context.Request.Headers.Add("transactionID", transactionID.ToString()); FinancingPMSLogger logMessage = new FinancingPMSLogger { message = $"Started executing the Http Request at {time.Elapsed}", transactionID = transactionID.ToString() }; _logger.LogInformation(message: logMessage.ToString()); await _next.Invoke(context); time.Stop(); logMessage.message = $"Completed executing the Http Request at {time.Elapsed}"; }
public IActionResult GetAllFirms() { Guid transactionID = Guid.NewGuid(); FinancingPMSLogger logMessage = new FinancingPMSLogger("GetAllFirms execution started", transactionID.ToString()); _logger.LogInformation(message: logMessage.ToString()); List <Firm> firmsList = new List <Firm>(); try { firmsList = _firmService.GetAllFirms(transactionID.ToString()); if (firmsList.Count == 0) { return(StatusCode(204)); } } catch (Exception ex) { return(StatusCode(500, ex)); } logMessage.message = "GetAllFirms execution ended"; _logger.LogInformation(message: logMessage.ToString()); return(Ok(firmsList)); }