Ejemplo n.º 1
0
        static void Main(string[] args)
        {
            var BillsCont = new BillsPaymentSysContext();

            //BillsCont.Database.EnsureCreated();
            //BillsCont.Database.Migrate();
            //Seed(BillsCont);
            Console.Write("Please Enter a User Id number: ");
            var userId = int.Parse(Console.ReadLine());

            if (BillsCont.Users.Find(userId) == null)
            {
                Console.WriteLine($"User with id {userId} not found!");
                return;
            }

            var user = BillsCont.Users.Where(u => u.UserId == userId).Select(e => new
            {
                Name        = $"{e.FirstName} {e.LastName}",
                ID          = e.UserId,
                CreditCards = e.PaymentMethods.Where(pm => pm.Type == PaymentMethodType.CreditCard)
                              .Select(pm => pm.CreditCard).ToArray(),
                BankAccounts = e.PaymentMethods.Where(pm => pm.Type == PaymentMethodType.BankAccount)
                               .Select(pm => pm.BankAccount).ToArray()
            }).SingleOrDefault();
            var creditCards  = user.CreditCards;
            var bankAccounts = user.BankAccounts;

            Console.WriteLine($"User: {user.Name}");
            GetPaymentMethods(creditCards, bankAccounts);
            PayBills();
        }
Ejemplo n.º 2
0
        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);
            }
        }
Ejemplo n.º 3
0
        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();
        }