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
}
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 ();
}