private void btnAddInvoiceFormCancel_Click(object sender, EventArgs e)
{
InvoiceListForm newForm = new InvoiceListForm();
newForm.Show();
this.Close();
}
private void btnAddInvoiceFormSaveChanges_Click(object sender, EventArgs e)
{
invoice.InvoiceDate = invoiceDateDateTimePicker.Value;
invoice.CustomerID = Convert.ToInt32(customerIDComboBox.SelectedValue);
addInvDb.Invoices.Add(invoice);
addInvDb.SaveChanges();
this.Close();
MessageBox.Show("Invoice added successfully.", "Invoice Added");
InvoiceListForm invoiceListForm = new InvoiceListForm();
invoiceListForm.Show();
}
private void btnDeleteInvLineItem_Click(object sender, EventArgs e)
{
int invLineItemDetailIdNum = Convert.ToInt32(textBox10.Text);
var deleteInvLineItem = (from invLineItem in invoicesDb.InvoiceLineItems
where invLineItem.InvLineItemDetailID == invLineItemDetailIdNum
select invLineItem).Single();
var deleteInvLineItemServiceName = (from invLineItem in invoicesDb.InvoiceLineItems
where invLineItem.InvLineItemDetailID == invLineItemDetailIdNum
select invLineItem.tblService.ServiceName).Single().ToString();
var deleteInvLineItemEmpName = (from invLineItem in invoicesDb.InvoiceLineItems
where invLineItem.InvLineItemDetailID == invLineItemDetailIdNum
select invLineItem.tblEmployee.EmployeeFName + " " + invLineItem.tblEmployee.EmployeeLName).Single().ToString();
DialogResult result = MessageBox.Show($"Delete Line Item where Invoice Line Item Detail ID = {invLineItemDetailIdNum} (Service Name: {deleteInvLineItemServiceName} | Service performed by: {deleteInvLineItemEmpName})?", "Confirm Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
try
{
invoicesDb.InvoiceLineItems.Remove(deleteInvLineItem);
invoicesDb.SaveChanges();
FilterInvoiceLineItemDataGridView();
}
catch (DbUpdateConcurrencyException)
{
this.Close();
if (invoicesDb.Entry(deleteInvLineItem).State == EntityState.Detached)
{
MessageBox.Show("Another user has deleted that invoice line item.", "Concurrency Error");
}
else
{
MessageBox.Show("Another user has updated that invoice line item.", "Concurrency Error");
}
}
catch (DbUpdateException)
{
this.Close();
MessageBox.Show("Unable to delete invoice line item. Unknown Error Occurred.", "Invoice Line Item Not Deleted");
InvoiceListForm newForm = new InvoiceListForm();
newForm.Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString());
}
}
}
private void btnDeleteInvoice_Click(object sender, EventArgs e)
{
if (invoiceIDTextBox.Text == "")
{
MessageBox.Show("No invoice selected. Please select an invoice to delete.", "Delete Error");
}
else
{
int currentInv = Convert.ToInt32(invoiceIDTextBox.Text);
var editedInv = (from invoice in invoicesDb.Invoices
where invoice.InvoiceID == currentInv
select invoice).Single();
DialogResult result = MessageBox.Show($"Delete Invoice ID: {currentInv.ToString()}?", "Confirm Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
try
{
invoicesDb.Invoices.Remove(editedInv);
invoicesDb.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
this.Close();
if (invoicesDb.Entry(editedInv).State == EntityState.Detached)
{
MessageBox.Show("Another user has deleted that invoice.", "Concurrency Error");
}
else
{
MessageBox.Show("Another user has updated that invoice.", "Concurrency Error");
}
}
catch (DbUpdateException)
{
this.Close();
MessageBox.Show("Unable to delete invoice. Unknown Error Occurred.", "Invoice Not Deleted");
InvoiceListForm newForm = new InvoiceListForm();
newForm.Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString());
}
}
}
}