Esempio n. 1
0
        static void Main(string[] args)
        {
            // TYPE --------------------------------------------------------------
            MType.CreateTable();

            MType outgoing = new MType();

            outgoing.name = "Outgoing";
            outgoing.Create();

            MType incoming = new MType();

            incoming.name = "Incoming";
            incoming.Create();

            foreach (MType type in MType.RetrieveAll())
            {
                Console.WriteLine(type.id + " - " + type.name);
            }


            //CATEGORY --------------------------------------------------------------
            Category.CreateTable();

            Category food = new Category();

            food.name = "Food";
            food.Create();

            Category bills = new Category();

            bills.name = "Bills";
            bills.Create();

            Category loans = new Category();

            loans.name = "Loans";
            loans.Create();

            Category vehicles = new Category();

            vehicles.name = "Vehicles";
            vehicles.Create();

            Category psales = new Category();

            psales.name = "Personal sales";
            psales.Create();

            foreach (Category category in Category.RetrieveAll())
            {
                Console.WriteLine(category.id + " - " + category.name);
            }


            // CURRENCY --------------------------------------------------------------
            Currency.CreateTable();

            Currency euro = new Currency();

            euro.name = "Euro";
            euro.Create();

            Currency usDollar = new Currency();

            usDollar.name = "US Dollar";
            usDollar.Create();

            foreach (Currency currency in Currency.RetrieveAll())
            {
                Console.WriteLine(currency.id + " - " + currency.name);
            }

            //Currency test = Currency.RetrieveById(2).First();
            //test.Delete();

            //Currency test = new Currency();
            //test.id = Currency.RetrieveByName("US Dollar").First().id;
            //test.name = "American Dollar";
            //test.value = 0.7;
            //test.Update();


            // USER --------------------------------------------------------------
            User.CreateTable();

            User bernardo = new User();

            bernardo.login       = "******";
            bernardo.password    = "******";
            bernardo.currency_id = 1;
            bernardo.Create();

            User tiago = new User();

            tiago.login       = "******";
            tiago.password    = "******";
            tiago.currency_id = 1;
            tiago.Create();

            foreach (User user in User.RetrieveAll())
            {
                Console.WriteLine(user.id + " - " + user.login);
                Console.WriteLine("PW - " + user.password);
            }


            // ACCOUNT --------------------------------------------------------------
            Account.CreateTable();

            Account wallet = new Account();

            wallet.name    = "Wallet";
            wallet.balance = 0;
            wallet.user_id = User.RetrieveByLogin("bernardo").First().id;
            wallet.Create();

            Account bank_acc = new Account();

            bank_acc.name    = "Bank account";
            bank_acc.balance = 702.01;
            bank_acc.user_id = User.RetrieveByLogin("bernardo").First().id;
            bank_acc.Create();

            foreach (Account account in Account.RetrieveAll())
            {
                Console.WriteLine(account.id + " - " + account.name);
                Console.WriteLine("Balance - " + account.balance + " " + Currency.RetrieveById(User.RetrieveById(account.user_id).First().currency_id).First().name);
                Console.WriteLine("Owner - " + User.RetrieveById(account.user_id).First().login);
            }


            // DEBT --------------------------------------------------------------
            Debt.CreateTable();

            Debt loan = new Debt();

            loan.amount      = 1500;
            loan.description = "Bank loan";
            loan.deadline    = DateTime.Parse("11/12/2016");
            loan.category_id = Category.RetrieveByName("Loans").First().id;
            loan.user_id     = User.RetrieveByLogin("tiago").First().id;
            loan.type_id     = MType.RetrieveByName("Outgoing").First().id;
            loan.Create();

            Debt library = new Debt();

            library.amount      = 5.8;
            library.description = "Library membership";
            library.deadline    = DateTime.Parse("30/11/2016");
            library.category_id = Category.RetrieveByName("Bills").First().id;
            library.user_id     = User.RetrieveByLogin("tiago").First().id;
            library.type_id     = MType.RetrieveByName("Outgoing").First().id;
            library.Create();

            foreach (Debt debt in Debt.RetrieveAll())
            {
                Console.WriteLine(debt.description + " - " + debt.amount);
            }

            //foreach (Debt debt in Debt.RetrieveByDeadline(DateTime.Parse("30/11/2016")))
            //{
            //    Console.WriteLine(debt.description + " - " + debt.amount);
            //}

            //Debt test = new Debt();
            //test = Debt.RetrieveByUser(2).First();
            //test.description = "Test worked";
            //test.amount = 700;
            //test.Update();


            // TRANSACTION --------------------------------------------------------------

            Transaction.CreateTable();

            Transaction car = new Transaction();

            car.amount      = 15000;
            car.description = "Car purchase";
            car.date        = DateTime.Parse("25/08/2016");
            car.category_id = Category.RetrieveByName("Vehicles").First().id;
            car.user_id     = User.RetrieveByLogin("bernardo").First().id;
            car.type_id     = MType.RetrieveByName("Outgoing").First().id;
            car.account_id  = Account.RetrieveByName("Bank account").First().id;
            car.Create();

            Transaction sale = new Transaction();

            sale.amount      = 145;
            sale.description = "Used TV sale";
            sale.date        = DateTime.Parse("12/01/2014");
            sale.category_id = Category.RetrieveByName("Personal sales").First().id;
            sale.user_id     = User.RetrieveByLogin("bernardo").First().id;
            sale.type_id     = MType.RetrieveByName("Incoming").First().id;
            sale.account_id  = Account.RetrieveByName("Wallet").First().id;
            sale.Create();

            foreach (Transaction t in Transaction.RetrieveAll())
            {
                Console.WriteLine(t.description + " - " + t.amount);
            }

            //foreach (Transaction t in Transaction.RetrieveByDateRange(DateTime.Parse("1/1/2013"), DateTime.Parse("31/12/2015")))
            //{
            //    Console.WriteLine(t.description + " - " + t.amount);
            //}
        }