public RouletteResponse2 CreateRoulette()
{
RouletteResponse2 response = new RouletteResponse2();
response.rouletteId = 0;
int answer = 0;
try
{
Open();
command = new SqlCommand("EXEC dbo.createNewRoulette", connection);
reader = command.ExecuteReader();
while (reader.Read())
{
answer = reader.GetFieldValue <int>(0);
}
Close();
if (answer != 0)
{
response.message = new Message("0000", "Transaccion exitosa, ruleta creada", null);
response.rouletteId = answer;
}
else
{
response.message = new Message("0006", "Transaccion fallida.", null);
}
}
catch (Exception ex)
{
response.message = new Message("0005", "Transaccion fallida.", ex);
}
return(response);
}
public RouletteResponse2 Create()
{
RouletteResponse2 response = new RouletteResponse2();
try
{
DB db = new DB();
response = db.CreateRoulette();
}
catch (Exception ex)
{
response.message = new Message("0003", "Transaccion fallida", ex);
}
return(response);
}
