private void FindRecord_Click(object sender, RoutedEventArgs e) { //create a new empty customer object Customer find = new Customer(); //get customer ID from form String CustID = FindID.Text.Trim(); // Create an instance of a data connection to the database customer table CustomerDataDataContext con = new CustomerDataDataContext(); //find customer based upod ID find = (from cust in con.Customers where (cust.CustomerID == CustID) select cust).FirstOrDefault(); //if a matching customer is not found if (object.Equals(find, default(Customer))) { MessageBox.Show("Customer Does not Exist!"); } //if found proceed else { // Close the find edit window DialogResult = false; //open the edit record window EditRecord editRecordWindow = new EditRecord(find); editRecordWindow.ShowDialog(); } }
}//end Cancel_Click //code to handle the Add button click event private void btnAdd_Click(object sender, RoutedEventArgs e) { //add the record to the database //the ID must be unique and specified or do not proceed with the add if (txtCustomerID.Text.Trim() == "") { MessageBox.Show("Missing unique Customer ID", "Entry error", MessageBoxButton.OK, MessageBoxImage.Error); return; } //add the record Customer cust = new Customer(); cust.CustomerID = txtCustomerID.Text.Trim(); cust.CompanyName = txtCompanyName.Text.Trim(); cust.ContactName = txtContactName.Text.Trim(); cust.ContactTitle = txtContactTitle.Text.Trim(); cust.Country = txtCountry.Text.Trim(); cust.City = txtCity.Text.Trim(); cust.Region = txtRegionState.Text.Trim(); cust.PostalCode = txtPostalCode.Text.Trim(); cust.Address = txtAddress.Text.Trim(); cust.Phone = txtPhone.Text.Trim(); cust.Fax = txtFax.Text.Trim(); //main try block try { //create an instance of a data connection to the database customer table CustomerDataDataContext con = new CustomerDataDataContext(); //add new record to the database con.Customers.InsertOnSubmit(cust); con.SubmitChanges(); //tell the user this was added successfully MessageBox.Show("Customer " + cust.CustomerID + " was added successfully."); //refresh the data grid Application app = Application.Current; MainWindow main = (MainWindow)app.MainWindow; main.refreshGrid(); //exit the dialog window with a success result DialogResult = true; } catch (Exception ex) { //tell the user this was successful MessageBox.Show("The item '" + cust.CustomerID + "' could not be added. " + ex.ToString()); //exit the dialog window without doing anything. DialogResult = false; } }//end btnAdd_Click
public EditRecord(Customer cust) { InitializeComponent(); //asign cust to customer object this.customer = cust; //put customer data into form fields ID.Text = customer.CustomerID; CompanyName.Text = customer.CompanyName; ContactName.Text = customer.ContactName; ContactTitle.Text = customer.ContactTitle; Country.Text = customer.Country; City.Text = customer.City; Region.Text = customer.Region; PostalCode.Text = customer.PostalCode; Address.Text = customer.Address; Phone.Text = customer.Phone; Fax.Text = customer.Fax; }
private void OK_Click(object sender, RoutedEventArgs e) { // Add the record to the datbase // The ID must be unique and specified or do not proceed with the add if (ID.Text.Trim() == "") { MessageBox.Show("Missing unique customer ID", "Entry error", MessageBoxButton.OK, MessageBoxImage.Error); return; } // Add the record Customer cust = new Customer(); cust.CustomerID = ID.Text.Trim(); cust.CompanyName = CompanyName.Text.Trim(); cust.ContactName = ContactName.Text.Trim(); cust.ContactTitle = ContactTitle.Text.Trim(); cust.Country = Country.Text.Trim(); cust.City = City.Text.Trim(); cust.Region = Region.Text.Trim(); cust.PostalCode = PostalCode.Text.Trim(); cust.Address = Address.Text.Trim(); cust.Phone = Phone.Text.Trim(); cust.Fax = Fax.Text.Trim(); // Create an instance of a data connection to the database customer table CustomerDataDataContext con = new CustomerDataDataContext(); // Add new record to the database con.Customers.InsertOnSubmit(cust); con.SubmitChanges(); MessageBox.Show("Customer " + cust.CustomerID + " Was added ok"); //refresh the display grid to show changes Application app = Application.Current; MainWindow main = (MainWindow) app.MainWindow; main.refreshGrid(); DialogResult = true; }
partial void DeleteCustomer(Customer instance);
partial void UpdateCustomer(Customer instance);
partial void InsertCustomer(Customer instance);