public Juridico LeerJuridico(string rif)
{
try
{
Conexion.Open();
string Comando = "SELECT * FROM juridico WHERE cl_rif = @rif";
Script = new NpgsqlCommand(Comando, Conexion);
Script.Parameters.AddWithValue("rif", rif);
Reader = Script.ExecuteReader();
if (Reader.Read())
{
Juridico juridico = new Juridico(ReadString(0), ReadString(1), ReadString(2), ReadFloat(3), ReadString(4),
ReadInt(5), ReadInt(6));
Cliente cliente = new Cliente(juridico.RIF);
juridico.Base(cliente);
return(juridico);
}
}
finally
{
Conexion.Close();
}
return(null);
}
public List <Juridico> TodosJuridicos()
{
List <Juridico> lista = new List <Juridico>();
try
{
Conexion.Open();
string Command = "SELECT * FROM juridico";
NpgsqlCommand Script = new NpgsqlCommand(Command, Conexion);
Reader = Script.ExecuteReader();
while (Reader.Read())
{
Juridico juridico = new Juridico(ReadString(0), ReadString(1), ReadString(2), ReadFloat(3),
ReadString(4), ReadInt(5), ReadInt(6));
lista.Add(juridico);
}
}
catch (Exception e)
{
throw new Exception("Ha ocurrido un error en la base de datos", e);
}
finally
{
Conexion.Close();
foreach (Juridico juridico in lista)
{
Cliente cliente = new Cliente(juridico.RIF);
juridico.Base(cliente);
}
}
return(lista);
}