public CloseRouletteResponse Close(int rouletteId)
{
CloseRouletteResponse response = new CloseRouletteResponse();
try
{
DB db = new DB();
response = db.CloseRoulette(rouletteId);
}
catch (Exception ex)
{
response.message = new Message("0024", "Transaccion fallida.", ex);
}
return(response);
}
public CloseRouletteResponse CloseRoulette(int rouletteId)
{
CloseRouletteResponse response = new CloseRouletteResponse();
Process process = new Process();
List <BetResult> resultList = new List <BetResult>();
string value = "";
try
{
response.gameResult = process.ExecuteRoulette();
Open();
command = new SqlCommand("dbo.closeRoulette", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@rouletteId", rouletteId);
command.Parameters.AddWithValue("@number", response.gameResult.number);
command.Parameters.AddWithValue("@color", response.gameResult.color);
reader = command.ExecuteReader();
while (reader.Read())
{
resultList.Add(new BetResult(reader.GetFieldValue <string>(0), reader.GetFieldValue <string>(1), reader.GetFieldValue <double>(2), reader.GetFieldValue <int>(3), reader.GetFieldValue <string>(4), reader.GetFieldValue <double>(5), reader.GetFieldValue <int>(6), reader.GetFieldValue <string>(7)));
response.resultList = resultList;
value = reader.GetFieldValue <string>(7);
}
Close();
if (value == "0")
{
response.message = new Message("0026", "Transaccion fallida, la ruleta indicada no es valida.", null);
response.gameResult = null;
}
else
{
response.message = new Message("0000", "Transaccion exitosa.", null);
}
}
catch (Exception ex)
{
response.message = new Message("0025", "Ocurrio un error. ", ex);
}
return(response);
}
