private Decimal?CompareBudget(Decimal?lineAmt, VAdvantage.Model.MOrder order)
{
Decimal?amt = 0;
sql.Clear();
sql.Append(" SELECT SUM(fa.AmtAcctDr) FROM Fact_Acct fa " + whereClause);
Decimal?accBudget = Util.GetValueOfDecimal(DB.ExecuteScalar(sql.ToString(), null, null));
if (bgtAmount < Decimal.Add(accBudget.Value, lineAmt.Value))
{
amt = Decimal.Subtract(Decimal.Add(accBudget.Value, lineAmt.Value), bgtAmount.Value);
if (maxAmount < amt)
{
//sql.Clear();
order.SetIsBudgetViolated(true);
order.SetMaxBudgetViolationAmount(amt);
if (!order.Save())
{
}
//sql.Append("UPDATE " + tableName + " SET IsBudgetViolated = 'Y', MaxBudgetViolationAmount = " + amt + " WHERE " + tableName + "_ID = " + _Record_ID);
//int res = Util.GetValueOfInt(DB.ExecuteQuery(sql.ToString(), null, null));
}
}
return(amt);
}