private void GetLineItem(int lineItemsID)
{
try
{
lineItem = InvoiceLineItemsDB.GetLineItem(lineItemsID);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString());
}
}
private void DeleteBtn_Click(object sender, EventArgs e)
{
if (lineItemsIDTextBox.Text.Length == 0)
{
MessageBox.Show("Please select an invoice first.");
return;
}
int lineItemID = Convert.ToInt32(lineItemsIDTextBox.Text);
this.GetLineItem(lineItemID);
DialogResult result = MessageBox.Show("Delete " + lineItem.lineItemsID + "?",
"Confirm Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
try
{
if (!InvoiceLineItemsDB.DeleteLineItem(lineItem))
{
MessageBox.Show("Another user has updated or deleted " +
"that line item.", "Database Error");
this.GetLineItem(lineItem.lineItemsID);
if (lineItem != null)
{
this.Display();
}
else
{
this.ClearControls();
}
}
else
{
this.ClearControls();
}
}
catch (Exception ex)
{
MessageBox.Show("Can't delete due to referencial integrity.");
//MessageBox.Show(ex.Message, ex.GetType().ToString());
}
}
}
private void BtnAccept_Click(object sender, EventArgs e)
{
if (IsValidData())
{
if (addLineItem)
{
lineItem = new InvoiceLineItem();
this.PutData(lineItem);
try
{
lineItem.lineItemsID = InvoiceLineItemsDB.AddLineItem(lineItem);
this.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString());
}
}
else
{
InvoiceLineItem newLineItem = new InvoiceLineItem();
newLineItem.lineItemsID = lineItem.lineItemsID;
this.PutData(newLineItem);
try
{
if (!InvoiceLineItemsDB.UpdateLineItem(lineItem, newLineItem))
{
MessageBox.Show("Another user has updated or " +
"deleted that line item.", "Database Error");
this.DialogResult = DialogResult.Retry;
}
else
{
lineItem = newLineItem;
this.DialogResult = DialogResult.OK;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString());
}
}
}
}
