public List<Order> GetOrders() { List<Order> orders = new List<Order>(); DataSet ds = new DataSet(); DataSetTableAdapters.ordersTableAdapter adapter = new DataSetTableAdapters.ordersTableAdapter(); adapter.Fill(ds.orders); DataSet.ordersDataTable table = adapter.GetOrderData(); // 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; }
/// <summary> /// /// </summary> /// <param name="name"></param> /// <returns>An order if found; null if order not found</returns> public Order GetOrderById(int id) { DataSet ds = new DataSet(); DataSetTableAdapters.ordersTableAdapter adapter = new DataSetTableAdapters.ordersTableAdapter(); adapter.Fill(ds.orders); Order o = new Order(); // find the order DataSet.ordersDataTable table = adapter.GetOrderById(id); // if a order was found, then fill in the details if (table.Rows.Count > 0) { // use the 1st row's data DataSet.ordersRow row = (DataSet.ordersRow)table.Rows[0]; 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; return o; } else { return null; } }