private void deleteCustomerButton_Click(object sender, EventArgs e) { if (indexCustomer > -1) { var confirmResult = MessageBox.Show("Are you sure you want to delete this Customer?", "Confirm Delete", MessageBoxButtons.YesNo); if (confirmResult == DialogResult.Yes) { try { if (!customerHasAppt(TrackSelected.SelectedCustomerId)) { ; } } catch (CustomerDeletionException customerDeletionException) { Console.WriteLine("/n" + customerDeletionException.Message); return; } U069LrDataSetTableAdapters.customerTableAdapter customerTableAdapter = new U069LrDataSetTableAdapters.customerTableAdapter(); customerTableAdapter.DeleteQuery(TrackSelected.SelectedCustomerId); U069LrDataSetTableAdapters.addressTableAdapter addressTableAdapter = new U069LrDataSetTableAdapters.addressTableAdapter(); addressTableAdapter.DeleteQuery(TrackSelected.SelectedAddressId); } else { MessageBox.Show("Customer deletion cancelled."); } } else { MessageBox.Show("Please select a Customer to delete."); } indexCustomer = -1; formatDataGridView(customerDataGridView); this.customerTableAdapter.Fill(this.u069LrDataSet.customer); }
private void saveCustomerButton_Click(object sender, EventArgs e) { DatabaseConnection con = new DatabaseConnection(); string custNameValue, add1Value, add2Value, postalCodeValue, phoneValue, city; int cityId = 0; int countryId = 0; custNameValue = custNameTextBox.Text; add1Value = add1TextBox1.Text; add2Value = add2TextBox2.Text; postalCodeValue = postalCodeTxtBox.Text; phoneValue = phoneTextBox.Text; DateTime updateDate = DateTime.UtcNow; con.Open(); try { MySqlDataReader row; string query = "select countryId, cityId, city from city where city = '" + cityComboBox.Text + "'"; row = con.ExecuteReader(query); if (row.HasRows) { while (row.Read()) { cityId = Convert.ToInt32(row["cityId"]); countryId = Convert.ToInt32(row["countryId"]); city = row["city"].ToString(); } U069LrDataSetTableAdapters.customerTableAdapter customerTableAdapter = new U069LrDataSetTableAdapters.customerTableAdapter(); customerTableAdapter.UpdateQuery(custNameValue, updateDate, CurrentOnlineUser.currentOnlineUserName, TrackSelected.SelectedCustomerId); U069LrDataSetTableAdapters.addressTableAdapter addressTableAdapter = new U069LrDataSetTableAdapters.addressTableAdapter(); addressTableAdapter.UpdateQuery(add1Value, add2Value, cityId, postalCodeValue, phoneValue, updateDate, CurrentOnlineUser.currentOnlineUserName, TrackSelected.SelectedAddressId); } else { MessageBox.Show("Customer Record not Saved!", "Information"); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Information"); } con.Close(); this.Hide(); CustomersForm customerForm = new CustomersForm(); customerForm.Show(); }