public Expense GetById(Guid id)
{
Expense expense = null;
using (var em = EntityManagerFactory.CreateInstance(ds))
{
var q = new Query().From(tableName).Where("ID").Equal("{" + id + "}");
expense = em.ExecuteObject <Expense>(q.ToSql(), new ExpenseMapper());
}
if (expense != null)
{
expense.ExpenseItems = expenseItemRepository.GetByExpenseId(expense.ID);
}
return(expense);
}
private void LoadExpenseItems(Guid id)
{
var expenseItems = expenseItemRepository.GetByExpenseId(id);
lvwExpense.Items.Clear();
decimal total = 0;
foreach (var expenseItem in expenseItems)
{
total = total + (expenseItem.Total);
PopulateExpenseItem(expenseItem);
}
lblTotal.Text = total.ToString("N0").Replace(",", ".");
}
