public void UpdateRoulette(ResponseBets model) { using (SqlConnection connection = new SqlConnection(connectionString)) { string query = "update Roulettes set WinNumber=@WinNumber,DateClose=@DateClose" + "where IdRoulette=@id"; SqlCommand command = new SqlCommand(query, connection); command.Parameters.AddWithValue("@WinNumber", model.WinNumber); command.Parameters.AddWithValue("@DateClose", DateTime.UtcNow); command.Parameters.AddWithValue("@id", model.IdRoulette); try { connection.Open(); command.ExecuteNonQuery(); connection.Close(); } catch (Exception ex) { throw new Exception("Ha ocurrido un error en la BD: " + ex.Message); } } }
public IActionResult Close(int Id) { try { _log.LogInformation("Getting the bets..."); var InBets = _db.ListBets(Id); CalculateCloseRoulette calculate = new CalculateCloseRoulette(); _log.LogInformation("Calculating de Amount Earned..."); var OutBets = calculate.Calculate(InBets); ResponseBets model = new ResponseBets(); model.Bets = OutBets; model.IdRoulette = Id; model.WinNumber = calculate.WinNumber; _log.LogInformation("Updating Roulette..."); _db.UpdateRoulette(model); _log.LogInformation("Everything has been successful !"); return(Ok(model)); } catch (Exception ex) { _log.LogWarning("Error: " + ex.Message); return(BadRequest(ex.Message)); } }