private TableViewModel(
ObjectRepository repository)
{
Headers = repository.Set <MoneyColumnMetadataModel>().SortColumns().ToList();
Dictionary <string, MoneyColumnMetadataModel> headersCached = new Dictionary <string, MoneyColumnMetadataModel>();
foreach (var h in Headers)
{
if (!string.IsNullOrWhiteSpace(h.UserFriendlyName))
{
headersCached[h.UserFriendlyName] = h;
}
headersCached[h.Provider + "/" + h.AccountName] = h;
}
Values = repository.Set <MoneyStateModel>()
.GroupBy(x => x.When.Date)
.OrderByDescending(v => v.Key)
.Select(v => new TableRowViewModel(v.ToList(), Headers, headersCached))
.ToList();
for (int i = 0; i < Values.Count - 1; i++)
{
var row = Values[i];
row.Previous = Values[i + 1];
foreach (var value in row.Cells)
{
var previous = Values[i + 1];
value.PreviousValue = previous.Cells.FirstOrDefault(v => v.Column == value.Column);
}
}
var markedAsOkCells = Enumerable.Empty <MoneyColumnMetadataModel>();
for (int i = Values.Count - 1; i >= 0; i--)
{
var row = Values[i];
var toAddMissing = markedAsOkCells.Except(row.Cells.Select(v => v.Column)).ToList();
foreach (var item in toAddMissing)
{
row.Cells.Add(CalculatedResult.Empty(item));
}
markedAsOkCells = row.Cells.Where(v => v.Value != null && double.IsNaN(v.Value.Value))
.Select(v => v.Column).ToList();
}
foreach (var rowViewModel in Values)
{
rowViewModel.CalculateItems();
}
}
public EmptyExpression(MoneyColumnMetadataJsModel model)
{
Value = CalculatedResult.Empty(model);
}
public TableViewModel(ObjectRepository repository)
{
var headersDictionary = repository.Set <MoneyColumnMetadataModel>().SortColumns()
.ToDictionary(v => new MoneyColumnMetadataJsModel(v), v => v);
Headers = headersDictionary.Keys.ToList();
var headersCached = new Dictionary <string, MoneyColumnMetadataJsModel>();
foreach (var h in Headers)
{
if (!string.IsNullOrWhiteSpace(h.UserFriendlyName))
{
headersCached[h.UserFriendlyName] = h;
}
headersCached[h.Provider + "/" + h.AccountName] = h;
}
var paymentsToExempt = repository.Set <PaymentModel>().Where(v => v.Kind == PaymentKind.Transfer).ToList().GroupBy(v => v.Column)
.ToDictionary(v => new MoneyColumnMetadataJsModel(v.Key), v =>
{
var d = new Dictionary <DateTime, double>();
foreach (var item in v)
{
d[item.When.Date] = d.GetValueOrDefault(item.When.Date, 0) + item.Amount;
}
return(d);
});
var rows = repository.Set <MoneyStateModel>()
.GroupBy(x => x.When.Date)
.OrderByDescending(v => v.Key)
.ToList();
var end = rows.Select(v => (DateTime?)v.Key.Date).FirstOrDefault();
foreach (var col in paymentsToExempt)
{
var cumulative = 0.0;
DateTime start = col.Value.Keys.Min();
for (; start <= (end ?? start); start = start.AddDays(1))
{
var curValue = col.Value.GetValueOrDefault(start, 0);
if (Math.Abs(cumulative + curValue) >= 0.0001)
{
col.Value[start] = -(curValue + cumulative);
cumulative += curValue;
}
}
}
Values = rows
.Select(v => new TableRowViewModel(v.ToList(), Headers, headersCached, paymentsToExempt))
.ToList();
for (int i = 0; i < Values.Count - 1; i++)
{
var row = Values[i];
row.Previous = Values[i + 1];
foreach (var value in row.CalculatedCells.Values)
{
var previous = Values[i + 1];
value.PreviousValue = previous.CalculatedCells.GetValueOrDefault(value.Column);
}
}
var markedAsOkCells = Enumerable.Empty <MoneyColumnMetadataJsModel>();
for (int i = Values.Count - 1; i >= 0; i--)
{
var row = Values[i];
var toAddMissing = markedAsOkCells.Except(row.CalculatedCells.Keys).ToList();
foreach (var item in toAddMissing)
{
row.CalculatedCells.Add(item, CalculatedResult.Empty(item));
}
markedAsOkCells = row.CalculatedCells.Values.Where(v => !(v is ExpressionCalculatedResult) && v.Value != null && double.IsNaN(v.Value.Value))
.Select(v => v.Column).ToList();
}
var columnsToCheck = Values.SelectMany(v => v.CalculatedCells.Keys).Distinct()
.Where(v => !v.IsComputed).ToList();
for (int i = Values.Count - 1; i >= 0; i--)
{
var row = Values[i];
columnsToCheck = columnsToCheck.Except(row.CalculatedCells.Keys).ToList();
foreach (var item in columnsToCheck)
{
row.CalculatedCells.Add(item, CalculatedResult.Empty(item));
}
}
foreach (var r in Values)
{
foreach (var cell in r.CalculatedCells.Values.OfType <ExpressionCalculatedResult>())
{
if (cell.IsOk && cell.Value != null)
{
repository.Add(new MoneyStateModel
{
Amount = cell.Value.Value,
Ccy = cell.Ccy,
Column = headersDictionary[cell.Column],
When = r.When,
Description = cell.TooltipWithoutAdjustment
});
}
}
}
}