/// <summary>
/// Updates the balance report.
/// </summary>
/// <param name="edc">The <see cref="Entities" /> representing data model.</param>
/// <param name="getOutboundQuantity">Delegate to get outbound quantity.</param>
/// <param name="batches">The batches.</param>
/// <param name="trace">The trace action.</param>
/// <returns><c>true</c> if the stock is valid (consistent), <c>false</c> otherwise.</returns>
internal bool UpdateBalanceReport(Entities edc, GetOutboundQuantity getOutboundQuantity, List <BalanceBatchWrapper> batches, NamedTraceLogger.TraceAction trace)
{
trace("Entering JSOXLib.UpdateBalanceReport", 43, TraceSeverity.Verbose);
bool _validated = false;
StockDictionary _balanceStock = new StockDictionary();
Dictionary <string, IGrouping <string, IPR> > _accountGroups = Linq.IPR.GetAllOpen4JSOXGroups(edc).ToDictionary(x => x.Key);
Linq.StockLib _stock = Stock(edc);
if (_stock != null)
{
_validated = _stock.Validate(edc, _accountGroups, _stock);
_stock.GetInventory(edc, _balanceStock);
_stock.Stock2JSOXLibraryIndex = this;
}
else
{
ActivityLogCT.WriteEntry(edc, "Balance report", "Cannot find stock report - only preliminary report will be created");
}
List <string> _processed = new List <string>();
IEnumerable <BalanceBatch> _existingBatches = this.BalanceBatch(edc);
foreach (BalanceBatch _bbx in _existingBatches)
{
if (_accountGroups.ContainsKey(_bbx.Batch))
{
List <BalanceIPR> _is = new List <BalanceIPR>();
_bbx.Update(edc, _accountGroups[_bbx.Batch], _balanceStock.GetOrDefault(_bbx.Batch), _is, trace);
batches.Add(new BalanceBatchWrapper()
{
batch = _bbx, iprCollection = _is.ToArray <BalanceIPR>()
});
}
else
{
edc.BalanceBatch.DeleteOnSubmit(_bbx);
}
_processed.Add(_bbx.Batch);
}
foreach (string _btchx in _processed)
{
_accountGroups.Remove(_btchx);
}
foreach (var _grpx in _accountGroups)
{
batches.Add(Linq.BalanceBatch.Create(edc, _grpx.Value, this, _balanceStock.GetOrDefault(_grpx.Key), trace));
}
//Introducing
DateTime _thisIntroducingDateStart = LinqIPRExtensions.DateTimeMaxValue;
DateTime _thisIntroducingDateEnd = LinqIPRExtensions.DateTimeMinValue;
decimal _introducingQuantity = Linq.IPR.GetIntroducingData(edc, this, out _thisIntroducingDateStart, out _thisIntroducingDateEnd);
this.IntroducingDateStart = _thisIntroducingDateStart;
this.IntroducingDateEnd = _thisIntroducingDateEnd;
this.IntroducingQuantity = Convert.ToDouble(_introducingQuantity);
//Outbound
DateTime _thisOutboundDateEnd = LinqIPRExtensions.DateTimeMinValue;
DateTime _thisOutboundDateStart = LinqIPRExtensions.DateTimeMaxValue;
decimal _outQuantity = getOutboundQuantity(edc, this, out _thisOutboundDateStart, out _thisOutboundDateEnd);
this.OutboundQuantity = _outQuantity.Convert2Double2Decimals();
this.OutboundDateEnd = _thisOutboundDateEnd;
this.OutboundDateStart = _thisOutboundDateStart;
//Balance
decimal _thisBalanceQuantity = Convert.ToDecimal(this.PreviousMonthQuantity) + _introducingQuantity - _outQuantity;
this.BalanceQuantity = _thisBalanceQuantity.Convert2Double2Decimals();
//Situation at
decimal _thisSituationQuantity = batches.Select <BalanceBatchWrapper, BalanceBatch>(x => x.batch).Sum <BalanceBatch>(x => x.IPRBookDecimal);
this.SituationQuantity = Convert.ToDouble(_thisSituationQuantity);
//Reassign
this.ReassumeQuantity = (_thisBalanceQuantity - _thisSituationQuantity).Convert2Double2Decimals();
return(_validated);
}
