private static void SeedAccounts(NakedContext context) { if (!context.Accounts.Any()) { var accounts = new List <Account>(); string defaultBranch = "1"; foreach (var user in context.Users.ToList()) { for (int i = 0; i < new Random().Next(2, 4); i++) { var acc = new Account() { UserId = user.UserId, AccountNumber = $"{defaultBranch.PadRight(3, '0')}9{user.UserId.ToString().PadRight(5, '0')}{i}", BranchId = 1, Balance = 85, }; accounts.Add(acc); } } context.AddRange(accounts); context.SaveChanges(); } }
private static void SeedUsers(NakedContext context) { if (!context.Users.Any()) { var users = new List <User> { new User { Login = "******", Password = "******", FirstName = "Daniel", LastName = "Pessoa", EmailAddress = "*****@*****.**", PhoneNumber = "+55 21 999-123-708", Active = true, LastAccessAt = DateTime.UtcNow }, new User { Login = "******", Password = "******", FirstName = "John", LastName = "Smith", EmailAddress = "*****@*****.**", PhoneNumber = "+1 12 123-456-789", Active = true, LastAccessAt = DateTime.UtcNow.AddMonths(-15) } }; context.AddRange(users); context.SaveChanges(); } }
private static void SeedTransactions(NakedContext context) { if (!context.Transactions.Any()) { foreach (var account in context.Accounts.ToList()) { var balances = new List <Transaction> { new Transaction { AccountId = account.AccountId, Timestamp = DateTime.Now.Date.AddDays(-0), Amount = 100, BalanceAfterTransaction = 85, TransactionType = (int)TransactionType.Deposit }, new Transaction { AccountId = account.AccountId, Timestamp = DateTime.Now.Date.AddDays(-0), Amount = 75, BalanceAfterTransaction = -15, TransactionType = (int)TransactionType.Payment }, new Transaction { AccountId = account.AccountId, Timestamp = DateTime.Now.Date.AddDays(-2), Amount = 25, BalanceAfterTransaction = 60, TransactionType = (int)TransactionType.Withdraw }, new Transaction { AccountId = account.AccountId, Timestamp = DateTime.Now.Date.AddDays(-3), Amount = 35, BalanceAfterTransaction = 85, TransactionType = (int)TransactionType.Deposit }, new Transaction { AccountId = account.AccountId, Timestamp = DateTime.Now.Date.AddDays(-4), Amount = 230, BalanceAfterTransaction = 50, TransactionType = (int)TransactionType.Payment }, new Transaction { AccountId = account.AccountId, Timestamp = DateTime.Now.Date.AddDays(-5), Amount = 300, BalanceAfterTransaction = 280, TransactionType = (int)TransactionType.Withdraw }, new Transaction { AccountId = account.AccountId, Timestamp = DateTime.Now.Date.AddDays(-6), Amount = 200, BalanceAfterTransaction = 580, TransactionType = (int)TransactionType.Withdraw }, new Transaction { AccountId = account.AccountId, Timestamp = DateTime.Now.Date.AddDays(-7), Amount = 20, BalanceAfterTransaction = 780, TransactionType = (int)TransactionType.Withdraw }, }; context.AddRange(balances); } context.SaveChanges(); } }
private static void SeedBalances(NakedContext context) { if (!context.Balances.Any()) { foreach (var account in context.Accounts.ToList()) { var balances = new List <Balance> { new Balance { AccountId = account.AccountId, Timestamp = DateTime.Now.Date.AddDays(-1), Amount = 60 }, new Balance { AccountId = account.AccountId, Timestamp = DateTime.Now.Date.AddDays(-2), Amount = 85 }, new Balance { AccountId = account.AccountId, Timestamp = DateTime.Now.Date.AddDays(-3), Amount = 50 }, new Balance { AccountId = account.AccountId, Timestamp = DateTime.Now.Date.AddDays(-4), Amount = 280 }, new Balance { AccountId = account.AccountId, Timestamp = DateTime.Now.Date.AddDays(-5), Amount = 580 }, new Balance { AccountId = account.AccountId, Timestamp = DateTime.Now.Date.AddDays(-6), Amount = 780 }, new Balance { AccountId = account.AccountId, Timestamp = DateTime.Now.Date.AddDays(-7), Amount = 800 }, }; context.AddRange(balances); } context.SaveChanges(); } }