public ActionResult Transfer(TransferViewModel transfer)
        {
            // check for available funds
            var sourceCheckingAccount = db.CheckingAccounts.Find(transfer.CheckingAccountId);
            if (sourceCheckingAccount.Balance < transfer.Amount)
            {
                ModelState.AddModelError("Amount", "You have insufficient funds!");
            }

            // check for a valid destination account
            var destinationCheckingAccount = db.CheckingAccounts.Where(c => c.AccountNumber == transfer.DestinationCheckingAccountNumber).FirstOrDefault();
            if (destinationCheckingAccount == null)
            {
                ModelState.AddModelError("DestinationCheckingAccountNumber", "Invalid destination account number.");
            }

            // add debit/credit transactions and update account balances
            if (ModelState.IsValid)
            {
                db.Transactions.Add(new Transaction { CheckingAccountId = transfer.CheckingAccountId, Amount = -transfer.Amount });
                db.Transactions.Add(new Transaction { CheckingAccountId = destinationCheckingAccount.Id, Amount = transfer.Amount });
                db.SaveChanges();

                var service = new CheckingAccountService(db);
                service.UpdateBalance(transfer.CheckingAccountId);
                service.UpdateBalance(destinationCheckingAccount.Id);

                return PartialView("_TransferSuccess", transfer);
            }
            return PartialView("_TransferForm");
        }
        public ActionResult Transfer(TransferViewModel transfer)
        {
            // verifica se existe saldo na sua conta
            CheckingAccount sourceCheckingAccount = db.CheckingAccounts.Find(transfer.CheckingAccountId);
            if (sourceCheckingAccount.Balance < transfer.Amount)
            {
                // se não houver saldo, erro ao adicionado ao estado do model
                ModelState.AddModelError("Amount", "You have insufficient funds!");
            }

            // verificar se a conta destino existe
            // FirstOrDefault() faz com que possa retornar null, evitando uma exeption caso não exista uma conta destino
            CheckingAccount destinationCheckingAccount = db.CheckingAccounts.Where(c => c.AccountNumber == transfer.DestinationCheckingAccountNumber).FirstOrDefault();
            if (destinationCheckingAccount == null)
            {
                // se não existe uma conta destino, adiciona erro a uma propriedade do modelo
                ModelState.AddModelError("DestinationCheckingAccountNumber", "Invalid destination account number");
            }

            // se model for valido
            // adicionando transações de debito e credito e atualizando saldo das duas contas
            if(ModelState.IsValid)
            {
                //sua conta
                db.Transactions.Add(new Transaction { CheckingAccountId = transfer.CheckingAccountId, Amount = -transfer.Amount });
                // conta destino
                db.Transactions.Add(new Transaction { CheckingAccountId = destinationCheckingAccount.Id, Amount = transfer.Amount });
                db.SaveChanges();

                // atualiza o saldo das duas contas
                CheckingAccountService service = new CheckingAccountService(db);
                service.UpdateBalance(sourceCheckingAccount.Id);
                service.UpdateBalance(destinationCheckingAccount.Id);

                // sucesso em tudo =)
                return PartialView("_TransferSuccess", transfer);
            }

            // se ModelState não for valido
            return PartialView("_TransferForm");
        }