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));
}
}
