/// <summary> /// Devuelve un ArrayList con todos los alimentos /// </summary> /// <returns>ArrayList de todos los alimentos</returns> public static ArrayList SelectAll() { ArrayList alimentos = new ArrayList(); using (SqlConnection conn = new SqlConnection(Properties.Settings.Default.ConnectionString)) { conn.Open(); string selectString = "select * from Alimento"; using (SqlCommand selectCommand = new SqlCommand(selectString, conn)) { SqlDataReader reader = selectCommand.ExecuteReader(CommandBehavior.CloseConnection); while (reader.Read()) { Alimento a = new Alimento(); a.Id = reader.GetInt32(0); a.Nombre = reader.GetString(1); try { a.Imagen = Alimento.GetImagen(reader.GetInt32(2)); a.Familia = Familia.Select(reader.GetInt32(3)); } catch (System.Data.SqlTypes.SqlNullValueException ex) {} a.Descripcion = reader.GetString(4); alimentos.Add(a); } } } return(alimentos); }
/// <summary> /// Devuelve un alimento dado su id /// </summary> /// <param name="Id">Id del alimento</param> /// <returns>El alimento</returns> public static Alimento Select(int Id) { Alimento a = null; using (SqlConnection conn = new SqlConnection(Properties.Settings.Default.ConnectionString)) { string selectString = "select * from Alimento where Id = @id"; using (SqlCommand selectCommand = new SqlCommand(selectString, conn)) { conn.Open(); selectCommand.Parameters.Add("@id", SqlDbType.Int).Value = Id; SqlDataReader reader = selectCommand.ExecuteReader(CommandBehavior.CloseConnection); while (reader.Read()) { a = new Alimento(); a.Id = reader.GetInt32(0); a.Nombre = reader.GetString(1); try { a.Imagen = Alimento.GetImagen(reader.GetInt32(2)); }catch (Exception e) { a.Imagen = null; } try { a.Familia = Familia.Select(reader.GetInt32(3)); } catch (Exception e) { a.Familia = null; } a.Descripcion = reader.GetString(4); } } } return(a); }