public LastValueWidgetViewModel(WidgetModel model, TableViewModelFactory vmf, int?period) : base(model, new LastValueWidgetSettings(model.Properties.ToDictionary(v => v.Key, v => v.Value))) { _settings = (LastValueWidgetSettings)Settings; var vm = vmf.GetVM(); var column = vm.Headers.First(v => v.Provider == _settings.ProviderName && (v.AccountName == _settings.AccountName || v.UserFriendlyName == _settings.AccountName)); var tableRowViewModel = vm.Values.OrderByDescending(v => v.When).FirstOrDefault(v => v.CalculatedCells.GetValueOrDefault(column)?.IsOk == true); var matchedCell = tableRowViewModel?.CalculatedCells.GetValueOrDefault(column); CurrentValue = matchedCell?.Value; CurrentDate = matchedCell?.Money?.When ?? tableRowViewModel?.When.Date ?? DateTime.MinValue; var p = new PercentageCalculator(); Values = new Dictionary <DateTime, double?>(); bool first = true; foreach (var row in vm.Values.OrderByDescending(v => v.When).Where(v => IsApplicable(v.When, period))) { var cell = row.CalculatedCells.GetValueOrDefault(column); var value = _settings.ExemptTransfers ? cell?.AdjustedValue : cell?.Value; if (value == null || double.IsNaN(value.Value)) { continue; } p.PushValue(row.When, cell.Value.Value, cell.Adjustment); Values[cell.Money?.When ?? row.When.Date] = value; IncompleteData |= cell.FailedToResolve.Any(); if (first) { first = false; (Color, Delta) = SetDiffPercenage(cell.DiffPercentage); } } p.Finalize(this); IncompleteData |= _settings.NotifyStaleData && (!Values.Any() || Values.Select(v => v.Key).Max() < DateTime.Now.AddHours(-36)); if (IsCompact) { Values = null; } }
public LastValueWidgetViewModel(WidgetModel model, ObjectRepository repo) : base(model, new LastValueWidgetSettings(model.Properties.ToDictionary(v => v.Key, v => v.Value))) { _settings = (LastValueWidgetSettings)Settings; try { var column = repo.Set <MoneyColumnMetadataModel>().First(v => v.Provider == _settings.ProviderName && (v.AccountName == _settings.AccountName || v.UserFriendlyName == _settings.AccountName)); var vm = TableViewModel.GetCachedViewModel(true, false, false, repo); Values = new Dictionary <DateTime, double?>(); bool first = true; foreach (var row in vm.Values.OrderByDescending(v => v.When)) { var cell = row.Cells.FirstOrDefault(v => v.Column == column); if (cell == null) { continue; } Values[row.When] = cell.Value; IncompleteData |= !cell.Value.HasValue || cell.FailedToResolve.Any(); if (first) { first = false; (Color, Delta) = SetDiffPercenage(cell.DiffPercentage); } } var minValue = Values.OrderBy(v => v.Key).First(); var maxValue = Values.OrderBy(v => v.Key).Last(); var dV = (maxValue.Value - minValue.Value) / minValue.Value; var dt = (maxValue.Key - minValue.Key).TotalDays; var yearDelta = dV / dt * 365.25; (ColorYear, DeltaYear) = SetDiffPercenage(yearDelta); } catch (Exception ex) { Exception = ex; } }