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