public IActionResult UpdateMarketBettype([FromBody] MarketBettype marketbettype) { try { if (marketbettype != null) { _logger.LogInformation("API Request hit: UPDATE MarketBettype : " + marketbettype.Id); var result = _bettypeRepository.UpdateMarketBettype(marketbettype); if (result == 0) { return(Ok("{\"status\": \"Success\"}")); } else { _logger.LogInformation("API Request (UPDATE MarketBettype : " + marketbettype.Id + " ) not committed"); return(NotFound("Failed: UPDATE could not commit")); } } else { _logger.LogInformation("API Request hit (UPDATE MarketBettype) with null entry"); return(BadRequest("Failed: null entry")); } } catch (Exception e) { _logger.LogError("API Request (UPDATE MarketBettype) FAILED: ", e); return(BadRequest("Failed")); } }
public IActionResult PostMarketBettype([FromBody] MarketBettype marketBettype) { try { if (marketBettype != null) { _logger.LogInformation("API Request hit: INSERT MarketBettype : "); var result = _marketRepository.AddMarketBettype(marketBettype); if (result == 0) { return(Ok("{\"status\": \"Success\"}")); } else { _logger.LogInformation("API Request (INSERT MarketBettype : ) not committed"); return(NotFound("Failed: INSERT could not commit")); } } else { _logger.LogInformation("API Request hit (INSERT MarketBettype) with null entry"); return(BadRequest("Failed: null entry")); } } catch (Exception e) { _logger.LogError("API Request (INSERT MarketBettype) FAILED: ", e); return(BadRequest("Failed")); } }
public int UpdateMarketBettype(MarketBettype entity) { using (var connection = DBService.GetSqlConnection()) { var result = connection.Execute($"EXECUTE dbo.UpdateMarketBettype {entity.Id},{entity.MarketId},{entity.BettypeId}"); return(result + 1); } }