LoadTransactions() private method

Used internally by the importers to load transactions into the statement model.
private LoadTransactions ( IEnumerable transactions ) : StatementModel
transactions IEnumerable The transactions to load.
return StatementModel
        /// <summary>
        /// Statement Model with transactions between 15/07/2013 and 14/09/2013
        /// Includes income transactions.
        /// </summary>
        public static StatementModel TestData2()
        {
            var statement = new StatementModel(new FakeLogger())
            {
                FileName = @"C:\TestData2\Foo2Statement.csv",
                LastImport = new DateTime(2013, 08, 15),
            };

            var transactions = CreateTransactions2();
            statement.LoadTransactions(transactions);
            return statement;
        }
        /// <summary>
        ///     Statement Model with transactions between 15/07/2013 and 14/09/2013
        ///     Includes income transactions.
        ///     Adjusted for use with LedgerCalculator - No ledgers will be overdrawn when using LedgerBook TestData 1.
        /// </summary>
        public static StatementModel TestData3()
        {
            var statement = new StatementModel(new FakeLogger())
            {
                StorageKey = @"C:\TestData3\Foo2Statement.csv",
                LastImport = new DateTime(2013, 08, 15)
            };

            IEnumerable<Transaction> transactions = CreateTransactions3();
            statement.LoadTransactions(transactions);
            return statement;
        }
        public StatementModel Build()
        {
            if (this.additionalTransactions.None())
            {
                return this.model;
            }

            // IEnumerable<MethodInfo> privateMergeMethods = this.model.GetType().GetMethods(BindingFlags.Instance | BindingFlags.NonPublic).Where(m => m.Name == "Merge");
            // MethodInfo privateMergeMethod = privateMergeMethods.First(m => m.IsPrivate);
            // privateMergeMethod.Invoke(this.model, new object[] { this.additionalTransactions });
            var additionalTransactionsModel = new StatementModel(new FakeLogger())
            {
                LastImport = this.additionalTransactions.Max(t => t.Date).Date,
            };
            additionalTransactionsModel.LoadTransactions(this.additionalTransactions);
            return this.model.Merge(additionalTransactionsModel);
        }
示例#4
0
        internal virtual StatementModel Merge([NotNull] StatementModel additionalModel)
        {
            ThrowIfDisposed();
            if (additionalModel == null)
            {
                throw new ArgumentNullException(nameof(additionalModel));
            }

            var combinedModel = new StatementModel(this.logger)
            {
                LastImport = additionalModel.LastImport,
                StorageKey = StorageKey
            };

            List <Transaction> mergedTransactions = AllTransactions.ToList().Merge(additionalModel.AllTransactions).ToList();

            combinedModel.LoadTransactions(mergedTransactions);
            return(combinedModel);
        }
