public static int InsertInvoice(FC_Invoice inInvoice, FC_LocalContract InContract)
{
inInvoice.FC_InvoiceID = SQL.GetNextID("FC_Invoice");
SQL.Insert(inInvoice);
FC_InvoiceContractLine newLine = new FC_InvoiceContractLine(InContract.FC_LocalContractID, inInvoice.FC_InvoiceID);
SQL.Insert(newLine);
return(inInvoice.FC_InvoiceID);
}
public static void AddContractToInvoices(FC_Invoice inInvoice, FC_LocalContract InContract)
{
double OtherContractCost = GenerateInvoiceTotal(InContract);
string query = "update FC_Invoice set TotalCost = " + Math.Round((inInvoice.TotalCost + OtherContractCost), 2) + " where FC_InvoiceID = " + inInvoice.FC_InvoiceID.ToString() + ";";
SQL.GenericFunction(query);
FC_InvoiceContractLine newLine = new FC_InvoiceContractLine(InContract.FC_LocalContractID, inInvoice.FC_InvoiceID);
SQL.Insert(newLine);
TMSLogger.LogIt(" | " + "PlannerClass.cs" + " | " + "PlannerClass" + " | " + "AddContractToInvoices" + " | " + "Confirmation" + " | " + "Contract added to invoices" + " | ");
}
