public ActionResult CreateNew(NewDeposit newDeposit) { Deposit deposit = context.Deposits.Where(d => d.DepositID == newDeposit.Deposit).FirstOrDefault(); ClientsDeposit lastDeposit = context.ClientsDeposits.ToList().LastOrDefault(); String num = lastDeposit.ClientDepositNumber.Substring(lastDeposit.ClientDepositNumber.Length - 9); int depNum = int.Parse(num); depNum++; num = depNum.ToString(); while (num.Length != 9) { num = "0" + num; } ClientsDeposit clientsDeposit = new ClientsDeposit(); clientsDeposit.ClientID = newDeposit.id; clientsDeposit.DepositID = newDeposit.Deposit; clientsDeposit.Amount = newDeposit.Ammount; clientsDeposit.DateStart = DateTime.Today; clientsDeposit.DateEnd = DateTime.Today.AddMonths(deposit.Period); clientsDeposit.Period = deposit.Period; clientsDeposit.ClientDepositNumber = deposit.BalanceId.ToString() + num; clientsDeposit.Revocable = deposit.Revocable; clientsDeposit.Active = true; context.ClientsDeposits.Add(clientsDeposit); context.SaveChanges(); Currency currency = context.Currency.Where(c => c.CurrencyID == deposit.CurrencyID).FirstOrDefault(); ClientsDeposit Fond = context.ClientsDeposits.Where(d => d.ClientID == 0).FirstOrDefault(); ClientsDeposit fond = Fond; fond.Amount = Fond.Amount + clientsDeposit.Amount * currency.Value; context.Entry(Fond).CurrentValues.SetValues(fond); InterestDeposit interestDeposit = new InterestDeposit(); interestDeposit.ClientsDepositID = clientsDeposit.ClientsDepositID; interestDeposit.InterestDepositNumber = clientsDeposit.ClientDepositNumber = "7770" + num; interestDeposit.InitialAmount = clientsDeposit.Amount; interestDeposit.Percent = deposit.Percent; interestDeposit.Amount = 0; interestDeposit.Active = true; context.InterestDeposits.Add(interestDeposit); context.SaveChanges(); return(Json(new AjaxResponse(new AjaxResponse()))); }
public ActionResult Revocable(int id) { InterestDeposit interestDeposit = context.InterestDeposits.Where(i => i.ClientsDepositID == id).FirstOrDefault(); InterestDeposit tempInterest = interestDeposit; tempInterest.Active = false; context.Entry(interestDeposit).CurrentValues.SetValues(tempInterest); ClientsDeposit clientDeposit = context.ClientsDeposits.Where(c => c.ClientsDepositID == id).FirstOrDefault(); ClientsDeposit tempDeposit = clientDeposit; tempDeposit.Active = false; context.Entry(clientDeposit).CurrentValues.SetValues(tempDeposit); ClientsDeposit Fond = context.ClientsDeposits.Where(c => c.ClientID == 0).FirstOrDefault(); ClientsDeposit tempFond = Fond; tempFond.Amount -= clientDeposit.Amount; context.Entry(Fond).CurrentValues.SetValues(tempFond); context.SaveChanges(); return(RedirectToAction("/DepositList/" + clientDeposit.ClientID.ToString())); }