/// <summary>
/// Inserts data into the LineItems table
/// </summary>
/// <param name="InvoicedItems"></param>
private void AddLineItems(ObservableCollection <Item> InvoicedItems)
{
//string invoiceNum, int lineItemNum, string itemCode
try
{
clsInvoices invoice = GetMaxInvoice();
foreach (Item item in InvoicedItems) // add LineItem to DB
{
int LineItemNum = 1;
int row = db.ExecuteNonQuery(SQL.InsertLineItems(invoice.InvoiceNum, LineItemNum.ToString(), item.itemCode));
LineItemNum++;
}
}
catch (Exception ex)
{ //this is reflection for exception handling
throw new Exception(MethodInfo.GetCurrentMethod().DeclaringType.Name + "." +
MethodInfo.GetCurrentMethod().Name + " -> " + ex.Message);
}
}
/// <summary>
/// Non Query to Insert Invoice Item into Line Item DB
/// </summary>
/// <param name="invoiceNum"></param>
/// <param name="lineItemNum"></param>
/// <param name="itemCode"></param>
public void InsertLineItem(string invoiceNum, string lineItemNum, string itemCode)
{
try
{
var query = sql.InsertLineItems(invoiceNum, lineItemNum, itemCode);
db.ExecuteNonQuery(query);
}
catch (Exception ex)
{
throw new Exception(MethodInfo.GetCurrentMethod().DeclaringType.Name + "." +
MethodInfo.GetCurrentMethod().Name + " -> " + ex.Message);
}
}
