示例#1
0
        public static void Main()
        {
            using (var db = new BillsPaymentDbContext())
            {
                SeedData(db);

                UserInfoById(db);
            }
        }
示例#2
0
        private static void UserInfoById(BillsPaymentDbContext db)
        {
            var id = int.Parse(Console.ReadLine());

            var user = db
                       .Users
                       .Where(u => u.Id == id)
                       .Select(u => new
            {
                u.FirstName,
                u.LastName,
                u.Email,
                u.Password,
                PaymentMethods = u.PaymentMethods.Select(pm => pm.Type)
            })
                       .FirstOrDefault();

            Console.WriteLine($"{user.FirstName} {user.LastName} - {user.Email}, {user.Password}");

            foreach (var method in user.PaymentMethods)
            {
                Console.WriteLine(method);
            }
        }
 public DbSeeder(BillsPaymentDbContext db)
 {
     this.db     = db;
     this.random = new Random();
 }
        public decimal PayWithBankAsMuchAsPossible(IEnumerable <BankAccount> bankAccounts, decimal amount, BillsPaymentDbContext db)
        {
            foreach (var account in bankAccounts)
            {
                db.Entry(account).State = EntityState.Unchanged;

                if (account.Balance >= amount)
                {
                    account.Withdraw(amount);
                    amount = 0;
                    break;
                }

                amount -= account.Balance;
                account.Withdraw(account.Balance);
            }

            return(amount);
        }
 public UserService(BillsPaymentDbContext db)
 {
     this.db = db;
 }
        public void PayWithCreditCards(decimal amount, IEnumerable <CreditCard> creditCards, BillsPaymentDbContext db)
        {
            if (creditCards.Select(c => c.LimitLeft).Sum() < amount)
            {
                throw new InvalidOperationException(AmountGreaterThanPossibilities);
            }

            foreach (var card in creditCards)
            {
                db.Entry(card).State = EntityState.Unchanged;

                if (card.LimitLeft >= amount)
                {
                    card.Withdraw(amount);
                    return;
                }

                amount -= card.LimitLeft;
                card.Withdraw(card.LimitLeft);
            }
        }
示例#7
0
        private static void SeedData(BillsPaymentDbContext db)
        {
            var bankAccounts = new List <BankAccount>
            {
                new BankAccount
                {
                    Balance   = 100m,
                    BankName  = "Shit Bank",
                    SwiftCode = "1234"
                },
                new BankAccount
                {
                    Balance   = 340m,
                    BankName  = "Shit Bank",
                    SwiftCode = "1234"
                },
                new BankAccount
                {
                    Balance   = 2300m,
                    BankName  = "Shit Bank",
                    SwiftCode = "1234"
                },
            };

            var creditCards = new List <CreditCard>
            {
                new CreditCard
                {
                    Limit          = 1000m,
                    ExpirationDate = DateTime.Now,
                    MoneyOwed      = 2000m
                }
            };

            var users = new List <User>
            {
                new User
                {
                    FirstName = "Pesho",
                    LastName  = "Goshov",
                    Email     = "*****@*****.**",
                    Password  = "******"
                },
                new User
                {
                    FirstName = "Minka",
                    LastName  = "Svirkata",
                    Email     = "*****@*****.**",
                    Password  = "******"
                },
                new User
                {
                    FirstName = "Vanq",
                    LastName  = "Miteva",
                    Email     = "*****@*****.**",
                    Password  = "******"
                }
            };

            var paymentMethods = new List <PaymentMethod>
            {
                new PaymentMethod
                {
                    BankAccountId = 8,
                    CreditCardId  = 3,
                    Type          = MethodType.BankAccount,
                    UserId        = 7
                }
            };

            db
            .Users
            .AddRange(users);

            db
            .CreditCards
            .AddRange(creditCards);

            db
            .BankAccounts
            .AddRange(bankAccounts);

            db
            .PaymentMethods
            .AddRange(paymentMethods);

            db.SaveChanges();
        }