static void PayBills() { var pbContext = new BillsPaymentSysContext(); try { Console.WriteLine("*********Bills Payment Console*********"); Console.Write("User ID: "); int userId = int.Parse(Console.ReadLine()); Console.Write("Payment amount: "); decimal amount = decimal.Parse(Console.ReadLine()); var bankAccountsTotal = pbContext.PaymentMethods .Include(pm => pm.BankAccount) .Where(pm => pm.UserId == userId && pm.Type == PaymentMethodType.BankAccount) .Select(pm => pm.BankAccount) .ToList(); var cardsTotal = pbContext.PaymentMethods .Include(pm => pm.CreditCard) .Where(pm => pm.UserId == userId && pm.Type == PaymentMethodType.CreditCard) .Select(pm => pm.CreditCard) .ToList(); var totalMoney = bankAccountsTotal.Select(ba => ba.Balance).Sum() + cardsTotal.Select(cc => cc.LimitLeft).Sum(); if (totalMoney < amount) { throw new Exception("Insufficient Funds"); } foreach (var account in bankAccountsTotal) { if (amount == 0 || account.Balance == 0) { continue; } decimal moneyInAccount = account.Balance; if (moneyInAccount < amount) { account.Withdraw(moneyInAccount); } else { account.Withdraw(amount); Console.WriteLine($"Money left in account: {moneyInAccount - amount}"); amount -= amount; } } foreach (var creditCard in cardsTotal) { if (amount == 0 || creditCard.LimitLeft == 0) { continue; } decimal limitLeft = creditCard.LimitLeft; if (limitLeft < amount) { creditCard.Withdraw(limitLeft); amount -= limitLeft; } else { creditCard.Withdraw(amount); Console.WriteLine($"Limit left in card: {limitLeft - amount}"); amount -= amount; } } pbContext.SaveChanges(); } catch (Exception ex) { Console.WriteLine(ex.Message); } }
private static void Seed(BillsPaymentSysContext billsCont) { var Users = new[] { new User() { FirstName = "McTest", LastName = "Testov", Email = "*****@*****.**", Password = "******" }, new User() { FirstName = "Test", LastName = "McTestov", Email = "*****@*****.**", Password = "******" }, new User() { FirstName = "Stanka", LastName = "Stankova", Email = "*****@*****.**", Password = "******" }, new User() { FirstName = "Pesho", LastName = "Peshev", Email = "*****@*****.**", Password = "******" } }; billsCont.AddRange(Users); var creditCards = new List <CreditCard>() { new CreditCard() { Limit = 598.50m, MoneyOwed = 40, ExpirationDate = DateTime.Parse("07-02-2015") }, new CreditCard() { Limit = 1298.50m, MoneyOwed = 350, ExpirationDate = DateTime.Parse("12-10-1998") }, new CreditCard() { Limit = 598.50m, MoneyOwed = 40, ExpirationDate = DateTime.Parse("08-07-1979") } }; billsCont.AddRange(creditCards); var bankAccounts = new [] { new BankAccount() { Balance = 1459m, BankName = "Serious Test Bank", SwiftCode = "SprSrsSw" }, new BankAccount() { Balance = 9876.50m, BankName = "Serious Bank Supreme", SwiftCode = "SrsBnkSpr" } }; billsCont.AddRange(bankAccounts); var paymentMethods = new PaymentMethod[] { new PaymentMethod() { User = Users[0], CreditCard = creditCards[2], Type = PaymentMethodType.CreditCard }, new PaymentMethod() { User = Users[2], BankAccount = bankAccounts[1], Type = PaymentMethodType.BankAccount }, new PaymentMethod() { User = Users[3], CreditCard = creditCards[1], Type = PaymentMethodType.CreditCard }, new PaymentMethod() { User = Users[1], BankAccount = bankAccounts[0], Type = PaymentMethodType.BankAccount } }; billsCont.AddRange(paymentMethods); billsCont.SaveChanges(); }