public RouletteResponse1 GetRoulettes()
{
List <Roulette> rows = new List <Roulette>();
RouletteResponse1 response = new RouletteResponse1();
try
{
Open();
command = new SqlCommand("SELECT * FROM dbo.getRouletteStatus", connection);
reader = command.ExecuteReader();
while (reader.Read())
{
rows.Add(new Roulette(reader.GetFieldValue <int>(0), reader.GetFieldValue <DateTime>(1), reader.GetFieldValue <DateTime>(2), reader.GetFieldValue <string>(3), reader.GetFieldValue <int>(4), reader.GetFieldValue <int>(5)));
}
Close();
response.message = new Message("0000", "Transaccion exitosa", null);
}
catch (Exception ex)
{
response.message = new Message("0002", "Ocurrio un error", ex);
}
response.rouletteList = rows;
return(response);
}
public RouletteResponse1 List()
{
RouletteResponse1 response = new RouletteResponse1();
try
{
DB db = new DB();
response = db.GetRoulettes();
}
catch (Exception ex)
{
response.message = new Message("0000", "Transaccion exitosa", ex);
}
return(response);
}
