public static ProveedorList Get()
{
ProveedorList res = new ProveedorList();
SqlCommand cmd = null;
SqlDataReader dr = null;
string query = "SELECT * FROM Proveedor";
try
{
cmd = Methods.CreateBasicCommand(query);
dr = Methods.ExecuteDataReaderCommand(cmd);
while (dr.Read())
{
int idProveedor = dr.GetInt32(0);
Proveedor proveedor = ProveedorDal.Get(idProveedor);
res.Add(new Proveedor()
{
ProveedorId = idProveedor,
NombreProveedor = proveedor.NombreProveedor,
ApellidoProveedor = proveedor.ApellidoProveedor,
CorreoElectronico = proveedor.ApellidoProveedor,
});
}
}
catch (SqlException ex)
{
//Methods.GenerateLogsRelease("KeyValuePacienteListDal", "Obtener", ex.Message + " " + ex.StackTrace);
throw ex;
}
catch (Exception ex)
{
//Methods.GenerateLogsRelease("KeyValuePacienteListDal", "Obtener", ex.Message + " " + ex.StackTrace);
throw ex;
}
finally
{
cmd.Connection.Close();
}
return(res);
}
