public List <Conta> GetAll()
{
//using (connection)
//{
var sql = "select * from Conta";
connection.Close();
connection.Open();
var comando = new SqlCommand(sql, connection);
SqlDataReader reader = comando.ExecuteReader();
Conta conta = null;
List <Conta> listUsuarios = new List <Conta>();
while (reader.Read())
{
String Tipo = reader["Tipo"].ToString();
if (Tipo == "P")
{
conta = new ContaPoupanca();
}
else
{
conta = new ContaCorrente();
}
conta.Id = Convert.ToInt32(reader["Id"]);
conta.Numero = reader["Numero"].ToString();
conta.Agencia = reader["Agencia"].ToString();
conta.Saldo = Convert.ToDecimal(reader["Saldo"]);
conta.Tipo = Tipo;
listUsuarios.Add(conta);
}
connection.Close();
return(listUsuarios);
//}
}
public Conta Buscar(string Num)
{
var sql = "select * from Conta where Numero=@Numero;";
connection.Close();
connection.Open();
var comando = new SqlCommand(sql, connection);
comando.Parameters.AddWithValue("@Numero", Num);
SqlDataReader rdr = comando.ExecuteReader();
Conta c = null;
while (rdr.Read())
{
String Tipo = rdr["Tipo"].ToString();
if (Tipo == "P")
{
c = new ContaPoupanca();
}
else
{
c = new ContaCorrente();
}
c.Id = Convert.ToInt32(rdr["Id"]);
c.Numero = rdr["Numero"].ToString();
if (c.Numero.Equals(Num))
{
c.Id = Convert.ToInt32(rdr["Id"]);
c.Numero = rdr["Numero"].ToString();
c.Agencia = rdr["Agencia"].ToString();
c.Saldo = Convert.ToDecimal(rdr["Saldo"]);
c.Tipo = Tipo;
}
}
return(c);
}
