Example #1
0
        public static void Initialize()
        {
            using (var context = new BankAContext(""))
            {
                context.Database.EnsureCreated();
                //   context.Database.Migrate();

                BankA.Data.SeedData.SeedDataHelper.EnsureSeedData(context);
            }
        }
Example #2
0
        public static void Seed(BankAContext context)
        {
            context.Set <BankVersion>().Add(new BankVersion()
            {
                Version = "1.0.0"
            });
            context.Set <BankAccount>().Add(new BankAccount()
            {
                BankName = "HSBC", Description = "Demo Account"
            });

            context.Set <BankFile>().Add(new BankFile()
            {
                AccountID = 1, FileContent = new byte[10], FileName = "statement.csv", ContentType = "csv"
            });

            context.Set <BankTransactionRule>().Add(new BankTransactionRule()
            {
                Description = "ABC", Tag = "Groceries", TagGroup = "Food"
            });

            for (int i = 12; i >= 0; i--)
            {
                var debitList = new List <decimal>()
                {
                };
                var date = DateTime.Now.AddMonths(-i);
                context.Set <BankTransaction>().Add(new BankTransaction()
                {
                    AccountID = 1, TransactionDate = date.AddDays(4), Tag = "School", Description = "School Fee", DebitAmount = RandomNonNegativeDecimal(new Random(), 4, 2), CreditAmount = 0, FileID = 1
                });
                context.Set <BankTransaction>().Add(new BankTransaction()
                {
                    AccountID = 1, TransactionDate = date.AddDays(6), Tag = "Utilities", Description = "City Power & Light", DebitAmount = RandomNonNegativeDecimal(new Random(), 4, 2), CreditAmount = 0, FileID = 1
                });
                context.Set <BankTransaction>().Add(new BankTransaction()
                {
                    AccountID = 1, TransactionDate = date.AddDays(7), Tag = "Groceries", Description = "Supermarket ABC", DebitAmount = RandomNonNegativeDecimal(new Random(), 4, 2), CreditAmount = 0, FileID = 1
                });
                context.Set <BankTransaction>().Add(new BankTransaction()
                {
                    AccountID = 1, TransactionDate = date.AddDays(7), Tag = "Groceries", Description = "Grocery Store", DebitAmount = RandomNonNegativeDecimal(new Random(), 4, 2), CreditAmount = 0, FileID = 1
                });
                context.Set <BankTransaction>().Add(new BankTransaction()
                {
                    AccountID = 1, TransactionDate = date.AddDays(8), Tag = "Entertainment", Description = "Southridge Video", DebitAmount = RandomNonNegativeDecimal(new Random(), 4, 2), CreditAmount = 0, FileID = 1
                });
                context.Set <BankTransaction>().Add(new BankTransaction()
                {
                    AccountID = 1, TransactionDate = date.AddDays(10), Tag = "Phone", Description = "The Phone Company", DebitAmount = RandomNonNegativeDecimal(new Random(), 4, 2), CreditAmount = 0, FileID = 1
                });
                context.Set <BankTransaction>().Add(new BankTransaction()
                {
                    AccountID = 1, TransactionDate = date.AddDays(12), Tag = "Income", Description = "John's Paycheck", DebitAmount = 0, CreditAmount = 1000.10m, FileID = 1
                });
                context.Set <BankTransaction>().Add(new BankTransaction()
                {
                    AccountID = 1, TransactionDate = date.AddDays(14), Tag = "Utilities", Description = "Water Company", DebitAmount = RandomNonNegativeDecimal(new Random(), 4, 2), CreditAmount = 0, FileID = 1
                });
                context.Set <BankTransaction>().Add(new BankTransaction()
                {
                    AccountID = 1, TransactionDate = date.AddDays(16), Tag = "Insurance", Description = "Humongous Insurance", DebitAmount = RandomNonNegativeDecimal(new Random(), 4, 2), CreditAmount = 0, FileID = 1
                });
                context.Set <BankTransaction>().Add(new BankTransaction()
                {
                    AccountID = 1, TransactionDate = date.AddDays(17), Tag = "Training", Description = "Fine Art Classes", DebitAmount = RandomNonNegativeDecimal(new Random(), 4, 2), CreditAmount = 0, FileID = 1
                });
                context.Set <BankTransaction>().Add(new BankTransaction()
                {
                    AccountID = 1, TransactionDate = date.AddDays(21), Tag = "Groceries", Description = "T Stores", DebitAmount = RandomNonNegativeDecimal(new Random(), 4, 2), CreditAmount = 0, FileID = 1
                });
                context.Set <BankTransaction>().Add(new BankTransaction()
                {
                    AccountID = 1, TransactionDate = date.AddDays(23), Tag = "Fuel", Description = "Petrol Station", DebitAmount = RandomNonNegativeDecimal(new Random(), 4, 2), CreditAmount = 0, FileID = 1
                });
                context.Set <BankTransaction>().Add(new BankTransaction()
                {
                    AccountID = 1, TransactionDate = date.AddDays(24), Tag = "Income", Description = "Pat's Paycheck", DebitAmount = 0, CreditAmount = RandomNonNegativeDecimal(new Random(), 5, 2), FileID = 1
                });
                context.Set <BankTransaction>().Add(new BankTransaction()
                {
                    AccountID = 1, TransactionDate = date.AddDays(25), Tag = "Loan", Description = "House Loan", DebitAmount = RandomNonNegativeDecimal(new Random(), 4, 2), CreditAmount = 0, FileID = 1
                });
                context.Set <BankTransaction>().Add(new BankTransaction()
                {
                    AccountID = 1, TransactionDate = date.AddDays(26), Tag = "Insurance", Description = "Car Insurance", DebitAmount = RandomNonNegativeDecimal(new Random(), 4, 2), CreditAmount = 0, FileID = 1
                });
                context.Set <BankTransaction>().Add(new BankTransaction()
                {
                    AccountID = 1, TransactionDate = date.AddDays(27), Tag = "Groceries", Description = "Grocery Store", DebitAmount = RandomNonNegativeDecimal(new Random(), 4, 2), CreditAmount = 0, FileID = 1
                });
                context.Set <BankTransaction>().Add(new BankTransaction()
                {
                    AccountID = 1, TransactionDate = date.AddDays(29), Tag = "Gym", Description = "Woodgrove Gym", DebitAmount = RandomNonNegativeDecimal(new Random(), 4, 2), CreditAmount = 0, FileID = 1
                });
                context.Set <BankTransaction>().Add(new BankTransaction()
                {
                    AccountID = 1, TransactionDate = date.AddDays(30), Tag = "Entertainment", Description = "Dinner & Movie", DebitAmount = RandomNonNegativeDecimal(new Random(), 4, 2), CreditAmount = 0, FileID = 1
                });
            }
        }