public Voucher CreateVoucher(Voucher voucher)
 {
     ctx.Vouchers.Add(voucher);
     ctx.SaveChanges();
     return(voucher);
 }
        private static void SeedDatabase(VouchersDBContext context)
        {
            //To Create the DB go to console:
            //[dotnet restore]
            //dotnet ef migrations add MIGRATION-NAME
            //dotnet ef database update

            if (context.BalanceAccounts.FirstOrDefault() == null)
            {
                var a1 = new BalanceAccount {
                    Name = "Unclassified", Expense = true
                };
                var a2 = new BalanceAccount {
                    Name = "Car Maintenance", Expense = true
                };
                var a3 = new BalanceAccount {
                    Name = "Development", Expense = false
                };
                var a4 = new BalanceAccount {
                    Name = "Consulting", Expense = false
                };
                var a5 = new BalanceAccount {
                    Name = "Training", Expense = false
                };
                var a6 = new BalanceAccount {
                    Name = "Software", Expense = true
                };
                var a7 = new BalanceAccount {
                    Name = "Hosting & Internet", Expense = true
                };

                context.BalanceAccounts.AddRange(a1, a2, a3, a4, a5, a6, a7);
                context.SaveChanges();

                var v1 = new Voucher
                {
                    Date    = DateTime.Now.AddDays(-2),
                    Amount  = 800,
                    Text    = "Bogus AG",
                    Paid    = false,
                    Expense = false,
                    Remark  = true
                };
                var v2 = new Voucher
                {
                    Date    = DateTime.Now.AddDays(-2),
                    Amount  = 65,
                    Text    = "BP Tankstelle",
                    Paid    = false,
                    Expense = true,
                    Remark  = true
                };
                var v3 = new Voucher
                {
                    Date    = DateTime.Now.AddDays(-2),
                    Amount  = 56,
                    Text    = "Amazon",
                    Paid    = false,
                    Expense = true
                };
                var v4 = new Voucher
                {
                    Date    = DateTime.Now.AddDays(-3),
                    Amount  = 100,
                    Text    = "Media Markt",
                    Paid    = true,
                    Expense = true
                };
                context.Vouchers.AddRange(v1, v2, v3, v4);
                context.SaveChanges();

                var vd1 = new VoucherDetail {
                    VoucherID = v4.ID, Text = "Ladekabel", Amount = 100, Account = a1
                };
                var vd7 = new VoucherDetail
                {
                    VoucherID = v3.ID,
                    Text      = "Game of Thrones, Season 6",
                    Amount    = 29,
                    Account   = a6
                };
                var vd2 = new VoucherDetail {
                    VoucherID = v3.ID, Text = "USB Stick", Amount = 11, Account = a1
                };
                var vd3 = new VoucherDetail {
                    VoucherID = v3.ID, Text = "DVI Kabel", Amount = 45, Account = a1
                };
                var vd4 = new VoucherDetail {
                    VoucherID = v2.ID, Text = "Diesel", Amount = 45, Account = a2
                };
                var vd6 = new VoucherDetail {
                    VoucherID = v2.ID, Text = "Reifenwechsel", Amount = 20, Account = a2
                };
                var vd5 = new VoucherDetail {
                    VoucherID = v1.ID, Text = "Remote Support", Amount = 800, Account = a4
                };

                context.VoucherDetails.AddRange(vd1, vd2, vd3, vd4, vd5, vd6, vd7);
                context.SaveChanges();
            }
        }
Example #3
0
        public static void Initialize(VouchersDBContext context)
        {
            context.Database.EnsureCreated();

            if (context.BalanceAccounts.FirstOrDefault() == null)
            {
                var a1 = new BalanceAccount {
                    Name = "Depreciation", Expense = true
                };
                var a2 = new BalanceAccount {
                    Name = "Car Maintenance", Expense = true
                };
                var a3 = new BalanceAccount {
                    Name = "Development", Expense = false
                };
                var a4 = new BalanceAccount {
                    Name = "Consulting", Expense = false
                };
                var a5 = new BalanceAccount {
                    Name = "Training", Expense = false
                };
                var a6 = new BalanceAccount {
                    Name = "Software", Expense = true
                };
                var a7 = new BalanceAccount {
                    Name = "Hosting & Internet", Expense = true
                };

                context.BalanceAccounts.AddRange(a1, a2, a3, a4, a5, a6, a7);
                context.SaveChanges();

                var v1 = new Voucher
                {
                    Date    = DateTime.Now.AddDays(-2),
                    Amount  = 800,
                    Text    = "Bogus AG",
                    Paid    = false,
                    Expense = false,
                    Remark  = true
                };
                var v2 = new Voucher
                {
                    Date    = DateTime.Now.AddDays(-2),
                    Amount  = 65,
                    Text    = "BP Tankstelle",
                    Paid    = false,
                    Expense = true,
                    Remark  = true
                };
                var v3 = new Voucher
                {
                    Date    = DateTime.Now.AddDays(-2),
                    Amount  = 56,
                    Text    = "Amazon",
                    Paid    = false,
                    Expense = true
                };
                var v4 = new Voucher
                {
                    Date    = DateTime.Now.AddDays(-3),
                    Amount  = 100,
                    Text    = "Media Markt",
                    Paid    = true,
                    Expense = true
                };
                context.Vouchers.AddRange(v1, v2, v3, v4);
                context.SaveChanges();

                var vd1 = new VoucherDetail {
                    VoucherID = v4.ID, Text = "Ladekabel", Amount = 100, Account = a1
                };
                var vd7 = new VoucherDetail
                {
                    VoucherID = v3.ID,
                    Text      = "Game of Thrones, Season 6",
                    Amount    = 29,
                    Account   = a6
                };
                var vd2 = new VoucherDetail {
                    VoucherID = v3.ID, Text = "USB Stick", Amount = 11, Account = a1
                };
                var vd3 = new VoucherDetail {
                    VoucherID = v3.ID, Text = "DVI Kabel", Amount = 45, Account = a1
                };
                var vd4 = new VoucherDetail {
                    VoucherID = v2.ID, Text = "Diesel", Amount = 45, Account = a2
                };
                var vd6 = new VoucherDetail {
                    VoucherID = v2.ID, Text = "Reifenwechsel", Amount = 20, Account = a2
                };
                var vd5 = new VoucherDetail {
                    VoucherID = v1.ID, Text = "Remote Support", Amount = 800, Account = a4
                };

                context.VoucherDetails.AddRange(vd1, vd2, vd3, vd4, vd5, vd6, vd7);
                context.SaveChanges();
            }
        }
