예제 #1
0
        public ExpensesWidget(Provider provider)
        {
            _provider = provider;
            this.Build();
            SetupTreeview();
            //_listStore.AppendValues(new DateTime(2009,1,30), "Type", 100, "Description");
            _listStore.AppendValues(new Expense { Date = new DateTime(2009,1,30), Description = "Description", Amount = 100, Type = new ExpenseType { Description = "Type" } } );
            IList<Expense> expenses = provider.GetExpenses();

            from expense in expenses
        }
예제 #2
0
        public static void Main(string[] args)
        {
            ISessionFactory sessionFactory = new Configuration().Configure().BuildSessionFactory();

            Expense e = new Expense();

            Provider p = new Provider(sessionFactory.OpenSession());
            e = p.GetExpenseById(1);

            e.Date = new DateTime(2009, 1, 18);
            e.Description = "description";
            e.Amount = 100;
            //e.ExpenseTypeId = 1;

            using(var session = sessionFactory.OpenSession())
                using(session.BeginTransaction())
            {
                session.Save(e);
                session.Transaction.Commit();
            }

            //			Expense e = new Expense();
            //
            //
            //
            //			Provider p = new Provider();
            //			e = p.GetExpenseById(1);
            //
            //			Console.Write(e.Id);
            //			Console.Write(e.Description);
            //			Console.Write(e.Amount);
            //
            //			Mono.Data.Sqlite.SqliteConnection conn = new Mono.Data.Sqlite.SqliteConnection("Data Source=database.sqlite3");
            //			Mono.Data.Sqlite.SqliteCommand cmd = new Mono.Data.Sqlite.SqliteCommand("select * from expenses", conn);
            //			conn.Open();
            //			Mono.Data.Sqlite.SqliteDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
            //			string s = "";
            //			while(rdr.Read())
            //			{
            //				s+=rdr.ToString();
            //			}
            //
            //
            //

            Application.Init ();
            MainWindow win = new MainWindow ();
            win.Show ();
            Application.Run ();
        }