public List <Port2> DoWork()
{
Port2 port = new Port2();
port.PortNumber = 1;
port.PortSpecifier = "nice";
List <Port2> list = new List <Port2>();
list.Add(port);
return(list);
}
public List <Port2> getPorts()
{
List <Port2> brandList = new List <Port2>();
SqlConnection connection = new SqlConnection(this.conString);
connection.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM Port", connection);
cmd.CommandType = CommandType.Text;
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
Port2 brand = new Port2();
brand.PortSpecifier = (string)sdr["PortSpecifier"];
brand.PortNumber = (int)sdr["PortNumber"];
brand.PortActivity = (bool)sdr["Activity"];
brandList.Add(brand);
}
return(brandList.ToList());
}