Example #4
0
        private static void SeedDatabase(VouchersDBContext context)
        {
            //To Create the Code First DB go to Package Manager Console ->
            //PackageManagerConsole:
            //Install-Package Microsoft.EntityFrameworkCore.Tools -Pre
            //Add-Migration MigrationName
            //Update-Database

            if (context.BalanceAccounts.FirstOrDefault() == null)
            {
                var a1 = new BalanceAccount {
                    Name = "Unclassified", Expense = true
                };
                var a2 = new BalanceAccount {
                    Name = "Car Maintenance", Expense = true
                };
                var a3 = new BalanceAccount {
                    Name = "Development", Expense = false
                };
                var a4 = new BalanceAccount {
                    Name = "Consulting", Expense = false
                };
                var a5 = new BalanceAccount {
                    Name = "Training", Expense = false
                };
                var a6 = new BalanceAccount {
                    Name = "Software", Expense = true
                };
                var a7 = new BalanceAccount {
                    Name = "Hosting & Internet", Expense = true
                };

                context.BalanceAccounts.AddRange(a1, a2, a3, a4, a5, a6, a7);
                context.SaveChanges();

                var v1 = new Voucher {
                    Date = DateTime.Now.AddDays(-2), Amount = 800, Text = "Reiser-ST", Paid = false, Expense = false, Remark = true
                };
                var v2 = new Voucher {
                    Date = DateTime.Now.AddDays(-2), Amount = 65, Text = "BP Tankstelle", Paid = false, Expense = true, Remark = true
                };
                var v3 = new Voucher {
                    Date = DateTime.Now.AddDays(-2), Amount = 56, Text = "Amazon", Paid = false, Expense = true
                };
                var v4 = new Voucher {
                    Date = DateTime.Now.AddDays(-3), Amount = 100, Text = "Media Markt", Paid = true, Expense = true
                };
                context.Vouchers.AddRange(v1, v2, v3, v4);
                context.SaveChanges();

                var vd1 = new VoucherDetail {
                    VoucherID = v4.ID, Text = "Ladekabel", Amount = 100, Account = a1
                };
                var vd7 = new VoucherDetail {
                    VoucherID = v3.ID, Text = "Game of Thrones, Season 6", Amount = 29, Account = a6
                };
                var vd2 = new VoucherDetail {
                    VoucherID = v3.ID, Text = "USB Stick", Amount = 11, Account = a1
                };
                var vd3 = new VoucherDetail {
                    VoucherID = v3.ID, Text = "DVI Kabel", Amount = 45, Account = a1
                };
                var vd4 = new VoucherDetail {
                    VoucherID = v2.ID, Text = "Diesel", Amount = 45, Account = a2
                };
                var vd6 = new VoucherDetail {
                    VoucherID = v2.ID, Text = "Reifenwechsel", Amount = 20, Account = a2
                };
                var vd5 = new VoucherDetail {
                    VoucherID = v1.ID, Text = "Remote Support", Amount = 800, Account = a4
                };

                context.VoucherDetails.AddRange(vd1, vd2, vd3, vd4, vd5, vd6, vd7);
                context.SaveChanges();
            }
            ;

            if (context.Assets.FirstOrDefault() == null)
            {
                var as1 = new Asset {
                    ActivatedOn = DateTime.Now, PurchaseDate = DateTime.Now.AddDays(-1), Periods = 20, Text = "Foo", Value = 10
                };
                var as2 = new Asset {
                    ActivatedOn = DateTime.Now, PurchaseDate = DateTime.Now.AddDays(-2), Periods = 10, Text = "Foo", Value = 20
                };
                var as3 = new Asset {
                    ActivatedOn = DateTime.Now, PurchaseDate = DateTime.Now.AddDays(-3), Periods = 5, Text = "Foo", Value = 40
                };

                context.Assets.AddRange(as1, as2, as3);
                context.SaveChanges();
            }
        }