private void btnAddVendorFormCancel_Click(object sender, EventArgs e)
{
VendorsListForm vendorsListForm = new VendorsListForm();
vendorsListForm.Show();
this.Close();
}
private void btnVendorsFormDeleteVend_Click(object sender, EventArgs e)
{
if (vendorIDTextBox.Text == "")
{
MessageBox.Show("No vendor selected. Please select a vendor to delete.", "Delete Error");
}
else
{
int currentVend = Convert.ToInt32(vendorIDTextBox.Text);
var editedVend = (from vendor in VendorDb.Vendors
where vendor.VendorID == currentVend
select vendor).Single();
DialogResult result = MessageBox.Show($"Delete {editedVend.VendorName}?", "Confirm Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
try
{
VendorDb.Vendors.Remove(editedVend);
VendorDb.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
this.Close();
if (VendorDb.Entry(editedVend).State == EntityState.Detached)
{
MessageBox.Show("Another user has deleted that vendor.", "Concurrency Error");
}
else
{
MessageBox.Show("Another user has updated that vendor.", "Concurrency Error");
}
VendorsListForm newForm = new VendorsListForm();
newForm.Show();
}
catch (DbUpdateException)
{
this.Close();
MessageBox.Show("Unable to delete vendor. The vendor has records related in the purchase order table.", "Vendor Not Deleted");
VendorsListForm newForm = new VendorsListForm();
newForm.Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString());
}
}
}
}
private void btnAddVendorFormSaveChanges_Click(object sender, EventArgs e)
{
vendor.VendorName = vendorNameTextBox.Text;
vendor.VendorPhoneNum = vendorPhoneNumTextBox.Text;
vendor.VendorAddress = vendorAddressTextBox.Text;
vendor.VendorCity = vendorCityTextBox.Text;
vendor.VendorState = vendorStateComboBox.SelectedValue.ToString();
vendor.VendorZipCode = vendorZipCodeTextBox.Text;
AddVendorDb.Vendors.Add(vendor);
AddVendorDb.SaveChanges();
VendorsListForm vendorsListForm = new VendorsListForm();
vendorsListForm.Show();
this.Close();
}
