/// <summary> /// Delete the given customer /// </summary> public void DeleteCustomer(CustomerDataObject customer) { // find the row which this data object maps to NorthwindDataSet.CustomersRow customerRow = NorthWindDataProvider.NorthwindDataSet.Customers.FindByCustomerID(customer.ID); // remove this object customerRow.Delete(); // use the table adapter to write to the database adapter.Update(NorthWindDataProvider.NorthwindDataSet.Customers); }
/// <summary> /// Updates or adds the given customer /// </summary> public void UpdateCustomer(CustomerDataObject customer) { // find the row which this data object maps to NorthwindDataSet.CustomersRow customerRow = NorthWindDataProvider.NorthwindDataSet.Customers.FindByCustomerID(customer.ID); // if we cannot find this customer - it must be a new instance if (customerRow == null) { // create a new row and populate the columns customerRow = NorthWindDataProvider.NorthwindDataSet.Customers.NewCustomersRow(); DataRowFromBusinessObject(customerRow, customer); // add it to the table NorthWindDataProvider.NorthwindDataSet.Customers.Rows.Add(customerRow); } else { // map changes DataRowFromBusinessObject(customerRow, customer); } // use the table adapter to write to the database adapter.Update(NorthWindDataProvider.NorthwindDataSet.Customers); }
private void DataRowFromBusinessObject(NorthwindDataSet.CustomersRow row, CustomerDataObject dataObject) { row.CustomerID = dataObject.ID; row.ContactName = dataObject.ContactName; row.CompanyName = dataObject.CompanyName; }