/// <summary>
/// creates a new invoice
/// </summary>
/// <param name="date"></param>
/// <param name="Line"></param>
public int CreateInvoice(string date, string cost, List <clsLineItems> lstItems)
{
try
{
db.ExecuteNonQuery(Query.CreateInvoice(date, cost));
Int32.TryParse(db.ExecuteScalarSQL(Query.GetInsertedInvoiceId(date, cost)), out int id);
InsertLineItems(id, lstItems);
return(id);
}
catch (Exception ex)
{
throw new Exception(MethodInfo.GetCurrentMethod().DeclaringType + "." +
MethodInfo.GetCurrentMethod().Name + "->" + ex.Message);
}
}
/// <summary>
/// delete selected item if it is not on an invoice
/// </summary>
/// <param name="code"></param>
/// <returns>coonfirmation of deletion</returns>
public void DeleteItems(int code)
{
try
{
SQL = "SELECT count(*) FROM LineItems as LI " +
"WHERE LI.ItemCode = " + code + "";
string Qrows = db.ExecuteScalarSQL(SQL);
if (Qrows == "0")
{
SQL = "DELETE FROM ItemDesc " +
"WHERE ItemCode = " + code + "";
int test = db.ExecuteNonQuery(SQL);
}
else
{
MessageBox.Show("Item is in an invoice. Can not be deleted");
}
}
catch (Exception ex)
{
throw new Exception(MethodInfo.GetCurrentMethod().DeclaringType.Name + "." + MethodInfo.GetCurrentMethod().Name + " -> " + ex.Message);
}
}
