public async Task <IActionResult> Edit(int id, [Bind("DaysAmount,MonthsAmount,YearsAmount,Id")] DepositTerm depositTerm)
{
if (id != depositTerm.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(depositTerm);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!DepositTermExists(depositTerm.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(depositTerm));
}
public async Task <IActionResult> Create([Bind("DaysAmount,MonthsAmount,YearsAmount,Id")] DepositTerm depositTerm)
{
if (ModelState.IsValid)
{
_context.Add(depositTerm);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(depositTerm));
}
private void SetInterestValueByDepositTerm(DepositTerm depositTerm, IQueryable <Deposit> deposits)
{
if (depositTerm == DepositTerm.OneMonth)
{
foreach (var deposit in deposits)
{
deposit.Interest = deposit.InterestForOneMonth;
deposit.DepositTerm = DepositTerm.OneMonth;
}
this.dbContext.SaveChanges();
}
if (depositTerm == DepositTerm.ThreeMonths)
{
foreach (var deposit in deposits)
{
deposit.Interest = deposit.InterestForThreeMonths;
deposit.DepositTerm = DepositTerm.ThreeMonths;
}
this.dbContext.SaveChanges();
}
if (depositTerm == DepositTerm.SixMonths)
{
foreach (var deposit in deposits)
{
deposit.Interest = deposit.InterestForSixMonths;
deposit.DepositTerm = DepositTerm.SixMonths;
}
this.dbContext.SaveChanges();
}
if (depositTerm == DepositTerm.NineMonths)
{
foreach (var deposit in deposits)
{
deposit.Interest = deposit.InterestForNineMonths;
deposit.DepositTerm = DepositTerm.NineMonths;
}
this.dbContext.SaveChanges();
}
if (depositTerm == DepositTerm.TwelveMonths)
{
foreach (var deposit in deposits)
{
deposit.Interest = deposit.InterestForTwelveMonths;
deposit.DepositTerm = DepositTerm.TwelveMonths;
}
this.dbContext.SaveChanges();
}
if (depositTerm == DepositTerm.EighteenMonths)
{
foreach (var deposit in deposits)
{
deposit.Interest = deposit.InterestForEighteenMonths;
deposit.DepositTerm = DepositTerm.EighteenMonths;
}
this.dbContext.SaveChanges();
}
if (depositTerm == DepositTerm.TwentyFourMonths)
{
foreach (var deposit in deposits)
{
deposit.Interest = deposit.InterestForTwentyFourMonths;
deposit.DepositTerm = DepositTerm.TwentyFourMonths;
}
this.dbContext.SaveChanges();
}
if (depositTerm == DepositTerm.ThirtySixMonths)
{
foreach (var deposit in deposits)
{
deposit.Interest = deposit.InterestForThirtySixMonths;
deposit.DepositTerm = DepositTerm.ThirtySixMonths;
}
this.dbContext.SaveChanges();
}
if (depositTerm == DepositTerm.FortyEightMonths)
{
foreach (var deposit in deposits)
{
deposit.Interest = deposit.InterestForFortyEightMonths;
deposit.DepositTerm = DepositTerm.FortyEightMonths;
}
this.dbContext.SaveChanges();
}
if (depositTerm == DepositTerm.SixtyMonths)
{
foreach (var deposit in deposits)
{
deposit.Interest = deposit.InterestForSixtyMonths;
deposit.DepositTerm = DepositTerm.SixtyMonths;
}
this.dbContext.SaveChanges();
}
}
public IQueryable <TModel> Compared <TModel>(decimal amount, Currency currency, DepositTerm depositTerm,
InterestPayment interestPayment, DepositFor depositFor, InterestType interestType,
IncreasingAmount increasingAmount, OverdraftOpportunity overdraftOpportunity,
CreditOpportunity creditOpportunity)
{
var deposits = this.dbContext.Deposits.Where(d => d.Currency == currency);
this.SetAmountForDeposits(amount, deposits);
this.SetInterestValueByDepositTerm(depositTerm, deposits);
deposits = deposits.Where(d => d.MinimumAmount <= amount && d.MaximumAmount >= amount);
deposits = this.FilterDepositsByDepositProperties(interestPayment, depositFor, interestType, increasingAmount, overdraftOpportunity, creditOpportunity, deposits);
var compared = deposits.AsQueryable().ProjectTo <TModel>();
return(compared);
}
