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; } }
public int DeleteOrder(int id) { DataSet ds = new DataSet(); DataSetTableAdapters.ordersTableAdapter adapter = new DataSetTableAdapters.ordersTableAdapter(); return adapter.Delete(id); }
public int UpdateOrder(int orderId, int catalogId, int clientId, int paymentId, DateTime orderDate, String details, double price) { DataSet ds = new DataSet(); DataSetTableAdapters.ordersTableAdapter adapter = new DataSetTableAdapters.ordersTableAdapter(); return adapter.Update(catalogId, clientId, paymentId, orderDate, details, price, orderId); }
public int InsertOrder(int catalogId, int clientId, int paymentId, DateTime orderDate, String details, double price) { DataSet ds = new DataSet(); DataSetTableAdapters.ordersTableAdapter adapter = new DataSetTableAdapters.ordersTableAdapter(); adapter.Insert(catalogId, clientId, paymentId, orderDate, details, price); // this is a *bad* way of getting the record's identity, but MS Access doesn't support batch SQL statements // a real DB would be able to combine the insert statement and a select statement in one batch call! int identity = (int)adapter.GetIdentity(); return identity; }