public async Task <IActionResult> Edit(int id, [Bind("ID,ContractNo,Investment")] FutureInv futureInv) { if (id != futureInv.ID) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(futureInv); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!FutureInvExists(futureInv.ID)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(futureInv)); }
public async Task <IActionResult> Create([Bind("ID,ContractNo,Investment")] FutureInv futureInv) { if (ModelState.IsValid) { _context.Add(futureInv); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(futureInv)); }
public async Task <IActionResult> Create([Bind("ID,MonthlyInvestment,YearlyInterestRate,Years")] FutureValueModel futureValueModel, FutureInv fv) { if (ModelState.IsValid) { int months = futureValueModel.Years * 12; decimal monthlyInterestRate = futureValueModel.YearlyInterestRate / 12 / 100; decimal futureValue = 0; for (int i = 0; i < months; i++) { futureValue = (futureValue + futureValueModel.MonthlyInvestment) * (1 + monthlyInterestRate); fv.ContractNo = futureValueModel.ContractNo; fv.Investment = futureValue; _context.Add(fv); await _context.SaveChangesAsync(); } _context.Add(futureValueModel); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(futureValueModel)); }