//Deletes customer
private void btnCustomerFormDeleteCust_Click(object sender, EventArgs e)
{
if (customerIDTextBox.Text == "")
{
MessageBox.Show("No customer selected. Please select a customer to delete.", "Delete Error");
}
else
{
int currentCust = Convert.ToInt32(customerIDTextBox.Text);
var editedCust = (from customer in CustDb.Customers
where customer.CustomerID == currentCust
select customer).Single();
DialogResult result = MessageBox.Show($"Delete {editedCust.CustomerFName} {editedCust.CustomerLName}?", "Confirm Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
try
{
CustDb.Customers.Remove(editedCust);
CustDb.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
this.Close();
if (CustDb.Entry(editedCust).State == EntityState.Detached)
{
MessageBox.Show("Another user has deleted that customer.", "Concurrency Error");
}
else
{
MessageBox.Show("Another user has updated that customer.", "Concurrency Error");
}
CustomersListForm newForm = new CustomersListForm();
newForm.Show();
}
catch (DbUpdateException)
{
this.Close();
MessageBox.Show("Unable to delete customer. The customer has invoices in the invoices table.", "Customer Not Deleted");
CustomersListForm newForm = new CustomersListForm();
newForm.Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString());
}
}
}
}
private void btnAddCustomerFormSaveChanges_Click(object sender, EventArgs e)
{
customer.CustomerFName = customerFNameTextBox.Text;
customer.CustomerLName = customerLNameTextBox.Text;
customer.CustomerPhoneNum = customerPhoneNumTextBox.Text;
customer.CustomerAddress = customerAddressTextBox.Text;
customer.CustomerCity = customerCityTextBox.Text;
customer.CustomerState = customerStateComboBox.SelectedValue.ToString();
customer.CustomerZipCode = customerZipCodeTextBox.Text;
Db.Customers.Add(customer);
Db.SaveChanges();
CustomersListForm = new CustomersListForm();
CustomersListForm.Show();
this.Close();
}
private void btnAddCustomerFormCancel_Click(object sender, EventArgs e)
{
CustomersListForm = new CustomersListForm();
CustomersListForm.Show();
this.Close();
}