Пример #1
0
        private static bool Withdraw(string account, string pin, decimal amount)
        {
            bool isSuccessful = false;

            using (var context = new AtmDbContext())
            {
                using (var transaction = context.Database.BeginTransaction(IsolationLevel.RepeatableRead))
                {
                    var accountToWithdraw = context.CardAccounts.FirstOrDefault(n => n.CardNumber == account);
                    try
                    {
                        ValidateAccount(accountToWithdraw, pin);
                        CheckForEnoughFunds(accountToWithdraw, amount);
                        accountToWithdraw.CardCash -= amount;
                        context.SaveChanges();
                        transaction.Commit();
                        RecordWithdrawOperation(context, accountToWithdraw, amount);
                        isSuccessful = true;
                    }
                    catch (ArgumentException e)
                    {
                        Console.WriteLine(e.Message);
                        transaction.Rollback();
                    }
                    catch (OptimisticConcurrencyException e)
                    {
                        Console.WriteLine("There is a conflict with that transaction, try again.");
                        transaction.Rollback();
                    }
                }
            }

            return isSuccessful;
        }
Пример #2
0
        private static void RecordWithdrawOperation(AtmDbContext context, CardAccount account, decimal amount)
        {
            context.TransactionsHistory.Add(new TransactionHistory
            {
                CardNumber = account.CardNumber,
                TransactionDate = DateTime.Now,
                Amount = amount
            });

            context.SaveChanges();
        }
Пример #3
0
        private static void SeedData()
        {
            using (var context = new AtmDbContext())
            {
                IList<CardAccount> accounts = new List<CardAccount>
               {
                   new CardAccount {CardNumber = "1234567890", CardPIN = "0000", CardCash = 1000m},
                   new CardAccount {CardNumber = "0123456789", CardPIN = "1234", CardCash = 0},
                   new CardAccount {CardNumber = "2034567899", CardPIN = "4321", CardCash = 199},
                   new CardAccount {CardNumber = "1111111111", CardPIN = "0001", CardCash = 200},
               };

                if (!context.CardAccounts.Any())
                {
                    foreach (var account in accounts)
                    {
                        context.CardAccounts.Add(account);
                    }

                    context.SaveChanges();
                }
            }
        }