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