示例#5
0
        internal virtual StatementModel Merge([NotNull] StatementModel additionalModel)
        {
            ThrowIfDisposed();
            if (additionalModel == null)
            {
                throw new ArgumentNullException(nameof(additionalModel));
            }

            var combinedModel = new StatementModel(this.logger)
            {
                LastImport = additionalModel.LastImport,
                StorageKey = StorageKey
            };

            List<Transaction> mergedTransactions = AllTransactions.ToList().Merge(additionalModel.AllTransactions).ToList();
            combinedModel.LoadTransactions(mergedTransactions);
            return combinedModel;
        }
            public static StatementModel TestDataGenerated()
            {
                var model = new StatementModel(new FakeLogger())
                {
                    StorageKey = @"C:\Foo\StatementModel.csv",
                    LastImport = new DateTime(2015, 11, 21)
                };

                var transactions = new List<Transaction>
                {
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("CHEQUE"),
                        Amount = -55.00M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("PHNET"),
                        Date = new DateTime(2015, 10, 21),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("ce628396-3f6b-4980-88ff-e4ea68a5c804"),
                        Reference1 = "5235ghkh",
                        Reference2 = "792fgjgghkh",
                        Reference3 = "kjhgjklshgjsh",
                        TransactionType = new NamedTransaction("Payment")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("CHEQUE"),
                        Amount = -24.10M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("PHNET"),
                        Date = new DateTime(2015, 10, 21),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("67f9cbff-18ca-4d11-a5ef-22988e04584a"),
                        Reference1 = "5235ghkh",
                        Reference2 = "792fgjgghkh",
                        Reference3 = "kjhgjklshgjsh",
                        TransactionType = new NamedTransaction("Payment")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("CHEQUE"),
                        Amount = -3000.00M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 10, 23),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("c66eb722-6d03-48b2-b985-6721701a01ae"),
                        Reference1 = "automatchref12",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Debit Transfer")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("CHEQUE"),
                        Amount = -130.00M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("CAR MTC"),
                        Date = new DateTime(2015, 10, 23),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("233a8a87-5583-47ef-ae72-592aa9c10eb8"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Debit Transfer")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("SAVINGS"),
                        Amount = 3000.00M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SAVINGS"),
                        Date = new DateTime(2015, 10, 23),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("9ecd767b-b3c7-4c15-a40f-1c0098e422ed"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Transfer")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("SAVINGS"),
                        Amount = 130.00M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("CAR MTC"),
                        Date = new DateTime(2015, 10, 23),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("1a0dd7ef-2962-4c8c-85cb-7d3e64748211"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Transfer")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -27.44M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("FUEL"),
                        Date = new DateTime(2015, 10, 31),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("7ac24965-e21e-4f63-b3e4-9ec391843f56"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -73.34M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("CAR MTC"),
                        Date = new DateTime(2015, 10, 31),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("7a9dd17a-1957-4ac4-8175-28a93d9a1eb9"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -32.70M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 11, 1),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("31b7af5c-4429-4cf7-b0b4-54ff8d72eb1d"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -49.70M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 11, 1),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("246fe376-d6b2-4a09-a881-f07d1577ffa7"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("CHEQUE"),
                        Amount = -30.00M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 11, 2),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("886b4bd5-455c-42bb-826c-cc61edcec84f"),
                        Reference1 = "5235ghkh",
                        Reference2 = "792fgjgghkh",
                        Reference3 = "kjhgjklshgjsh",
                        TransactionType = new NamedTransaction("Atm Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("CHEQUE"),
                        Amount = -120.00M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("FOOD"),
                        Date = new DateTime(2015, 11, 2),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("8673ce8f-629a-413f-b7c9-afbcc123cf80"),
                        Reference1 = "5235ghkh",
                        Reference2 = "792fgjgghkh",
                        Reference3 = "kjhgjklshgjsh",
                        TransactionType = new NamedTransaction("Atm Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -10.79M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 11, 3),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("2a3b17cf-c4a0-4c01-893b-73677cc650ad"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -8.30M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 11, 5),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("2a5b1821-802d-4b5e-af72-728dde935931"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -7.99M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 11, 5),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("b87d9668-6d17-444f-89ef-d53cd1ba826c"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("CHEQUE"),
                        Amount = -17.32M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("POWER"),
                        Date = new DateTime(2015, 11, 6),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("af952e91-9ca8-442e-9569-13b8796c9eef"),
                        Reference1 = "5235ghkh",
                        Reference2 = "792fgjgghkh",
                        Reference3 = "kjhgjklshgjsh",
                        TransactionType = new NamedTransaction("Payment")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -42.50M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 11, 6),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("00172bd9-0ec4-4d92-94bf-d533299e0dc5"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -30.60M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 11, 6),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("63a9d1dd-a28e-4561-8443-570af6f1da6a"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -11.47M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS.FENCE"),
                        Date = new DateTime(2015, 11, 8),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("e53f7c07-f06b-4a99-8310-57d6f7aef2e8"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -31.49M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 11, 8),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("810c31e3-bdfb-4aef-a6dd-b96a3789e27f"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -14.10M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 11, 8),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("34249540-ac64-4392-9fa7-c0e10ecc06af"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("CHEQUE"),
                        Amount = -2.00M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 11, 9),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("f705a9c8-533c-451e-9e4b-70266679af58"),
                        Reference1 = "5235ghkh",
                        Reference2 = "792fgjgghkh",
                        Reference3 = "kjhgjklshgjsh",
                        TransactionType = new NamedTransaction("Eft-Pos")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -38.00M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 11, 11),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("b56e8c82-501e-4c77-b2ba-0fa9e86e19ef"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -8.90M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 11, 12),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("eb465d02-e82c-4d5d-884a-2adb1c86cf4c"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -9.50M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 11, 12),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("0ec1c6b3-8f4c-47d5-99e2-c01168cbae2c"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("CHEQUE"),
                        Amount = -40.00M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 11, 13),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("ac3a08f2-3274-4667-b382-9f23e81fa9e8"),
                        Reference1 = "5235ghkh",
                        Reference2 = "792fgjgghkh",
                        Reference3 = "kjhgjklshgjsh",
                        TransactionType = new NamedTransaction("Eft-Pos")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("CHEQUE"),
                        Amount = -444.63M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("PHNET"),
                        Date = new DateTime(2015, 11, 13),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("ce618893-06ab-4dab-8fd8-5578e6b90700"),
                        Reference1 = "5235ghkh",
                        Reference2 = "792fgjgghkh",
                        Reference3 = "kjhgjklshgjsh",
                        TransactionType = new NamedTransaction("Payment")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -11.50M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 11, 13),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("5db38e40-a58b-47bb-9b1c-077b5f8cecc5"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -159.00M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS.FENCE"),
                        Date = new DateTime(2015, 11, 14),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("92a6d37b-a846-4b2c-b9b3-14ba85c70295"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -24.10M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 11, 14),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("f32b2ed3-717f-41b5-8892-d48df86579ef"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -471.01M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("CAR MTC"),
                        Date = new DateTime(2015, 11, 14),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("8626f06a-5ba6-45e1-b197-4c0b0ab927c3"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -8.64M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 11, 14),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("0f3d74ba-4456-41a1-a58e-b006534b664b"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -141.79M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 11, 15),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("15bde657-e077-42a3-b0eb-1b49f76ba17d"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -5.00M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 11, 16),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("860cce1e-abca-4520-8a03-6e73a2ddca13"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("CHEQUE"),
                        Amount = -8.50M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 11, 18),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("8a6cd650-77cc-427b-a481-ac4b286ccfd4"),
                        Reference1 = "5235ghkh",
                        Reference2 = "792fgjgghkh",
                        Reference3 = "kjhgjklshgjsh",
                        TransactionType = new NamedTransaction("Eft-Pos")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("CHEQUE"),
                        Amount = -27.74M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 11, 19),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("840acbce-af64-4ce8-a3e9-d33beea48bdb"),
                        Reference1 = "5235ghkh",
                        Reference2 = "792fgjgghkh",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Payment")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("CHEQUE"),
                        Amount = -25.30M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("PHNET"),
                        Date = new DateTime(2015, 11, 19),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("9e18b22f-9623-44e7-b391-e868b482d545"),
                        Reference1 = "5235ghkh",
                        Reference2 = "792fgjgghkh",
                        Reference3 = "kjhgjklshgjsh",
                        TransactionType = new NamedTransaction("Payment")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -45.98M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 11, 19),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("212a5450-81c7-4441-a851-84a1830e7a4a"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -3.50M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 11, 19),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("aeb3c1ac-fb5a-4164-8125-3b5cf3487616"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -31.90M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 11, 19),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("02861f41-a92c-4ffd-bd22-8194dc402f8d"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    }
                };

                return model.LoadTransactions(transactions);
            }
        /// <summary>
        ///     Statement Model with transactions between 15/07/2013 and 14/09/2013
        ///     Includes income transactions.
        ///     Adjusted for use with LedgerCalculator - No ledgers will be overdrawn when using LedgerBook TestData 1.
        ///     Includes some duplicate transactions
        /// </summary>
        public static StatementModel TestData4()
        {
            var statement = new StatementModel(new FakeLogger())
            {
                StorageKey = @"C:\TestData4\Foo2Statement.csv",
                LastImport = new DateTime(2013, 08, 15)
            };

            List<Transaction> transactions = CreateTransactions3().ToList();
            transactions.AddRange(CreateTransactions1());
            statement.LoadTransactions(transactions);
            return statement;
        }
            public static StatementModel TestDataGenerated()
            {
                var model = new StatementModel(new FakeLogger())
                {
                    StorageKey = @"C:\Foo\StatementModel.csv",
                    LastImport = new DateTime(2015, 11, 21)
                };

                var transactions = new List<Transaction>
                {
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -9.90M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 10, 20),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("7a8cc7f2-c257-4d41-9b4c-87e4c623f482"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -8.50M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 10, 20),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("110a6497-b19b-4faf-a932-7a41312b0f61"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -6.00M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 10, 20),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("46e45965-275f-415f-a49b-bcd0031541c0"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("CHEQUE"),
                        Amount = -11.00M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 10, 21),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("b0438bb3-112d-40c2-81c0-29590e00853c"),
                        Reference1 = "5235ghkh",
                        Reference2 = "792fgjgghkh",
                        Reference3 = "kjhgjklshgjsh",
                        TransactionType = new NamedTransaction("Eft-Pos")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("CHEQUE"),
                        Amount = -55.00M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("PHNET"),
                        Date = new DateTime(2015, 10, 21),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("ce628396-3f6b-4980-88ff-e4ea68a5c804"),
                        Reference1 = "5235ghkh",
                        Reference2 = "792fgjgghkh",
                        Reference3 = "kjhgjklshgjsh",
                        TransactionType = new NamedTransaction("Payment")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("CHEQUE"),
                        Amount = -24.10M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("PHNET"),
                        Date = new DateTime(2015, 10, 21),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("67f9cbff-18ca-4d11-a5ef-22988e04584a"),
                        Reference1 = "5235ghkh",
                        Reference2 = "792fgjgghkh",
                        Reference3 = "kjhgjklshgjsh",
                        TransactionType = new NamedTransaction("Payment")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -34.00M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 10, 22),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("a8f49deb-f932-44f4-8c8e-afbabfdbfa84"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("CHEQUE"),
                        Amount = -3000.00M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 10, 23),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("c66eb722-6d03-48b2-b985-6721701a01ae"),
                        Reference1 = "automatchref12",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Debit Transfer")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("CHEQUE"),
                        Amount = -130.00M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("CAR MTC"),
                        Date = new DateTime(2015, 10, 23),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("233a8a87-5583-47ef-ae72-592aa9c10eb8"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Debit Transfer")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -32.41M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 10, 23),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("79a48868-7160-4b6f-9883-60156dd1d6e2"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -27.60M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 10, 23),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("6838efc5-872d-449a-9e29-3425beba7c79"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("SAVINGS"),
                        Amount = 3000.00M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SAVINGS"),
                        Date = new DateTime(2015, 10, 23),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("9ecd767b-b3c7-4c15-a40f-1c0098e422ed"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Transfer")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("SAVINGS"),
                        Amount = 130.00M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("CAR MTC"),
                        Date = new DateTime(2015, 10, 23),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("1a0dd7ef-2962-4c8c-85cb-7d3e64748211"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Transfer")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -15.99M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 10, 25),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("56e3bc85-30f4-47c5-9782-f3a16ad69a93"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -6.20M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 10, 25),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("bd57bac2-08f8-4036-98b1-cd23eb2b0e6e"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -12.70M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 10, 25),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("08c8e941-aefd-4a13-b492-dcfffaefa35a"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -17.25M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 10, 26),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("f2003ef7-2b15-448a-82cb-6608b52a8a76"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -152.30M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS.FENCE"),
                        Date = new DateTime(2015, 10, 26),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("bed39dfb-26bd-45eb-bab1-c47bb3d534ed"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -39.96M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS.FENCE"),
                        Date = new DateTime(2015, 10, 26),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("e590d0a8-9e27-444f-9d55-c07dff41d3e1"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -29.10M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 10, 26),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("05f5007e-1094-4ffe-8068-edd1abc030e8"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("CHEQUE"),
                        Amount = -60.00M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 10, 27),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("aed79385-473e-4384-988c-643bc6bb1bce"),
                        Reference1 = "5235ghkh",
                        Reference2 = "792fgjgghkh",
                        Reference3 = "kjhgjklshgjsh",
                        TransactionType = new NamedTransaction("Atm Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -39.20M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS.FENCE"),
                        Date = new DateTime(2015, 10, 27),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("5cc62085-f7fd-48bc-a5e0-495cb3d8b2ce"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -23.96M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS.FENCE"),
                        Date = new DateTime(2015, 10, 28),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("90b7cce0-baf0-4258-943b-1e3ffd25f15e"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("CHEQUE"),
                        Amount = -11.00M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 10, 29),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("9afd8670-1f8b-48e2-af1d-d6dad513b6fd"),
                        Reference1 = "5235ghkh",
                        Reference2 = "792fgjgghkh",
                        Reference3 = "kjhgjklshgjsh",
                        TransactionType = new NamedTransaction("Eft-Pos")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -92.00M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 10, 29),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("4e746665-37ce-47da-ae78-13d5adfc2ab2"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -3.50M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 10, 29),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("e447b974-8da5-4200-ae15-7eaaf3e6831c"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -10.90M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 10, 30),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("cf2f7845-ef16-4156-8bd5-f9fd19d3180c"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -22.50M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 10, 30),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("a76111b9-86b4-4f88-ab57-0e04f52c9888"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -25.50M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 10, 30),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("8c79342c-1ac2-49e0-9a3a-693a44f0ab73"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -12.80M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 10, 30),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("c6b41c5a-153b-4ae5-afc2-0abffbcbc4a5"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -35.48M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 10, 30),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("94f3fc23-57ec-4924-96fb-43cac64d2a54"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -7.99M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 10, 30),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("8a7ea9dd-e654-49b3-a128-8a6aa7d86002"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -24.22M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS.FENCE"),
                        Date = new DateTime(2015, 10, 31),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("60412b90-dfc5-4b3b-844f-6fb73a60c688"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -242.28M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS.FENCE"),
                        Date = new DateTime(2015, 10, 31),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("2eca888e-a3f9-497b-a341-3b6f723afb6b"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -27.44M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("FUEL"),
                        Date = new DateTime(2015, 10, 31),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("7ac24965-e21e-4f63-b3e4-9ec391843f56"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -24.80M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 10, 31),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("4936ef28-1d2d-4395-93dc-2dd8bd84b2a3"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -73.34M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("CAR MTC"),
                        Date = new DateTime(2015, 10, 31),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("7a9dd17a-1957-4ac4-8175-28a93d9a1eb9"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -32.70M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 11, 1),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("31b7af5c-4429-4cf7-b0b4-54ff8d72eb1d"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -49.70M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 11, 1),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("246fe376-d6b2-4a09-a881-f07d1577ffa7"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("CHEQUE"),
                        Amount = -30.00M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 11, 2),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("886b4bd5-455c-42bb-826c-cc61edcec84f"),
                        Reference1 = "5235ghkh",
                        Reference2 = "792fgjgghkh",
                        Reference3 = "kjhgjklshgjsh",
                        TransactionType = new NamedTransaction("Atm Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("CHEQUE"),
                        Amount = -120.00M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("FOOD"),
                        Date = new DateTime(2015, 11, 2),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("8673ce8f-629a-413f-b7c9-afbcc123cf80"),
                        Reference1 = "5235ghkh",
                        Reference2 = "792fgjgghkh",
                        Reference3 = "kjhgjklshgjsh",
                        TransactionType = new NamedTransaction("Atm Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("CHEQUE"),
                        Amount = 2650.98M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 11, 3),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("dc7ab7ca-ea4d-453a-9051-320e5b328b57"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "kjhgjklshgjsh",
                        TransactionType = new NamedTransaction("Direct Credit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -849.00M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 11, 3),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("04f9f607-e6cc-449b-a18b-a5b45a7a1e2a"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -10.79M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 11, 3),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("2a3b17cf-c4a0-4c01-893b-73677cc650ad"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("CHEQUE"),
                        Amount = -2650.98M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 11, 4),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("bace1969-e4d4-4374-8cef-e671e1287b6c"),
                        Reference1 = "5235ghkh",
                        Reference2 = "792fgjgghkh",
                        Reference3 = "kjhgjklshgjsh",
                        TransactionType = new NamedTransaction("Debit Transfer")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -8.30M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 11, 5),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("2a5b1821-802d-4b5e-af72-728dde935931"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -7.99M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 11, 5),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("b87d9668-6d17-444f-89ef-d53cd1ba826c"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("CHEQUE"),
                        Amount = -17.32M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("POWER"),
                        Date = new DateTime(2015, 11, 6),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("af952e91-9ca8-442e-9569-13b8796c9eef"),
                        Reference1 = "5235ghkh",
                        Reference2 = "792fgjgghkh",
                        Reference3 = "kjhgjklshgjsh",
                        TransactionType = new NamedTransaction("Payment")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -42.50M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 11, 6),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("00172bd9-0ec4-4d92-94bf-d533299e0dc5"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -30.60M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 11, 6),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("63a9d1dd-a28e-4561-8443-570af6f1da6a"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -11.47M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS.FENCE"),
                        Date = new DateTime(2015, 11, 8),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("e53f7c07-f06b-4a99-8310-57d6f7aef2e8"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -118.98M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS.FENCE"),
                        Date = new DateTime(2015, 11, 8),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("bab0a41a-4b78-4277-ae73-2392a2ab5f75"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -31.49M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 11, 8),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("810c31e3-bdfb-4aef-a6dd-b96a3789e27f"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -14.10M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 11, 8),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("34249540-ac64-4392-9fa7-c0e10ecc06af"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("CHEQUE"),
                        Amount = -2.00M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 11, 9),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("f705a9c8-533c-451e-9e4b-70266679af58"),
                        Reference1 = "5235ghkh",
                        Reference2 = "792fgjgghkh",
                        Reference3 = "kjhgjklshgjsh",
                        TransactionType = new NamedTransaction("Eft-Pos")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -38.00M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 11, 11),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("b56e8c82-501e-4c77-b2ba-0fa9e86e19ef"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -8.90M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 11, 12),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("eb465d02-e82c-4d5d-884a-2adb1c86cf4c"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -9.50M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 11, 12),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("0ec1c6b3-8f4c-47d5-99e2-c01168cbae2c"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("CHEQUE"),
                        Amount = -40.00M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 11, 13),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("ac3a08f2-3274-4667-b382-9f23e81fa9e8"),
                        Reference1 = "5235ghkh",
                        Reference2 = "792fgjgghkh",
                        Reference3 = "kjhgjklshgjsh",
                        TransactionType = new NamedTransaction("Eft-Pos")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("CHEQUE"),
                        Amount = -444.63M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("PHNET"),
                        Date = new DateTime(2015, 11, 13),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("ce618893-06ab-4dab-8fd8-5578e6b90700"),
                        Reference1 = "5235ghkh",
                        Reference2 = "792fgjgghkh",
                        Reference3 = "kjhgjklshgjsh",
                        TransactionType = new NamedTransaction("Payment")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -11.50M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 11, 13),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("5db38e40-a58b-47bb-9b1c-077b5f8cecc5"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -159.00M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS.FENCE"),
                        Date = new DateTime(2015, 11, 14),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("92a6d37b-a846-4b2c-b9b3-14ba85c70295"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -24.10M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 11, 14),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("f32b2ed3-717f-41b5-8892-d48df86579ef"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -471.01M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("CAR MTC"),
                        Date = new DateTime(2015, 11, 14),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("8626f06a-5ba6-45e1-b197-4c0b0ab927c3"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -8.64M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 11, 14),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("0f3d74ba-4456-41a1-a58e-b006534b664b"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -141.79M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 11, 15),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("15bde657-e077-42a3-b0eb-1b49f76ba17d"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -5.00M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 11, 16),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("860cce1e-abca-4520-8a03-6e73a2ddca13"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("CHEQUE"),
                        Amount = -8.50M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 11, 18),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("8a6cd650-77cc-427b-a481-ac4b286ccfd4"),
                        Reference1 = "5235ghkh",
                        Reference2 = "792fgjgghkh",
                        Reference3 = "kjhgjklshgjsh",
                        TransactionType = new NamedTransaction("Eft-Pos")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("CHEQUE"),
                        Amount = -27.74M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 11, 19),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("840acbce-af64-4ce8-a3e9-d33beea48bdb"),
                        Reference1 = "5235ghkh",
                        Reference2 = "792fgjgghkh",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Payment")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("CHEQUE"),
                        Amount = -25.30M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("PHNET"),
                        Date = new DateTime(2015, 11, 19),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("9e18b22f-9623-44e7-b391-e868b482d545"),
                        Reference1 = "5235ghkh",
                        Reference2 = "792fgjgghkh",
                        Reference3 = "kjhgjklshgjsh",
                        TransactionType = new NamedTransaction("Payment")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -45.98M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 11, 19),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("212a5450-81c7-4441-a851-84a1830e7a4a"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -3.50M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 11, 19),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("aeb3c1ac-fb5a-4164-8125-3b5cf3487616"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    },
                    new Transaction
                    {
                        Account = AccountTypeRepo.GetByKey("VISA"),
                        Amount = -31.90M,
                        BudgetBucket = BudgetBucketRepo.GetByCode("SURPLUS"),
                        Date = new DateTime(2015, 11, 19),
                        Description = "Lorem Ipsum Dolor",
                        Id = new Guid("02861f41-a92c-4ffd-bd22-8194dc402f8d"),
                        Reference1 = "5235ghkh",
                        Reference2 = "",
                        Reference3 = "",
                        TransactionType = new NamedTransaction("Credit Card Debit")
                    }
                };

                return model.LoadTransactions(transactions);
            }