public List<Order> GetOrdersByClientId(int id)
{
List<Order> orders = new List<Order>();
DataSet ds = new DataSet();
DataSetTableAdapters.ordersTableAdapter adapter = new DataSetTableAdapters.ordersTableAdapter();
adapter.Fill(ds.orders);
// find the order
DataSet.ordersDataTable table = adapter.GetOrdersByClientId(id);
// load all orders into the list
foreach (DataSet.ordersRow row in table.Rows)
{
// create memory for new order & fill in properties
Order o = new Order();
o.ID = row.orderId;
o.CatalogId = row.catalogId;
o.ClientId = row.clientId;
o.PaymentId = row.paymentId;
o.OrderDate = row.orderDate;
o.Details = row.details;
o.Price = row.price;
// add this order to the list
orders.Add(o);
}
// returns the list w/ 0 or more Orders
return orders;
}
