private void CalculateSavings(int savingsId) { List <Savings_Transactions> savingsList = BaseRepository.Context.Savings_Transactions .Where(i => i.Savings_Id == savingsId) .ToList(); CalcModel calcObj = new CalcModel(); foreach (var transaction in savingsList) { if (transaction.Type == "I") { calcObj.TotalIncome += transaction.Value; } else { calcObj.TotalOutcome += transaction.Value; } } Models.DataBase.Savings savingsObj = BaseRepository.GetById(savingsId); savingsObj.TotalAmount = calcObj.TotalProfit; BaseRepository.Context.SaveChanges(); }
private SavingsFormViewModel GetSavingsObj(Models.DataBase.Savings savingsObj) { return(savingsObj.Map(i => new SavingsFormViewModel { Id = i.Id.ToString(), Description = i.Description, Transactions = BaseRepository.Context.Savings_Transactions.Where(u => u.Savings_Id == i.Id).Select(k => new TransactionsViewModel { Id = k.Id.ToString(), Description = k.Description, Type = k.Type, Value = k.Value.ToString("C3"), InputDate = k.InputDate.ToString("dd/MM/yyyy") }).ToList(), TotalAmount = savingsObj.TotalAmount.ToString("C3") })); }