/// <summary>
/// Devuelve una Familia dado su Nombre
/// </summary>
/// <param name="Nombre">Nombre de la familia</param>
/// <returns>La familia</returns>
public static Familia SelectWhereNombreIs(string Nombre)
{
Familia f = new Familia();
using (SqlConnection conn = new SqlConnection(Properties.Settings.Default.ConnectionString))
{
conn.Open();
string selectString = "select * from Familia where Nombre like @nombre";
using (SqlCommand selectCommand = new SqlCommand(selectString, conn))
{
selectCommand.Parameters.Add("@nombre", SqlDbType.VarChar, 50).Value = Nombre;
SqlDataReader reader = selectCommand.ExecuteReader(CommandBehavior.CloseConnection);
while (reader.Read())
{
f.Id = reader.GetInt32(0);
f.Nombre = reader.GetString(1);
}
}
}
return(f);
}
/// <summary>
/// Devuelve un ArrayList de todas las familias
/// </summary>
/// <returns></returns>
public static ArrayList SelectAll()
{
ArrayList familias = new ArrayList();
using (SqlConnection conn = new SqlConnection(Properties.Settings.Default.ConnectionString))
{
conn.Open();
string selectString = "select * from Familia";
using (SqlCommand selectCommand = new SqlCommand(selectString, conn))
{
SqlDataReader reader = selectCommand.ExecuteReader(CommandBehavior.CloseConnection);
while (reader.Read())
{
Familia f = new Familia();
f.Id = reader.GetInt32(0);
f.Nombre = reader.GetString(1);
familias.Add(f);
}
}
}
return(familias);
}
