public List <OrderLine> FindOrderLines(int orderNo) { List <OrderLine> orderLines = new List <OrderLine>(); try { using (SqlConnection con = dBConnection.OpenConnection()) { SqlCommand command = new SqlCommand(FIND_ORDERLINES, con); command.Parameters.AddWithValue("o_id", orderNo); SqlDataReader dr = command.ExecuteReader(); DBProduct dBProduct = new DBProduct(); while (dr.Read()) { OrderLine orderLine = new OrderLine(); orderLine.Product = dBProduct.FindProduct(dr.GetInt("pr_id")); orderLines.Add(orderLine); } } return(orderLines); } catch (TransactionAbortedException) { } return(null); }