public List <Modelo.UF> Select(int aidEstado)
{
Modelo.UF uf;
List <Modelo.UF> listUF = new List <Modelo.UF>();
SqlConnection conn = new SqlConnection(connectionString);
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "Select * from UF Where id = @id";
cmd.Parameters.AddWithValue("@id", aidEstado);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
uf = new Modelo.UF(
(int)dr["id"],
dr["sigla"].ToString()
);
listUF.Add(uf);
}
}
dr.Close();
conn.Close();
return(listUF);
}
public List <Modelo.UF> SelectAll()
{
Modelo.UF aUF;
List <Modelo.UF> aListUF = new List <Modelo.UF>();
SqlConnection conn = new SqlConnection(connectionString);
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "Select * from UF";
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
aUF = new Modelo.UF(
(int)dr["id"],
dr["sigla"].ToString()
);
aListUF.Add(aUF);
}
}
dr.Close();
conn.Close();
return(aListUF);
}
