Esempio n. 1
0
        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"));
            }
        }
Esempio n. 2
0
        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"));
            }
        }
Esempio n. 3
0
 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);
     }
 }